Php And Mysql

Front 1

Create a database named jokes

Back 1

create database jokes;

Front 2

Specify that you want to work with the database jokes.

Back 2

use jokes;

Front 3

Create a table named Jokes, with fields called ID, JokeText, and JokeDate.

Back 3

create table Jokes (
ID int not null auto_increment primary key,
JokeText text,
JokeDate date
);

Front 4

See all the tables in a database.

Back 4

show tables;

Front 5

Add a record.

Back 5

insert into Jokes set
JokeText = "Why did the chiecken cross the road. To get to the other side.",
JokeDate = "2004-12-25";

Front 6

See all the tables in the database jokes.

Back 6

show tables;

Front 7

See the structure of the table Jokes.

Back 7

describe Jokes;

Front 8

Delete the table Jokes.

Back 8

drop table Jokes;

Front 9

Add a joke and the date to the table Jokes.

Back 9

insert in Jokes set
JokeText="Why did the chicken cross the road?",
JokeDate="2004-12-15";

Front 10

See all the records in Jokes.

Back 10

select * from Jokes;

Front 11

See all the IDs and JokeText in Jokes.

Back 11

select ID, JokeText from Jokes;

Front 12

See the first 20 characters of JokeText and also the date in Jokes.

Back 12

select left(JokeText,20), JokeDate from Jokes;

Front 13

Find out how many records are in Jokes.

Back 13

select count(*) from Jokes;

Front 14

See how many records there are with a date after or on Dec. 10, 2004.

Back 14

select count(*) from Jokes where JokeDate >= "2004-12-10";

Front 15

See all JokeText that contains the word "chicken."

Back 15

select JokeText from Jokes where JokeText like "%chicken%";

Front 16

See all the JokeText that contains the word "knock" that has a JokeDate later or on Dec. 10, 2004 and before Jan. 1 2005.

Back 16

select JokeText from Jokes where
JokeText like "%knock%" and
JokeDate >= "2004-12-10" and
JokeDate < "2005-01-01";

Front 17

Change the JokeDate of the first record to Dec. 16, 2004.

Back 17

update Jokes set JokeDate = "2004-12-16" where ID = 1;

Front 18

Change JokeDate to Jan. 1, 2005, for all jokes that contain the word "chicken."

Back 18

Update Jokes set JokeDate = "2005-01-01"
where JokeText like "%chicken%";

Front 19

Delete all jokes that contain the word "chicken."

Back 19

delete from Jokes where JokeText like "%chicken%";

Front 20

Empty the Jokes table.

Back 20

delete from Jokes;