MySQL problems with VC++ n Ado

i cant add record to MySQL using VC++6 with Ado.. i can del record but i cant move forwrd.. it will have a error stating tat Query-based update failed because the row to update cannot be found. - Before posting, please check

Re: Order by does not use an index when it should.

harm, Your order by will not use your weg_2 index because, as you stated, weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used for the individual columns as you need try to create a separate index on just the nr column, that should be used by the orderby clause. This way your

MySQL cant add or del usign VC++ with ADO

i cant add or del the MySQL database using Ado with VC++6.. anyone done this b4? pls help.. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: Question - SELECT

Thanks for your help, but I just want /* this condition */ lcreceive.due_date < current_date /* affect to */ SUM(lcreceive.amount_us) /* and not */ SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open Terence --- "Christensen, Dave" <[EMAIL PROTECTED]> ªº¶l¥ó¤º®e¡G> SELECTlcopen.bank, >

Order by does not use an index when it should.

Hello, I am trying to get a sort to use an index. The query is very simple: select nr from mytable where col1='const' and col2='another const' and col3='YA const' order by nr; The explain gives me: +-+--+--+---+-+---+--+

RE: auto increment question

It sounds to me that a trigger would help, but mysql doesn't has them yet. Adolfo > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 03, 2003 8:04 PM > To: Kevin; [EMAIL PROTECTED] > Subject: Re: auto increment question > > > At 15:28 -0800 1/3/

RE: auto increment question

It sounds to me that a trigger would help, but mysql doesn't has them yet. Adolfo > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 03, 2003 8:04 PM > To: Kevin; [EMAIL PROTECTED] > Subject: Re: auto increment question > > > At 15:28 -0800 1/3/

Re: auto increment question

At 15:28 -0800 1/3/03, Kevin wrote: Hello, I have a table with an ID column and a viewed column. I would like the viewed column to increment by one each time the row is updated. Stats === ID views is this possible? Sure. Since you're updating the row anyway, set the column value to one m

can't use MySQL control center 0.8.7-alpha update Chinese

Hi, I can't use MySQL control center 0.8.7-alpha to insert records with fields of Chinese GB2312 characters. The updated execution result is something like "?20", I use varchar. I run it on IIS, Chinese windows2000 professtional with service pack3. But when I use console insert record comm

Re: Info: Using MySQL as Mutex

On Fri, Jan 03, 2003 at 11:10:38AM -0600, Dana Diederich wrote: > Yup, MySQL works quite well as a lock server; we've been using it as such > for years. Yeah, do we. > I would suggest looking at the get_lock() function specifically. It's > designed to do exactly what you're looking for, and it w

auto increment question

Hello, I have a table with an ID column and a viewed column. I would like the viewed column to increment by one each time the row is updated. Stats === ID views is this possible? -k sql, query - Before posting, please ch

Re: Can Expect scripts interact with mysql ?

"Paul Choy" writes: >Hi : > >I try your scripts except changing the spawn directory but still does not wor >k. I wonder is it because my mysql is window version and I am running the Exp >ect scripts in the Cygwin environment.Here is the output below. It looks like > Expect is not getting the

Re: configuring MySQL

[EMAIL PROTECTED] wrote: Ok, I finally got a src version of MySQL that worked. Now, i've got another problem. I FINALLY found this "termcap" library, I guess it's part of Emacs. SO, I installed Emacs. I even checked that termcap.c was in the /src directory. Now, I still get this error when config

Re: configuring MySQL

Ok, I finally got a src version of MySQL that worked. Now, i've got another problem. I FINALLY found this "termcap" library, I guess it's part of Emacs. SO, I installed Emacs. I even checked that termcap.c was in the /src directory. Now, I still get this error when configuring MySQL: "checking fo

RE: Can Expect scripts interact with mysql ?

Hi : I try your scripts except changing the spawn directory but still does not work. I wonder is it because my mysql is window version and I am running the Expect scripts in the Cygwin environment.Here is the output below. It looks like Expect is not getting the feedback from mysql output.It ke

Re: built in commands are atomic, right?

Kathryn, - Original Message - From: "Kathryn Cassidy" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, January 03, 2003 1:14 PM Subject: built in commands are atomic, right? > Hi there, > > This is probably a rather foolish question, but I can't find a definitive > an

Re: LOAD DATA LOCAL

I posted the same question two weeks ago. The only suggestion was to add flags to the my.cnf file: [mysqld] local-infile=1 [mysql] local-infile=1 But this didn't work. I've tried using the flags on startup of MySQL as shown in the manual but this fails as well. We were running 3.23.49. I t

RE: Can Expect scripts interact with mysql ?

At 11:37 -0800 1/3/03, Paul Choy wrote: "Paul Choy" writes: >Hi : > >I am trying to run Expect scripts to interact with mysql. So far I cannot get > it to work here is the list of log I got.Does anyone know how to interact Ex >pect scripts with mysql. What am I missing ? I've done it, but

LOAD DATA LOCAL

Hi, (I posted this question once before in a Re: that everyone seems to have missed ;-) I use 4.0.7-max-nt on a Win2K box, and whatever I do, I cannot use LOAD DATA LOCAL (keep getting error 1148). I tried: - Starting the server with --local-infile=1, and with --local-infile. - Starting the mysq

Re: Select Date Help

Thanks everyone for their help! "Max Clark" <[EMAIL PROTECTED]> wrote in message av2eai$8he$[EMAIL PROTECTED]">news:av2eai$8he$[EMAIL PROTECTED]... > Hi all, > > I have a DATE column (CCYY-MM-DD), I would like to do a query like this: > > select * from table where date = '2003-01' > > What additio

RE: Can Expect scripts interact with mysql ?

Hi : I try it but could not get it to work. Here is part of my scripts: exp_internal -f error_file.txt 0 spawn bash expect "*$ " send "/cygdrive/c/mysql/bin/mysql -u root -p test\r" expect "Enter password:" send "\r" expect "*mysql>" spawn bash parent: waiting for sync byte parent: telling

Re: unixOBDC

On 3 Jan 2003, bruno peracchio wrote: > I use MySQL 3.23.52/linux Mandrake 9.0 > Installing SQLEditor-2.1.3 (CBD-Common-2.1.3-3.i386.rpm) > error:failed dependencies: > unixODBC is needed by CBC-Common-2.1.3-3 > > Installing UnixODBC-mysql-2.2.3-1.i386.rpm > error: failed dependencies > odbc is ne

Re: table relations

Nuno Lopes Try this: SELECT music_id, title, artist_name, country FROM music_table, artist_table WHERE music_table.artist_id = artist_table.artist_id AND country LIKE 'desired country' Anderson Ataides Em Sex 03 Jan 2003 07:57, you wrote: > Hi everybody, > > I have a question about table relati

unixOBDC

Hi everybody I use MySQL 3.23.52/linux Mandrake 9.0 Installing SQLEditor-2.1.3 (CBD-Common-2.1.3-3.i386.rpm) error:failed dependencies: unixODBC is needed by CBC-Common-2.1.3-3 Installing UnixODBC-mysql-2.2.3-1.i386.rpm error: failed dependencies odbc is needed by UnixODBC-mysql-2.2.3-1 Please c

Continual Database Corruption

Hello, Sorry if this has been covered, but I've searched the archives with no results. I have 2 identical servers running mysql 3.23.54a on RedHat linux 7.2 (custom kernel 2.4.17). One is running as master, one slave using mysql internal replication. The primary server has a database where one o

Re: changing database location

shutdown mysql, move all the files in your current data directory to the new location in your my.cnf file (ie. unix: /etc/my.cnf) [mysqld] datadir=/my --- all data files are in /my - hcir On Friday, January 3, 2003, at 07:56 AM, aman raheja wrote: Hi All Right now I have all my MySQL dat

Can't lock file (errno: 13) - don't understand this one on win32

Group, Here is the problem. I have my mysql databases set up on one windoze 2000 box on d drive with the main folder on C drive using junction to create a symbolic link ( Unix so much easier! ) so as to make the sys admin happier. I have a perl script on another box that accesses this database v

comparision in the datetime field

Hi All I have a datetime field in one of my tables in the MySQL database. Can I do something like return all records between two certain dates, say between Nov 02, 2002 and Nov 07, 2002. Thanks Aman - Before posting, please check:

RE: "What MySQL is"

take out the last two sentences. scares people away. suggest last sentence: "MySql's CLI tools give you full access and control to all the the power of MySQL. If you prefer a visual tool to manage your data in MySQL, like Access & Paradox tools see the downloads/links page, as you learn MySQL's c

deleting tables with same prefix !

Hi All How can I delete all tables starting with prefix 'abc' in the MySQL database (there are about 200 such tables). Wild cards? Or if I just delete the files from the location where all the MySQL database tables are stored, what would happen ? Thanks Aman ---

Re: Replication and the function now()

Remi, Michael, On Fri, Jan 03, 2003 at 11:39:44AM -0500, Michael T. Babcock wrote: > Fred van Engen wrote: > > >SET TIMESTAMP=1039489014; > > > >Each time with the current timestamp of course. I haven't checked > >if it is actually used by the slave however. > > > > > > If it is used, I would i

RE: Info: Using MySQL as Mutex

Yup, MySQL works quite well as a lock server; we've been using it as such for years. I would suggest looking at the get_lock() function specifically. It's designed to do exactly what you're looking for, and it won't require knowledge of any tables or rows. Cheers. -Dana > -Original Message-

AIX 4.3.3 and gethostbyaddr_r() [again?]

I'm trying to move our webserver with MySQL 3.22.32 from a slow AIX 4330-09 box to a somewhat faster one with 4330-10. Though not heavily used, the 3.22.32 has worked like a charm for several years in a chroot:ed environment. It seems that we've forgotten to update the libraries (e.g. libpthr

INNER JOIN problem

I hope someone can help. I have a table that has serveral records with the same name but unique datestamps. I need to show only the records with the latest datestamp associated with them. I am enclosing the sql that I am working with in hopes that someone can see the problem that I can't. I cras

changing database location

Hi All Right now I have all my MySQL database files getting stored in /var/lib/mysql/ If I want to change that to another location, say, /home/mysql or something else, how do I do it? Thanks Aman - Before posting, please check:

Info: Using MySQL as Mutex

Just as an FYI to fellow developpers out there (feeling generous today): How many times have you written a semaphore locking system for your programs and worried they weren't thread-safe, or wished you didn't have to? Well, if you're feeling especially lazy (as I often do) and you have MySQL o

Replication and the function now()

I would like to know if there is a way of telling mysql to transfer the value of the function now() in it's replication, as it is now (from what I see in the binlog file) mysql passes the now() to the slave instead of the value, this causes a difference in my 2 databases. Thank you in advance. Ré

Re: Replication and the function now()

Remi, n Fri, Jan 03, 2003 at 10:56:21AM -0500, Remi Lanteigne wrote: > I would like to know if there is a way of telling mysql to transfer the > value of the function now() in it's replication, as it is now (from what I > see in the binlog file) mysql passes the now() to the slave instead of the >

Re: "What MySQL is"

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael, et al -- ...and then Michael T. Babcock said... % % Suggestion page: "What MySQL is; layman style" (unless one exists I % haven't seen). Good idea. Maybe a "what it isn't" as well. I'd like to suggest that this be part of the now-nascent

RE: Cannot download MySQL Connector/J from www.mysql.com

Thomas, Thanks - I got it now. Regards, Richard. -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, January 03, 2003 6:52 PM To: Richard Mayebo Cc: '[EMAIL PROTECTED]' Subject: Re: Cannot download MySQL Connector/J from www.mysql.com On Fri, 3 Jan 2003, R

re: How to use HANDLER statement with primary key ?

On Wednesday 01 January 2003 15:28, Jocelyn Fournier wrote: > I'm trying to use to following HANDLER syntax : > > HANDLER tbl_name READ index_name=(value1); > > However I fail since I don't know what is 'index_name' for a PRIMARY KEY (I > already tried PRIMARY, `PRIMARY KEY`, and the column name w

re: Is it a bug

On Tuesday 31 December 2002 10:21, Walter Procopio wrote: > I have installed mysql max 4.0.4 beta on a Suse (ver. 8.0) linux server and > I have created a database with this schema: [skip] > > And I try to execute this query: > > > SELECTecoras.rstda, ecotes.rstes, ecoras.rsart, ecoras.rsimm

Re: Cannot download MySQL Connector/J from www.mysql.com

On Fri, 3 Jan 2003, Richard Mayebo wrote: > I am using IE5 and Windows 2000. I am trying to download the Type 4 JDBC > driver for MySQL for a MySQL/Java/Linux project from the > link http://www.mysql.com/downloads/api-jdbc-stable.html. > > The download I get as a result is about 45KB. However, it

Question - SELECT

How do I correct this SQL code: 2 tables there, and I want to add one conditon to item "receive" lcopen : id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive

"What MySQL is"

Suggestion page: "What MySQL is; layman style" (unless one exists I haven't seen). Something like: "MySQL is a back-end database program. It stores data for your programs and allows you to interface with that data using SQL commands (see reference manual). MySQL has a command-line interface p

Re: MySQL Help Needed Please

Anton, check the .err and .log files in your data directory. Then check permissions. My sock file looks like: srwxrwxrwx1 mysqldaemon 0 Dez 30 19:12 mysql.sock and finally check for your socket= /tmp/mysql.sock entries in /etc/my.cnf and ~/.my.cnf Thomas Spahn

optimizing big table

hello, i have a table with 29 million rows (1,6 Go) with maritime distances inside working on mysql 3.23.52-Max on a dual xeon 800Mhz 1Go mem example : los angeles > rotterdam 7728 Nmvia panama and english channel los angeles > rotterdam 13456 Nm via cape horn and engl

Re: user updates trace

Egor Egorov wrote: ... i mean ... in my database i have a lot of users with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it possible? Nope. A good question might be whether the TODO includes auditing of this kind. Tha

Cannot download MySQL Connector/J from www.mysql.com

I am using IE5 and Windows 2000. I am trying to download the Type 4 JDBC driver for MySQL for a MySQL/Java/Linux project from the link http://www.mysql.com/downloads/api-jdbc-stable.html. The download I get as a result is about 45KB. However, it is not recognised by tar or gzip utilities as a vali

Question - SELECT

How do I correct this SQL code: I want to add one conditon to item "receive" lcopen : id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive.due_date < current_

inserting records into database with utf8 char-set

Hello, I am attempting to insert a string in utf-8 to a text field using DBI but mysql does preserve the original char_et but rather changes it, does any one have any idea why? I am working with Mysql 3.23.36 DBI-1.30 Thanks Dana

re: Help!

On Friday 03 January 2003 13:18, Gman wrote: > I am currently using Mysql version 1.4 for Windows 2000, and I cannot > connect to my database via phpMyAdmin. > > I have run mysql and was able to type > Use SAMDB<--my database and it worked. > > But when I type the following > grant all to theedge2k

re: user updates trace

On Thursday 02 January 2003 10:13, Natale Babbo wrote: > anyone knows how to get the history of updates of a > user? > ... i mean ... in my database i have a lot of users > with different privileges. > what i need is to reach all the insert, update and > delete queries executed by one user. > is i

re: table relations

On Friday 03 January 2003 11:57, Nuno Lopes wrote: > I have a question about table relations and I would like you to help me. > I have two tables in one server. The first tables has the following fiels: > music_id; title; artist_id; chords > The second one: artist_id; artist_name; country > > How

Re: strange behaviour

Hi Wash, Please see ntoes on this page for explanations. http://jeremy.zawodny.com/blog/archives/000203.html#000203 Next please upgrade to 3.23.54 as this does contain some fixes that should help including a compile option for broken real path. Here are my compile flags, I don't recommend -O3 b

MySQL-3.23 and gcc-2.96

Hi, on the website http://www.mysql.com/downloads/mysql-3.23.html there is hint to a problem with gcc-2.96. Within the changelog of RedHat gcc-2.96-113.i386.rpm I found: - * Sat Jul 15 2000 Jakub Jelinek <[EMAIL PROTECTED]> - Put Richard Henderson's mysql compilation fix inste

MySQL Help Needed Please

Hi guys, I'm new here and need help. I'm installing MySQL on FreeBSD 4.7. I actually had/have MySQL installed but when I'm trying to run it says: error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' ex

user's updates trace

# S.O.S. # hi all, anyone knows how to get the history of updates of a user? ... i mean ... in my database i have a lot of users with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it possible? i check the bin logs but t

mysql_init

I'm currently writing a shared library on Solaris. When I add mysql_init(&mysql) to the code and run the parent process, it bombs out. Unfortunately I don't have the source for the parent process so it could be quite hard to debug. Is there any issues with using the C api with shared libraries??

Re: FAQ hosting site [FAQTS.COM]

Hi, > Can I strongly suggest there be a link from the MySQL documentation page to: > http://www.faqts.com/knowledge_base/index.phtml/fid/52 > > It is the MySQL section of FAQTS.com which, IMHO, is the best online > FAQ site. Thanks for the pointer - I've added link to this to our documentation pa

Re: Different Table type between MASTER and SLAVE

Yes, this shouldn't be a problem. Master on InnoDB & Slaves on MyIsam. Only after a commit on the master does it get replicated to the slave. Regards P.Murali Placed At : "Heo, Jungsu" <[EMAIL PROTECTED]> on 01/03/2003 01:37:50 PM To: [EMAI

Re: MySQL Source tar.gz files

On Thu, 2 Jan 2003, Tyler wrote: > Ok, I've got gunzip and tar, and every time I try (multiple versions) of > your source .tar.gz file, I get: > (when running 'tar -zxf mysql-3.23.54a.tar.gz') > gzip: stdin: not in gzip format > > (when running 'gunzip mysql-3.23.54a.tar.gz') > gunzip: mys

Re: Foreign Key problem? in MySQL 4.0.7

Haisam, - Original Message - From: ""Haisam K. Ido"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, January 03, 2003 2:01 AM Subject: Re: Foreign Key problem? in MySQL 4.0.7 > Heikki: > > Do you mean the PRIMARY KEY order? >> UNIQUE KEY keyword(id,groupname,gid),

Help!

I am currently using Mysql version 1.4 for Windows 2000, and I cannot connect to my database via phpMyAdmin. I have run mysql and was able to type Use SAMDB<--my database and it worked. But when I type the following grant all to theedge2k@flatman identified by 'mysql password'; It comes back and

Re: Different Table type between MASTER and SLAVE

Yes, this shouldn't be a problem. Master on InnoDB & Slaves on MyIsam. Only after a commit on the master does it get replicated to the slave. Regards P.Murali Placed At : "Heo, Jungsu" <[EMAIL PROTECTED]> on 01/03/2003 01:37:50 PM To: [EMAI

Re: Pattern Match on 3.23

On Tue, 31 Dec 2002, Frank Peavy wrote: > I asked the pattern match question, because I am using a hosting service > that hosts MySQL 3.23. Since I have a need to search on terms less than 3 > characters long and I can not re-compile, I was looking for another > solution. I thought that I might be

built in commands are atomic, right?

Hi there, This is probably a rather foolish question, but I can't find a definitive answer anywhere in the docs and I don't like assumptions... Are all built in mysql commands atomic? In particular, is replace atomic. In the docs it says that it deletes the entry if it exists then inserts it, i

Question - SELECT

How do I correct this SQL code: 2 tables there, and I want to add one conditon to item "receive" lcopen : id, bank, unit_price_us, order_cbm lcreceive: id, amount_us, due_date SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive

libwrap ignores entry in hosts.allow

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm using mysql-3.23.51 compiled with libwrap support. If hosts.{allow,deny} have similar to the following structure: hosts.allow: #start of hosts.allow mysqld: ALL #end of hosts.allow hosts.deny: #start of hosts.deny ALL: ALL #end of hosts.deny

table relations

Hi everybody, I have a question about table relations and I would like you to help me. I have two tables in one server. The first tables has the following fiels: music_id; title; artist_id; chords The second one: artist_id; artist_name; country How can I JOIN this tables?? (I'm working in PHP, if

Re: Newbie: MySQL + Java + web?

Brynley wrote: Anyhow - basically it appears he writes some Java code that contains a MySQL query (which I'm still not sure how is done - but I think I can nut it out) and then "calls" that piece of Java code from within the browser (via HTML) - it is this part that has me bamboozled. Seach f

Different Table type between MASTER and SLAVE

Hello. I'm build a system aka of Shopping mall.(I think most of queies will be SELECT) For performance, MySQL will run on replication. I need TRANSACTIONs to manages orders and payment. So, Master's Table type is InnoDB. But I think that InnoDB is slower than MyISAM. (InnoDB's row level locking i