can't create table

kv79

hi all,

$sql = "CREATE TABLE $title(

topic1 varchar(500) ,                 

topic1_num int(50) 


)";

I can create tables without space like (e. "dabar" , "house",..)
I can't create tables with space like (e. "da ba r" , "h use",..)

thanks for reading

Jareh

As far as I know, you cannot create tables with spaces in the name.

bradgrafelman

Identifier names may certainly have spaces if you so choose, but note that any identifier with a space in it must be surrounded with backticks (`) so that MySQL knows where the identifier begins and ends (just like a string in PHP).

Not only does this mean you'll need the backticks in your CREATE TABLE query, but also in every other query that deals with (or might possibly deal with, in the case of variable table/column/database names) as well.

For more information, see this page in the MySQL manual (assuming you're using MySQL, that is) in regards to Schema Object Names.

kv79

OK, thanks

I done it ,

I have another problem

can't create tables with Large letter .

I can't see resolved .

bradgrafelman

What in the world is a large letter? Can you show us an example of a table name that doesn't work?

kv79

e .
I can create ( "tata" ,"t a t a ")
but can' t ( "TaTa" , "T A T A" )

bradgrafelman

Can you show us how you tried to create the tables?

Works fine for me:

mysql> CREATE TABLE `T A T A` (
    ->     foo VARCHAR(50)
    -> );
Query OK, 0 rows affected (0.11 sec)

kv79

$sql = "CREATE TABLE `test`.`$title`(

topic1 varchar(500) ,                 

topic1_num int(50) 


)";

kv79

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
Look at this **** , only UNIX system support case sensitive .
OMFG i have IDIOTIC WIN XP .🙁

kv79

I am using PHP to create tables .
Is it not same from the command line .
Did you ever try to use InnoDB ?
I dunno how to solve this problem about case sensitive .
I could try with PHP code , did you ever come to this problem ? What was solution ?

illzz

kv79 wrote:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
Look at this **** , only UNIX system support case sensitive .
OMFG i have IDIOTIC WIN XP .🙁

If you read the part at the bottom, there is a way to sort of mimic this on Windows using the lower_case_table_names variable.

Do you really want to be able to create separate databases whose names differ only by case? I can see a lot of confusion stemming from that.

Drakla

Always, always, always create tables with lower case just in case you do have to port to a different system. It really saves you from wanting to punch some other guys face in whose work you've been given to fix when he's run off the job.