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: 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

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

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

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: 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]

Re: Importing MS SQL exported CSV files adds spaces

... 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 characters.) Change your MySQL character set for the apps table

RE: Spaces in sourced file names?

-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 ya me believes --Original Message-- From: Jerry

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.com

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

What is up with = and trailing spaces?

# 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 spaces in the name

Re: What is up with = and trailing spaces?

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, 'TEST

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 misfires

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 spaces

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 sometimes

Re: finding count of spaces in a string

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: finding count of spaces in a string We have numerous identical tables with a varchar column that holds data like this: 0

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 ( and 29 spaces

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

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

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

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 another way, will TINTTEXT break

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 VARBINARY(255) for the name field

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

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. Future imports into the table will have

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 spaces

RE: Remove spaces

:[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) --- John Berman [EMAIL PROTECTED] wrote: Hi I have a table with a number of fields The table is already populated

RE: Remove spaces

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

RE: Remove spaces

[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- From: John Berman

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: You have an error in your SQL syntax; check

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 list archives: http

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: INSERT INTO 'tbl name with spaces

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

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 with spaces') VALUES(15,16

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`) VALUES

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, 'col name with spaces

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 String ID

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

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 tablespace mentioned

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

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 integer value I

Re: Errors from Extra Spaces in Spreadsheets

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 this one: 060 is not a valid integer value I

OT: Errors from Extra Spaces in Spreadsheets

. 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... TrippspaceCounty I just wondered if there's a simple trick anyone knows of for getting rid of spaces like

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 not using 4.0.17

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, Matt W at [EMAIL

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 returns

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 space

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

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 SERVICES Groupe

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/String_syntax.html http

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 documented behavior

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 due

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 process

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

? -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 syntax my php

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`)

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. Thanks. Nelson Azambuja Jr

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 the

spaces in index name

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) ! of course , mysql doesn't accept spaces in index names , so why did he

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

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 sometimes

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

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 (SHIFT

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 weekends, volume-wise. And I see

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

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:\Program

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: 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:\Program Files\mysql\data

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

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 with SPACES

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 empty string. If I try a select searching

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 select searching

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, but it trims the strings down to the empty string

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 select searching

RE: Inserting strings containing spaces only fails?

characters 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.) /snip Regards Al -Original Message- From: Wout Neirynck [mailto:[EMAIL PROTECTED

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

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. Thanks a lot, sincerely, Gil

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

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

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

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 create table

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 "a b" ( "x y&qu

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 ); Doesnt the normal (SQL9?) double quote do the trick? : create table &quo

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] Sent: Sunday, F