MySQL 语句

CREATE DATABASE LY_APP;

如果是MySQL，可以使用AUTO_INCREMENT关键字，表示自增长。

CREATE TABLE tb_user (userId INTEGER NOT NULL PRIMARY KEY ,

userName VARCHAR(20) NOT NULL,

userAge INT ,

userAddress VARCHAR(30))

INSERT INTO tb_user VALUES (3,'liyang3', 35,'北京');

SELECT * FROM tb_user;

mysql 用Oricon 不一样 用top 1

SELECT * FROM tb_user WHERE userAge = 25 LIMIT 1;

更新

UPDATE tb_user SET userName = 'liyang1' WHERE userName = 'liyang';

ALTER TABLE tb_user ADD userSex INT NOT NULL DEFAULT 1;

ALTER TABLE tb_user CHANGE userSex userHeight INT NOT NULL DEFAULT 100;

ALTER TABLE tb_user userId DROP PRIMARY KEY(col);

ALTER TABLE tb_user CHANGE userId user_id INTEGER NOT NULL auto_increment PRIMARY KEY;