首页 > IT职业 > IT生活 > php项目之mysql准备
建立登陆表单
| 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")
|
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/2637/viewspace-2801486/ ,如需转载,请注明出处,否则将追究法律责任。