RE: [PHP-DB] Does MySQL support tables with numbers in them?
| From: | Craig Vincent | Date: | Tue, 08 Aug 2000 20:25:10 +0000 |
| Subject: | RE: [PHP-DB] Does MySQL support tables with numbers in them? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1869@lists.php.net to get a copy of this message | ||
> > Can I create a table that has a number as part of its name:
> >
> > $a = 555555;
> >
> > $sql="CREATE TABLE " . $a . "_person_num (person_num int primary key,
> > quantity int, cost MONEY)";
> >
> > The above sql returns an error. Is there a way around this?
I think your problem is with your syntax...not the fact you're using a
number. MONEY is not AFAIK a column type of mysql...you'll probably want to
use the decimal column type instead...I bet you that will solve your problem
Sincerely,
Craig Vincent
-------------------------
Senior Programmer
Jazzmonkey Media Inc.
http://www.jazzmonkey.com
-------------------------
> >
> > Thanks,
> > Dave
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net