SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:12 AM
| |||
| |||
 Re: What is MySQL's field delimiter ?? Stefano Del Furia wrote: > Hi all, > i have a table that have some fields that have names with spaces. > I know that some databases use [] as delimiter but this don't works > with MySQL > What is MySQL's field delimiter ?? > Thanks in advance > Stefano It is a backtick: ` But do not mix it up with ', " or ´ Greetings Kai -- This signature is left as an exercise for the reader.      |
|
02-28-2008, 07:12 AM
| |||
| |||
| Re: What is MySQL's field delimiter ?? Thanks but how can i type it on keyboard ?? what is the ascii code ? thank again Stefano In data Wed, 07 Dec 2005 21:03:29 +0100, Kai Ruhnau <kai.newsgroup@tragetaschen.dyndns.org> ha scritto: > Stefano Del Furia wrote: >> Hi all, >> i have a table that have some fields that have names with spaces. >> I know that some databases use [] as delimiter but this don't works >> with MySQL >> What is MySQL's field delimiter ?? >> Thanks in advance >> Stefano > > It is a backtick: > ` > > But do not mix it up with ', " or ´ > > Greetings > Kai |
|
02-28-2008, 07:12 AM
| |||
| |||
| Re: What is MySQL's field delimiter ?? Stefano Del Furia wrote: > In data Wed, 07 Dec 2005 21:03:29 +0100, Kai Ruhnau > <kai.newsgroup@tragetaschen.dyndns.org> ha scritto: > >> Stefano Del Furia wrote: >> >>> Hi all, >>> i have a table that have some fields that have names with spaces. >>> I know that some databases use [] as delimiter but this don't works >>> with MySQL >>> What is MySQL's field delimiter ?? >>> Thanks in advance >>> Stefano >> >> >> It is a backtick: >> ` >> >> But do not mix it up with ', " or ´ >> > Thanks > but how can i type it on keyboard ?? > what is the ascii code ? > thank again > Stefano Please stop top posting. It depends on your keyboard layout. On the german keyborad it is shift-[first key left of backspace] and mostly a deadkey. That means pressing it will not print it immediately. A workaround is to press space right after pressing the key for `. On an us keyboard layout it is the key left of 1 (one). See http://en.wikipedia.org/wiki/Keyboard_layout Greetings Kai -- This signature is left as an exercise for the reader. |
|
02-28-2008, 07:12 AM
| |||
| |||
| Re: What is MySQL's field delimiter ?? > i have a table that have some fields that have names with spaces. > I know that some databases use [] as delimiter but this don't works with Not "some", only on MS SQL Server and MS Access :-) > MySQL > What is MySQL's field delimiter ?? The name delimiter is the back-tick: ` (on my keyboard, it's on the same key as the ~ , left of the "1"). In MySQL ANSI mode, you can also use the SQL standard " as in: "name with spaces" instead of `name with spaces` In general, I would say: don't use them unless you have to. -- Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com |
|
02-28-2008, 07:12 AM
| |||
| |||
| Re: What is MySQL's field delimiter ?? In data Wed, 07 Dec 2005 22:26:21 +0100, Martijn Tonies <m.tonies@upscene.removethis.com> ha scritto: > >> i have a table that have some fields that have names with spaces. >> I know that some databases use [] as delimiter but this don't works with > > Not "some", only on MS SQL Server and MS Access :-) > >> MySQL >> What is MySQL's field delimiter ?? > > The name delimiter is the back-tick: ` (on my keyboard, it's on the > same key as the ~ , left of the "1"). > > In MySQL ANSI mode, you can also use the SQL standard " as in: > "name with spaces" instead of `name with spaces` > > In general, I would say: don't use them unless you have to. > Thanks a lot. Where can i change MySQL'mode to ANSI ??? Thanks again Stefano |
|
02-28-2008, 07:12 AM
| |||
| |||
| Re: What is MySQL's field delimiter ?? Stefano Del Furia wrote: > Where can i change MySQL'mode to ANSI ??? It's documented in the manual. Read this page: http://dev.mysql.com/doc/refman/5.0/...-sql-mode.html Regards, Bill K. |
Linear Mode
