Table name problem
am 05.10.2006 08:50:05 von Ata ur Rehman
------=_Part_121194_5380957.1160031005949
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Dear All
I used a tool Access2MySQL to convert my database from Access to MySQL. (I
am using version 4). There was a table Book Record in Access. Access alow
spaces between table names.
When i use the command:
MySQL>show tables;
I found that table in the list as
....
....
Book Record
.....
.....
But when i want to use it for data entry as
Insert into Book Record (........
I found the error, table not exist..
What should i do?
------=_Part_121194_5380957.1160031005949--
Re: Table name problem
am 05.10.2006 09:28:10 von Tata Respecia
use single quotes like this:
Insert into `Book Record` (........
--- Ata ur Rehman wrote:
> Dear All
>
> I used a tool Access2MySQL to convert my database
> from Access to MySQL. (I
> am using version 4). There was a table Book Record
> in Access. Access alow
> spaces between table names.
> When i use the command:
> MySQL>show tables;
> I found that table in the list as
>
> ...
> ...
> Book Record
> ....
> ....
>
> But when i want to use it for data entry as
>
> Insert into Book Record (........
>
> I found the error, table not exist..
>
>
> What should i do?
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Re: Table name problem
am 05.10.2006 20:04:24 von Randy Clamons
Those are back ticks. Single quotes won't do it.
Randy Clamons
Systems Programming
randy@novaspace.com
Tata Respecia wrote:
> use single quotes like this:
>
> Insert into `Book Record` (........
>
>
>
>
> --- Ata ur Rehman wrote:
>
>> Dear All
>>
>> I used a tool Access2MySQL to convert my database
>> from Access to MySQL. (I
>> am using version 4). There was a table Book Record
>> in Access. Access alow
>> spaces between table names.
>> When i use the command:
>> MySQL>show tables;
>> I found that table in the list as
>>
>> ...
>> ...
>> Book Record
>> ....
>> ....
>>
>> But when i want to use it for data entry as
>>
>> Insert into Book Record (........
>>
>> I found the error, table not exist..
>>
>>
>> What should i do?
>>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
RE: Table name problem
am 05.10.2006 23:07:36 von Charles Mabbott
Can I suggest using the '_' for example
Book_Record
Because spaces in Access are treated internally a little
Different. Look at the queries in SQL mode and you'll see
what I mean. The easiest way is use the '_' rather than a
a space.
--
Chuck
>SELECT * FROM users WHERE clue = TRUE;
0 rows returned
Ahhh they are clueless!
-----Original Message-----
From: Randy Clamons [mailto:randy@novaspace.com]
Sent: Thursday, October 05, 2006 2:04 PM
To: win32@lists.mysql.com
Subject: Re: Table name problem
Those are back ticks. Single quotes won't do it.
Randy Clamons
Systems Programming
randy@novaspace.com
Tata Respecia wrote:
> use single quotes like this:
>
> Insert into `Book Record` (........
>
>
>
>
> --- Ata ur Rehman wrote:
>
>> Dear All
>>
>> I used a tool Access2MySQL to convert my database
>> from Access to MySQL. (I
>> am using version 4). There was a table Book Record
>> in Access. Access alow
>> spaces between table names.
>> When i use the command:
>> MySQL>show tables;
>> I found that table in the list as
>>
>> ...
>> ...
>> Book Record
>> ....
>> ....
>>
>> But when i want to use it for data entry as
>>
>> Insert into Book Record (........
>>
>> I found the error, table not exist..
>>
>>
>> What should i do?
>>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=crmabbott@comcast.net
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Re: Table name problem
am 05.10.2006 23:24:19 von Charles Mabbott
There an approach of '_' between the words also
Chuck
Tata Respecia wrote:
__________
>use single quotes like this:
>
>Insert into `Book Record` (........
>
>
>
>
>--- Ata ur Rehman wrote:
>
>> Dear All
>>
>> I used a tool Access2MySQL to convert my database
>> from Access to MySQL. (I
>> am using version 4). There was a table Book Record
>> in Access. Access alow
>> spaces between table names.
>> When i use the command:
>> MySQL>show tables;
>> I found that table in the list as
>>
>> ...
>> ...
>> Book Record
>> ....
>> ....
>>
>> But when i want to use it for data entry as
>>
>> Insert into Book Record (........
>>
>> I found the error, table not exist..
>>
>>
>> What should i do?
>>
>
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam? Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>--
>MySQL Windows Mailing List
>For list archives: http://lists.mysql.com/win32
>To unsubscribe: http://lists.mysql.com/win32?unsub=crmabbott@
omcast.net
>
>.
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org
Re: Table name problem
am 06.10.2006 02:54:52 von Dijital
Access allows you to do all sorts of things that you shouldn't be
allowed to do where databases are concerned. When it allows you to make
a column named '+/-' you know there's going to be trouble if you ever
try to move the data into another platform.
Simple rule of thumb, the only special character you should ever use is
an underscore. It will save you tons of headache. Cheers.
Armando
Charles Mabbott wrote:
> Can I suggest using the '_' for example
> Book_Record
>
> Because spaces in Access are treated internally a little
> Different. Look at the queries in SQL mode and you'll see
> what I mean. The easiest way is use the '_' rather than a
> a space.
>
>
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org