t; To: mysql list
> Subject: changing mySQL table name screws phpMyAdmin?? reverting change
> fixes??
>
> I changed a name of the table from within phpMyAdmin, and immediately
> it crapped. after that when I try to connect using phpMyAdmin
> (/phpMyAdmin/index.php) I get error in log:
>
I changed a name of the table from within phpMyAdmin, and immediately it
crapped. after that when I try to connect using phpMyAdmin
(/phpMyAdmin/index.php) I get error in log:
[Wed Aug 0814:18:582012][error]Query call
failed:Table'mydb.mychangedtbls'doesn't exist (1146)
(I changed the name from
han De Meersman'
Cc: 'MY SQL Mailing list'
Sent: Friday, 17 June 2011 7:41 PM
Subject: RE: Encoding "Table Name" and "Filed Name"
>-Original Message-
>From: Vikram A [mailto:vikkiatb...@yahoo.in]
>Sent: Friday, June 17, 2011 2:54 AM
>To: Joh
>-Original Message-
>From: Vikram A [mailto:vikkiatb...@yahoo.in]
>Sent: Friday, June 17, 2011 2:54 AM
>To: Johan De Meersman
>Cc: MY SQL Mailing list
>Subject: Re: Encoding "Table Name" and "Filed Name"
>
>Sir,
>
>I agree, its impossible
- Original Message -
> From: "Vikram A"
> I agree, its impossible to do manual look ups. But our aim is to
> avoid the use of DB with out code. Also we have ensured, 'secret
> data is encrypted using some functions with key'.
> I shall follow both enc
Sir,
I agree, its impossible to do manual look ups. But our aim is to avoid the use
of DB with out code. Also we have ensured, 'secret data is encrypted using some
functions with key'.
I shall follow both encode i.e, 1) filed and table name, 2) data level? Or
only data level is
- Original Message -
> From: "Vikram A"
>
> My question is, DO i face any negative project management problems by
> doing this? Pleas share your experience on this aspect and commend
> our idea.
Seems... a bit pointless, no? If someone has access to the database, they can
still see the
Hello there,
I request you to give your commends on the following,
1. We have planned to cipher our table name and filed name [the necessary data
will be ciphered with predefined functions with 'key']
2. This cipher functions will be our own code
3. Using these functions we can
r me, though, because I want the table name "dante" to not
be visible to other connections. The whole point of this code is to enable
me to create "alias" names for tables inside a stored procedure.
Can someone tell me why the temporary merge table is failing?
Dante
yhow, let me know what you think of this strategy for sidestepping the
need for prepared statements when working with MyISAM tables passed to
stored procedures.
-- Dante
Regards,
Gavin Towey
-Original Message-
From: Dante Lorenso [mailto:da...@lorenso.com]
Sent: Thursday, December 10, 2009 3:20
To: mysql@lists.mysql.com
Subject: stored procedure and random table name -> temp table, merge, prepared
statement
All,
I have a stored procedure that I'm writing where I need to run a lot of
queries against a particular table. The name of the table will be a
parameter to the stored procedure
table, I don't want to have to use
prepared statements for all the queries because treating my queries as
strings gets ugly. Ideally I want to use the table name as a variable in
the stored procedure, but as a hack around that, I thought about trying this
trick instead: give the table name an a
table for this table.
Also, this table name is passed as a parameter for another SP, but instead
of get the value of the parameter, I got the name of the parameter. For
example:
CREATE PROEDURE my_test_sp()
BEGIN
DECLARE my_table CHAR(32);
SET my_table = UNIX_TIMESTAMP();
CREATE
Hi, I'm creating a stored procedure and inside this procedure I have a
CREATE TABLE statement, but I want to make a dynamic table for this table.
Also, this table name is passed as a parameter for another SP, but instead
of get the value of the parameter, I got the name of the parameter
d
> with MySQL. I found that some of the tests were failing, apparently because
> of table name case-sensitivity issues. I was able to fix some of the code
> references, but after that I hit other, probably for the same issue. The
> tables were created with lower case names, but g
Ubuntu 8.10.
I was experimenting with the Spring Petclinic sample application,
configured with MySQL. I found that some of the tests were failing,
apparently because of table name case-sensitivity issues. I was able to
fix some of the code references, but after that I hit other, probably
Hi,
I made a silly typo:
Joerg Bruehe wrote:
> [[...]]
>
> So allowing placeholders (variables) for identifiers (table, column, and
> other database object names) would block (future) optimization.
>
> That is (probably) the reason why the SQL standard also does not allow
> this.
Hi all!
Paul DuBois wrote:
>
> On Feb 14, 2009, at 8:00 PM, Moon's Father wrote:
>
>> Thanks for your fast reply.
>>
>> Do you know MySQL will support this feature in the future?
(("this feature" = placeholders for table names in prepared statements))
>
> It doesn't need to. Baron indicated h
set @b = 'g';
set @stmt = concat('select * from ?,? where a.id = g.id');
prepare s1 from @stmt;
execute s1;
drop prepare s1;
END$$
DELIMITER ;
But it didn't work for me.
So what I want to know is how to table name when there're a
placeholder
within sproc.
You c
> >drop prepare s1;
> >END$$
> >
> > DELIMITER ;
> >
> > But it didn't work for me.
> > So what I want to know is how to table name when there're a placeholder
> > within sproc.
>
> You can't use placeholders for identif
from ?,? where a.id = g.id');
>prepare s1 from @stmt;
>execute s1;
>drop prepare s1;
>END$$
>
> DELIMITER ;
>
> But it didn't work for me.
> So what I want to know is how to table name when there're a placeholder
> within sproc.
You can'
>How do you escape a dash in a table name such as temp-08-08-28?
Best not to use them at all. If you must for some odd reason, use
backticks round the name.
PB
Dan O'Keefe wrote:
How do you escape a dash in a table name such as temp-08-08-28?
Thanks,
Dan
--
MySQL General
Using backticks
`temp-08-08-28`
Cheers,
Ewen
On Thu, Aug 28, 2008 at 1:01 PM, Dan O'Keefe <[EMAIL PROTECTED]> wrote:
> How do you escape a dash in a table name such as temp-08-08-28?
>
> Thanks,
>
> Dan
>
> --
> MySQL General Mailing List
> For list archi
Dan O'Keefe wrote:
How do you escape a dash in a table name such as temp-08-08-28?
Thanks,
Dan
How about `` ?
hth,
Stijn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How do you escape a dash in a table name such as temp-08-08-28?
Thanks,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can you just do
SELECT t1.*, "t1" as tablename FROM t1
UNION
SELECT t2.*, "t2" as tablename FROM t2
Roger
-Original Message-
From: Miguel Vaz [mailto:[EMAIL PROTECTED]
Sent: 17 February 2008 00:04
To: mysql@lists.mysql.com
Subject: select with table name
At 12:04 AM + 2/17/08, Miguel Vaz wrote:
Hi,
I have a small issue that i can get my head around to solve:
Is it possible to do a select from two tables using a union
all (select * from t1 union all select * from t2), and have it
display the table name in front of each
Hi,
I have a small issue that i can get my head around to solve:
Is it possible to do a select from two tables using a union all
(select * from t1 union all select * from t2), and have it display
the table name in front of each row?
What i need is, on the big resulting
AIL PROTECTED]>
To:
Sent: Monday, December 11, 2006 8:39 PM
Subject: Prefixing fields with table name when joining?
I have three tables (x, y, and z) with the same 3 fields (id, name,
number). If I do:
SELECT * FROM x, y, z WHERE ...
each row of my result will contain 3 id fields, 3 name fiel
,
y.id AS y_id, y.name AS y_name, y.number AS y_number,
z.id AS z_id, z.name AS z_name, z.number AS z_number
FROM x, y, z WHERE ...
Short of scripting, is there any way to get MySQL to do this? Something like:
SELECT * FROM x, y, z PREFIX FIELDS WITH TABLE NAME WHERE ...
--
We're
Hello.
My advice doesn't solve your issue, but if you had a 5.0, you would have
been able to use INFORMATION_SCHEMA to retrieve the table names and
assign them to variables. Then using prepared statements and variables
you can dynamically drop a table. And at the end, you can put all this
stuff in
Hello,
I'm using mysql 4.1.14-standard.
I would like to drop multiple tables in one or few queries. I don't
have an easy way to predict their names (I have a way to find their
names, but it's by using software and I prefer doing it with mysql).
All of the table names have a fixed part which I
:41PM +0200, Gleb Paharenko wrote:
> AESYS S.p.A. [Enzo Arlati] wrote:
> > I need to pass to a stored procedure a var a table name.
--
Definition of Terror: A female Klingon having a bad hair day.
This message is PGP/MIME signed.
pgpnepMnZ0Wfx.pgp
Description: PGP signature
to a stored procedure a var a table name.
> But I don't known how use the variable in the sql statement.
> If I use the method described belowe I get an error, the procedure use the
> variable name as the name of the table.
> Someone can help ?
>
> CREATE FUNCTION `myF
I need to pass to a stored procedure a var a table name.
But I don't known how use the variable in the sql statement.
If I use the method described belowe I get an error, the procedure use the
variable name as the name of the table.
Someone can help ?
CREATE FUNCTION `myFunc`( tbl_name va
y, when you type the first few letters of a table name and
press
tab, the mysql client does not auto complete anymore. Can this be
enabled with a my.cnf setting or something since it is no longer the
default behaviour on my machine?
Hello.
Try 'rehash' command.
Kieran Kelleher <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: US-ASCII, 15 lines --]
>
> Normally, when you type the first few letters of a table name and press
> tab, the mysql client does not auto co
Normally, when you type the first few letters of a table name and press
tab, the mysql client does not auto complete anymore. Can this be
enabled with a my.cnf setting or something since it is no longer the
default behaviour on my machine?
Regards, Kieran
Hi.
select concat(database(),_utf8".",_utf8'table')
works fine. It is not clear for me - what is the problem? You can choose charset
according to your local settings.
Nick Arnett <[EMAIL PROTECTED]> wrote:
> I don't see a way to ask MySQL what the "full" name of a table is... the
I don't see a way to ask MySQL what the "full" name of a table is... the
equivalent of this:
SELECT CONCAT(DATABASE(), ".", "table_name")
which would return something like this (assuming the current database is
called "my_database":
my_database.table_name
The reason I want this is to ensure tha
ase at http://bugs.mysql.com/ ?
> b)
> SELECT products.*, categories.name AS categoryname FROM products,
> categories WHERE MATCH(products.name,products.description)
> AGAINST('keywords');
>
> works anyway well.
>
> 2) Table name locking doesn't work with ta
.name,p.description) AGAINST('keywords');
It will cause an error that there is no FULLTEXT index matching the query.
b)
SELECT products.*, categories.name AS categoryname FROM products,
categories WHERE MATCH(products.name,products.description)
AGAINST('keywords');
works anyway we
"Bluemel, Marco" <[EMAIL PROTECTED]> wrote:
> I have a problem with mysql 4.0.18 on WindowsXP
> I set the lower_case_table_names=2 as it is mentioned for windows
> t the mysql website.
>
> (before I'm using version 4.0.15 and had set it to 0)
> so the tablenames should be stored in this case as I w
Hi,
I have a problem with mysql 4.0.18 on WindowsXP
I set the lower_case_table_names=2 as it is mentioned for windows
at the mysql website.
(before I'm using version 4.0.15 and had set it to 0)
so the tablenames should be stored in this case as I wrote it.
So I create a table in Java wi
On Mon, 2004-02-23 at 08:56, Tim Hayes wrote:
> OK
>
> There is still the possibility of an in-compatability between the 2
> platforms.
>
> However - in both Linux and Windows (MySQL 4.0.17) the variable is not
> recognized / updateable using the set command!
>
>
> I get - Unknown system variab
At 16:56 + 2/23/04, Tim Hayes wrote:
OK
There is still the possibility of an in-compatability between the 2
platforms.
However - in both Linux and Windows (MySQL 4.0.17) the variable is not
recognized / updateable using the set command!
Correct. You must set it using an option at server start
fault setting.
"
I think it is bad programming style to have tables whose name only differs
in case. I recommend using in my.cnf
lower_case_table_names=1
on all platforms.
Regards,
Heikki
..
List: MySQL General Discussion
From: Tim Hayes Date:February 23 2004 5:56pm
Subject: Re:
al Message -
From: "Peter Zaitsev" <[EMAIL PROTECTED]>
To: "Tim Hayes" <[EMAIL PROTECTED]>
Sent: Monday, February 23, 2004 4:19 PM
Subject: Re: Table Name Case Sensitivity
> On Mon, 2004-02-23 at 08:15, Tim Hayes wrote:
> > Can anyone offer advice?
>
"shortcoming"?
> Postgress rejects duplicate table names.
It is a design feature - shortcoming if you will. For MyISAM tables, each
table is a file (well, three files). The table name therefore shares the
case (in)sensitivity of the underlying OS. The same will apply to database
names, b
Tim Hayes said:
> Can anyone offer advice?
>
> I have come across a MySQL database on Linux with duplicate table
> names - "Accounts" and "accounts". This seems fine on Linux, but
> does not transfer to the Windows environment - it is rejected
> because of the duplicate name. However I do see that
Can anyone offer advice?
I have come across a MySQL database on Linux with duplicate table names - "Accounts"
and "accounts". This seems fine on Linux, but does not transfer to the Windows
environment - it is rejected because of the duplicate name. However I do see that
Column Names have to be
Eduardo
MySQL does not use the square brackets [] as field delimiters. Try to use
`Clientes of Supermarkets` instead
Note, these are not single quotes (') but ASCII 96
Freddie
-Original Message-
From: Eduardo Melo [mailto:[EMAIL PROTECTED]
Sent: Sonntag, 26. Oktober 2003 14:40
To: [EM
Hi all !
I am migrating my database from MS-ACCESS to MYSQL. When I try to use a
select statement below the application fails.
select * from [Clientes of Supermarkets]
anybody have an idea ?
best regards,
Eduardo F. Melo
_
MSN M
ccess Method
> >
> >
> > Matt
> >
> >
> > - Original Message -
> > From: "Jim Mathews"
> > Sent: Saturday, October 18, 2003 3:44 PM
> > Subject: Pronunciation of ISAM table name
> >
> >
> > > I have a very b
Hi
- Original Message -
From: "Matt W" <[EMAIL PROTECTED]>
To: "Jim Mathews" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, October 18, 2003 10:18 PM
Subject: Re: Pronunciation of ISAM table name
> Hi Jim,
>
> As far as I kn
Hi Jim,
As far as I know: eye-sam & my-eye-sam. At least that's how I pronounce
them. :-)
Matt
- Original Message -
From: "Jim Mathews"
Sent: Saturday, October 18, 2003 3:44 PM
Subject: Pronunciation of ISAM table name
> I have a very basic newbie question th
I have a very basic newbie question that, despite
multiple searches, I have been unable to find an
answer to. How is ISAM pronounced? Is it:
1. eye-sam (As in I dont like green eggs and ham,
Sam I am.)
2. is-am
3. I-S-A-M (with the individual letters spoken out
like most acronyms)
I
anonymous
user accounts. Must have dropped that ;-)
>
> Best regards
>
> Nils Valentin
> Tokyo/Japan
>
> 2003年 7月 3日 木曜日 06:18、Dan Ullom さんは書きました:
> > I recently stumbled onto the ability to log into a mysql server from the
> > command line with any table name, an
anonymous user
accounts. ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 3日 木曜日 06:18、Dan Ullom さんは書きました:
> I recently stumbled onto the ability to log into a mysql server from the
> command line with any table name, and a blank password. ie: mysql -u mysql
> My root account has
I recently stumbled onto the ability to log into a mysql server from the command line
with any table name, and a blank password. ie:
mysql -u mysql
My root account has a password set, and a few users with limited access but I haven't
done much else as far security goes.
I've tried
"Me" <[EMAIL PROTECTED]> wrote:
>
> I would like to know how to create a table within MySQL at the command
> prompt where the table name will be something like:
>
>
> MyTableName_TodaysDate
>
>
> Is this possible while at the command prompt? I a
I would like to know how to create a table within MySQL at the command
prompt where the table name will be something like:
MyTableName_TodaysDate
Is this possible while at the command prompt? I am trying to create a batch
file that will create a table in MySQL based on todays date. The
thanks heaps that works abosultely fine
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 6:00 PM
To: Daniel Rossi
Cc: [EMAIL PROTECTED]
Subject: RE: get table name from select staement as output as field
On 30-Mar-2003 Daniel Rossi wrote:
>
On 30-Mar-2003 Daniel Rossi wrote:
> hi guys is this possible ? select tablename1 as table1, id from
> tablename1 , tablename2 ?
>
select 'tablename1' as table1, id from ...
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So
hi guys is this possible ? select tablename1 as table1, id from tablename1 ,
tablename2 ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 15:40 +1100 3/28/03, Daniel Rossi wrote:
hi there i would like to find out how to get the table from a field
if i am joining three tables together for instance select a.id,
b.id, c.id from a, b, c
when i get the results i need to be able to get the table name a if
i get the result from
hi there i would like to find out how to get the table from a field if i am joining
three tables together for instance select a.id, b.id, c.id from a, b, c
when i get the results i need to be able to get the table name a if i get the result
from a.id , is it possible ?
--
MySQL General
On Tue, 2003-03-11 at 07:33, Richard Taubo wrote:
>
> When using the Union statement in MySQL, is it possible to retrieve the
> corresponding table name for a given row? The reason I need to know
> this is that I present info from different tables in their own way. I
> know
Hi!
Sorry for the repost, but I am really eager to hear the verdict so I
give it another go, thanks ;-)
When using the Union statement in MySQL, is it possible to retrieve the
corresponding table name for a given row? The reason I need to know
this is that I present info from different tables
Hi!
When using the Union statement in MySQL, is it possible to retrieve the
corresponding table name for a given row? I know I can create a column
in each table that describes which table the row actually is being
retrieved from, but I am looking for a more intelligent solution.
Thanks
names "MLSData1" and we had those table
names programmed into the mysql.db permissions table with the mixed case
for our PHP scripts to connect. (localhost)
Upgrading to 3.23.55 from a previous version prevented our PHP from
connecting until we lowercased the table name column entry to &#
* Ben Clewett
> I was trying to create a table named 'con' on version 3.23.52-max-nt and
> found my request was ignored:
>
> mysql>
>create table if not exists con (
> code integer unsigned not null auto_increment primary key,
> ...
> ...
>) type=innodb;
> Query OK, 0 rows af
MySql,
I was trying to create a table named 'con' on version 3.23.52-max-nt and
found my request was ignored:
mysql>
create table if not exists con (
code integer unsigned not null auto_increment primary key,
...
...
) type=innodb;
Query OK, 0 rows affected (0.00 sec)
A 'show ta
12:12
An: MySQL
Betreff: Odd behaviour if you use incorrect case for table name
I thought you might be interested in a bug that I traced to my having used
the wrong case for the table name. This had me baffled for a while because
the behaviour was not consistent, sometimes the error was duplicat
I thought you might be interested in a bug that I traced to my having used
the wrong case for the table name. This had me baffled for a while because
the behaviour was not consistent, sometimes the error was duplicate key,
other times wrong column count
CORRECT BEHAVIOR
the contents of the hidden field just to be sure it is correct,
and that does indeed show what I expect. I then make the query statement
point to the variable but it always responds that it cannot find the
table. The table does exist, the variable does contain the appropriate
table name, but is not
Hi,
> To answer my own question yes this word is reserved.
Yes, it is reserved, but you may still use it any query that you like, by
quoting the name. To take from the manual:
"Note that if the identifier is a restricted word or contains special
characters you must always quote it with ` when y
I get the ID-10-T award of the day.
http://www.mysql.com/doc/R/e/Reserved_words.html
To answer my own question yes this work is reserved.
PEBKAC
Thank You
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
Does mysql allow you to name your table
Does mysql allow you to name your tables anything. I created a table
called 'purge' and insert 3 field purgeday, purgemonth, purgeyear. ALL of
the fields are set to INT or INT NOT NULL.
When I try to add a record to this table I get and error 'SELECT * FROM
purge LIMIT 0,50'
Anyone have a clu
TABLE IF
> EXISTS INT'
>
> Is there any way around this, or must I use a different table
> name than 'INT'
You can use reserved words as table and field names by putting them
inside backtics ` `.
http://www.mysql.com/doc/L/e/Legal_names.h
use a different table
name than 'INT'
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
http://www.johnsons-web.com
-
Before posting, please check:
http://www.mysql.com/ma
Hello.
To answer only a part:
On Fri, Apr 26, 2002 at 03:26:15PM -0400, [EMAIL PROTECTED] wrote:
[...]
> Having loaded these tables, the mysql
> monitor appears not to care about case:
>
> mysql> select ID from Maps;
> ++
> | ID |
> ++
> | 1 |
> ++
> 1 row in set (0.00 sec)
>
> my
mysqldump does not preserve table name case when dumping tables on my
Windows platform.
Distribution file name: mysql-3.23.49-win.zip
C:\mysql\bin>mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.49, for Win95/Win98 on i32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX Dat
oesn't exist
mysql>
nickg
-Original Message-
From: David Chen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 2:20 PM
To: nickg; [EMAIL PROTECTED]
Subject: Re: "-" character in table name
mysql> describe 'A-14c';
ERROR 1064: You have an error in
lt;[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 2:13 PM
Subject: RE: "-" character in table name
> Try enclosing it:
>
> describe `A-14c`;
>
> nickg
>
>
> -Original Message-
> From: David Chen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday
Have you tried delimiting the table name with some form of quotes?
> -Original Message-
> From: David Chen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 10, 2002 4:05 PM
> To: [EMAIL PROTECTED]
> Subject: "-" character in table name
>
>
> Hell
Try enclosing it:
describe `A-14c`;
nickg
-Original Message-
From: David Chen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 2:05 PM
To: [EMAIL PROTECTED]
Subject: "-" character in table name
Hello,
I probably installed a PHP script that created a table with
Hello,
I probably installed a PHP script that created a table with a - in its name.
I can't figure out how to even touch this table. If I try:
mysql> describe A-14c;
ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1
This table exists for sure though:
| Tables_in_blesysdb
At 19:00 +0200 3/24/02, Okan CIMEN wrote:
>Hello,
>
>I am trying to write a script that creates tables via a cronjob but I want
>to name these tables including the current date as a suffix -like
>transections_20020324- . Does anybody know the SQL statement that entegrates
>the t
Hello,
I am trying to write a script that creates tables via a cronjob but I want
to name these tables including the current date as a suffix -like
transections_20020324- . Does anybody know the SQL statement that entegrates
the table name with the current date?
I tried to do it by storing the
Since Mac OS X is Unix it should use the same rules as a Unix machine
when it comes to MySQL and case sensitivity of table and database
names. According to Dubois: "DB and tables in MySQL correspond to
directories and files in the underlying file system on the server
host. As a result, case se
Is this what you are looking for?
RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]
Just take a look at the manual!
Cheers, Nessi
At 09:22 22/06/01 , you wrote:
>how do i change a table's name without recreating it?
>
>
> how do i change a table's name without recreating it?
See:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
ALTER TABLE RENAME TO
Take care,
seth
---
Seth Northrop
Manager of Information Technology
Reflectivity, Inc.
3910 Freedom Circle, Suite 103
Santa Clara, CA 95054
voice: 408-970-8881 x
how do i change a table's name without recreating it?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMA
Heikki,
> when you try to create the table test with type = innodb,
> does the server print into the error log or to the screen:
> Innobase: error: table test/test already exists in Innobase data
dictionary
Yes, indeed. I missed that line between all the stack backtrace output.
> If so, then yo
Markus,
when you try to create the table test with type = innodb,
does the server print into the error log or to the screen:
Innobase: error: table test/test already exists in Innobase data dictionary
If so, then you have probably created the table already in the InnoDB
format and deleted the .
At 20:41 20/06/2001 +0200, Markus Wichitill wrote:
Hi,
Thanks for the bug report. I was be able to repeat the issue
after I dropped the already existing database test.
The problem is InnoDB applies the following error:
Innobase: error: table test/test already exists in Innobase data dictionary
Hi,
I'm using MySQL 3.23.39-log compiled from sources on SuSE Linux 6.4. When I
create an InnoDB table with the same name as the database, I get the
following error message:
mysql> create database test;
Query OK, 1 row affected (0.01 sec)
mysql> create table test (x int) type=innodb;
ER
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
> >
;[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
> tick " ` " like
>
> create table `my foo` (`foo column` char(10) primary
&
1 - 100 of 106 matches
Mail list logo
