\u4e00\u3001\u4ece\u547d\u4ee4\u884c\u767b\u5f55MySQL\u6570\u636e\u5e93\u670d\u52a1\u5668 1\u3001\u767b\u5f55\u4f7f\u7528\u9ed8\u8ba43306\u7aef\u53e3\u7684MySQL<\/p>\n
\/usr\/local\/mysql\/bin\/mysql -u root -p<\/p>\n
2\u3001\u901a\u8fc7TCP\u8fde\u63a5\u7ba1\u7406\u4e0d\u540c\u7aef\u53e3\u7684\u591a\u4e2aMySQL\uff08\u6ce8\u610f\uff1aMySQL4.1\u4ee5\u4e0a\u7248\u672c\u624d\u6709\u6b64\u9879\u529f\u80fd\uff09<\/p>\n
\/usr\/local\/mysql\/bin\/mysql -u root -p –protocol=tcp –host=localhost –port=3307<\/p>\n
3\u3001\u901a\u8fc7socket\u5957\u63a5\u5b57\u7ba1\u7406\u4e0d\u540c\u7aef\u53e3\u7684\u591a\u4e2aMySQL<\/p>\n
\/usr\/local\/mysql\/bin\/mysql -u root -p –socket=\/tmp\/mysql3307.sock<\/p>\n
4\u3001\u901a\u8fc7\u7aef\u53e3\u548cIP\u7ba1\u7406\u4e0d\u540c\u7aef\u53e3\u7684\u591a\u4e2aMySQL<\/p>\n
\/usr\/local\/mysql\/bin\/mysql -u root -p -P 3306 -h 127.0.0.1<\/p>\n
——————————————————————————–<\/p>\n
\u4e8c\u3001\u6570\u636e\u5e93\u64cd\u4f5cSQL\u8bed\u53e5 1\u3001\u663e\u793a\u670d\u52a1\u5668\u4e0a\u5f53\u524d\u5b58\u5728\u4ec0\u4e48\u6570\u636e\u5e93<\/p>\n
SHOW DATABASES;<\/p>\n
2\u3001\u521b\u5efa\u540d\u79f0\u4e3arewin\u7684\u6570\u636e\u5e93<\/p>\n
CREATE DATABASE rewin;<\/p>\n
3\u3001\u5220\u9664\u540d\u79f0\u4e3arewin\u7684\u6570\u636e\u5e93<\/p>\n
DROP DATABASE rewin;<\/p>\n
4\u3001\u9009\u62e9rewin\u6570\u636e\u5e93<\/p>\n
USE rewin;<\/p>\n
——————————————————————————–<\/p>\n
\u4e09\u3001\u8868\u64cd\u4f5cSQL\u8bed\u53e5\uff08\u767b\u5f55\u4e4b\u540e\u5fc5\u987b\u7528\u4ee5\u4e0a\u7684USE\u547d\u4ee4\u9009\u62e9\u4e00\u4e2a\u6570\u636e\u5e93\uff0c\u518d\u8fdb\u884c\u8868\u64cd\u4f5c\uff09 1\u3001\u663e\u793a\u5f53\u524d\u6570\u636e\u5e93\u4e2d\u5b58\u5728\u4ec0\u4e48\u8868<\/p>\n
SHOW TABLES;<\/p>\n
2\u3001\u521b\u5efa\u6570\u636e\u5e93\u8868zhangyan\uff1a\u5728mysql>\u540e\u7c98\u8d34\u4ee5\u4e0bSQL\u8bed\u53e5\uff0c\u5b58\u50a8\u5f15\u64ce\u4e3aMYISAM\uff0c\u5b57\u6bb5id\u4e3a\u4e3b\u952e\u3001\u552f\u4e00\u7d22\u5f15<\/p>\n
\u3002<\/p>\n
CREATE TABLE `zhangyan` ( `id` INT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT , `username` VARCHAR( 20 ) NOT NULL , `password` CHAR( 32 ) NOT NULL , `time` DATETIME NOT NULL , `number` FLOAT( 10 ) NOT NULL , `content` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ;<\/p>\n
3\u3001\u67e5\u770bzhangyan\u8868\u7ed3\u6784<\/p>\n
DESCRIBE zhangyan;<\/p>\n
4\u3001\u4ece\u8868\u4e2d\u68c0\u7d22\u4fe1\u606f 4.1\u3001\u4ecezhangyan\u8868\u4e2d\u68c0\u7d22\u6240\u6709\u8bb0\u5f55<\/p>\n
SELECT * FROM zhangyan;<\/p>\n
4.2\u3001\u4ecezhangyan\u8868\u4e2d\u68c0\u7d22\u7279\u5b9a\u7684\u884c\uff1a\u5b57\u6bb5username\u7b49\u4e8eabc\uff0c\u5b57\u6bb5number\u7b49\u4e8e1\uff0c\u6309\u5b57\u6bb5id\u964d\u5e8f\u6392\u5217<\/p>\n
SELECT * FROM zhangyan WHERE username = abc AND number=1 ORDER BY id DESC;<\/p>\n
4.3\u3001\u4ecezhangyan\u8868\u4e2d\u68c0\u7d22\u6307\u5b9a\u7684\u5b57\u6bb5\uff1ausername\u548cpassword<\/p>\n
SELECT username, password FROM zhangyan;<\/p>\n
4.4\u3001\u4ecezhangyan\u8868\u4e2d\u68c0\u7d22\u51fa\u552f\u4e00\u7684\u4e0d\u91cd\u590d\u8bb0\u5f55\uff1a<\/p>\n
SELECT DISTINCT username FROM zhangyan;<\/p>\n
5\u3001\u63d2\u5165\u4fe1\u606f\u5230zhangyan\u8868<\/p>\n
INSERT INTO zhangyan (id, username, password, time, number, content) VALUES (, abc, 123456,<\/p>\n
2007-08-06 14:32:12, 23.41, hello world);<\/p>\n
6\u3001\u66f4\u65b0zhangyan\u8868\u4e2d\u7684\u6307\u5b9a\u4fe1\u606f<\/p>\n
UPDATE zhangyan SET content = hello china WHERE username = abc;<\/p>\n
7\u3001\u5220\u9664zhangyan\u8868\u4e2d\u7684\u6307\u5b9a\u4fe1\u606f<\/p>\n
DELETE FROM zhangyan WHERE id = 1;<\/p>\n
8\u3001\u6e05\u7a7azhangyan\u8868<\/p>\n
DELETE FROM zhangyan;<\/p>\n
9\u3001\u5220\u9664zhangyan\u8868<\/p>\n
DROP TABLE zhangyan;<\/p>\n
10\u3001\u66f4\u6539\u8868\u7ed3\u6784\uff0c\u5c06zhangyan\u8868username\u5b57\u6bb5\u7684\u5b57\u6bb5\u7c7b\u578b\u6539\u4e3aCHAR(25)<\/p>\n
ALTER TABLE zhangyan CHANGE username username CHAR(25);<\/p>\n
11\u3001\u5c06\u5f53\u524d\u76ee\u5f55\u4e0b\u7684mysql.sql\u5bfc\u5165\u6570\u636e\u5e93<\/p>\n
SOURCE .\/mysql.sql;<\/p>\n","protected":false},"excerpt":{"rendered":"