I had this problem when I was building my watch today
Baidu checked many answer (including CSDN)
many bosses from the Angle of the InnoDB to solve, what say what type of master-slave table
white
I really can’t understand later widely verification
to find the problem in MySQL and SQL server syntax differences
when define a foreign key, MySQL must be outside the parentheses indicate the key attributes, otherwise an error will be submitted to the above
Ex. :
Create table course(course_id varchar(8),title varchar(50),dept_name varchar(20),credits numeric(2,0) check(credits> 0),primary key(course_id),foreign key(dept_name) references department on delete cascade);
will error create table course(course_id varchar(8),title varchar(50),dept_name varchar(20),credits numeric(2,0) check(credits> 0),primary Key (course_ID), Foreign Key (DEPT_name) REFERENCES Department (DEPt_name) on delete cascade);
executes normally
Read More:
- SQL exception handling – MySQL error 1005 (HY000): can’t create table ‘TMP’ (errno: 13)
- MySQL error: can’t create table ‘..’（ errno:150 ）Solutions
- Error: cannot fetch last explain plan from plan_table
- [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
- MySQL error: 1005 can’t create table (error: 150)
- DB2 create table error – 104 42601 illegal symbol encountered in SQL statement
- Solution to error 2002 (HY000) in MySQL
- mysql Error Code: 1022. Can’t write; duplicate key in table `xxx`
- Solution to error 2002 (HY000) in MySQL login startup
- MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
- ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./myapp’, errno: 39)
- Errors in IntelliJ ieeasql statements and table names in @ table
- Solve MySQL error 2002 (HY000)
- MySQL partitions the existing tables of the data table
- Error 1396 (HY000): Operation create user failed for ‘xxx’ @’xxx ‘
- mysql ERROR 1025 (HY000): Error on rename of
- Question: cannot create windows service for mysql.error : 0 (install MySQL)
- Mysql start slave error 1201 (HY000)
- ERROR 2005 (HY000): Unknown MySQL server host
- mysql ERROR 1050 (42S01): Table already exists