ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"
規範說明:所有的error 標題寫成 error No *: key words
key words: 是報錯資訊關鍵詞,因為標題有字數限制,所有不能把整個報錯資訊都寫在部落格title上,只能取關鍵詞,以便於日後檢視。
自己在往MySQL裡面插入資料時,發現產生error: "ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"
先後建立表 SC, 直到第三次才成功:
點選(此處)摺疊或開啟
-
CREATE TABLE SC(Sno CHAR(9) NOT NULL,cno CHAR(6) NOT NULL,Grade SMALLINT,PRIMARY KEY (Sno,cno),constraint f1 FOREIGN KEY (Sno) REFERENCES Student(Sno),FOREIGN KEY (Cno) REFERENCES Course(cno))engine= innodb;
-
-
-
CREATE TABLE SC(Sno CHAR(9) not null,cno CHAR(6) not null,Grade SMALLINT,PRIMARY KEY (Sno,cno),constraint f1 FOREIGN KEY (Sno) REFERENCES Student(Sno),FOREIGN KEY (cno) REFERENCES Course(cno))engine= innodb;
-
-
- CREATE TABLE SC(Sno CHAR(9),cno CHAR(6),Grade SMALLINT,PRIMARY KEY (Sno,cno),constraint f1 FOREIGN KEY (Sno) REFERENCES Student(Sno),FOREIGN KEY (cno) REFERENCES course(cno))engine= innodb;
原因見: http://www.itokit.com/2012/0730/74634.html
MYSQL在LINUX下資料庫名、表名、列名、別名大小寫規則如下:
1.資料庫名與表名是嚴格區分大小寫的
2.表的別名是嚴格區分大小寫的
3.列名與列的別名在所有的情況下均是忽略大小寫的
4.變數名也是嚴格區分大小寫的
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26435490/viewspace-1258771/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- ERROR 1005 (HY000): Can't create table'matrix.system_log' (errno: 150)Error
- ERROR 1135 (HY000): Can't create a new thread (errno 11)Errorthread
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- MySQL案例-不同尋常的[ERROR]Can't create a new thread (errno 11)MySqlErrorthread
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECTError
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sockErrorServerMySql
- MYSQL ERROR 2003 (HY000) CanMySqlError
- 解決Error (1133): Can’t find any matching row in the user tableError
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- MySQL 5.7向表匯入資料包錯"ERROR 13 (HY000): Can't get stat of"MySqlError
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- ERROR 2003 (HY000)Can't connect to MySQL server on '192.168.8.247' (113)ErrorMySqlServer
- ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'ErrorMySql
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)ErrorMySqlServerlocalhost
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase
- ERROR 2002 (HY000): Can't connect server socket /var/run/mysqld/mysqld.sockErrorServerMySql
- can't create PID file問題處理
- ERROR 1114 (HY000) The table '' is fullError
- [ERROR] mysqld: Can‘t open shared library ‘/usr/local/mysql/lib/plugin/validate_password.so‘ (errno:ErrorMySqlPlugin
- T-SQL的CREATE TABLE語法(下)SQL
- T-SQL的CREATE TABLE語法(上)SQL
- ERROR in Entry module not found Error Can't resolve 'babel' in ' UseErrorBabel
- You can‘t specify target table ‘Person‘ for update in FROM clause
- mysql中You can’t specify target table for update in FROM clMySql
- [筆記].痛哉!!!Error: Can't access JTAG chain, Error: Operation failed筆記ErrorAI
- ERROR 1168 (HY000): Unable to open underlying table which isError
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- mysql can't connect error about privilege----not root userMySqlError
- MySQL ERROR 1031 (HY000) at line 33: Table storage engine forMySqlError
- ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default valueError
- ?Error: Can't locate /etc/centreon/conf.pm in @INC (@INError
- MySQL 建立外來鍵報錯Can't write; duplicate key in tableMySql
- ERROR 1206 (HY000): The total number of locks exceeds the lock table sizeError
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error