![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
zhuxianfeng
这个作者很懒,什么都没留下…
展开
-
left join
DB: MySQL 1. create table and insert values:create table t1(id int, name varchar(30));insert into t1(id, name) values(1, 'a');insert into t1(id, name) values(2, 'b');create table t2(id i...2010-03-28 16:26:12 · 109 阅读 · 0 评论 -
MySQL查看表结构
MySQL上面查看表结构的方式: 1. desc table_name; --describe table_name 2. show columns from table_name; 3. show create table table_name; 4. use information_schema;select * from columns where t...2010-04-10 23:51:42 · 87 阅读 · 0 评论 -
推荐一个网址generatedata
若是觉得做test时没有data,呵呵,这有一个不错的网址哦,也许能够帮上忙~http://www.generatedata.com 下面是一个生成SQL数据的小demo:CREATE TABLE t1 ( `id` mediumint(8) unsigned NOT NULL auto_increment, `id` MEDIUMINT default NULL...2010-05-09 12:28:37 · 254 阅读 · 0 评论