| 澶辨晥閾炬帴澶勭悊 |
|
MySQL甯哥敤SQL璇彞 PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1jY2zw74Ok5Q_SK42LjcXXQ
鎻愬彇鐮侊細(xì)rpzn
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
鏌ョ湅鏁版嵁搴?/div>
show databases;
鍒涘緩鏁版嵁搴?/div>
create database qxr;
閫夋嫨鎿嶄綔鐨勬暟鎹簱
use qxr;
鏌ョ湅褰撳墠鎵€鍦ㄤ綅緗?/div>
select database();
鍒犻櫎鏁版嵁搴?/div>
drop database `qxr`;
縐誨姩鏁版嵁搴撶洰褰?/div>
mv/data/mysql/data/qxr /
鍒涘緩琛?/div>
create table test(id int(10),name char(15),age int(8));
鏌ョ湅琛?/div>
show tables;
鏌ョ湅琛ㄧ粨鏋?/div>
desc test;
鍒犻櫎琛?/div>
drop table test;
淇敼琛ㄥ悕縐?/div>
alter table test rename test1;
淇敼瀛楁綾誨瀷
alter table test modify age int(10);
淇敼瀛楁綾誨瀷鍜屽瓧孌靛悕縐?/div>
alter table test change name name1 char(20);
鍦ㄨ〃涓坊鍔犲瓧孌?/div>
alter table test add sex int(10);
鍦ㄦ寚瀹氫綅緗坊鍔犲瓧孌?/div>
alter table test add uid int(10)first; 鍦ㄧ涓€鍒?/div>
alter table test add name char(15) after id; 鍦╥d鍚庤竟
鍒犻櫎琛ㄤ腑瀛楁
alter table test drop name1;
鎻掑叆璁板綍insert
insert into test values(1,'qxr',18);
鍚屾椂鎻掑叆澶氭潯
insert into test values(2,'lisi',20),(3,'zhangsan',28);
鍒嗗紑鎻掑叆琛ㄨ褰?/div>
insert into test(id,name)values(4,'wangwu');
鏌ヨ琛ㄤ腑璁板綍
select * from test錛?/div>
鏌ヨ鏌愪釜瀛楁鎴栨煇浜涘瓧孌靛唴瀹?/div>
select name from test;
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
