| 澶辨晥閾炬帴澶勭悊 |
|
MySQL鍛戒護(hù)璇﹁В(鍛戒護(hù)鍙?qiáng)閲婁? PDF 涓嬭澆
鏈珯鏁寸悊涓嬭澆錛?/strong>
閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1zR1RkOsgsmIWNmkRPfkWtQ
鎻愬彇鐮侊細(xì)crqa
鐩稿叧鎴浘錛?/strong>
涓昏鍐呭錛?/strong>
鍒汣REATE TABLE vendors(--鍒涘緩涓€涓柊琛?vend_id int NOT NULL AUTO_INCREMENT;
--NOT NULL 鍏抽敭瀛楄〃紺鴻鍒椾笉鑳戒負(fù)絀?--AUTO_INCREMENT 鍏抽敭瀛椾嬌寰楀啀姣忔坊鍔犱竴琛屾椂鑷姩澧為噺錛屾瘡涓〃涓彧鑳藉瓨鍦ㄤ竴涓繖鏍風(fēng)殑鍒?--鍙互浣跨敤 SELECT last_insert_id()錛涜繑鍥炴渶鍚庝竴涓彃鍏ョ殑AUTO_INCREMENT鐨勫€?vend_address char(50) NULL; --NULL鍏抽敭瀛楀厑璁歌鍒椾負(fù)絀猴紝榛樿鎯呭喌涓嬩篃涓篘ULL vend_city char(50) NOT NULL DEFAULT 'CITY'; --DEFAULT鍏抽敭瀛楄緗粯璁ゅ€?PRIMARY KEY (vend_id); --PRIMARY KEY 鍏抽敭瀛楄緗富閿紝涓婚敭鍙互涓哄涓垪鏋勬垚 )ENGING = InooDB; --ENGING 鍏抽敭瀛楄緗暟鎹簱寮曟搸錛?--InooDB錛氬彲闈犵殑浜嬪姟澶勭悊寮曟搸錛屼笉鏀寔鍏ㄦ枃鏈悳绱?--MEMORY錛氬姛鑳界瓑鍚屼簬MyISAM --MyISAM錛氭敮鎸佸叏鏂囨湰鎼滅儲(chǔ)錛屼絾涓嶆敮鎸佷簨鍔″鐞嗭紙涓€鑸負(fù)榛樿寮曟搸錛?ALTER ALTER TABLE vendors--瀵硅〃vendors榪涜鏇存柊 ADD vend_phone CHAR(20);--娣誨姞涓€涓垪 DROP COLUMN vend_phone;--鍒犻櫎涓€涓垪 ADD CONSTRAINT fk FOREIGN KEY (vend_num)REFERENCES vendors(vend_num); --娣誨姞涓€涓閿?DROP DROP TABLE vendors;--鍒犻櫎涓€涓〃 RENAME RENAME TABLE vendors TO vendors2;--閲嶅懡鍚嶈〃 瑙嗗浘瑙咰REATE VIEW productcustomer AS SELECT cust_name,cust_contact,prod_id FROM customers,orders,orderitems WHERE customers.cust_id=orders.cust_id AND orderitems.order_num = orders.order_num; --鍏抽敭瀛梀IEW涓嶢S鍒涘緩瑙嗗浘錛岃鍥劇殑涓昏浣滅敤鍦ㄤ簬鏁版嵁鐨勬绱?--瑙嗗浘鐨勭敤娉曞拰琛ㄧ殑鐢ㄦ硶綾諱技 瀛樺偍榪囩▼ 瀛樺垱寤烘棤鍙傛暟瀛樺偍榪囩▼ 鍒汣REATE PROCEDURE productpricing() BEGINSELECT Avg(prod_price) AS pricecaverage FROM products; END; DELIMITER DELIMITER // CREATE PROCEDURE productpricing() BEGINSELECT Avg(prod_price) AS pricecaverage FROM products; END // DELIMITER ; --DELIMITER 鍏抽敭瀛椾復(fù)鏃跺畾涔夎鍙ュ垎闅旂錛屼互闃叉鍑虹幇璇硶閿欒
|
| Java1234瀹樻柟緹?5錛?/td> | 
|
| Java1234瀹樻柟緹?5錛?/td> | 838462530 |
鑻忓叕緗戝畨澶?32061202001004鍙?/p>
