mysql数据库代码建表，简单用例，及简单操作语句
CREATE TABLE `user` (`id` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL,
`age` int(11) default NULL,
`name` char(10) default NULL,
`address` varchar(50) default NULL,
`stratime` datetime NOT NULL,
PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--添加
insert into `user`(uid,age,name,address) values(7,20,'aaa','bbb');
--删除
delete from `user` where uid='7';
--查询
select * from `user` where uid='' and name=''
uid='' or name=''
like '%name%'
uid between 1 and 3;
--修改
update `user` set address='qqqq' where uid='1';
页:
[1]