php学习笔记（六)数据库表的关联

创建表并插入几条记录的代码

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 SET
joketext = 'Why did the chicken cross the road? To get to the other side!',
jokedate = '2009-04-01';
INSERT INTO joke 
(joketext,jokedate) VALUES(
    'Knock-knock!who\'s there?Boo!who?Don\'t cry；it\'s only a joke!',
    "2009-04-01");

#通过放置反斜杠来对内容中的单引号进行转义

给表添加列

ALTER TABLE joke ADD COLUMN authorname VARCHAR(255);#VARCHAR(255)表示可变长度的字符串，最多包含255个字符
ALTER TABLE joke ADD COLUMN authoremail VARCHAR(255);#添加列

删除表中的列

ALTER TABLE joke DROP COLUMN authorname;#删除表中的列

ALTER TABLE joke DROP COLUMN authoremail;#删除表中的列

建立新表

CREATE TABLE author (
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
    )DEFAULT CHARACTER SET utf8 ENGINE=INNODB

给表添加新列

ALTER TABLE joke ADD COLUMN authorid INT

添加内容