MySQL附录：语句语法

1. 语句语法

1. alter table
alter table tablename
(
    add    colunm         datatype [null|not null] [constraints],
    change colunm colunms datatype [null|not null] [constraints],
    drop   colunm
    ...
)

2. commit;
commit;

3. create index
create index indexname
on tablename (colunm [asc|desc], ...);

4. create procedure
create procedure procedurename([parameters])
begin
...
end;

5. create table
create table tablename
(
    colunm datatype [null|not null] [constraints],
	colunm datatype [null|not null] [constraints],
	...
)

6. create user
create user username[@hostname]
[identified by [password] 'password'];

7. create view
create [or replace] view viewname
as
select ...;

8. delete
delete from tablename
[where ...];

9. drop
drop database|index|procedure|table|trigger|user|view
    itemname;
	
10. insert
insert into tablename [(colunms, ...)]
values(valus, ...);

11. insert select
insert into tablename [(columns, ...)]
select colunms,... from tablename, ...
[where ...];

12. rollback
rollback [to savepointname];

13. savepoint
savepoint sp1;

14. select
select colunmname, ...
from tablename, ...
[where ...]
[union ...]
[group by ...]
[having ...]
[order by ...];

15. start transaction
start transaction;

16. update
update tablename
set colunmname = value, ...
[where ...];