Re: multilple mysql engines, one set of shared table spaces? (addendum)

On 5/14/2014 3:45 PM, shawn l.green wrote: Hello Bruce, On 5/14/2014 2:11 PM, Bruce Ferrell wrote: OK, put away the flamethrowers, I KNOW it's dumb. I've been asked for the upteenth time is this possible and if so under what conditions? So I pose the question to the community, is it? Under

Re: multilple mysql engines, one set of shared table spaces?

Hello Bruce, On 5/14/2014 2:11 PM, Bruce Ferrell wrote: OK, put away the flamethrowers, I KNOW it's dumb. I've been asked for the upteenth time is this possible and if so under what conditions? So I pose the question to the community, is it? Under what conditions? Is it reliable or not? Are t

Re: multilple mysql engines, one set of shared table spaces?

As far as I know, the only way this is possible is if your entire database is formatted as MyISAM. In that case, multiple MySQL processes, each started with external-locking enabled, may safely share a data folder. The contention will almost certainly kill you as far as performance goes.. and i

multilple mysql engines, one set of shared table spaces?

OK, put away the flamethrowers, I KNOW it's dumb. I've been asked for the upteenth time is this possible and if so under what conditions? So I pose the question to the community, is it? Under what conditions? Is it reliable or not? Are there authoritative references to support the answers?

Re: Importing MS SQL exported CSV files adds spaces

u SQL Server export will be Unicode, UTF8 or UTF16 ... thus the appearance of the extra spaces. (That's just coincidence, they're not really extra spaces ... the text editor you're viewing the file with is treating the data as ASCII, and not recognising the multi-byte nature of the ch

Re: Importing MS SQL exported CSV files adds spaces

> try "OPTIONALLY ENCLOSED BY ' " ' already tried that. no help :( saqib http://doctrina.wordpress.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Importing MS SQL exported CSV files adds spaces

I exported a large data set from from Microsoft SQL server in CSV format. However whenever I try to import that data to a a mySQL server running on Linux, it adds a space between each character in each field. Essentially: Saqib Ali becomes S a q i b A l i I have tried to use the dos2unix cmd on

RE: Spaces in sourced file names?

e.com >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Monday, July 21, 2008 4:50 PM >To: Jerry Schwartz; mysql@lists.mysql.com >Subject: Re: Spaces in sourced file names? > >Ls -la file\ name.file > > >\ >Will escape the space for

Re: Spaces in sourced file names?

Ls -la file\ name.file \ Will escape the space for ya me believes --Original Message-- From: Jerry Schwartz To: mysql@lists.mysql.com Sent: Jul 21, 2008 13:48 Subject: Spaces in sourced file names? In the CLI, is there any way to source a file whose name has whitespace in it

Spaces in sourced file names?

In the CLI, is there any way to source a file whose name has whitespace in it (particularly spaces)? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 <http://www.the-infoshop.

Re: What is up with = and trailing spaces?

QL to reproduce the problem. # # Running mysql 5.0.41 # CREATE TABLE test ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) default NULL, PRIMARY KEY (id) ) CHARSET=utf8 ENGINE=MyISAM; # Note the trailing spaces in the name. INSERT INTO test( id, name ) VALUES( 1,

What is up with = and trailing spaces?

.0.41 # CREATE TABLE test ( id int(10) unsigned NOT NULL auto_increment, name varchar(255) default NULL, PRIMARY KEY (id) ) CHARSET=utf8 ENGINE=MyISAM; # Note the trailing spaces in the name. INSERT INTO test( id, name ) VALUES( 1, 'TEST ' ); # Note there are no trailing spa

Re: finding count of spaces in a string

> [EMAIL PROTECTED] wrote: >> We have numerous identical tables with a varchar column that holds data >> like this: "0 0 0 1 0 1 0 25 7 0 139 0 9". Essentially there are a bunch >> of integers with a single space as a separator. There _should_ be no more >

Re: finding count of spaces in a string

[EMAIL PROTECTED] ha scritto: > We have numerous identical tables with a varchar column that holds data > like this: "0 0 0 1 0 1 0 25 7 0 139 0 9". Essentially there are a bunch > of integers with a single space as a separator. There _should_ be no more > than 30 entries

Re: finding count of spaces in a string

1 0 1 0 25 7 0 139 0 9' st) A; ++ | FieldCount | ++ | 13 | ++ 1 row in set (0.00 sec) - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, September 4, 2007 11:36:41 AM (GMT-0500) America/New_York Subject: fin

Re: finding count of spaces in a string

[EMAIL PROTECTED] wrote: We have numerous identical tables with a varchar column that holds data like this: "0 0 0 1 0 1 0 25 7 0 139 0 9". Essentially there are a bunch of integers with a single space as a separator. There _should_ be no more than 30 entries ( and 29 spaces ), but

Re: finding count of spaces in a string

Hi, [EMAIL PROTECTED] wrote: We have numerous identical tables with a varchar column that holds data like this: "0 0 0 1 0 1 0 25 7 0 139 0 9". Essentially there are a bunch of integers with a single space as a separator. There _should_ be no more than 30 entries ( and 29 spa

finding count of spaces in a string

We have numerous identical tables with a varchar column that holds data like this: "0 0 0 1 0 1 0 25 7 0 139 0 9". Essentially there are a bunch of integers with a single space as a separator. There _should_ be no more than 30 entries ( and 29 spaces ), but sometimes the system mi

Re: InnoDB per-table table spaces

At 23:44 + 1/10/06, Marvin Wright wrote: Hi, My innodb installation is using per-table table spaces for every table on the system. I originally configured 4Gig for the shared table space. However when I do a show table status I see the following. Comment: InnoDB free: 6144 kB So

InnoDB per-table table spaces

Hi, My innodb installation is using per-table table spaces for every table on the system. I originally configured 4Gig for the shared table space. However when I do a show table status I see the following. Comment: InnoDB free: 6144 kB So 6Meg free, I assumed this was 6Meg free in the

Re: varchar and trailing spaces...

At 15:39 -0400 9/3/05, Jason Pyeron wrote: I have found out that some files on the system, have trailing spaces... To make matters worse I have found 'file ' and 'file ' both exist, breaking constraint "name". So am I better off going to TINYTEXT or VAR

varchar and trailing spaces...

I have found out that some files on the system, have trailing spaces... To make matters worse I have found 'file ' and 'file ' both exist, breaking constraint "name". So am I better off going to TINYTEXT or VARBINARY(255) for the name field? That said anothe

RE: Remove spaces

> -Original Message- > From: John Berman [mailto:[EMAIL PROTECTED] > Sent: Friday, February 11, 2005 16:22 > To: 'Tom Crimmins' > Cc: mysql@lists.mysql.com > Subject: RE: Remove spaces > > The error is simply: > > [JGSGB 4.1 Host] ERROR 1064:

RE: Remove spaces

m Crimmins [mailto:[EMAIL PROTECTED] Sent: 11 February 2005 22:16 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: Remove spaces Please post the error because this looks correct. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa > -Original Message- > F

RE: Remove spaces

s.mysql.com > Subject: RE: Remove spaces > > Thanks for this > > > I did this: > > update mc_census set surname = trim(surname) > > however it fails with a syntax error ? > > I'm on 4.1 > > Regards > > John B > > -Original Messa

RE: Remove spaces

gt; Regards > > John B > > -Original Message- > From: Homam S.A. [mailto:[EMAIL PROTECTED] > Sent: 11 February 2005 21:29 > To: mysql@lists.mysql.com > Subject: Re: Remove spaces > > update your_table > set your_field = trim(your_field) > > >

RE: Remove spaces

Thanks for this I did this: update mc_census set surname = trim(surname) however it fails with a syntax error ? I'm on 4.1 Regards John B -Original Message- From: Homam S.A. [mailto:[EMAIL PROTECTED] Sent: 11 February 2005 21:29 To: mysql@lists.mysql.com Subject: Re: Remove s

Re: Remove spaces

update your_table set your_field = trim(your_field) --- John Berman <[EMAIL PROTECTED]> wrote: > Hi > > I have a table with a number of fields > > The table is already populated, however some entries > have got spaces both > before and after the data. > > F

Remove spaces

Hi I have a table with a number of fields The table is already populated, however some entries have got spaces both before and after the data. Future imports into the table will have the spaces removed, however im still stuck with my extra spaces. I have checked the Mysql manual but could not

RE: Strip off leading and trailing spaces once in db?

UPDATE my_table SET my_column = TRIM(my_column), my_other_column = TRIM(my_other_column) etc... Dave Merrill > Is it possible to remove all trailing and leading spaces for selected > fields once the data has already been loaded? > > Steve -- MySQL General Mailing List For l

Strip off leading and trailing spaces once in db?

Is it possible to remove all trailing and leading spaces for selected fields once the data has already been loaded? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: spaces in table/column name

On Thu, 9 Dec 2004, sharif islam wrote: > How mysql deals with spaces in table / column name? I am also using > mysqlcc. If I try the following in the doesn't work. Creating table > name with spaces from mysqlcc didn't give any error. But the following > does: > >

Re: spaces in table/column name

We have always found using anything other than alphanumeric characters and maybe an occasional underscore for clarity is a bad idea. It will always come back to bite you at some point. Try not using spaces or punctuation in table or column names and your life will be easier. White space and

Re: spaces in table/column name

sharif islam wrote: How mysql deals with spaces in table / column name? I am also using mysqlcc. If I try the following in the doesn't work. Creating table name with spaces from mysqlcc didn't give any error. But the following does: INSERT INTO 'tbl name with spaces' (col1, &

Re: spaces in table/column name

Behind the scenes mysqlcc wraps the both the table name with spaces and the column name with spaces with back-ticks (`) not single quotes('). http://dev.mysql.com/doc/mysql/en/Legal_names.html Try this statement instead: INSERT INTO `tbl name with spaces` (col1, `col name with spaces`) V

spaces in table/column name

How mysql deals with spaces in table / column name? I am also using mysqlcc. If I try the following in the doesn't work. Creating table name with spaces from mysqlcc didn't give any error. But the following does: INSERT INTO 'tbl name with spaces' (col1, 'col name w

Trailing spaces

Hi, I'm just trying to make sure I am going about this the right way. I have a group of String IDs , strings up to 31 characters long, case-insensitive, trailing spaces allowed. I've got these IDs in their own table, to specifiy a numerical ID. So I have a numerical ID and a Stri

Re: Reg Table spaces and Rollback segments in MySQL 4.0.21

Lakshmi, - Original Message - From: <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, November 18, 2004 1:07 PM Subject: Reg Table spaces and Rollback segments in MySQL 4.0.21 Hi ALL, We are using MySQL 4.0.21 with InnoDB. For creating the tabl

Reg Table spaces and Rollback segments in MySQL 4.0.21

Hi ALL, We are using MySQL 4.0.21 with InnoDB. For creating the tablespace mentioned as innodb_data_file_path = ibdata1:10M:autoextend in my.cnf file. Here, is there a facility to know the table space name?. Shall we create multiple table spaces like the above in MySQL 4.0.21 and assign

Filed names with trailing spaces

I had created a table and started populating it, but did not get to certain fields until later. When I tried to do an insert it would not go. It was not reconizing 2 fields. I read and re-read the statement etc. Tried it from phpMyAdmin, command line and my php script. Anyways, I removed one f

Re: OT: Errors from Extra Spaces in Spreadsheets

At 22:33 -0700 on 06/06/2004, David Blomstrom wrote about OT: Errors from Extra Spaces in Spreadsheets: I've been having a tough time importing comma-delimited files into my database tables. I just discovered that most of the errors are similar to this one: "060 " is not a valid

Re: Errors from Extra Spaces in Spreadsheets

ROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 07, 2004 1:33 AM Subject: OT: Errors from Extra Spaces in Spreadsheets > I've been having a tough time importing > comma-delimited files into my database tables. I just > discovered that most of the errors are similar to

OT: Errors from Extra Spaces in Spreadsheets

many of my numerals. I'm not sure how to remove these spaces. I didn't see anything in the Help files. I could do a search and replace, but that would also wipe out spaces between words - like... TrippCounty I just wondered if there's a simple trick anyone knows of for getting rid

Re: Another Trailing Spaces Issue

I am using 4.0.18. I also checked out the "Bugs Fixed" report--and it kind of looks like #2295 applies, although I can't be certain. It definitely returns rows without trailing spaces, even though the SELECT asks for rows WITH trailing spaces. Hmmm... on 5/2/04 2:05 AM, M

Re: Another Trailing Spaces Issue

Hi John, What version do you use? In 4.0.18, they fixed some bugs that were introduced in 4.0.17 related to trailing spaces on indexed TEXT-family columns: http://dev.mysql.com/doc/mysql/en/News-4.0.18.html I see 3 "Bugs fixed" entries with "trailing spaces" in them. If you

Re: Another Trailing Spaces Issue

>If the string is theString + space and another row has an entry with >theString (+ no space), the query returns BOTH rows. > >Is there a way to get around returning the latter entry? You could do something like: select stuff from mytable where stuff = 'foo ' and length(stuff) = 4; -- Steve Ba

Re: Another Trailing Spaces Issue

John Mistler wrote: The TINYTEXT format solves the problem of storing the string with spaces at the end. Now, I'm having trouble SELECTING a row WHERE the TINYTEXTcolumn = theStringWithTheSpacesAtTheEnd; If the string is theString + space and another row has an entry with theString (+ no

Another Trailing Spaces Issue

The TINYTEXT format solves the problem of storing the string with spaces at the end. Now, I'm having trouble SELECTING a row WHERE the TINYTEXTcolumn = theStringWithTheSpacesAtTheEnd; If the string is theString + space and another row has an entry with theString (+ no space), the query re

Re: inserting white spaces

Hello Lemasson. Monday, December 8, 2003, 8:16:18 PM, you wrote: LS> I have a table witch has a column of type VARCHAR(10) LS> BINARY. When I tried to insert white spaces in it (insert into LS> mytable (mycolumn) values('')), an empty String is stored. Why? This is a

RE: inserting white spaces

[snip] I have a table witch has a column of type VARCHAR(10) BINARY. When I tried to insert white spaces in it (insert into mytable (mycolumn) values('')), an empty String is stored. Why? [/snip] Because (' ') is an empty string see http://www.mysql.com/doc/en/Str

inserting white spaces

Hi, I have a table witch has a column of type VARCHAR(10) BINARY. When I tried to insert white spaces in it (insert into mytable (mycolumn) values('')), an empty String is stored. Why? Lemasson Sylvain Ingénieur développeur [EMAIL PROTECTED] tel: 01.48.63.27.27 MAK-SYSTEM SERVI

Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces.

Duke, Brian wrote: I agree with that. the LERG does not get generated by us. I push it immediately to Mysql every week. so you are recommending: $query="SELECT LERG_6.SWITCH, `LERG_6.SHA INDICATOR` FROM LERG_6 WHERE `LERG_6.SHA INDICATOR` = 00;" (the backticks are around `LERG_6.SHA INDICATOR`

RE: MySql40, MSAccess2003, MyODBC3.51, and white spaces.

is correct? -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Saturday, December 06, 2003 2:46 PM To: Duke, Brian; [EMAIL PROTECTED] Subject: Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces. >can someone help me either fix my ODBC load or help me correctly

Re: MySql40, MSAccess2003, MyODBC3.51, and white spaces.

Duke, Brian wrote: I have a question about spaces in fieldnames. locally running Access03 and using MyODBC3.51 to populate a MySQL40 database. The Database name and table names are ok. It's the field names I am having trouble with. The tables are huge and there are 26 tables. The ODBC pr

MySql40, MSAccess2003, MyODBC3.51, and white spaces.

I have a question about spaces in fieldnames. locally running Access03 and using MyODBC3.51 to populate a MySQL40 database. The Database name and table names are ok. It's the field names I am having trouble with. The tables are huge and there are 26 tables. The ODBC process completes but d

Re: Comparing spaces with LIKE

On 12 Sep 2003 at 8:39, Nelson Azambuja Jr. wrote: > I tried the following: > > SELECT * FROM table WHERE name LIKE '% John %'; > > But it didn't work. Please explain what didn't work. What were you expecting to happen, and what actually happened? > To explain: I don't want th

Comparing spaces with LIKE

How do I compare blank spaces in a string using LIKE ? I tried the following: SELECT * FROM table WHERE name LIKE '% John %'; But it didn't work. To explain: I don't want the string 'Johnson' to be shown when running the query above. Th

Re: spaces in index name

Hi, - Original Message - From: "Benjamin KRIEF" Sent: Sunday, August 31, 2003 8:17 PM Subject: Re: spaces in index name > thanks for all your answers ! i'd never imagine that mailing-list to be > so active and efficient! It's usually not that active on weeken

Re: spaces in index name

thanks for all your answers ! i'd never imagine that mailing-list to be so active and efficient! matt : does mysql locks the table during the whole alter table execution? Matt W wrote: Hi Ben, When using column/index names with odd characters (such as spaces), you need to use backticks (

Re: spaces in index name

Hi Ben, When using column/index names with odd characters (such as spaces), you need to use backticks (SHIFT + the ~ key) around the name: `index id` This ALTER TABLE query should make all the changes you want: ALTER TABLE v2easy0_users DROP INDEX `login connexion`, DROP INDEX `index id

Re: spaces in index name

In the last episode (Sep 01), Benjamin KRIEF said: > hi all , > > i'm trying to improve performance of a quite big and heavily used mysql > set of tables. > i want to create some indexes on this table , but before this , i'd like > to remove the ones created by my predecessor , which are sometim

Re: spaces in index name

* Benjamin KRIEF [...] > first of all , i'm asking myself : why is there 2 primary keys on the > same column ? Don't know... strange. [...] > mysql> drop index login connexion on v2easy0_users; > ERROR 1064: You have an error in your SQL syntax near 'connexion on > v2easy0_users' at line 1

spaces in index name

gin connexion" , and the index "index id" , but the problem is : mysql> drop index login connexion on v2easy0_users; ERROR 1064: You have an error in your SQL syntax near 'connexion on v2easy0_users' at line 1 (the same goes with ' and " around the index name

Re: Inserting strings containing only spaces fails?

Hi All, I had the same problem on MySql server 3.23.43 on Solaris platform but, so far, I don't know how to solve it. Can you help me? Thanks in advance. Regards. Stefano Bruno Grenci -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stefano Bruno Grenci ([EMAIL PROTECTED]) Ion Trading System s.r

RE: How to file a bug: "Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command."

file a bug for mysql for Windows NT/2000/XP. Problem: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command. e.g. mysqld-nt --datadir=c:\Program Files\mysql\data Is not possible, nor is mysqld-nt "--datadir=c:\Pr

Re: How to file a bug: "Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command."

On 24 Sep 2002 at 9:16, Tobias Eriksson wrote: > Hi > How do I file a bug for mysql for Windows NT/2000/XP. > > Problem: > Can not handle spaces in paths for the arguments given on the > commandline to the mysqld-nt command. > e.g. mysqld-nt --datadir=c:\Pro

How to file a bug: "Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command."

Hi How do I file a bug for mysql for Windows NT/2000/XP. Problem: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command. e.g. mysqld-nt --datadir=c:\Program Files\mysql\data Is not possible, nor is mysqld-nt

RE: Start mysqld-nt from command line with SPACES in the path, how?

mOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: 16 September 2002 15:59 To: [EMAIL PROTECTED] Subject: re: Start mysqld-nt from command line wit

Re: Inserting strings containing spaces only fails?

Hello Wout, > Appareantly it's impossible to insert a string, consisting entirely out of > spaces, in a textual field (I've tried varchar(19) and char(2) types, they > both don't work). MySQL doesn't complain about it, but it trims the strings > down to the

RE: Inserting strings containing spaces only fails?

cters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. (This space removal differs from the ANSI SQL specification.) Regards Al > -Original Message- > From: Wout Neirynck [mailto:[EMAIL PROTECT

Inserting strings containing spaces only fails?

Hello, Appareantly it's impossible to insert a string, consisting entirely out of spaces, in a textual field (I've tried varchar(19) and char(2) types, they both don't work). MySQL doesn't complain about it, but it trims the strings down to the empty string. If I try a

Re: Inserting strings containing only spaces fails?

From: "Wout Neirynck" <[EMAIL PROTECTED]> > Appareantly it's impossible to insert a string, consisting entirely out of > spaces, in a textual field (I've tried varchar(19) and char(2) types, they > both don't work). MySQL doesn't complain about it,

Inserting strings containing only spaces fails?

Hello, Appareantly it's impossible to insert a string, consisting entirely out of spaces, in a textual field (I've tried varchar(19) and char(2) types, they both don't work). MySQL doesn't complain about it, but it trims the strings down to the empty string. If I try a

Re: when column contains spaces

On Thu, Nov 01, 2001 at 11:55:40PM -0700, I. TS wrote: > When I create a table, when one column contains a space, how can I > create it > correctly in mysql? > Use backticks (`) like this for column names with spaces in them: CREATE TABLE mytable( name CHAR(60) NOT NULL, `this

when column contains spaces

I am a newbie. When I create a table, when one column contains a space, how can I create it correctly in mysql? for example: CREATE TABLE mytable( name CHAR(60) NOT NULL, this column CHAR(60) ///Here there is a space? ); When I use ' or ", it does not

Re: Re: Truncated data on spaces..?

>database,sql,query,table At 12:29 PM -0500 11/1/01, Gil G. wrote: >Hello, > >Does the data stored in a VARCHAR field get truncated on spaces? Trailing spaces, yes. >All my fields contain the data up to the first space... >What should I use ? One of the TEXT types. > >

Truncated data on spaces..?

Hello, Does the data stored in a VARCHAR field get truncated on spaces? All my fields contain the data up to the first space... What should I use ? Thanks a lot, sincerely, Gil. [ PHP 4.01, MySQL 3.23, FreeBSD 4.2 ] -- PGP public key at: keskydee.com/gil.asc ICQ: 3310801

Problem with Access, recordsets, and ODBCDirect work spaces...

Yes, I have read the manual, many times, and searched the archives. I am using an ODBCDirect (in MS Access 97) workspace to connect to the MySQL server. That works fine, and I can get and display data. I can even execute a recordset.edit command, but when I do recordset.update, I get ODBC cal

Re: Spaces

Mind you, having spaces in your table names is not a good idea. Mainly due to portability between systems. You'll save yourself a lot of agro if you use underscore instead. - Original Message - From: "Yoav Bornstein" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]

Re: SV: Spaces

On Sun, Feb 18, 2001 at 03:06:08PM +0100, Jarmo Paavilainen wrote: > Hi, > > ... > > > Is there a way to create column names with spaces ? > > > > > > > Yes you can use backquotes for this: > > > > create table `a b` ( `x y` int ); >

SV: Spaces

Hi, ... > > Is there a way to create column names with spaces ? > > > > Yes you can use backquotes for this: > > create table `a b` ( `x y` int ); Doesnt the normal (SQL9?) double quote do the trick? : create table "

Re: Spaces

On Sun, Feb 18, 2001 at 12:30:57PM +0200, Yoav Bornstein wrote: > Is there a way to create column names with spaces ? > Yes you can use backquotes for this: create table `a b` ( `x y` int ); I'm not sure this is documented though, so you may want to check before using this. show c

Spaces

Is there a way to create column names with spaces ? Thanks :), -- Yoav Bornstein. Listen to Weird Al and George Carlin, watch South Park, use Linux and have fun ! - Before posting, please check: http://www.mysql.com