1.20:01:56 update test.work_info set sex = 'F' where name = 'Yng' Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.016 sec 必须建立索引
2. MySQL cursor的使用参考:
http://www.mysqltutorial.org/mysql-cursor/
3.远程连接MySQL数据库
mysql -h ip_address -u username -ppassword -P port [-D database name]
windows下必须关闭防火墙
Question:
ubuntu下可以访问windows上的MySQL数据库,但从windows上无法访问Ubuntu上的。需要查询解决措施
4.在cmd窗口下输入SQL语句必须以 ; 结束