|
|
Posted by Kimmo Laine on 12/23/05 09:57
"lawrence k" <lkrubner@geocities.com> wrote in message
news:1135323786.086492.272160@o13g2000cwo.googlegroups.com...
> If I write an update script, so people can upgrade their software to
> the newest version I've written, and since the last version I've
> created a new table in the database, so I want to add it, if it does
> not already exist, is the syntax something like
>
> create table if not exists subscribers
>
Exactly like that.
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
[(create_definition,...)]
[table_options] [select_statement]
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
--
"En ole paha ihminen, mutta omenat ovat elinkeinoni." -Perttu Sirviφ
antaatulla.sikanautaa@gmail.com.NOSPAM.invalid
Navigation:
[Reply to this message]
|