1. 创建表:create table users(userid,username,password,age);

  2. 插入:insert into users(username,password,age) values('ni','12','21');

    (users 有四个属性:编号、用户名、密码、年龄)

  3. 删除:delete from users where userid=4;

  4. 查找:select * from users [username='xxx'];

  5. 查找:select * from table1 where field1 like ’%value1%’

  6. 修改:update users set username='rose' where userid=3;