LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   mysql tables with a - (http://www.linuxquestions.org/questions/linux-software-2/mysql-tables-with-a-61324/)

pk21 05-23-2003 03:36 AM

mysql tables with a -
 
Hi all,

A friend of mine made a database, but he named his tables like forum-thread. Mysql doesnt like those "-" signs in tables :(

mysql> select * from forum-thread;
ERROR 1064: You have an error in your SQL syntax near '-thread' at line 1

Does anyone know if i can adjust mysqld to accept the "-" in table names?

jharris 05-23-2003 04:00 AM

Use backticks around the table name
Code:

mysql> create table `test-table` (id int);
Query OK, 0 rows affected (0.01 sec)

mysql> drop table `test-table`;
Query OK, 0 rows affected (0.00 sec)

http://www.mysql.com/doc/en/Legal_names.html

HTH

Jamie...

pk21 05-23-2003 04:02 AM

Ok, thanks.

Do i also have to use backticks in my phpscripts if i want to retrieve something from the database?

jharris 05-23-2003 04:14 AM

I would guess so as I don't think that PHP will automatically delimit this. Give it a go and see if you get an error.

cheers

Jamie...

pk21 05-23-2003 04:32 AM

Thanks for all the help.

But it seems this wasnt the problem, it is a query which i (and mysql) really don't understand :(

jharris 05-23-2003 04:44 AM

Why, what you trying to get working?

Jamie...

pk21 05-23-2003 06:23 AM

The guy who made the database and php scripts just has a query that won't work. I think the query is too large. I've advised him to use indexes. I hope it works.

jharris 05-23-2003 06:27 AM

I've never know a query be too large, although if he's not making proper use of indexes so the query is taking a long time (>30 secs by default) then PHP will time out. You can change this in your php.ini find mind you.

cheers

Jamie...


All times are GMT -5. The time now is 05:59 AM.