php项目笔记（一）mysql准备
建立登陆表单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
写入用户
INSERT INTO users(login_user,login_password) VALUES ('root','root')
建立内容表单
CREATE TABLE joke (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
joketext TEXT,
jokedate DATE NOT NULL
)DEFAULT CHARACTER SET utf8 ENGINE=INNODB
更新内容表单
INSERT INTO joke
(joketext,jokedate) VALUES (
"Why did the chicken cross the road? To get to the other side!",
"2012-04-01")
页:
[1]