Hi,
After connectig to a database i whant to check if a database is already created and with a specific structure.
As an example:mysql> describe Teste;
+---------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| field01 | int(11) | NO | PRI | NULL | |
| field02 | int(11) | YES | | NULL | |
+---------+---------+------+-----+---------+-------+
+---------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| field01 | int(11) | NO | PRI | NULL | |
| field02 | int(11) | YES | | NULL | |
+---------+---------+------+-----+---------+-------+
To copy to clipboard, switch view to plain text mode
What sort of query showld i use?
Thanks
Bookmarks