Re: MySQL table design
| From: | Bastien | Date: | Fri, 23 Mar 2012 00:49:22 +0000 |
| Subject: | Re: MySQL table design | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-317194@lists.php.net to get a copy of this message | ||
On 2012-03-22, at 8:10 PM, Chris Stinemetz <chrisstinemetz@gmail.com> wrote:
> Hello List,
>
> Is it possible to create a MySQL table with characters such as "." and
> "[]" in the column headers? If so would you explain how?
>
> Thank you,
>
> Chris
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
Periods are not allowed, nor other characters that are reflected in file paths.
You can use the back tick to wrap the field names, but I really don't recommend it. If you ever
need to port this to another DB, it might not be as forgiving
Bastien