Hi, All.
Help my, please! I can't compile MySQL util comp_err. Where can I
find it as binary for Win32?
--
Best regards,
Pavel mailto:[EMAIL PROTECTED]
-
Before posting, please check:
victor writes:
can mysql use the linux password /etc/passwd for the authentication
No, and it'd be a _really_ bad thing to do anyway.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned
Hello,
I know this mail group may be not according to my question, so Please help
me. I have been use PHP connect to mssql 6.5 with FreeTDS. I'd like to
select data from 2 table with separate in 2 database name. How could I do
this? here is some example.
DB#1
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
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 or
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';
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
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 `.
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:
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.
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
-
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
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]
/ /|_/ / // /\ \/ /_/ / /__ MySQL
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
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]
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
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 error
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
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:
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:
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
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,
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
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=
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
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 + what
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 use
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 mysql.h
...
main()
{
MYSQL
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
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
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
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
c1,c2,c3
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
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
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
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
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:11 AM
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 found
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
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
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
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
Hello
I'm trying to do the following:
Update tblCompany SET CoName='quot;testerquot;' WHERE CoID=109
But getting an error message
I tried the escape character \ like
Update tblCompany SET CoName='quot\;testerquot\;' WHERE CoID=109
but get the same error
This happens whether I use ADODB in
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 point me in the
At 6:44 PM +0100 9/20/01, johnlucas-Arluna wrote:
Hello
I'm trying to do the following:
Update tblCompany SET CoName='quot;testerquot;' WHERE CoID=109
But getting an error message
I tried the escape character \ like
Update tblCompany SET CoName='quot\;testerquot\;' WHERE CoID=109
but get
There probably is a better way but the following should work:
UPDATE tblCompany SET CoName=CONCAT('quot', CHAR(59), 'tester', CHAR(59),
'quot', 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.
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('quot', CHAR(59), 'tester', CHAR(59),
'quot', CHAR(59)) WHERE CoID=109
Like you, I believe there probably is an escape sequence for the semi-colon
but
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='quot\;testerquot\;' WHERE CoID=109 is what
leads me to believe this.
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
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
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
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
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
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
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
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?
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
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 guide me
Update tblCompany SET CoName='quot;testerquot;' 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
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]
Subject:
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
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
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,
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
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
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, Also
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 |
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
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. I
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';
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]
CC: mysql
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
Hello,
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
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
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
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:
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:
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
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
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
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 for the
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 element
89 matches
Mail list logo