常用SQL语句

1.  create table users (id int not null primary key auto_increment, name varchar(20) not null,password varchar(20) not null);

            //其中auto_increment是自动添加id。当向表里插入数据时，执行：insert users(name,password) values ('zhangsan','1234');       insert users (name,password) values('" + name  + "', '" + password + "');

2. 在sql语句中应该注意先后顺序，例如下列的示例中，limit应写在最后，order by 应写在 group by之后。

SELECT distinct name as pass FROM students where name = 'quding' group by name having name = 'quding' order by id LIMIT 0,1000 ;

3.更新数据表中的数据，update与set连用。UPDATE students set name = 'quding' where id = 2;