摘要:
1、mysql> SHOW COLUMNS FROM users;+ + + + + + +| Field | Type | Null | Key | Default | Extra |+ + + + + + +| id | smallint(5) unsigned | NO | PRI | NUL 阅读全文
摘要:
DELETE FROM tbl_name [WHERE where_condition] mysql> SELECT * FROM users;+ + + + + +| id | username | password | age | sex |+ + + + + +| 1 | Tom | 123 阅读全文
摘要:
1、单表更新 (1)mysql> SELECT * FROM users;+ + + + + +| id | username | password | age | sex |+ + + + + +| 1 | Tom | 123 | 25 | 1 || 2 | John | 456 | 25 | 1 阅读全文
摘要:
1、第一种:INSERT [INTO] tbl_name[ (col_name, ... ) ] {VALUES | VALUE}({expr |default}, ... ), (...), ... 如果为自动编号的字段赋值的话,可以采用NULL或者DEFAULT让其采用默认的递增的形式来实现。 阅读全文