Re: [PHP] MySQL DB Schema

2003-02-18 Thread David Otton
On Tue, 18 Feb 2003 09:23:52 -0800, you wrote: Greetings all, Is there an easy way to pull out the schema of a MySQL for viewing?? You want the tables and the relationships between them? Not easy to get the links because of the lack of foreign keys in MySQL. If you want a table, DESC

Re: [PHP] MySQL DB Schema

2003-02-18 Thread Erik Price
On Tuesday, February 18, 2003, at 12:23 PM, Phillip S. Baker wrote: Is there an easy way to pull out the schema of a MySQL for viewing?? If you have access to the command line (either directly or via the system() function), try this: bash 2.05 $ mysqldump -t databasename --user=username

Re: [PHP] MySQL DB Schema

2003-02-18 Thread Erik Price
On Tuesday, February 18, 2003, at 12:39 PM, David Otton wrote: You want the tables and the relationships between them? Not easy to get the links because of the lack of foreign keys in MySQL. You can add a comment to your table with the COMMENT modifier, which gives you 60 characters to