My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
being too old but how muc trouble is it to upgrade.the LIB
V. 3.23.40 is running but with 12 failed tests including bigint is
this an install I want to develop with.
Please advise
MYSQLBUG
SEND-PR: -*- send-pr -*-
SEND-P
Server is 3.23.40, for sun-solaris2.7 (sparc)
Is it possible to define an element of a key as being in descending order?
The info in the manual regarding the "Collation" index attribute says
that an index element can be "A" for ascending or NULL for not sorted
(why would you have an index elem
on 9/21/01 12:43 AM, Will French at [EMAIL PROTECTED] wrote:
> Actually yes (if I read the documentation correctly - I have not tried
> this).
> In MySql Manual section "4.10.5 Replication Options in my.cnf", I find:
> binlog-do-db=database_name
> Tells the master it should log updates fo
>Description:
MySQL fails to make under Mac OSX. During the make process
numerous errors are displayed, but are generally ignored until I start
recieving these errors:
/usr/bin/ld: multiple definitions of symbol _optarg
/usr/lib/libcurses.dylib(getopt.o) definition of _optarg
../libmy
Actually yes (if I read the documentation correctly - I have not tried
this).
In MySql Manual section "4.10.5 Replication Options in my.cnf", I find:
binlog-do-db=database_name
Tells the master it should log updates for the specified
database, and exclude al
On Thu, Sep 20, 2001 at 04:25:29PM -0500, Christopher Raymond wrote:
>
> Friends:
>
> My ISP does not enable update logging with their MySQL server. Is it
> possible for them or me to turn on update logging just for MY database(s)
> ???
No.
Jeremy
-
I have been receiving error 127 from table handler when running some basic
select queries on a large table 1.8 M rows.
I have run myisamchk with the -o -r and -e options but for each of them I
receive an error that is not fixed and I assume that this error is the same
one that is causing the 127 e
Hi,
I have a table that hold a lot of information about pricing and dates. I
would like to list the of differnce of prices between last week and this
week.
Adrian
-
Before posting, please check:
http://www.mysql.com/manual
Hey List,
I hope this is the right list to post this too, I apologize in advance if it
is not (this is a first post).
I'm having a bit of trouble with an application I'm writing in VC++6.0 MFC.
I get the following LNK Errors:
--
Try this:
CREATE TEMPORARY TABLE tmp_avldate (date datetime, nadate datetime);
INSERT INTO tmp_avldate (date, nadate)
SELECT DISTINCT schedule.date, nonavailable.date
FROMschedule LEFT JOIN nonavailable ON schedule.date = nonavailable.date;
SELECT dat
Hi all, just subscribed. Normally I work these out for myself, but time
and frustration are winning.
I have two tables:
SCHEDULE which contains a column called "date" and in that are DATETIME
entries from 2001-09-14 to who cares.
NONAVAIALBLE which contains users and dates they aren't availa
Hello everyone,
I have been running mysql for a little while now and my filesystem seems to get a
little tight. I decided to setup a file server that would provide one of its disk to
act as the mysql data drive.
Anyhow, the operation seemed to be quite simple:
1. Mount the new partition us
I encounter the same problem . And I think the BDB take the table lock
instead of row level lock.
To resolve the problem .You can use Innodb table.
>From: Monika Andr?Jönsson <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Berkeley DBD and locking
>Date: Thu, 20 Sep 2001 11:28:18 +0200
>
>
Thanks!
But my setting is "max_allowed_packet=50M",I have changed the setting
before I send the help. Someone tell me It may be the jdbc problem or the
stack value of jvm is too small.
I'm very puzzle !
>From: [EMAIL PROTECTED]
>Reply-To: <[EMAIL PROTECTED]>
>To: "'Àî Çà'" <[EMAIL PROTECTED]>
Or:
SELECT DISTINCT T1.item_number
FROM Attributes t1, Attributes t2, Attributes t3
WHERE
t1.item_number=t2.item_number
AND t2.item_number=t3.item_number
AND t1.attribute='sport' AND t1.value='football'
AND t2.attribute='league' AND t2.value='nfl'
AND t3.attribute='typeb' AND t3.value='jersey';
Neil,
Please indicate what you mean by converting the string "x" to a percent
value???
-Jason Garber
www.deltacron.com
At 08:51 AM 9/21/2001 +1000, Neil Silvester wrote:
>Another PHP problem has kept me up all night, scouring through my database
>books and trying everything I could think of.
A book I've found very usefull is 'MySQL and mSQL' by O'Reilly
You could use a query like this, but...
"select distinct item_number from Attributes where attribute like 'football'
and value like 'nfl' "
You will be happier if you rethink your layout and create multiple tables.
Give them unique
Hello,
I have a question about the best way to pose this question:
We have a table named Attributes:
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+
This really isn't a MySQL question and should be handled by another
list, But to answer your question (logically). You need to have the
whole string `productcategory.ID=\"$cat\"' optional, so that if your
variable `$cat' isn't populated the string
`productcategory.ID=\"$cat\"'
isn't included, Al
Another PHP problem has kept me up all night, scouring through my database
books and trying everything I could think of. I am still new to the MySQL
and PHP field, but never the lass I will not give up.
$cat is a variable that is passed to the query from the previous page. The
SELECT statement
Another PHP problem has kept me up all night, scouring through my database
books and trying everything I could think of. I am still new to the MySQL
and PHP field, but never the lass I will not give up.
$cat is a variable that is passed to the query from the previous page. The
SELECT statement
Another PHP problem has kept me up all night, scouring through my database
books and trying everything I could think of. I am still new to the MySQL
and PHP field, but never the lass I will not give up.
$cat is a variable that is passed to the query from the previous page. The
SELECT statement
Friends:
My ISP does not enable update logging with their MySQL server. Is it
possible for them or me to turn on update logging just for MY database(s)
???
I appreciate any help & God Bless America,
Christopher Raymond
Try running "ANALYZE TABLE x;" and redoing the query. If this fixes your
query, there is some index corruption going on. Are there any other queries
going through the system during these tests, or is it only your 2 threads?
There were some BDB index bugs fixed in the last few mysql releases, b
Hello folks
Thanks first of all for all your replies, this is helping to isolate the
problem, which I now have found is not an ADO problem but a DBTools 1.0.9
problem in it's parser.
Here is a way to create the problem:
CREATE TABLE tblCompany_test (CoName VARCHAR(50));
INSERT INTO tblCompany_
Robert,
there was a bug in 3.23.41 which caused InnoDB to ignore
SET INSERT_ID=...
That is a command used in replication of auto-inc columns.
That bug was fixed in .42, but obviously still some bug
remains.
It would be valuable to know how the master handles the
failing statement? What is the au
Ok, an accidental double posting I can understand... but this is the 4th
time in an hour that you have posted the same message...
Chill out!
> -Original Message-
> From: phani krishna [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 2:42 PM
> To: [EMAIL PROTECTED]
> Subjec
> "Update tblCompany SET CoName='"tester"' WHERE CoID=109"
It's not the query string. I just submitted this query using urSQL
(uses ODBC) and it worked just fine (assuming CoName is a varchar(32)).
I'm also able to successfully run this query and similar queries via ADO
from a Delphi applicat
On 20-Sep-2001 gaurang khatri wrote:
> Hello Friends,
>
> I am getting an error when using MySql with CGI. I am
> using Linux 6.2 with Apache 1.13.12 and MySql 3.22.32.
> I am getting following error:
>
> error in loading shared libraries: undefined
> symbol:mysql_num_fields
>
> Can anybody g
I need some help in installing MySQL.
I did the following things
1) Downloaded the mysql version 3.23.36-pc-linux-gnu-i686.tar.gz
2) tar -zxvf mysql-version
3) ln -s /usr/local/mysql-version mysql
4) adduser mysql
5) passwd mysql
6) chown -R mysql mysql-vesion mysql
7) chgrp -R root mysql-ve
Hello Friends,
I am getting an error when using MySql with CGI. I am
using Linux 6.2 with Apache 1.13.12 and MySql 3.22.32.
I am getting following error:
error in loading shared libraries: undefined
symbol:mysql_num_fields
Can anybody guide me why I am getting the error andthe
solution?
Thank
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both. i want to use one linux server as back up.so i
need to updat
Hello,
Before I say anything, know that I decided to kick the caffeine habit this
week... :)
I am having some problems with replication that I have been unable to to
figure out. Let me describe my systems. They are identical PIII PowerEdge
350s with 512megs of RAM and two 60GB drives in a RAID
Yes I see your point, Paul. If the bug is in fact in ado or in the oledb
driver for mysql, then I think the solution I outlined below using the
CONCAT and CHAR functions may still apply if only as a workaround to the
presumed ado/oledb bug.
On a related note:
Jay Fesco wrote:
> Paul et al - I th
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both. i want to use one linux server as back up.so i
need to updat
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both. i want to use one linux server as back up.so i
need to updat
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both. i want to use one linux server as back up.so i
need to updat
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both. i want to use one linux server as back up.so i
need to updat
hi all,
is there any way such that the data(any alteration of
the data like update , insert , delete etc) on server1
can synchroinize with the data on server2 in MYSQL
database.
i am having two linux servers with MYSQL running on
both. i want to use one linux server as back up.so i
need to updat
>
> There is no need for such an escape sequence because semicolons
> in strings are not special. Maybe it's an ADO bug.
>
Paul et al - I think his problem is with quotes, not semicolons. The line
"Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109" is what
leads me to believe this.
Tr
At 2:00 PM -0400 9/20/01, Will French wrote:
>There probably is a better way but the following should work:
>
>"UPDATE tblCompany SET CoName=CONCAT('"', CHAR(59), 'tester', CHAR(59),
>'"', CHAR(59)) WHERE CoID=109"
>
>Like you, I believe there probably is an escape sequence for the semi-colon
>but
There probably is a better way but the following should work:
"UPDATE tblCompany SET CoName=CONCAT('"', CHAR(59), 'tester', CHAR(59),
'"', CHAR(59)) WHERE CoID=109"
Like you, I believe there probably is an escape sequence for the semi-colon
but I'll be damned if I can find it documented. Until
At 6:44 PM +0100 9/20/01, johnlucas-Arluna wrote:
>Hello
>
>I'm trying to do the following:
>
>"Update tblCompany SET CoName='"tester"' WHERE CoID=109"
>
>But getting an error message
>
>I tried the escape character "\" like
>
>"Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109"
>
>but ge
> >
> > A basic description is that If Column A in Table 1 is Equal to
> Column A in
> > table 2 then it returns the data from Column B in Table 2.
> > However, Column A
> > in Table 1 may contain a list of words that need to be matched
> > not just one
> > single entry.
> >
> > If someone could p
Hello
I'm trying to do the following:
"Update tblCompany SET CoName='"tester"' WHERE CoID=109"
But getting an error message
I tried the escape character "\" like
"Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109"
but get the same error
This happens whether I use ADODB in VB or if
Hello JSaur,
Here is a php script i whipped up for you. Hope it helps
Please Please PLEASE update your data before running this script.
I have tried a version of this on a data table here but changing
column names etc for testing the changing back can always lead to
some error.
One thing you
Hi there,
Usually mysql.sock is configured to go into /tmp which is
readable/writable for anybody.
Like that if you delete it, simply restarting the server should
re-create it.
So, I'd suggest you check your configuration and the permissions.
Regards
jmr
-Original Message-
From: Sandeep
> Hi all,
>
> I'm trying to create a query that returns a set of data based on
> two tables.
>
> A basic description is that If Column A in Table 1 is Equal to Column A in
> table 2 then it returns the data from Column B in Table 2.
> However, Column A
> in Table 1 may contain a list of words that
Hi all,
I'm trying to create a query that returns a set of data based on two tables.
A basic description is that If Column A in Table 1 is Equal to Column A in
table 2 then it returns the data from Column B in Table 2. However, Column A
in Table 1 may contain a list of words that need to be matc
hi,
Can anyone pl tell me as to how I can resolve a missing mysql.sock
problem??? Can anyone pl send me the mysql.sock file??? been trying to
start mysql for the past 3 days and everytime am getting a "unable to
connect localhost error, missing mysql.sock"
I tried most of the suggestions foun
False alarm!! Turns out one of my engineers was using 'LOAD DATA INTO TABLE'
instead of inserts.
Thanks for all of the replies.
- Original Message -
From: "Will French" <[EMAIL PROTECTED]>
To: "Gabe E. Nydick" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 19, 2001 10
>Can someone give me a quick *complete* example code of setting up a
>connection, performing a small query, and reading back the result?
Any of the standard MySQL clients included in the source distribution
that are written in C provide examples. Some are more brief than others.
Another source
I'm not currently on the mailing list so please reply directly.
I have three tables joined as follows (Table WORKPLACE is just a codes
lookup with wrk_id and name):
MEMBERS(A) | EMPLOY(B) | WORKPLACE(C)
--
mem_id >> mem_id
workpla
Hi,
I keep getting "500 Internal Server error" when accessing my database, my
application is a C++ development of my own.
I used to suspect memory leaks but thats has been checked with LeakTracer,
and passed!
The problem I think is documented here at
http://www.mysql.com/doc/C/o/Communication_e
At 11:37 AM -0400 9/20/01, Kevin Slean wrote:
>I have come across a flawed transaction counter in a mysql application that
>I now support. I believe it is flawed because it does not use record
>locking to deal with concurrency and was hoping someone could give me ideas
>on how to correct.
>
>The
do a simple script to read, parse and edit then finally update based on c1
Luke
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 11:34 PM
Subject: Update
> Hello there,
>
> could you please help to a novice...
>
> I have table
>
I have noticed some odd behavior in my mysql server (running build 41 on
Win2k).
I have a large table (4 million rows, 118 columns, about 1.7Gb on disk). As
its primary key, this table has an auto increment int field called 'runid'.
The machine it runs on has 733Mhz cpu/1.25Gb RAM and a 60Gb ide
Occasionally I have to add an index on a table with almost 2M rows and it
takes a long time. This is expected but when adding the index it seems to
block all other queries from other users from executing.
Is there a way to prevent this?
Thanks
Michael Blood
-
MYSQL_RES *results1;
MYSQL_ROW row;
MYSQL DBsession;
mysql_init ( &DBsession );
mysql_real_connect ( &DBsession, PRI_HOST_IP, PRI_USER_NAME,
PRI_USER_PASSWORD, PRI_DB_NAME, PRI_PORT_NO, "", 0 );
sprintf ( sql, "SELECT filepath FROM filepath WHERE charset = '%s' AND
location = '%s'",
Hi,
We have MySQL 3.23.27 stalled and running on a Solaris 2.7 machine. We are
planning to move our server to AFS school system (OS version is Solaris 2.7
(Sparc)). The AFS version is 3.5 or 3.46.
Is anybody know whether MySQL 3.23.27 is compatible with AFS 3.5 3.46?
Thanks
Suping
--
Have a ni
I have come across a flawed transaction counter in a mysql application that
I now support. I believe it is flawed because it does not use record
locking to deal with concurrency and was hoping someone could give me ideas
on how to correct.
The transaction counter works like this:
1) Web transa
Hello there,
could you please help to a novice...
I have table
c1,c2,c3
'1' , 'man with hammer' , 'woman with hammer'
'2' , 'woman with hammer' , 'man with hammer'
where cX are column names.
And now I need to update database and change string 'with' to 'WITH'. But
just for women.
Thanks a lo
Hi,
Attached is my test program while exercising the C API of the MySQL.
Of course I have replaced the host name, user name, password and database
name with dummy ones.
I am using RH 6.1. The MySQL version is 3.22.
Essentially you need to do
#include
...
main()
{
MYSQL mysql;
MYS
Hi ? ?
> -Original Message-
> From: ? ? [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 12:12 PM
> To: [EMAIL PROTECTED]
> Subject: Faliue: Write huge binary data to blob Field of
> mysql use jdbc
>
>
> Hi all:
>
> We are making a project about "document manage " ,I
Hi Dana
> -Original Message-
> From: Dana Powers [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 19, 2001 7:19 PM
> To: [EMAIL PROTECTED]
> Cc: mysql mailing list (E-Mail)
> Subject: Re: BDB table : different results on adjacent queries
>
>
> What is the query you are running +
Hi,
We have MySQL 3.23.27 stalled and running on a Solaris 2.7 machine. We are
planning to move our server to AFS school system (OS version is Solaris 2.7
(Sparc)). The AFS version is 3.5 or 3.46.
Is anybody know whether MySQL 3.23.27 is compatible with AFS 3.5 3.46?
Thanks
Suping
--
Have a ni
Here is my info...
I am running slackware 8 (linux 2.2.19)
Mysql Ver. 3.23.40 (install via source)
System AMD T-Bird 1Gig / 1 512MB Ram
Here is my cnf
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=16M
set-variable= max_allowed_pa
Sorry, I hit send before I was done...
> examples, sadly, just aren't very good. And there is no example for
> mysql_use_result(). (the example code uses mysql_store_result())
The syntax and proceedure for mysql_use_result is very very similar. My
advice: get it working with *store* and then
hi.
this message means mysql is...well...reading table information for
completion of table names.
typing the beginning of a table or column name and pressing tab will either
complete the name, or present a list of appropriate tables/columns (like in
a bash shell).
if you have a lot of tables, th
> Can someone give me a quick *complete* example code of setting up a
> connection, performing a small query, and reading back the result?
>
In windows install, there is an examples directory which contains mytest.c.
I can't say if this exists for Linux but I bet it does in some form. Why
don't
Bob Kozdemba writes:
> When I try to use mysqlgui, it reports an error saying it can not connect
> using socket 111. The text based mysql works without specifying a socket #.
> Is it possible to find out what socket # is being used by 'mysql' so I can
> configure 'mysqlgui' properly ?
You'd bet
Can someone give me a quick *complete* example code of setting up a
connection, performing a small query, and reading back the result?
The docs conflict in a few places as far as how to declare the data types.
(in some places, they are pointers, in others they are not). Also, the
examples,
Perhaps mysql does not own the directory that contains the databases.
Ashley M. Kirchner wrote:
> I just compiled from scratch, and successfully installed v3.23.42 on an
> RH7.1 system. EVerything went fine, no errors anywhere, it started up
> fine and I was able to set passwords fine. T
Hi folks,
I wondered if I can install and run MySQLGUI in the BSDi environment. If it
is possible what component should I download ?
Yours,
Moses Shohet
Israel.
-
Before posting, please check:
http://www.mysql.com/manual.
My apologies in advance if this question has been answered in a previous
thread. I am a novice at MySQL and would appreciate any guidance any of the
more knowledable members of the list could provide.
I am installing mysql-3.23.42 on Solaris 2.7. I run configure with the
following:
CFLAGS="-
Hi:
When I try to use mysqlgui, it reports an error saying it can not connect
using socket 111. The text based mysql works without specifying a socket #.
Is it possible to find out what socket # is being used by 'mysql' so I can
configure 'mysqlgui' properly ?
Or perhaps I am up against some othe
What platform are you running on? Must... Have... Details...
database
> -Original Message-
> From: Pavel Popov [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 6:57 AM
> To: [EMAIL PROTECTED]
> Subject: UDF
>
>
> Hi, All.
>
> I have tried to add UDF, but has received a
We have exactly the same problems running ./scripts/mysql_install_db.
Did you already come to a solution? Please let me know how you solved this .
--
Nancy
-
Before posting, please check:
http://www.mysql.com/manual.php (t
Hi, All.
I have tried to add UDF, but has received a error 1105. The beginnings
to understand and has found out, I do not have table "func" in base
"mysql".
Help me, please! What structure it has?
--
Best regards,
Pavel mailto:[EMAIL PROTECTED]
Monika,
Transactional InnoDB type tables in MySQL -Max allow
users to read tables while they are being updated.
That is because of the multiversioned concurrency
control used in InnoDB.
See http://www.innodb.com/ibman.html
for more info. There you also find the startup
options you should add to
Alexander Skwar writes:
> sql
>
> Could this user please be removed? It's [EMAIL PROTECTED]
Done.
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ My
Hello,
I have installed the Mysql Max version with DBD tables (3.23.40) and is
running the server on NT. I have a rather small database with lots of
tables (22) and liked the idea with transactions. This is my situation:
I have one application writing and reading data from my tables (using
transa
Dump database:
mysqldump -uroot -px -A -a -F -l --opt --quote-names
-rc:/mysql/data/dump.sql
Restore
mysql -uroot -px < c:/mysql/data/dump.sql
I forgot to use --quote-names. -Q doesn't seem to work
/Benny
-
Befor
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 syntax
use DROP TABLE `resultat ...`
Best regards,
RTX Telecom A/S
Benny B. Simonsen
BB/Project Engineer
System Development
RTX Telecom A/S
Stroemmen 6
DK-9400 Noerresundby.
Phone.: +45 96 32 23 00
Fax.: +45 96 32 23 10
E-mail: [EMAIL PROTECTED]
Web: www.rtx.dk
> -Original Message-
> From: H
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 |
> +--+
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;
+--+
| Ta
Is it illegal to include spaces in a table name or column name?
I do have a problem with mysqldump which doesn't include the
` character and thereby prevent me to restore databases with
tablenames / column names with spaces.
PS: DROP TABLE `Table Name` does work. Just remember
that you have to us
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';
On Wed, Sep 19, 2001 at 09:37:29AM -0700, Cameron Watters -- List Subscriptions wrote:
> Just a quick question regarding how (if at all) MySQL's binary update log
> consumes resrouces as it records modifications to various tables in the
> database.
>
> Are there any potential performance issues o
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 w
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 tekn
95 matches
Mail list logo