浅谈“Mysql”的基础操作语句
your MySQL server version for the right syntax to use near ‘\)‘ at line 1
2 mysql> create table qq_user(id int primary key );
3 Query OK, 0 rows affected (0.01 sec)
4
5 mysql> show tables;
6 +------------------+
7 | Tables_in_systop |
8 +------------------+
9 | qq_user |
10 +------------------+
11 1 row in set (0.00 sec)
12
13 mysql>
14 mysql>
15 mysql>
16 mysql>
17 mysql>
18 mysql>
19 mysql>
20 mysql>
21 mysql>
22 mysql>
23 mysql>
24 mysql> create table qq_user(id int primary key )
25 -> create table qq_user(id/; int primary key )
26 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘create table qq_user(id/‘ at line 2
27 ->
28 -> ;
29 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘int primary key )‘ at line 1
30
31 mysql> create table qq_user(
32 -> qq_id bigint primary key,
33 -> Password nvrchar(50) not null,
34 -> ;
35 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘nvrchar(50) not null,‘ at line 3
36 mysql> create table qq_user(
37 -> ;
38 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘ at line 1
39 mysql> show tables;
40 +------------------+
41 | Tables_in_systop |
42 +------------------+
43 | qq_user |
44 +------------------+
45 1 row in set (0.00 sec)
46
47 mysql> drop table qq_user;
48 Query OK, 0 rows affected (0.00 sec)
49
50 mysql> show tables;
51 Empty set (0.00 sec)
52
53 mysql>
54 mysql>
55 mysql> create table qq_user(
56 -> qq_id bigint primary key,
57 -> Password nvarchar(50) not null,
58 -> LastLoginTime datetime,
59 -> Oline int,
60 -> Level int);
61 Query OK, 0 rows affected (0.00 sec)
62
63 mysql> show tables;
64 +------------------+
65 | Tables_in_systop |
66 +------------------+
67 | qq_user |
68 +------------------+
69 1 row in set (0.00 sec)
70
71 mysql> descl
72 -> ;
73 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘descl‘ at line 1
74 mysql> desc;
75 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘ at line 1
76 mysql> desc qq_user;
77 +---------------+-------------+------+-----+---------+-------+
78 | Field | Type | Null | Key | Default | Extra |
79 +---------------+-------------+------+-----+---------+-------+
80 | qq_id | bigint(20) | NO | PRI | NULL | |
81 | Password | varchar(50) | NO | | NULL | |
82 | LastLoginTime | datetime | YES | | NULL | |
83 | Oline | int(11) | YES | | NULL | |
84 | Level | int(11) | YES | | NULL | |
85 +---------------+-------------+------+-----+---------+-------+
86 5 rows in set (0.00 sec)
87
88 mysql> insert into qq_user values(‘123344‘,‘xiaoguo‘,‘2014-1-1‘,‘1‘,‘2‘);
89 Query OK, 1 row affected (0.00 sec)
90
91 mysql> select *from qq_user;
92 +--------+----------+---------------------+-------+-------+
93 | qq_id | Password | LastLoginTime | Oline | Level |
94 +--------+----------+---------------------+-------+-------+
95 | 123344 | xiaoguo | 2014-01-01 00:00:00 | 1 | 2 |
96 +--------+----------+---------------------+-------+-------+
97 1 row in set (0.00 sec)
98
99 mysql>
100 mysql>
101 mysql> truncate qq_user;
102 Query OK, 0 rows affected (0.00 sec)
103
104 mysql> selcet *from qq_user;
105 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘selcet *from qq_user‘ at line 1
106 mysql> show tables;
107 +------------------+
108 | Tables_in_systop |
109 +------------------+
110 | qq_user |
111 +------------------+
112 1 row in set (0.00 sec)
113
114 mysql> select * from qq_user;
115 Empty set (0.00 sec)
116
117 mysql> alter table qq_user rename user;
118 Query OK, 0 rows affected (0.00 sec)
119
120 mysql> show tables;
121 +------------------+
122 | Tables_in_systop |
123 +------------------+
124 | user |
125 +------------------+
126 1 row in set (0.00 sec)
127
128 mysql> alter table user modify qq_id int;
129 Query OK, 0 rows affected (0.00 sec)
130 Records: 0 Duplicates: 0 Warnings: 0
131
132 mysql> desc user;
133 +---------------+-------------+------+-----+---------+-------+
134 | Field | Type | Null | Key | Default | Extra |
135 +---------------+-------------+------+-----+---------+-------+
136 | qq_id | int(11) | NO | PRI | 0 | |
137 | Password | varchar(50) | NO | | NULL | |
138 | LastLoginTime | datetime | YES | | NULL | |
139 | Oline | int(11) | YES | | NULL | |
140 | Level | int(11) | YES | | NULL | |
141 +---------------+-------------+------+-----+---------+-------+
142 5 rows in set (0.00 sec)
143
144 mysql> alter table user qq_id bigint(6);
145 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘qq_id bigint(6)‘ at line 1
146 mysql> alter table user modify qq_id bigint(6);
147 Query OK, 0 rows affected (0.00 sec)
148 Records: 0 Duplicates: 0 Warnings: 0
149
150 mysql> desc user;
151 +---------------+-------------+------+-----+---------+-------+
152 | Field | Type | Null | Key | Default | Extra |
153 +---------------+-------------+------+-----+---------+-------+
154 | qq_id | bigint(6) | NO | PRI | 0 | |
155 | Password | varchar(50) | NO | | NULL | |
156 | LastLoginTime | datetime | YES | | NULL | |
157 | Oline | int(11) | YES | | NULL | |
158 | Level | int(11) | YES | | NULL | |
159 +---------------+-------------+------+-----+---------+-------+
160 5 rows in set (0.00 sec)
161
162 mysql>
163 mysql>
164 mysql> alter table user change qq_id id
165 -> ;
166 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘‘ at line 1
167 mysql> alter table user change qq_id id int;
168 Query OK, 0 rows affected (0.01 sec)
169 Records: 0 Duplicates: 0 Warnings: 0
170
171 mysql> desc user;
172 +---------------+-------------+------+-----+---------+-------+
173 | Field | Type | Null | Key | Default | Extra |
174 +---------------+-------------+------+-----+---------+-------+
175 | id | int(11) | NO | PRI | 0 | |
176 | Password | varchar(50) | NO | | NULL | |
177 | LastLoginTime | datetime | YES | | NULL | |
178 | Oline | int(11) | YES | | NULL | |
179 | Level | int(11) | YES | | NULL | |
180 +---------------+-------------+------+-----+---------+-------+
181 5 rows in set (0.00 sec)
182
183 mysql> alter table user add Name varchar(20) after id;
184 Query OK, 0 rows affected (0.01 sec)
185 Records: 0 Duplicates: 0 Warnings: 0
186
187 mysql> desc user;
188 +---------------+-------------+------+-----+---------+-------+
189 | Field | Type | Null | Key | Default | Extra |
190 +---------------+-------------+------+-----+---------+-------+
191 | id | int(11) | NO | PRI | 0 | |
192 | Name | varchar(20) | YES | | NULL | |
193 | Password | varchar(50) | NO | | NULL | |
194 | LastLoginTime | datetime | YES | | NULL | |
195 | Oline | int(11) | YES | | NULL | |
196 | Level | int(11) | YES | | NULL | |
197 +---------------+-------------+------+-----+---------+-------+
198 6 rows in set (0.00 sec)
199
200 mysql> alter table user drop Name;
201 Query OK, 0 rows affected (0.00 sec)
202 Records: 0 Duplicates: 0 Warnings: 0
203
204 mysql> desc user;
205 +---------------+-------------+------+-----+---------+-------+
206 | Field | Type | Null | Key | Default | Extra |
207 +---------------+-------------+------+-----+---------+-------+
208 | id | int(11) | NO | PRI | 0 | |
209 | Password | varchar(50) | NO | | NULL | |
210 | LastLoginTime | datetime | YES | | NULL | |
211 | Oline | int(11) | YES | | NULL | |
212 | Level | int(11) | YES | | NULL | |
213 +---------------+-------------+------+-----+---------+-------+
214 5 rows in set (0.00 sec)
215
216 mysql> alter table user modify Level int after Password;
217 Query OK, 0 rows affected (0.00 sec)
218 Records: 0 Duplicates: 0 Warnings: 0
219
220 mysql> desc user;
221 +---------------+-------------+------+-----+---------+-------+
222 | Field | Type | Null | Key | Default | Extra |
223 +---------------+-------------+------+-----+---------+-------+
224 | id | int(11) | NO | PRI | 0 | |
225 | Password | varchar(50) | NO | | NULL | |
226 | Level | int(11) | YES | | NULL | |
227 | LastLoginTime | datetime | YES | | NULL | |
228 | Oline | int(11) | YES | | NULL | |
229 +---------------+-------------+------+-----+---------+-------+
230 5 rows in set (0.00 sec)
231
232 mysql> alter table user modify id bigint(6);
233 Query OK, 0 rows affected (0.00 sec)
234 Records: 0 Duplicates: 0 Warnings: 0
235
236 mysql> desc user;
237 +---------------+-------------+------+-----+---------+-------+
238 | Field | Type | Null | Key | Default | Extra |
239 +---------------+-------------+------+-----+---------+-------+
240 | id | bigint(6) | NO | PRI | 0 | |
241 | Password | varchar(50) | NO | | NULL | |
242 | Level | int(11) | YES | | NULL | |
243 | LastLoginTime | datetime | YES | | NULL | |
244 | Oline | int(11) | YES