掌握insert操作和注意事项
insert 所有列
insert 指定列
注意：列与值，严格对应
数字和字符串的注意点
数字不必加单引号，字符串必须加单引号。
---------------------------------------------------------------------------------------------
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 |
Microsoft Windows [版本 6.1.7601] 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 C:\Users\Administrator>mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 63 Server version: 5.5.37 MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ 2 rows in set (0.00 sec) mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | a | | b | | boy | | category | | girl | | goods | | m | | mian | | result | | t | | user | +----------------+ 11 rows in set (0.00 sec) mysql> desc user; +-------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+----------------------+------+-----+---------+----------------+ | uid | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(20) | NO | | | | | age | smallint(5) unsigned | NO | | 0 | | +-------+----------------------+------+-----+---------+----------------+ 3 rows in set (0.01 sec) mysql> insert into user (uid,name,age) values (1,'lisi',23); Query OK, 1 row affected (0.00 sec) mysql> select * from user; +-----+------+-----+ | uid | name | age | +-----+------+-----+ | 1 | lisi | 23 | +-----+------+-----+ 1 row in set (0.00 sec) mysql> insert into user (uid,name) values (2,'lucy'); Query OK, 1 row affected (0.00 sec) mysql> select * from user; +-----+------+-----+ | uid | name | age | +-----+------+-----+ | 1 | lisi | 23 | | 2 | lucy | 0 | +-----+------+-----+ 2 rows in set (0.00 sec) mysql> insert into user (name) values('lilei'); Query OK, 1 row affected (0.00 sec) mysql> select * from user; +-----+-------+-----+ | uid | name | age | +-----+-------+-----+ | 1 | lisi | 23 | | 2 | lucy | 0 | | 3 | lilei | 0 | +-----+-------+-----+ 3 rows in set (0.00 sec) mysql> desc user; +-------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+----------------------+------+-----+---------+----------------+ | uid | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(20) | NO | | | | | age | smallint(5) unsigned | NO | | 0 | | +-------+----------------------+------+-----+---------+----------------+ 3 rows in set (0.01 sec) mysql> insert into user values (4,'white','36'); Query OK, 1 row affected (0.00 sec) mysql> select * from user; +-----+-------+-----+ | uid | name | age | +-----+-------+-----+ | 1 | lisi | 23 | | 2 | lucy | 0 | | 3 | lilei | 0 | | 4 | white | 36 | +-----+-------+-----+ 4 rows in set (0.00 sec) mysql> |
我的微信
把最实用的经验，分享给最需要的读者，希望每一位来访的朋友都能有所收获！
