منتديات phpBBArabia

مرسل: **السبت أكتوبر 31, 2015 12:47 pm**

??? ????? ?????? ????? ????? ?? ????? ?????? ?? ???? ?????? ????? mysql.exe ???? ????? ??????

??? ??????? ???? ????? ?? ????????

%SystemRoot%\system32\cmd.exe /K

-u <username> -p

use database_name;

??? ?????? ????? ???????? ?? ???? ?? ???? ????? ?????? ?????? ???????

charset utf8

????? ?? ?????? ?????

source filename.sql;

???? ??????? ????? ??? ??? ??????
????? ???? - ???? ????? ?????? ??? ????? ?? ????? 3:15
https://www.youtube.com/watch?v=f3M_bY29jAA

مرسل: **الاثنين نوفمبر 02, 2015 7:21 pm**

??? ??????? ????????

??? ????? ?????? ????? - ?????? ?? name ??????

create database name;

??????? ????? ???????? ???????? - ?????? ?? name ??????

use name;

??? ??????? ?? ????? ????????

show tables

??? ???? ?? ??????? ?? ????? ???????? - ?????? ?? name ??????

show columns from name;

????? ???? ???? ?? ?? ?????? - ?????? ?? name ??????

select * from name;

??? ??? ?????? ?? ?????? (????? ???) - ?????? ?? name ??????

SELECT COUNT(*) FROM name;

??? ??????? ?? ???? - ?????? ?? name ??????

describe name;

??? ????? ?????? ????? - - ?????? ?? name ??????

drop database name;

??? ???? ?? ???? ?????? ?? name ?????? ? ??? column ??????? ?? ??? ???????

alter table [name] drop column [column];

????? ???? ?? ???? ?????? ?? name ?????? ? ??? column ??????? ?? ??? ???????

alter table [name] add column [column] varchar (20);

?????? ???? ????? ???????? - ?????? news ???? ????? ????????

select engine from information_schema.TABLES where TABLE_NAME='news';

?????? ???? ????? ???????? ?????????

SET default_storage_engine=InnoDB;

مرسل: **الجمعة فبراير 05, 2016 3:17 pm**

????? ??? ??????? ?? ??? ??????

???? ?? ??? ?????? ??? ???????? ???? ?????

??? ?? ???? ??????? ?? ???? ???? ??????? ????

رفع قاعدة بيانات كبيرة الحجم