1.清空所有的元素(恢复主键id =1):truncate TABLE 2.更改主键自动更新值:ALTER TABLE 'table_name' AUTO_INCREMENT= 10000; 2015-12-2: 3.select 'abcdefg' 等价 select 0x41424344454647 通过hex() unhex()转换
很多时候,我们在执行命令行执行mysql命令行时,会报错误!mysql> show database;
ERROR 1064 (42000): You have an error in your SQLsyntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database' at line 1这就是我们执行命令拼写错误,mysql的错误提示! MySQL服务器会发回由上一个语句引起的错误、警告和注意的总数。SHOW WARNINGS [LIMIT [offset,] row_count] 显示由上一个生成消息的语句导致的错误、警告和注意消息。如果上一个使用表的语句未生成消息,则什么也不显示。 (或者只执行show errors 显示其错误的信息) SHOW COUNT(*) WARNINGS
语句显示错误、警告和注意的总数。mysql> show warnings;
+-------+------+----------------------------------------+
| Level | Code | Message |
+-------+------+----------------------------------------+
| Error | 1064 | 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 'database' at line 1 |
+-------+------+----------------------------------------+这语句就显示了刚才执行错误命令show database的详细信息 mysql> select @@warning_count;
+-------------------------+
| @@warning_count
|
+-------------------------+
|
1 |
+-------------------------+
1 row in set (0.00 sec)执行这条语句会告诉我们,刚才我们在执行show database这条错误命令时一共产生了多少的警告和错误信息,而这些错误警告信息的提示都是通过系统变量max_error_count设置最多错误显示数目和sql_notes会话变量,使&qu添加字段 ALTER TABLE `version` ADD COLUMN date int DEFAULT 0 AFTER `version_id`; 删除字段 alter table `version` drop column version_id; 看表结构 DESC user; show columns from user; alter table 表名称 change 字段名称 字段名称 字段类型 [是否允ot;注意"级别的警告是否被记录。mysql> show variables like 'max_error_count';
+-----------------+-------+
| Variable_name
| Value |
+-----------------+-------+
| max_error_count | 64
|
+-----------------+-------+mysql服务器默认保存错误记录为64,可以通过set max_error_count = 0 ;表示不保存错误信息mysql> show variables like 'sql_notes';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| sql_notes
| ON
|
+---------------+-------+mysql服务器默认将注意级别警告打开,可以通过set sql_notes = 0 ; 将"注意"级别的警告关闭和set sql_notes = 1; 将其打开。因此,如果max_error_count系统变量设置得过低,以致于有的消息没有被存储,则warning_count值可能比由SHOW WARNINGS显示的消息数目要大。mysql> set max_error_count=1;mysql> alter table test modify name char;Query OK, 3 rows affected, 3 warnings (0.00 sec)Records: 3
Duplicates: 0
Warnings: 3mysql> select @@warning_count;+-----------------+| @@warning_count |+-----------------+|
3 |+-----------------+mysql> show warnings;+---------+------+----------------------------------------+| Level
| Code | Message
|+---------+------+----------------------------------------+| Warning | 1263 | Data truncated for column 'name' at row 1 |+---------+------+----------------------------------------+