On 2/15/2012 22:16, Bobb Crosbie wrote:
Hi Folks,
I'm preparing an upgrade of a 5.0.51a database to 5.1.58 (Ubuntu 11.10) -
Some of the table names contain invalid characters which mysql_upgrade
(mysqlcheck) is attempting to escape by renaming the filename. However I'm
having trouble
Hi Folks,
I'm preparing an upgrade of a 5.0.51a database to 5.1.58 (Ubuntu 11.10) -
Some of the table names contain invalid characters which mysql_upgrade
(mysqlcheck) is attempting to escape by renaming the filename. However I'm
having trouble with some tables with long names.
For i
Marco, all,
Marco Bartz wrote:
> I accidentally sent it before finishing...
>
> I am looking for a way to do the following with a single query:
>> SELECT `ID`, `Name`, `Interface`,
>> (SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
>> `activeListings`
>> FROM `sites`
Marco Bartz wrote:
I accidentally sent it before finishing...
I am looking for a way to do the following with a single query:
SELECT `ID`, `Name`, `Interface`,
(SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
`activeListings`
FROM `sites`
I am querying the
I accidentally sent it before finishing...
I am looking for a way to do the following with a single query:
> SELECT `ID`, `Name`, `Interface`,
> (SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
> `activeListings`
> FROM `sites`
>
I am querying the sites table and I want
I am looking for a way to do the following with a single query:
SELECT `ID`, `Name`, `Interface`,
(select count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
`activeListings`
FROM `sites`
Hi guys, I wonder if there is any chance to set up replication/cluster with
different tables names on the servers (maybe using aliases for tables)
eg..
box1:
db name: base1
table name: users
box2:
db name: base1
table name: users_new
Any ideas?
Thanks in advance
--
Regards,
Ezequiel L.
uery
> > like
> > > select * from TAb1 ,will it make an effect.
> > > I have found that this is not a problem on windows but it is on
> > linux, i
> > > want a sol. for that a i can not change all the table names as in
> > some
> > > places it is
> > select * from TAb1 ,will it make an effect.
> > > I have found that this is not a problem on windows but it is on
> > linux, i
> > > want a sol. for that a i can not change all the table names as in
> > some
> > > places it is in small case and in ot
ter on linux ie if i have table name as tab1 and i execute query like
> select * from TAb1 ,will it make an effect.
> I have found that this is not a problem on windows but it is on linux, i
> want a sol. for that a i can not change all the table names as in some
> places it is in small
xecute query like
> select * from TAb1 ,will it make an effect.
> I have found that this is not a problem on windows but it is on linux, i
> want a sol. for that a i can not change all the table names as in some
> places it is in small case and in other places it is in capital case.
>
have found that this is not a problem on windows but it is on linux, i
> want a sol. for that a i can not change all the table names as in some
> places it is in small case and in other places it is in capital case.
Yes, this is a problem on Linux if you're using MyISAM etc, anything
e query like
> select * from TAb1 ,will it make an effect.
> I have found that this is not a problem on windows but it is on linux, i
> want a sol. for that a i can not change all the table names as in some
> places it is in small case and in other places it is in capital case.
Yes.. There
is not a problem on windows but it is on linux, i
want a sol. for that a i can not change all the table names as in some
places it is in small case and in other places it is in capital case.
Pl. help me,
Thanks,
Abhishek jain
#x27;t exist
mysql> select * from a;
Empty set (0.01 sec)
I have upgraded from mysql-4.0.17 to 5.0.21 ,and all the ANSI-SQL
queries from my application using UPPERCASE table names are bombing, i
immediately had to stop 5.0.21 and restart mysql-4.0.17.
Is there any way to get around this prob
Empty set (0.01 sec)
I have upgraded from mysql-4.0.17 to 5.0.21 ,and all the ANSI-SQL
queries from my application using UPPERCASE table names are bombing, i
immediately had to stop 5.0.21 and restart mysql-4.0.17.
Is there any way to get around this problem and have a smooth upgrade.
Regards
Digz
Empty set (0.01 sec)
I have upgraded from mysql-4.0.17 to 5.0.21 ,and all the ANSI-SQL
queries from my application using UPPERCASE table names are bombing, i
immediately had to stop 5.0.21 and restart mysql-4.0.17.
Is there any way to get around this problem and have a smooth upgrade.
Regards
Digz
C.R. Vegelin wrote:
Hi, I am looking for a method to use variable table names.
I have various download-tables, all having the same structure.
All I want is to run a series of queries on each of these tables.
I tried
SET @mytable = 'Download200501';
SELECT count(*) FROM @mytable
Hi, I am looking for a method to use variable table names.
I have various download-tables, all having the same structure.
All I want is to run a series of queries on each of these tables.
I tried
SET @mytable = 'Download200501';
SELECT count(*) FROM @mytable;
but this doen't wor
Thanks everyone for all of the replies! I have been banging my head against
this for a week now and I was never looking in the direction of the cron
script... Sometimes it helps having another set (or ten) of eyes looking at
the problem.
Thanks again!
On 10/3/05, Bastian Balthazar Bux <[EMAIL P
ad, that he wasn't looking for
help in db design, just a solution to the punctuation issue.
Pat...
- Original Message -
From: [EMAIL PROTECTED]
To: Patrick
Cc: Chance Ellis ; mysql@lists.mysql.com
Sent: Monday, October 03, 2005 4:30 PM
Subject: Re: Table names with periods
Repl
Chance Ellis wrote:
[snip]
> of CREATE TABLE entries. I then import those files with a cron script into
> mysql. This is where I am looking to convert IP address into something
[snip]
There is a world of possibilities at this point, one is this:
sed \
--expression='s/@@@NEEDTOREPLACETHIS\([012345
You should be able to do the conversion when you run the cron script. Or at
least just before. Preprocess the output from syslog-ng to translate all .
to _. in the table names.
Jerl
On 10/3/05, Chance Ellis <[EMAIL PROTECTED]> wrote:
>
> So more information about the project...
&g
Chance Ellis wrote:
[snip]
Thus, syslog-ng creates a file that contains a bunch of CREATE TABLE
entries. I then import those files with a cron script into mysql.
This is where I am looking to convert IP address into something
without periods. I cannot perform logic within the .conf file and it
a
ic SQL and I am not 100% sure it would
> accept what you typed.
>
> >
> > You would obviously add your "CREATE TABLE" options and "INTO
> > OUTFILE" options as needed.
> > This would be an alternative to converting IPv4 to 32bit Integer.
> >
>
this helps...
>
> If at all possible, it is probably best to continue in the MySQL
> list, there are some pretty clever people out there
>
> Pat...
>
> [EMAIL PROTECTED]
> CocoNet Corporation
> SW Florida's First ISP
> 825 SE 47th Terrace
> Cape Coral, FL 3390
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: Chance Ellis
To: Patrick
Sent: Monday, October 03, 2005 2:22 PM
Subject: Re: Table names with periods
Patrick,
I have been trying to figure out how I can convert an IP address to a 32bit
integer within a S
adily converted to
> single 32bit integers that minimize the need for dotted quartets.
>
> Early versions of MySQL allowed periods. This caused OS incompatibility
> issues. To my knowledge this was fixed prior to version 3 and you are no
> longer allowed periods in database or table
From: "Chance Ellis" <[EMAIL PROTECTED]>
Point taken and yes the manual was reviewed. However, I thought in the past
that I had seen someone post a method in which table names could be created
with special characters.
Can't you use a single table instead of more tabl
>Point taken and yes the manual was reviewed. However, I thought in the past
>that I had seen someone post a method in which table names could be created
>with special characters.
Most special characters can be used by using "back ticks":
`my_special name - for example wit
Point taken and yes the manual was reviewed. However, I thought in the past
that I had seen someone post a method in which table names could be created
with special characters.
On 9/28/05, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>
> >
> >
>
> >Instead of critic
my knowledge this was fixed prior to version 3 and you are no
longer allowed periods in database or table names. This, in my thinking, is
a good thing by assuring greater portability and easier migration.
I hope this helps.
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's Firs
>
>
>Instead of criticizing people's designs without understanding the
>requirements why don't you just answer the question, or don't you know
>either?
PS: As Shawn (who is more helpful in giving fast answers ;-) pointed
out: the answer can be found in the manual...
Which begs for another questi
re this has been asked before but I can't seemed to find it.
> > Canyou create table names with periods in them? I need to create tables
> >based on the IP address of machines (x.x.x.x)
>
> Ehm. Why?
>
> Instead of going the "silly table names" route, why not try a diffe
27;t seemed to find it.
> > Canyou create table names with periods in them? I need to create tables
> >based on the IP address of machines (x.x.x.x)
>
> Ehm. Why?
>
> Instead of going the "silly table names" route, why not try a different
> design?
>
>
>
>I am sure this has been asked before but I can't seemed to find it.
> Canyou create table names with periods in them? I need to create tables
>based on the IP address of machines (x.x.x.x)
Ehm. Why?
Instead of going the "silly table names" route, why not try a diff
Chance Ellis <[EMAIL PROTECTED]> wrote on 09/28/2005 11:56:53 AM:
> I am sure this has been asked before but I can't seemed to find it.
> Canyou create table names with periods in them? I need to create tables
> based on the IP address of machines (x.x.x.x) Currently,
I am sure this has been asked before but I can't seemed to find it.
Canyou create table names with periods in them? I need to create tables
based on the IP address of machines (x.x.x.x) Currently, Mysql is puking on
format.
Any ideas?
Thanks
Hello,
I was wondering if there is any way to get SELECT result with
`table_name.col_name` column names.
It seems to me that I have had such result set before (Not with my
current installation/configuration / :4.0.23_Debian-4). ( I know about
column aliases, but is this a the best or the only
http://dev.mysql.com/doc/mysql/en/show-tables.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 11:22 AM 4/21/05, Darryl Hoar wrote:
I am running Mysql 3.23. Is there an sql statment that will allow me
programmatically to retrieve the names of the tables in a database ?
show tables;
Yes, this is an SQL statement!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
At 10:22 -0500 4/21/05, Darryl Hoar wrote:
Greetings,
I am running Mysql 3.23. Is there an sql statment that will allow me
programmatically
to retrieve the names of the tables in a database ?
http://dev.mysql.com/doc/mysql/en/show-tables.html ?
--
Paul DuBois, MySQL Documentation Team
Madison, Wis
Greetings,
I am running Mysql 3.23. Is there an sql statment that will allow me
programmatically
to retrieve the names of the tables in a database ?
thanks,
Darryl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PR
Mauricio Pellegrini wrote:
Hi,
I'm using MySql 4.1.4 gamma and there are certain circumstances in
wich I need to create tables with random names from within querys.
And after using them I need to drop them; so I need a way to *remember*
these table names so I can dispose them later.
Is
At 06:56 AM 12/18/2004, you wrote:
Hi,
I'm using MySql 4.1.4 gamma and there are certain circumstances in
wich I need to create tables with random names from within querys.
And after using them I need to drop them; so I need a way to *remember*
these table names so I can dispose them late
Hi,
I'm using MySql 4.1.4 gamma and there are certain circumstances in
wich I need to create tables with random names from within querys.
And after using them I need to drop them; so I need a way to *remember*
these table names so I can dispose them later.
Is that possible with MySql?
Try enclosing it in backticks like this. `#table`
Here is the url for reference:
http://dev.mysql.com/doc/mysql/en/Legal_names.html
On Fri, 3 Dec 2004 13:37:38 -0600, Daniel Kemper <[EMAIL PROTECTED]> wrote:
>
>
>
> Hello,
>
>
>
> As you may know, the
Hello,
As you may know, the mambo (open source CMS) table names
begin with a “#” character. How does one describe a table that
begins with “#”?
-DK
Daniel Kemper
Lead Programmer
Intellisys, Inc.
I don't know if your desire to use the subquery form is academic or
performance driven. If I were having this much trouble getting a subquery
to work, I would refactor my queries using JOIN statements.
http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html
(your query #1 below)This query w
Hello, Lana.
Both queries works fine in 4.1.7 version. There were a lot of bugs in
earlier versions of MySQL with subqueries. I think you should upgrade to the
latest release.
Did you use $sql=".." in mysql client program? That won't work.
Try just
SELECT * from user_info WHERE (login_name
Hello,
Since I had a problem with except operator and subqueries, I investigated a
topic on mysql version capability. I tried a few examples which were offered
on this mailing list, all of them gave me a syntax error, so I've read a
manual and tried some examples from it. However, things that m
At 18:27 -0800 11/1/04, Ginger Cheng wrote:
Hello, MySQL gurus,
I am just wondering if there is a way to set MySQL so that you
can have the name of the mysql table completed for you if you hit
tab, like typing file names in bash, you only need to type enough
characters to uniquely identify
It should already by enabled for you unless you have the line
no-auto-rehash in your my.cnf configuration file. Or you could be
starting mysql with --no-auto-rehash or -a.
On Mon, 2004-11-01 at 20:27, Ginger Cheng wrote:
> Hello, MySQL gurus,
>I am just wondering if there is a way to set
Hello, MySQL gurus,
I am just wondering if there is a way to set MySQL so that you
can have the name of the mysql table completed for you if you hit tab,
like typing file names in bash, you only need to type enough characters
to uniquely identify the file or directory name, then you press
At 13:00 -0500 12/17/03, Mayuran Yogarajah wrote:
Paul DuBois wrote:
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote:
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT
Paul DuBois wrote:
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote:
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote:
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table name is still MyTest
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table name is still MyTest
but selects work with mytest ?
--
MySQL General
files for each of the
> databases.
>
> Under OSX I connect top the server and it sees the databases. If I use
> some_database where some_database has mixed case table names I see errors such
> as this:
>
> mysql> use some_database
> Reading table information for completion
Hi. We are migrating our Solaris setup to an OSX server. I used InnoDB Hot
Backup to copy the InnoDB files, and copied the .frm files for each of the
databases.
Under OSX I connect top the server and it sees the databases. If I use
some_database where some_database has mixed case table names I
"Knepley, Jim" <[EMAIL PROTECTED]> wrote:
>
> The docs explicitly say that wildcards are allowed when specifying
> database names in GRANT commands, but don't say anything about wildcards
> being allowed in table names.
> For example, in one large database I ha
The docs explicitly say that wildcards are allowed when specifying
database names in GRANT commands, but don't say anything about wildcards
being allowed in table names.
For example, in one large database I have table names that are grouped
by function:
security.ids_e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Friday 07 March 2003 18:38, Mark Matthews wrote:
> Why not mysqldump --quote-names test
Because I might not actually _want_ quoted names in my output.
This is not about the mysqldump output. This is about the correctness of
the statemen
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Smurf wrote:
Description:
How-To-Repeat:
mysql -e"create table `FIELDS` (x int)" test
mysqldump test
Fix:
Teach mysqldump to use backquotes.
Why not mysqldump --quote-names test
-Mark
- --
MySQL 2003 Users Conference -> http://www.
ySQL support: licence
>Synopsis: mysqldump doesn't quote table names
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-4.1.0-alpha (Bitkeeper), _old_ bug
>C compiler:gcc.real (GCC) 3.2.3 20030228 (Debian
Beuserie,
Tuesday, October 22, 2002, 8:15:33 PM, you wrote:
BF> i'm in process of migrating from a commercial dbms to mysql and
BF> have legacy tables referenced everywhere with names like 'tbl1#c'
--> '#' is not accepted for table names and must be escaped to cr
hi,
i'm in process of migrating from a commercial dbms to mysql and
have legacy tables referenced everywhere with names like 'tbl1#c'
--> '#' is not accepted for table names and must be escaped to create
one (but dissapeared from the table name then)
is there a
At 17:19 -0400 10/10/02, [EMAIL PROTECTED] wrote:
> >Description:
> It is possible to create a table which mysqldump can dump,
>but mysql cannot undump.
>>How-To-Repeat:
Yes. You'll probably have better luck if you run mysqldump with
the --quote-names option.
> Create a table
sers to name fields with reserved words
>Submitter-Id:
>Originator:
>Organization: 3edges
>MySQL support: none
>Synopsis: mysqldump allows reserved words as table names, but mysql does not
>Severity: non-critical
>Priority: low
>Category: mysql
>C
Mark,
> I notice that lots of mysql gui's all can find out the contents (tables)
> of any given database, how do they do this?
>
> Is it an sql command?
Parse the contents of "SHOW DATABASES" and then use the ouput of that to
"SHOW TABLES"...
mysql, query.
DSL
---
On Fri, 6 Sep 2002, Mark Worsdall wrote:
> Hi,
>
>
> I notice that lots of mysql gui's all can find out the contents (tables)
> of any given database, how do they do this?
>
> Is it an sql command?
>
> I hope so, I need to know what the SQL command is so I can pass it to
> perl DBI.
>
> M.
Try
The command "show tables;"
will give you what you want.
See: http://www.mysql.com/doc/en/SHOW.html
Gurhan
On Fri, 2002-09-06 at 02:42, Mark Worsdall wrote:
> Hi,
>
>
> I notice that lots of mysql gui's all can find out the contents (tables)
> of any given database, how do they do this?
>
> I
show tables from database;
- Original Message -
From: "Mark Worsdall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 2:42 PM
Subject: How to read table names within database?
Hi,
I notice that lots of mysql gui's all can find o
Hi,
I notice that lots of mysql gui's all can find out the contents (tables)
of any given database, how do they do this?
Is it an sql command?
I hope so, I need to know what the SQL command is so I can pass it to
perl DBI.
M.
--
Mark Worsdall
https://www.paypal.com/refer/pal=LS79YHQ9VUGLJ
table name: 021e0a5d20e6bf8211cfe55bd003a7c2
First of all I've seen no difference to the above
table names which were created correctly. Then I tried
to use
ph_021e0a5d20e6bf8211cfe55bd003a7c2
as table name, and everything was okay. But this is only
a workaround, so I tried to look up into the docs
Hi all,
You surely take note that a mysql server under windows take the same
table when selecting from T_User or t_user, it is case insensitive.
Every update into these tables rename all case sensitive table into
insensitive one.
I have to be carfull to check my tables names before copying data
Ronald,
Tuesday, May 14, 2002, 3:11:16 PM, you wrote:
RL> When testing some of our Perl/DBI code, we made a couple of tables with
RL> numeric names (e.g. test.1 test.2 etc), because the code we're making has to
RL> be able to handle them correctly. It does, w/o any problem, but mysqldump
RL> does
ck-tables --add-drop-table --user=root test
You also need the --quote-names option to tell mysqldump to quote
the table names as `1`, `2`, etc.
>
>mysqldump Ver 8.14 Distrib 3.23.41, for redhat-linux-gnu (i386)
>
>If you have any questions, don't h
Hello all,
When testing some of our Perl/DBI code, we made a couple of tables with
numeric names (e.g. test.1 test.2 etc), because the code we're making has to
be able to handle them correctly. It does, w/o any problem, but mysqldump
doesn't: I get a message "mysqldump: Got error: 1064: You have
>
>Does your master table have a list of table names and the table's
>characteristics? How is the search called?
currently i have a master table called "files", the primary key is id and
the data tables are called filedata1 filedata2, etc.
where 1 and 2 correspond to
rom: Mr Kent Cheung <[EMAIL PROTECTED]>
> Subject: Table names case sensitivity
> To: MySQL Discussion <[EMAIL PROTECTED]>
>
> Dear MySQL community,
>
> I am new MySQL user. I want to migrate a M$ SQL
> Server
> database to MySQL in a Linux box. Since table names
&
Mr,
Thursday, January 31, 2002, 12:29:24 PM, you wrote:
MKC> Hi,
MKC> As what I described in the original text, I have
MKC> changed the table names to lower cases. Thus, I think
MKC> I have done exactly what the manual says. Is this a
MKC> bug or what have I missed?
You
Hi,
As what I described in the original text, I have
changed the table names to lower cases. Thus, I think
I have done exactly what the manual says. Is this a
bug or what have I missed?
Thanks for your suggestion anyway.
Kent.
--- Egor Egorov <[EMAIL PROTECTED]> wrote:
> Date: Th
Mr,
Thursday, January 31, 2002, 6:01:21 AM, you wrote:
MKC> Dear MySQL community,
MKC> I am new MySQL user. I want to migrate a M$ SQL Server
MKC> database to MySQL in a Linux box. Since table names in
MKC> MySQL@Linux is case sensitive, I am having troubles
MKC> connecting to
Neil,
Thank you for your suggestion. Unfortunately, the
Grant command grants privileges to lower case table
names also. I have also tried to find solution from
archive of mysql mail lists but nothing useful have
been found.
Kent.
--- Neil Silvester
<[EMAIL PROTECTED]>
Dear MySQL community,
I am new MySQL user. I want to migrate a M$ SQL Server
database to MySQL in a Linux box. Since table names in
MySQL@Linux is case sensitive, I am having troubles
connecting to the server via ODBC from a Windows box.
I search the documentation and find that I may be able
to
Hi there,
I made a mySQL database with uppercase table names on a linux platform. I
migrated it, for maintenance reasons, on a win2000 platform. Now when I try
to put everything back I discovered that mySQL on win2000 changed my table
names to lowercase.
For java this is not a problem on the
gt;>CREATE TABLE 201 ( tagnumber varchar(8) not null default '' )
>>CREATE TABLE 301 ( tagnumber varchar(8) not null default '' )
>>I've looked thru various documentation about table reservered names and couldn't
>>find any info abou
ot null default '' )
I've looked thru various documentation about table reservered names and couldn't
find any info about numerical table names only.
Are numerical valued tables names not allowed then??
Mickalo,
manual_Reference.html#Legal_names 7.1.5 Database, Table, Index,
27; )
>>> I've looked thru various documentation about table reservered
>>> names and couldn't
>>> find any info about numerical table names only.
>>>
>>> Are numerical valued tables names not allowed then??
>>
>>Correct. Table na
27; )
> CREATE TABLE 301 ( tagnumber varchar(8) not null default '' )
> I've looked thru various documentation about table reservered
> names and couldn't
> find any info about numerical table names only.
>
> Are numerical valued tables names not allowed the
rchar(8) not null default '' )
I've looked thru various documentation about table reservered names and couldn't
find any info about numerical table names only.
Are numerical valued tables names not allowed then??
TIA,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=
[EMAIL PROTECTED] writes:
> >Description:
> mysql-utilities mysqlcheck and mysql_convert_table don't quote
> table names and so fail in converting/checking/repairing
> specially named tables.
>
> >How-To-Repeat:
> create e.g. a tabl
>Description:
mysql-utilities mysqlcheck and mysql_convert_table don't quote
table names and so fail in converting/checking/repairing
specially named tables.
>How-To-Repeat:
create e.g. a table `A-22bd` and run mysql
The character seems to be decimal 96 (enter it with Alt-96 on a PC).
Interestingly the command produces an error when the command is given
directly to mysql over a ssh connection but works fine when invoked with
Zeos Simple_mysql (http://www.zeoslib.org/zeos_zia_main.php ).
Thanks for the help.
Try using:
drop table `resultat impl VT2001`;
-Original Message-
From: Håkan Elmqvist [mailto:[EMAIL PROTECTED]]
Sent: 20 September 2001 9:34 am
To: [EMAIL PROTECTED]
Subject: Illegal table names
mysql> drop `resultat impl VT2001`;
ERROR 1064: You have an error in your SQL syn
; From: Håkan Elmqvist [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 10:34 AM
> To: [EMAIL PROTECTED]
> Subject: Illegal table names
>
> mysql> drop `resultat impl VT2001`;
> ERROR 1064: You have an error in your SQL syntax near 'resultat impl
> V
if all else fails shut the db down and go in your db directory and just
delete the data files ;-)
Håkan Elmqvist wrote:
>
> mysql> drop `resultat impl VT2001`;
> ERROR 1064: You have an error in your SQL syntax near 'resultat impl
> VT2001`' at line 1
> I don't seem to have the proper character
mysql> drop `resultat impl VT2001`;
ERROR 1064: You have an error in your SQL syntax near 'resultat impl
VT2001`' at line 1
I don't seem to have the proper character `. What's the ASCII?
H
Professor Håkan Elmqvist
Avdelningen för medicinsk teknik
Institutionen för medicinsk laboratorievetenskap
forward ticks
Håkan Elmqvist wrote:
>
> Thanks for your very rapid response but:
>
> mysql> show tables;
> +--+
> | Tables_in_test |
> +--+
> | personer |
> | resultat impl VT2001 |
> | tentamen_impl_vt2001 |
> +--+
1 - 100 of 107 matches
Mail list logo
