![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
想有钱_hua
入门学习
展开
-
MySQL插入数据(先判断原表中是否存在)
更新单个数据Insert into mol_target(mol_id,target_id,score) values ('MOLCID69232409', 'TAR1098' ,'0.9182') WHERE not EXISTS (SELECT mol_id,target_id FROM mol_target WHERE mol_id='MOLCID69232409' and target...原创 2020-04-28 20:02:45 · 1064 阅读 · 0 评论 -
MySQL :ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
报错:ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)起因:执行了一行语句先这个没问题SELECT * FROM targets WHERE gene_name in (SELECT gene_name from vitiligo_gene277);再SELECT DISTINCT gen...原创 2020-04-28 10:58:13 · 210 阅读 · 0 评论 -
pymysql 更新MySQL表格报错1064
报错如下pymysql.err.ProgrammingError: (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 ‘CID = ‘10008104’’ at l...原创 2020-04-23 20:33:28 · 339 阅读 · 0 评论 -
MYSQL外键设置报错:3780、1452
MYSQLMySQLMYSQL创建外键时提示:3780错误MYSQL创建外键时提示:1452错误MySQLMYSQL创建外键时提示:3780错误原因:字符集和排序规则不对应。(同时注意数据类型,长度)utf8mb4 和 utf8区别utf8mb4 和 utf8区别 : https://blog.csdn.net/qq_17555933/article/details/10144552...原创 2020-04-18 20:51:17 · 3104 阅读 · 0 评论 -
[转] Python操作数据库将文件夹中所有csv文件导入MySQL,操作成功但数据库没有数据
转自:重点是:需要特别注意的是,执行完excute那一行语句以后,一定一定要记得写commit语句,不然的话,数据库插入操作是不会成功的!!!转载 2019-12-03 10:49:00 · 521 阅读 · 0 评论