[PHP-DB] enum !!

2001-07-16 Thread McShen
how do i store multiple data in one field? i have a table like this +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | test | enum('a','b','c') | YES | |

Re: [PHP-DB] Re: enum !!

2001-07-16 Thread McShen
omeplace similar...you might find an environment like that better than the PHP-DB list to help you with this stuff. Doug At 02:56 PM 7/16/01 -0400, McShen wrote: ok. I use set to make a table. here is my table 'test' +---+--+ | name | cat | +---+--+ | shen | a,c | | she

[PHP-DB] duplicate a table

2001-04-02 Thread McShen
how do i duplicate a table? i tried create table refer2 select * from refer; create table refer2 as select * from refer; they didn't work. my mysql version is mysql 3.22.28, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional