Re: how to copt table not whole database
Dan, thank you very much. That's what I want. Xiaobo > > Xiaobo, > > Using mysqldump, you can specify which tables to copy. The man for > mysqldump > is as such: mysqldump [options] [dbname [tablename]] > > Say db 'db' has tables x, y, and z in it. You only want to copy table x. > mysqldump db x > x.sql(or whatever you want to name it). > > Dan > > Thank you Shawn. What I originally thought is that if there is any command > like 'sqldump' to copy a few tables of a database. > > Xiaobo > >> "Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 01/16/2006 03:33:36 PM: >>> Hi, all >>> >>> How should I copy a table of a database? >>> >>> Thanks in advance. >>> >>> Xiaobo >>> -- >>> Faculty of Computer Science >>> Dalhousie University >>> Halifax, Nova Scotia >>> Canada >> >> Do you want the data or the structure too? >> >> Just the data: >> >> CREATE TABLE newtable SELECT * from oldtable; >> >> Data and the original structure (no foreign keys): >> >> CREATE TABLE newtable LIKE oldtable; >> INSERT newtable SELECT * FROM oldtable; >> >> Both forms of CREATE TABLE documented here: >> http://dev.mysql.com/doc/refman/4.1/en/create-table.html >> >> Shawn Green >> Database Administrator >> Unimin Corporation - Spruce Pine > > -- > Faculty of Computer Science > Dalhousie University > Halifax, Nova Scotia > Canada > > -- Master of Applied Computer Science Faculty of Computer Science Dalhousie University Halifax, Nova Scotia Canada -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to copt table not whole database
Xiaobo, Using mysqldump, you can specify which tables to copy. The man for mysqldump is as such: mysqldump [options] [dbname [tablename]] Say db 'db' has tables x, y, and z in it. You only want to copy table x. mysqldump db x > x.sql(or whatever you want to name it). Dan Thank you Shawn. What I originally thought is that if there is any command like 'sqldump' to copy a few tables of a database. Xiaobo > "Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 01/16/2006 03:33:36 PM: >> Hi, all >> >> How should I copy a table of a database? >> >> Thanks in advance. >> >> Xiaobo >> -- >> Faculty of Computer Science >> Dalhousie University >> Halifax, Nova Scotia >> Canada > > Do you want the data or the structure too? > > Just the data: > > CREATE TABLE newtable SELECT * from oldtable; > > Data and the original structure (no foreign keys): > > CREATE TABLE newtable LIKE oldtable; > INSERT newtable SELECT * FROM oldtable; > > Both forms of CREATE TABLE documented here: > http://dev.mysql.com/doc/refman/4.1/en/create-table.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine -- Faculty of Computer Science Dalhousie University Halifax, Nova Scotia Canada -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to copt table not whole database
Thank you Shawn. What I originally thought is that if there is any command like 'sqldump' to copy a few tables of a database. Xiaobo > "Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 01/16/2006 03:33:36 PM: > >> Hi, all >> >> How should I copy a table of a database? >> >> Thanks in advance. >> >> Xiaobo >> -- >> Faculty of Computer Science >> Dalhousie University >> Halifax, Nova Scotia >> Canada >> > > Do you want the data or the structure too? > > Just the data: > > CREATE TABLE newtable SELECT * from oldtable; > > Data and the original structure (no foreign keys): > > CREATE TABLE newtable LIKE oldtable; > INSERT newtable SELECT * FROM oldtable; > > Both forms of CREATE TABLE documented here: > http://dev.mysql.com/doc/refman/4.1/en/create-table.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine -- Faculty of Computer Science Dalhousie University Halifax, Nova Scotia Canada -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to copt table not whole database
"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 01/16/2006 03:33:36 PM: > Hi, all > > How should I copy a table of a database? > > Thanks in advance. > > Xiaobo > -- > Faculty of Computer Science > Dalhousie University > Halifax, Nova Scotia > Canada > Do you want the data or the structure too? Just the data: CREATE TABLE newtable SELECT * from oldtable; Data and the original structure (no foreign keys): CREATE TABLE newtable LIKE oldtable; INSERT newtable SELECT * FROM oldtable; Both forms of CREATE TABLE documented here: http://dev.mysql.com/doc/refman/4.1/en/create-table.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
how to copt table not whole database
Hi, all How should I copy a table of a database? Thanks in advance. Xiaobo -- Faculty of Computer Science Dalhousie University Halifax, Nova Scotia Canada -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
