积累SQL语句

 CREATE DATABASE register_homework
 
 USE register_homework;
 
	CREATE TABLE `register`(
		`name` VARCHAR(30) NOT NULL,
		`age`  INTEGER(10) DEFAULT NULL,
		`sex` VARCHAR(10) DEFAULT NULL,
		`major` VARCHAR(30) DEFAULT NULL,
		`adress` VARCHAR(30) DEFAULT NULL,
		`email` VARCHAR(30) DEFAULT NULL,
		PRIMARY KEY(`username`)
	);
	
	INSERT INTO register(`name`,`age`,`sex`,`major`,`adress`,`email`) 
	VALUES('bob','14','男','chemistry','shenzhen','456123@email.com')	

积累一些sql语句，太弱了

CREATE DATABASE `user_register`;

USE  `user_register`;

CREATE TABLE `register` (
  `id` INT   PRIMARY KEY AUTO_INCREMENT ,
  `name` VARCHAR(30) DEFAULT NULL,
  `major` VARCHAR(30) DEFAULT NULL,
  `address` VARCHAR(30) DEFAULT NULL,
  `email` VARCHAR(30) DEFAULT NULL,
  `sex` VARCHAR(10) DEFAULT NULL

);
 INSERT INTO `register`(`id`,`name`,`major`,`address`,`email`,`sex`) 
 VALUES(NULL,'小明','math','shanghai','123412@email.com','男')