At 16:51 +0100 12/18/02, [EMAIL PROTECTED] wrote:
Hello

I have hade several problems with the character '-' (dash, minus, or
whatever you wan't to call it) the parser seems to regardles of quoting be
seen as an substraction operator.
Give us an example of where you use it within a quoted name and get a
failure.  Dashes are legal, at least at long as you quote with backtick:

mysql> create table `a-b` (`c-d` int);
Query OK, 0 rows affected (0.00 sec)

mysql> show create table `a-b`;
+-------+-----------------------------------------------------------------+
| Table | Create Table                                                    |
+-------+-----------------------------------------------------------------+
| a-b   | CREATE TABLE `a-b` (
  `c-d` int(11) default NULL
) TYPE=MyISAM |
+-------+-----------------------------------------------------------------+
1 row in set (0.00 sec)

 Does anybody recognice this, have I just
missed the part where the characters allowed in names and passwords is
specified.

antispam device: sql, query, queries, smallint

Merry Christmas/Happy Hannuka/Happy holidays & A Happy New Year

--
 &ers


-------------------------------------
Anders Nygård

---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to