[EMAIL PROTECTED] (Jonathan Villa) writes:
> Is there was to get a database's table schema?

I don't think it's called schemas in mysql, but I'm not sure :-)

> So far, I have a simple function which will output 
> INSERT INTO table (x,x,x,) VALUES(x,x,x);
> [ ... ]
> but what I'm missing is 
> CREATE table blah, blah, blah

mysqldump is the tool you need.

e.g.
  $ mysqldump -u user [-p] Database > db_dump_file.sql

man mysqldump for more info.


-- 
--Fredrik
If God is dead, who will save the Queen?

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to