Sql语句基础

基础建表Sql
create database databasename;
show database;
use database;

create table tablename(
id int auto_increment,
name varchar(50) not null default '',
gender char(1) not null default '0',
primary key(id)
);
show tables;
desc tablename;

create index indexname on tablename(column1,column2);
show index from tablename;


drop table tablename;
drop index indexname on student;

alter table tablename modify columnname datatype;