建立登陆表单
| 1234 | 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") |