| |
|
|
| | Господа.
Подскажите, как сделать запрос, чтобы узнать информацию о структуре таблицы? | |
| |
|
|
| |
|
|
| |
для: Agronom
(25.08.2005 в 16:14)
| | | http://dev.mysql.com/doc/mysql/en/charset-show.html
mysql> SHOW FULL COLUMNS FROM t;
+-------+---------+------------+------+-----+---------+-------+
| Field | Type | Collation | Null | Key | Default | Extra |
+-------+---------+------------+------+-----+---------+-------+
| a | char(1) | latin1_bin | YES | | NULL | |
| b | int(11) | NULL | YES | | NULL | |
+-------+---------+------------+------+-----+---------+-------+ | |
| |
|
|
| |
|
|
| |
для: barfly
(25.08.2005 в 16:43)
| | |
<table>
<tr><td>Field</td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
<?
$query = mysql_query("DESCRIBE tbl");
while($fetch = mysql_feetch_array($query))
echo "<tr><td>$fetch[0]</td><td>$fetch[1]</td><td>$fetch[2]</td><td>$fetch[3]</td><td>$fetch[4]</td><td>$fetch[5]</td></tr>";
?>
</table>
|
| |
| |
|
|
