parsed.org

Tips by tag: table

Dumping A Table by xinu on Oct 25, 2007 05:39 PM

Dumping an entire database is easy, but dumping a single table requires a few options:

$ mysqldump --opt -u <username> -p <database> <table> > outfile.sql
mysqlmysqldumpsingletable
Show Table/View Definition by xinu on Dec 14, 2007 10:03 AM

In MySQL you can describe tables to get their columns and types, but if you need to get the SQL that created them, you can run the following:

mysql> show create table <table_or_view_name>;
definintionmysqltableview
RSS