![]() |
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| MySQL DevZone RSS MySQL Developer Zone RSS |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Escape character in sed | pvedaa | Shell Programming and Scripting | 1 | 12-25-2008 01:08 PM |
| Escape character - sed | c00kie88 | Shell Programming and Scripting | 6 | 10-08-2008 03:33 AM |
| Escape character | deepakpv | Shell Programming and Scripting | 4 | 02-16-2007 03:19 AM |
| awk / escape character | OFFSIHR | Shell Programming and Scripting | 8 | 11-29-2006 01:28 PM |
| possible to escape the \ character in sed? | gammaman | UNIX for Dummies Questions & Answers | 1 | 07-07-2005 03:49 PM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
||||
|
Default escape character in MySQL
what is the default escape character in MySQL?
We have in ORACLE like ' " ', in MSSQL like ' [] ' which is used while creating table. MSSQL create table [aa/njh] (col1 INT); ORACLE create table "aa/njh" (col1 INT); If I use both( ", []) in MYSQL while create table it is not working fine. My aim is to have table name with special character on numeric. Also What is the default schema name in MySQL 5.1.34 like in ORACLE is username (system), in MSSQL is "dbo"? I think it is database name Isn't it? -----Post Update----- i got solution as : mysql> CREATE TABLE "test" (col INT); ERROR 1064: You have an error in your SQL syntax... mysql> SET sql_mode='ANSI_QUOTES'; mysql> CREATE TABLE "test" (col INT); Query OK, 0 rows affected (0.00 sec) |
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|