摘要:
1.查看创建表的SQL语句 show create table table_name \G; 2.查看表的字段信息 show full columns from table_name; 获取以下信息Field :字段名Type:字段类型Collation:字符集Null :是否可以为NULLKey: 阅读全文
摘要:
1.DefinitionsIterable Object:Iterables include all sequence types (such as list, str, and tuple, which has __getitem__() method) and some non-sequence... 阅读全文
摘要:
SQL语句:update table_1 set x = (select x from table_2 where table_1.y = table_2.y);如果括号中临时建立的表中元素的个数小于table_1中元素个数或者只想更新table_1中部分x的值,可以在后面加where子句.Exa... 阅读全文