Log in or Sign up

Plz Help Me To Write This Query

Discussion in 'Databases' started by ironmankho, Feb 1, 2013.

ironmankho Active Member

Messages:

393

Likes Received:

2

Best Answers:

0

Trophy Points:

55

#1

hi
i am totally noob in mysql can you able to write query for generate tabel like this .

Solved! View solution.

ironmankho, Feb 1, 2013 IP
tiamak Active Member Best Answer

Messages:

81

Likes Received:

2

Best Answers:

3

Trophy Points:

58

#2

CREATE TABLE `table_name` (
`id` smallint(5) NOT NULL AUTO_INCREMENT,
`url` text NOT NULL,
`shortened` char(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Click to expand...

tiamak, Feb 1, 2013 IP
gavo Active Member

Messages:

123

Likes Received:

4

Best Answers:

1

Trophy Points:

70

#3

You could browse the table in phpmyadmin then click export, select structure only and you will have the query to create the same table.

If you want the query to insert data into the table, browse the table in phpmyadmin, click insert, fill in the values and you will see the generated query

gavo, Feb 14, 2013 IP

(You must log in or sign up to reply here.)