Re: Must use '#' in fieldnames

[Werner Stuerenburg <ws@xxxxxxxxxxxxxxx>]

> create table test (
>     a35#70 char (70));


Looks like the reason is # is the remark sign like // in php

Why don't you call the columns any name? Then you write

INSERT INTO table
        (col1, col2)
        VALUES ('a35#70', 'id')

or whatever.


-- 
Herzlich
Werner Stuerenburg            

_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread77928@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php