Posted by Nicholas on 07/12/07 08:54

sure. appreciate the effort

Enter password: *********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 36 to server version: 5.0.24a-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use perth_special;
Database changed
mysql> show tables;
+-------------------------+
| Tables_in_perth_special |
+-------------------------+
| features |
+-------------------------+
1 row in set (0.11 sec)

mysql> desc features;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| feature | varchar(99) | YES | | NULL | |
| name | varchar(255) | NO | | | |
| longitude | float | NO | | | |
| latitude | float | NO | | | |
+-----------+--------------+------+-----+---------+-------+
4 rows in set (0.05 sec)

[Back to original message]