Code Name Leader
Con Conservative McLetchie MSP, David
Green Green
Lab Labour Dewar MSP, Rt Hon Donald
====
第三行里的Leader的值是空的。
那么插入数据时,如何指定这为空呢?
Con Conservative McLetchie MSP, David
Green Green
Lab Labour Dewar MSP, Rt Hon Donald
====
第三行里的Leader的值是空的。
那么插入数据时,如何指定这为空呢?
ConConservativeMcLetchie MSP, David
GreenGreen
LabLabour Dewar MSP, Rt Hon Donald
====
第三行里的Leader的值是空的。
那么插入数据时,如何指定这为空呢?insert into table(Code Name) values('GreenGreen')
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 'table
(Green) values(code name) values('GreenGreen')' at line 1
mysql> insert into table(Code Name) values('GreenGreen');
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 'table
(Code Name) values('GreenGreen')' at line 1
mysql>提示错误
Code Name Leader
Con Conservative McLetchie MSP, David
==
Name对应Conservative
Leader对应McLetchie MSP, David