CREATE TABLE users ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, login_user TEXT NOT NULL, login_password TEXT NOT NULL)DEFAULT CHARACTER SET utf8 ENGINE=INNODB
写入用户
1
INSERT INTO users(login_user,login_password) VALUES ('root','root')
建立内容表单
12345
CREATE TABLE joke (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,joketext TEXT,jokedate DATE NOT NULL)DEFAULT CHARACTER SET utf8 ENGINE=INNODB
更新内容表单
1234
INSERT INTO joke (joketext,jokedate) VALUES ("Why did the chicken cross the road? To get to the other side!","2012-04-01")
