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 with some
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 instance
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 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 to
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
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`
There is
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.
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 a difference. Casing Matters in *nix.
However there is an option for turning if off.
# http://dev.mysql.com/doc/refman/5.0/en
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 a difference. Casing Matters in *nix.
However there is an option for turning if off.
# http
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.
Pl. help me,
Thanks,
Abhishek jain
* 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 a difference. Casing Matters
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
that gets mapped to a file system
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.
Pl. help me,
Hi,
Windows
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 case and in other places it is in capital
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
--
MySQL General Mailing
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
The previous version
* 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 problem and have a smooth upgrade
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 work. Is there any
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
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
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 SQL create statement.
Is this possible or am I thinking about this all wrong? The input I am given
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 SQL create statement.
You are mixing purposes. MySQL has a CREATE TABLE statement
clever people out there
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's First ISP
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
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
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...
I am working
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 \
: [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
Replies embedded:
Patrick [EMAIL PROTECTED] wrote on 10/03/2005 03:43:20 PM:
There are many ways to approach this. How are you receiving the IP
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, Mysql is puking
on
format
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 different
design?
With regards
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?
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL
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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
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 question:
. To 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 First ISP
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 criticizing people's designs without
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 with dashes and spaces
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 tables?
Or each table has different
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 names. This, in my thinking,
is
a good thing by assuring
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
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,
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://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]
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?
Thank
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 later
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
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 mambo (open source CMS) table names
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,
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
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
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
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
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
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
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
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 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
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
.
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 of table and column names
You can turn off this feature to get
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 have table names that are grouped
by function
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_events
-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
: 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 prerelease)
C++ compiler: g++.real (GCC) 3.2.3 20030228 (Debian
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Smurf wrote:
Description:
How-To-Repeat:
mysql -ecreate table `FIELDS` (x int) test
mysqldump test
Fix:
Teach mysqldump to use backquotes.
Why not mysqldump --quote-names test
-Mark
- --
MySQL 2003 Users Conference -
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 create
BF one (but dissapeared from
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 way to use such table names
Submitter-Id: 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
Class: sw-bug
Release: mysql-3.23.44 (Official MySQL
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 with a
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
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 out the contents (tables)
of any
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?
Is it an
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 show
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
: 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 regarding
legal
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
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
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 hesitate to ask - I'm on the list and will
be watching this thread.
Thanx!
Ronald
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 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 the file id. Each
[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
in
MySQL@Linux is case sensitive, I am having troubles
connecting
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]
wrote:
-Original
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: Thu, 31 Jan 2002
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 have grants
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
) 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??
Correct. Table names may contain numbers, even start with
numbers -- but cannot consist solely
varchar(8) not null default '' )
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 about numerical table names only
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, Column, and Alias Names
A name may start
'' )
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 then??
Mickalo,
manual_Reference.html#Legal_names 7.1.5
[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 table `A-22bd` and run mysqlcheck
By accident, I don't know how (perhaps microsoft played me a trick), I
managed to create a table with a name containing spaces i. e. a useless
table with an illegal name.
Now would like to drop that table. Is there anyone who knows how?
H
Professor Håkan Elmqvist
Avdelningen för medicinsk
you can try
DROP TABLE `table name`;
Håkan Elmqvist wrote:
By accident, I don't know how (perhaps microsoft played me a trick), I
managed to create a table with a name containing spaces i. e. a useless
table with an illegal name.
Now would like to drop that table. Is there anyone who
Thanks for your very rapid response but:
mysql show tables;
+--+
| Tables_in_test |
+--+
| personer |
| resultat impl VT2001 |
| tentamen_impl_vt2001 |
+--+
3 rows in set (0.00 sec)
mysql drop 'resultat impl VT2001';
: www.rtx.dk
-Original Message-
From: Colin Faber [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, September 20, 2001 10:14 AM
To: Håkan Elmqvist
Cc: [EMAIL PROTECTED]
Subject: Re: Illegal table names
you can try
DROP TABLE `table name`;
Håkan Elmqvist wrote
I am sending this again since for some reasons undescores don't show up in
this forum. The third table name should read
tentamen_impl_vt2001 i.e. tentamen[underscore]implunderscore]vt2001 which
is legal.
Thanks for your very rapid response but:
mysql show tables;
+--+
|
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 |
+--+
3 rows in
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
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 `.
: 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
VT2001`' at line 1
I don't seem to have
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 syntax
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.
Hi!
I have a strange problem with my MySQL database!!
mysql show databases;
+--+
| Database |
+--+
| |
| |
| |
| |
| |
| |
| |
+--+
7 rows in set (0.00 sec)
Using mysql version 3.23.32 on Red Hat 7
Anyone
99 matches
Mail list logo