Aveek, Simcha, Johan,
Thanks for explaining the situation. I knew there were some reserved
words, but I hadn't realized there were so many.
Anyway, now that I know I can protect my column names with backticks,
I'm good to go.
--
Dave M G
--
MySQL General Mailing List
For list archives: http:/
LOL
--
João Cândido de Souza Neto
"mos" escreveu na mensagem
news:6.0.0.22.2.20110224093057.044a0...@mail.messagingengine.com...
> At 05:13 AM 2/24/2011, you wrote:
>>Use a quote around the column name or explicitly specify the column as
>>. (as for e.g. mytable
At 05:13 AM 2/24/2011, you wrote:
Use a quote around the column name or explicitly specify the column as
. (as for e.g. mytable.group) in the query. For more
details refer to http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html
Thanks
Aveek
Hmmm. Everyone has given me a great idea. I
The best comparison I´ve never seen in my life was the TNT.
LOL
--
João Cândido de Souza Neto
"Johan De Meersman" escreveu na mensagem
news:AANLkTikPeVuTpj9E0iepFncCJZQOF6sn_dbrhp0=p...@mail.gmail.com...
> On Thu, Feb 24, 2011 at 12:06 PM, Dave M G wrote:
>
>> Should I never use the word
On Thu, Feb 24, 2011 at 12:06 PM, Dave M G wrote:
> Should I never use the word "group" for column names? Seems a little
> silly. Is there a way to protect column names to that there is no
> confusion?
>
As several people already pointed out, simply use backticks. Simple quotes
have started to w
On Thu, 24 Feb 2011 16:43:56 +0530
Aveek Misra wrote:
> Use a quote around the column name or explicitly specify the column as
> . (as for e.g. mytable.group) in the query. For more details
> refer to http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html
>
use backticks
database, the column was named "group".
>
> I kept getting failed query errors until I renamed the column.
>
> I've never before encountered a situation where MySQL mistook a column
> name for part of the query syntax.
>
> Should I never use the word "group&qu
Use a quote around the column name or explicitly specify the column as
. (as for e.g. mytable.group) in the query. For more details
refer to http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html
Thanks
Aveek
On Feb 24, 2011, at 4:36 PM, Dave M G wrote:
> MySQL users,
>
> Simple
MySQL users,
Simple question:
In one table in my database, the column was named "group".
I kept getting failed query errors until I renamed the column.
I've never before encountered a situation where MySQL mistook a column
name for part of the query syntax.
Should I never use
Sent: Monday, March 15, 2010 12:58 AM
> To: mysql@lists.mysql.com
> Subject: udf return column name not value
>
> CREATE FUNCTION getcolumnvalue(id int,columnname varchar(30))
> RETURNS varchar(50) DETERMINISTIC
> READS SQL DATA
> begin
> declare retval varchar(50);
> retur
, 2010 12:58 AM
To: mysql@lists.mysql.com
Subject: udf return column name not value
CREATE FUNCTION getcolumnvalue(id int,columnname varchar(30))
RETURNS varchar(50) DETERMINISTIC
READS SQL DATA
begin
declare retval varchar(50);
return retval;
end;
I want get value of related column but it return column name
CREATE FUNCTION getcolumnvalue(id int,columnname varchar(30))
RETURNS varchar(50) DETERMINISTIC
READS SQL DATA
begin
declare retval varchar(50);
select columnname into retval from user where ID = id ;
return retval;
end;
I want get value of related column but it return column name.
ex:- (
Hi Gilles,
I search in the manual with "ERROR 1064", and then get the page :
http://dev.mysql.com/doc/refman/4.1/en/error-messages-server.html
Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR)
Message: %s near '%s' at line %d
I cannot figure out what is wrong from this info, whereas error code
106
Hello again Paul,
1-Why the error code (1064) can't lead explicitly to the syntax problem ?
I'm sorry, I don't understand the question.
The mysql command returned the error code [ ERROR 1064 (42000) ]
I search in the manual with "ERROR 1064", and then get the page :
http://dev.mysql.com/do
roblem.
Funny that the keywords were in my question to the list :
"DEC column name forbidden", but did not made
sens to me to query with these word.
first, I tried on the error code [ ERROR 1064
(42000) ] : not understandable to me.
then I tried "keyword DEC"(matching
SQL manual" works when you know where is the
problem.
Funny that the keywords were in my question to the list :
"DEC column name forbidden", but did not made sens to me to query with
these word.
first, I tried on the error code [ ERROR 1064 (42000) ] : not
understandable to me
or in your
SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax
to use near 'dec float' at line 1
UPPER case lead to the same error.
It seems that the reason is that "DEC" is a
keyword standing for "decimal". I do not
ght
syntax to use near 'dec float' at line 1
UPPER case lead to the same error.
It seems that the reason is that "DEC" is a keyword standing for
"decimal". I do not understand why this cannot be allowed for a column
name.
Is there a turn around ?
This is an
float' at line 1
>
> UPPER case lead to the same error.
>
> It seems that the reason is that "DEC" is a keyword standing for
> "decimal". I do not understand why this cannot be allowed for a column
> name.
>
> Is there a turn around ?
>
&
[snip]
It seems that the reason is that "DEC" is a keyword standing for
"decimal". I do not understand why this cannot be allowed for a column
name.
[/snip]
There are several reserved keywords in MySQL, none of which are
recommended for column names. You can try the
ve an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near 'dec float' at line 1
UPPER case lead to the same error.
It seems that the reason is that "DEC" is a keyword standing for
"decimal". I do n
If say something like the following from the mysql command line tool:
SELECT * FROM dognames INTO OUTFILE 'C:/outfiles/dognames.tab';
How do I get mysql to include the column names in the file's output?
Ferindo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Joseph Alotta wrote:
greetings,
I know this is pretty basic stuff, but I couldn't find an answer in
google.
1. I want to set the @maxdate variable, but mysql complains. What am I
doing wrong?
> set @maxdate = select max(date) from positions where account =
> "111200512343222";
select (
greetings,
I know this is pretty basic stuff, but I couldn't find an answer in
google.
1. I want to set the @maxdate variable, but mysql complains. What am
I doing wrong?
2. The 3rd to the last line:
and (p.value - t.amount) < -1000
I wanted to say
diff < -1000
but mysql
> mysql> create table prova (`Termination ` int);
> ERROR 1166: Incorrect column name 'Termination '
The manual says:
"Database, table, and column names should not end with space characters."
http://dev.mysql.com/doc/mysql/en/legal-names.html
--
MySQL General Mailing
inyint(3) unsigned NOT NULL default '0',
...
...
) TYPE=MyISAM
1 row in set (0.01 sec)
mysql>
The field `Termination ` cause me some trouble:
If i try to recreate from dump (mysqldump from 4.0) the table
'Dsmaccnt', on another server (version 4.1), i've got this error
ult '0',
...
...
) TYPE=MyISAM
1 row in set (0.01 sec)
mysql>
The field `Termination ` cause me some trouble:
If i try to recreate from dump (mysqldump from 4.0) the table
'Dsmaccnt', on another server (version 4.1), i've got this error:
ERROR 1166: Incorrect column n
From: "Scott Purcell"
> I cannot find any information on this, so I am thinking the answer is no.
But I have a column that I would like to change the name of:
>
> current the column name is"ID", and I would like it to change it to
"CHILD_ID", as the the
2005 4:56 PM
To: Scott Purcell; mysql@lists.mysql.com
Subject: RE: Alter Column Name?
I'm not sure if this will work for a column name but there is a CHANGE
COLUMN feature in the ALTER TABLE statement so that sounds promising. Then
again, I don't have a MySQL system to try it on this wee
I'm not sure if this will work for a column name but there is a CHANGE
COLUMN feature in the ALTER TABLE statement so that sounds promising. Then
again, I don't have a MySQL system to try it on this week - I am
travelling - so I can't be sure if it will work for the colu
I cannot find any information on this, so I am thinking the answer is no. But I
have a column that I would like to change the name of:
current the column name is"ID", and I would like it to change it to "CHILD_ID",
as the the software is changing, and we are adding "p
> In short: a column-name in a subquery can refer to a table *outside*
> of the subquery (fair enough), but if the column-name is ambiguous
> between *inside* and *outside*, the parser assumes that it refers to
> the *inside* context.
>
> I would have thought it better t
Hi, the following seems wrong to me. Not sure whether this is a bug.
In short: a column-name in a subquery can refer to a table *outside*
of the subquery (fair enough), but if the column-name is ambiguous
between *inside* and *outside*, the parser assumes that it refers to
the *inside* context
Hello.
Do you use mysql client program from the old release? Use
mysql --version
to check the version.
"Sehn, Timothy" <[EMAIL PROTECTED]> wrote:
> I am running IntranetMySQL (ie. MySQL 4.1.9) and I am getting the =
> strangest error:
>
> mysql> use devmail
> Reading table informa
I am running IntranetMySQL (ie. MySQL 4.1.9) and I am getting the strangest
error:
mysql> use devmail
Reading table information for completion of table and column names You can turn
off this feature to get a quicker startup with -A
Database changed
mysql> select type_name from faq_type;
+--
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:
>
>
coNet Corporation
SW Florida's 1st ISP
- Original Message -
From: "sharif islam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 09, 2004 4:07 PM
Subject: spaces in table/column name
> How mysql deals with spaces in table / column name? I am
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, &
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
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
t
> seem
> > to fix it.
> > Two tables, VendorID exists in both tables
> (neither
> > are primary keys)
> >
> > I'm getting a "VendorID in where clause is
> ambiguous"
> > Sometimes it actually processes the SQL weird.
> > I think
upposed to be but can't seem
> to fix it.
> Two tables, VendorID exists in both tables (neither
> are primary keys)
>
> I'm getting a "VendorID in where clause is ambiguous"
> Sometimes it actually processes the SQL weird.
> I think this is because same co
Try specifying the source tables more explicitly in your SELECT statement.
SELECT table_a.VendorJobs opt_a
, table_b.VendorJobs opt_b
...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
> I know what the deal is supposed to be but can't seem
> to fix it.
> Two tables, VendorID exists in both tables (neither
> are primary keys)
>
> I'm getting a "VendorID in where clause is ambiguous"
> Sometimes it actually processes the SQL weird.
&
Hi,
I know what the deal is supposed to be but can't seem
to fix it.
Two tables, VendorID exists in both tables (neither
are primary keys)
I'm getting a "VendorID in where clause is ambiguous"
Sometimes it actually processes the SQL weird.
I think this is because same
question about column name case sensitive. Currently, we use
> MySQL 3.23.32 running on Linux.
>
> I am trying to use JDBC to get email from table T1
>
> T1(
> id char(3),
> name varchar(12),
> Emailvarchar(16)
> )
>
> Now If I say,
>try{
&g
Hello,
I have a question about column name case sensitive. Currently, we use
MySQL 3.23.32 running on Linux.
I am trying to use JDBC to get email from table T1
T1(
id char(3),
name varchar(12),
Emailvarchar(16)
)
Now If I say,
try{
...
String email =
getString("
Hello,
I have a question about column name case sensitive. Currently, we use
MySQL 3.23.32 running on Linux.
I am trying to use JDBC to get email from table T1
T1(
id char(3),
name varchar(12),
Emailvarchar(16)
)
Now If I say,
try{
...
String email =
getString("
At 20:43 -0700 4/17/04, Zhang Yu wrote:
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name "id #", which is used by
At 20:43 -0700 4/17/04, Zhang Yu wrote:
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name "id #", which is used by
Zhang Yu <[EMAIL PROTECTED]> wrote:
>
> I am migrating an old Access database to MySQL. After
> migration, we'll keep using Access forms as front end,
> and MySQL as database.
>
> I experienced a strange problem when creating table
> with a column name "id #
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name "id #", which is used by many
queries in Access. My command is li
Hi Ya
I believe the Dos Mysql Client has limited table name completion, but
do any of the GUI Clients have this feature??
zzapper (vim & cygwin & zsh)
--
vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?"
http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips
--
MyS
Hi Hans,
> Yes, I have used `
>
> I don't think check is reserverd because I can CREATE the column name!
From
> the mysql prompt its possible to insert a record, but not from my Delphi
> Code. After that i try to alter / delete the column but thats impossible.
> Other co
Yes, I have used `
I don't think check is reserverd because I can CREATE the column name! From
the mysql prompt its possible to insert a record, but not from my Delphi
Code. After that i try to alter / delete the column but thats impossible.
Other columns in the same table where al
Have tried to use back sticks?
Like `check`
Thanks
Emery
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 24, 2003 16:41
Subject: Re: Column name: CHECK
>
> > I use the column name CHEC
> I use the column name CHECK (smallint), but when I insert into the table I
> get an error : Check the manual for: Check) values ( etc.etc.
>
> When I try to change the column name (alter table tablename change check
> blabla smallint) I get an error too, check your manual..
&
Hi Group,
I use the column name CHECK (smallint), but when I insert into the table I
get an error : Check the manual for: Check) values ( etc.etc.
When I try to change the column name (alter table tablename change check
blabla smallint) I get an error too, check your manual..
Does anybody
lto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 11:30 AM
To: [EMAIL PROTECTED]
Subject: RE: Searching all db tables for a column name in MySQL - how?
can I?
Chris:
Your syntax and all documented syntax is for querying column names in just
one table. My question is "How do I search for a speci
Chris:
Your syntax and all documented syntax is for querying column names in just one table.
My question is "How do I search for a specific column name in ALL tables?
Chris <[EMAIL PROTECTED]> wrote: SHOW COLUMNS FROM table_name LIKE 'Identifier';
should work.
It'
003 11:02 AM
To: [EMAIL PROTECTED]
Subject: Searching all db tables for a column name in MySQL - how? can
I?
In Oracle it looks like this:
SELECT table_name
FROM all_tables
WHERE column_name = 'Identifier'
Does anybody know if this is possible in MySQL and if so, what's the syntax
In Oracle it looks like this:
SELECT table_name
FROM all_tables
WHERE column_name = 'Identifier'
Does anybody know if this is possible in MySQL and if so, what's the syntax? I can't
find anything in the documentation that allows me to search for a specific column in
all tables.
Thank you,
Patr
On Saturday 22 February 2003 14:00, Prabu Subroto wrote:
> I don't want to be spoiled by PHPMyAdmin anymore.
> I want to get be more expert in SQL Command of MySQL.
>
> So far, everything is fine but today I realized a
> problem. If I want to diplay the columns of an empty
> table, the MySQL Clien
> T: +27 021 406 3681
> F: +27 021 406 3143
> E: [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>
>
>
> -Original Message-
> From: Prabu Subroto [mailto:[EMAIL PROTECTED]
> Sent: Saturday, February 22, 2003 2:00 PM
> To: [EMAIL PROTECTED]
> Su
Dear my friend
I don't want to be spoiled by PHPMyAdmin anymore.
I want to get be more expert in SQL Command of MySQL.
So far, everything is fine but today I realized a
problem. If I want to diplay the columns of an empty
table, the MySQL Client will diplay nothing such as :
"
mysql> select *
mp;
create temporary table temp select @canread := "false", @canread :=
if(FIND_IN_SET("8", Institution_Id) > 0,"true","false"), @canread AS canread from
persons;
select * from temp;
I get the error:
ERROR 1166: Incor
Check out the alter table syntax ...
something to note you can't just change the name - you have to retype the
whole column signature:
ALTER TABLE [table] CHANGE [old column name] [new column name] [old column
definition];
ie. ALTER TABLE users CHANGE st state char(2) NOT NULL DEFAUL
ALTER TABLE
Simon
-Original Message-
From: Gianluca Carnabuci [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2003 16:30
To: [EMAIL PROTECTED]
Subject: column name
Hi all,
I guess it's a dumb question for you guys, but MySql manual doesn't seem to
offer newbies a great deal of he
Hi all,
I guess it's a dumb question for you guys, but MySql manual doesn't seem to offer
newbies a great deal of help on this one: how do I change a column name?
Gian
-
Before posting, please check:
http://www
* blah
> Hi,
> I want to use MySQL to store ESM (Symantec Enterprise
> Security Manager)
> data. The problem is that in one of their table, there is a field named
> "FullText".
"FULLTEXT" is a reserved word in mysql. Use backticks:
mysql> create table ESMMessage2 (`FullText` text NOT NULL);
14:00:00 |
+-+
1 row in set (3.73 sec)
>Fix:
>Submitter-Id: ??
>Originator:Jettero Heller
>Organization:
>MySQL support: none
>Synopsis: max() null bug with funny column name
>Severity: non-critical
>Priority: low
>Catego
Have you tried "SELECT MAX(`timestamp`) FROM minutely_inbound_handovers;"?
-JF
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 26, 2002 6:48 AM
> To: [EMAIL PROTECTED]
> Subject: max() null bug with funny colum
qingfong,
Thursday, July 18, 2002, 4:49:16 AM, you wrote:
q> mysql:
q> how to rename column name exception that use alter table tablename column
newcolumn expression. I want get fast to rename the column name, but use front idea is
very slowly when my table has
q> 1000 rec
mysql:
how to rename column name exception that use alter table tablename column
newcolumn expression. I want get fast to rename the column name, but use front idea is
very slowly when my table has 1000 record. help me
bject: changing column name
Hi
Can anyone plz give me the query for chaning the column name of an
existing
table(which does not affect the elements of that column).
I hope there is a way to do that.
Any help appreciated
Thanx
Anil
-
Anil,
Thursday, May 30, 2002, 5:36:32 PM, you wrote:
AG> Can anyone plz give me the query for chaning the column name of an existing
AG> table(which does not affect the elements of that column).
AG> I hope there is a way to do that.
Use ALTER TABLE to change column name:
ALTER TABLE tablename CHANGE oldname newname VARCHAR(40)
Simon
-Original Message-
From: Anil Garg [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2002 15:37
To: MySql Mail List
Subject: changing column name
Hi
Can anyone plz give me the query for chaning the column name of an existing
Hi
Can anyone plz give me the query for chaning the column name of an existing
table(which does not affect the elements of that column).
I hope there is a way to do that.
Any help appreciated
Thanx
Anil
-
Before posting
To: [EMAIL PROTECTED]
Subject: help sorting by a column name
Hey Guys,
I need to reorganize the list of reviews on my site so they are displayed by
category. However, I want it to display all the reviews from all categories
at once. How do I do this? Here is my syntax now for display all reviews at
onc
$a["name"]);
}
?>
I want it so it displays them like this:
Processors -
Reviews listed here
Motherboards
Reviews listed here
the categories are stored under the column name "category", for reference.
Thanks!
-Alex "Big Al" Be
Perhaps you read the wrong part(s) of the manual:
http://www.mysql.com/doc/R/e/Reserved_words.html
On Sun, 20 Jan 2002 12:18:45 -0800 (PST), Dominique Plante wrote:
>I hope you can answer the following question. I am
>wondering how to create a table with a column named
>key. I have RTFMed an
Dominique,
On Sun, Jan 20, 2002 at 12:18:45PM -0800, Dominique Plante wrote:
> The following fails (after selecting a database):
>
> mysql> create table test (key varchar(255), value
> varchar(255));
>
You should be able to do this by using back-quotes around
the column n
I hope you can answer the following question. I am
wondering how to create a table with a column named
key. I have RTFMed and that didn't help. I'm using
3.23.47-max-debug.
The following fails (after selecting a database):
mysql> create table test (key varchar(255), value
varchar(255));
Wit
Hi,
Please, how do i correct wrong column name (field name, not one of values
stored under the column name) in a table in mysql?
I supposed to type password when i was creating the as field but end up
typed passwod.
Thanks.
kamal
> Hi,
>
> Please, how do i correct wrong column name (field name, not one of values
> stored under the column name) in a table in mysql?
>
> I supposed to type password when i was creating the as field but end up
> typed passwod.
http://www.bitbybit.dk/mysqlfaq/faq.htm
--
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Philip Mak" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 10:48 PM
Subject: Re: Perl DBI: Same column name in different tables problem
> On Fri, Sep 07, 2001 at 10:03:03PM -0700, Phil
On Fri, Sep 07, 2001 at 10:03:03PM -0700, Philip Mak wrote:
> Let's say I performed the following query using Perl DBI:
>
> $row = $dbh->selectrow_hashref(<<"~");
> SELECT fanfics.handle, authors.handle
> FROM fanfics, authors
> WHERE fanfics.aid = authors.aid
> ~
>
> I won't be able to access b
Let's say I performed the following query using Perl DBI:
$row = $dbh->selectrow_hashref(<<"~");
SELECT fanfics.handle, authors.handle
FROM fanfics, authors
WHERE fanfics.aid = authors.aid
~
I won't be able to access both fanfics.handle and authors.handle this
way, because they're called "handle
Jason Kwok writes:
> Even my mysql is compile with Big5, I couldn't use Chinese charaters (big 5)
> as column name. Is that normal?
Did you quote the names? And did they contain any of the illegal
characters discused in
http://www.mysql.com/doc/L/e/Legal_names.html ?
I wonder w
Even my mysql is compile with Big5, I couldn't use Chinese charaters (big 5)
as column name. Is that normal?
==
Best Regards
Jason Kwok
==
---
Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.274 / Virus Database: 144 - Release Date:
I had this error under win when using phpMyAdmin quite frequently.
It turned out that mysql creates temp files and somehow the
process terminates.
To get along, I dump the table, edit the sql file and reimport.
Never had a problem with this method.
Charles Mégnin schrieb am Freitag, 17. August
I am trying to change the name of a table column and get the following
error message. I've tried both as a user and as root with no success.
Thanks for your ideas
mysql> use music
Reading table information for completion of table and column names
You can turn off this feature to get a quicker sta
Lance Lovette writes:
> TYPE=PACKED does not seem to be documented in Chapter 7.7 in the online
> documentation. Where can I find a description of the PACKED option?
>
> Also, can it be noted in the documentation that CREATE ... SELECT * FROM ...
> does not create an exact copy of the table? Had
would not have noticed all the 320MB temporary tables I'd have been
creating.
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 6:40 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: ERROR 1060: Duplicate column name
Lance Lo
Lance Lovette writes:
> Thanks for the clarification. Is it a MySQL bug then that the CREATE query
> converts all the VARCHAR fields into CHAR fields so the query 'CREATE
> TEMPORARY TABLE User2 SELECT * FROM User' creates a temporary table much
> larger than the User table?
>
No, this is not a
l Widenius [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 9:32 AM
To: Lance Lovette
Cc: MySQL
Subject: ERROR 1060: Duplicate column name
Hi!
>>>>> "Lance" == Lance Lovette <[EMAIL PROTECTED]> writes:
Lance> The following CREATE TABLE statements seem st
Hi!
>>>>> "Lance" == Lance Lovette <[EMAIL PROTECTED]> writes:
Lance> The following CREATE TABLE statements seem straight forward but they all
Lance> fail. Can someone explain why they fail and what I can do to get rid of the
Lance> "Duplicate
Thank you for your bug report.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-
The following CREATE TABLE statements seem straight forward but they all
fail. Can someone explain why they fail and what I can do to get rid of the
"Duplicate column name" errors?
mysql> CREATE TEMPORARY TABLE User2 (UserID int(11)) SELECT UserID FROM
User;
ERROR 1060: Duplicat
hamad Ilhami" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 10:13
> Subject: space in column name and table name, standard?.
>
> > Hi,
> >
> > I think mysql support space in column name and table name, using left
> >
1 - 100 of 104 matches
Mail list logo
