* Massimo Bandinelli > I've problems sincronizing a Slave DB with a Master. > > I've a db created with name "foo-db" from phpmyadmin but the > mysql shell doesn't accept > > > create database foo-db; > > Do you know something about this??
The '-' character makes this name difficult for the mysql parser to understand, it could be interpreted as "foo minus db" (even though this would not make sense in a CREATE DATABASE statement). Use backticks: mysql> create database `foo-db`; Query OK, 1 row affected (0.36 sec) -- Roger --------------------------------------------------------------------- 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
