mysql and php building tables

@pelegk1Dec 02.2003

1)can i build tables at run time from php?
2) can i add and remove after it col’s from my table?
thanks in advance
peleg

to post a comment

PHP

@pyroDec 02.2003 — #Yes and yes... ?

@pelegk1authorDec 03.2003 — #yes isnt not an answer!?

@pyroDec 03.2003 — #Actually, it is a perfect answer to your questions. ?

Anyway, for 1, a sample would look something like this:

[code=php]CREATE TABLE tablename (
 id int(11) NOT NULL auto_increment,
 name varchar(50) NOT NULL,
 PRIMARY KEY  (id)
 );[/code]

For two, something like this would add a new column named newcol, that is a VARCHAR field with a length of 50:

[code=php]ALTER TABLE tablename ADD newcol VARCHAR(50) NOT NULL;[/code]

And to drop the same column:

[code=php]ALTER TABLE test DROP test;[/code]

@Paul_JrDec 04.2003 — #Pyro, he said "isn't not", which is a double negative -- meaning he said it is an answer... unless he made a typo...

@pelegk1authorDec 04.2003 — #?

@pyroDec 04.2003 — #?

@Paul_JrDec 04.2003 — #:eek: Now I'm totally and officially confused...

mysql and php building tables

7 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

mysql and php building tables

7 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

7 Comments(s) _↴

Also in #PHP _↴