Posted by Captain Paralytic on 07/12/07 09:38

On 12 Jul, 09:54, Nicholas <Nicholas.A...@gmail.com> wrote:
> 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)

Please try again!

I said:
"Can you post a dump of the table schema (the CREATE TABLE command
that
comes out of PMA would be great."

You sent the output from "show tables".

Please post what I asked for, and ensure that you have the option for
"Enclose table and field names with backquotes" ticked.

[Back to original message]