用sql还原一个年代久远的项目时候发现create table执行时报表不存在。。解决方法：先新建一个空表，然后删除，再然后就可以用sql创建其他内容的表了
2023-05-18 14:56
141
0
0
0
MySql的like语句中的通配符：百分号、下划线和escape%代表任意多个字符Sql代码 www.2cto.com select * from user where username like '%hu
2021-12-07 14:34
141
0
0
0
SELECT s.name, g.score
FROM student AS s
INNER JOIN grade AS g ON s.id = g.student_id
INNER JOIN course
2023-07-15 08:48
139
0
0
0
1. 语法选项说明-h, --host=name主机名-P[ port_num], --port=port_num用于连接MySQL服务器的的TCP/IP端口号--master-data这个选项可以把binlog的位
2021-12-07 14:33
138
0
0
0
早上看到服务器mysql挂掉了。于是重启mysql,启动失败:/usr/bin/mysqld_safe:line183:23638Killed
nohup/usr/sbin/mysqld--basedir=/usr-
2021-12-07 14:36
138
0
0
0
autocommit的测试对于innodb表：首先创建两个innodb表：mysql>createtabletab_kx(aintauto_increment,primarykey(a));
QueryOK,0row
2021-12-07 14:37
138
0
0
0
SELECT student_no,student_name,COUNT(course_no) AS course_num,SUM(score) AS total_score FROM student LEFT
2023-06-16 08:34
137
0
0
0