RE: help!

2004-08-23 Thread Tom Horstmann
I know i have to connect first to the server. I tried issuing the command like this: mysql mysql -h localhost -u root -p; but it says error in syntax. if i take out the semi colon, the shell would just add a '-' below. You are already running mysql by typing that. You should have read the

MySQL 4.1.3 won't autostart on Mac OS X?

2004-08-23 Thread Robert Kuhar
I've installed mysql-max-4.1.3-beta-apple-darwin7.4.0-powerpc to my PowerBook and have executed the MySQLStartupItem.pkg. The /Library/StartupItems/MySQLCOM exists and the /etc/hostconfig file includes the string MYSQLCOM=-YES-. However, the only way I can get MySQL to start after boot up is to

query plan

2004-08-23 Thread Cao Duy
Hi all, How can I get the query plan output? thanks alot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: special order

2004-08-23 Thread Leonardus Setiabudi
that will work.. or if you can guarantee that it always prefixed with '#' you can try select id from mydata order by if(left(id,1)='#',concat('z',id),id) or if you didnt sure.. you can try the similiar way.. select id from mydata order by if(left(id,1)'A',concat('z',id),id) just make sure that

RE: Root password lost?; can't manage existing database...

2004-08-23 Thread Peter Lovatt
Hi the usual syntax is mysql -u root -p if that does not work look into skip grant tables option http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html HTH Peter -Original Message- From: DBS [mailto:[EMAIL PROTECTED] Sent: 23 August 2004 03:50 To: [EMAIL PROTECTED]

Table needs to be repaired once a week

2004-08-23 Thread Jens Bierkandt
Hi, we are experiencing a strange problem with a table of our MySQL-Server. About every week this table gets corrupt and we have to repair it manually. Besides a couple other tables and databases there is another table who gets corrupted but not that often. Both tables are the biggest on the

Re: select count(*)

2004-08-23 Thread Egor Egorov
Eko Budiharto [EMAIL PROTECTED] wrote: I am trying to find how to use command select count(*). I tried it in mysql query console, it shows the number of my rows in my table. But when I tried it in perl with $sth-do(select count(*) from mytable) and run the perl script from DOS console, I

Re: Table needs to be repaired once a week

2004-08-23 Thread Egor Egorov
Jens Bierkandt [EMAIL PROTECTED] wrote: we are experiencing a strange problem with a table of our MySQL-Server. [] System: Software: Installiertes OS: Fedora Core release 1 (Yarrow) Installierter Kernel: 2.4.22-1.2188.nptlsmp Filesystem:

Re: about creation error of full text index

2004-08-23 Thread Egor Egorov
°í ¿ìÁ¾ [EMAIL PROTECTED] wrote: mysql select count(*) from pages; ERROR 1016 (HY000): Can't open file: 'pages.MYI' (errno: 144) mysql repair tables pages; +---++--+-+ | Table | Op | Msg_type | Msg_text

distributed queries

2004-08-23 Thread Leonardo Francalanci
Is there any way to issue a distibute query with mysql, such as SELECT * from mytab JOIN (SELECT * FROM another_server_on_another_machine.MYTAB2) ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Root password lost?; can't manage existing database...

2004-08-23 Thread Egor Egorov
DBS [EMAIL PROTECTED] wrote: I have a problem, It's been months since I used MySQL and (I believe) I had set it up with a root password. Now I can't log on to MySQL as root MySQL user and create a new user or manage an existing user (I can log onto server Familiar situation. :) Do so:

Re: Dependency problem with MySQL rpm's (Fedora Core 1)

2004-08-23 Thread Egor Egorov
Frank Perez [EMAIL PROTECTED] wrote: I am trying to install MySQL 5.0.0 on a fresh install of Fedora Core 1, however I am running into a little trouble and I was hoping someone could give me a little insight on what I might be doing wrong. I am able to install the 'server', 'clients', and

Re: Re-installing db/tables from dumpfile

2004-08-23 Thread Egor Egorov
Joseph E. Maxwell [EMAIL PROTECTED] wrote: I am moving my database(s) from one server to another, did a full dump of the data and have a large file with all the create instruction sets etc. My question, what is the best way to recreate these db, tables etc. on the new server. MySQL is

Re: LOAD DATA

2004-08-23 Thread Egor Egorov
[EMAIL PROTECTED] wrote: I use following code use databasea load data infileabcd.txt' into table databasea.tablename; Data gets loaded in table, however at the end of each record I see a square symbol, the symbol usually we see in compiled code. This may be a linefeed or

Re: A new Machine

2004-08-23 Thread Egor Egorov
Info [EMAIL PROTECTED] wrote: After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to = rob the piggy bank and build a new linux mysql server. This seem to be a good fruit of your repentance. :) I'm not rich, but what hardware and distro do you experts suggest? (My =

How to get the last record from the slected record set

2004-08-23 Thread Manisha Sathe
I am having more than 10 records in a table. I want to select only first top 10 records (depending on one field score) and then want to select 10th position record. select * from table1 order by score desc LIMIT 10 This will give me 10 records but then how to get the last record ? Thanks in

Re: query plan

2004-08-23 Thread Egor Egorov
Cao Duy [EMAIL PROTECTED] wrote: How can I get the query plan output? See http://dev.mysql.com/doc/mysql/en/EXPLAIN.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __

LEFT JOIN table USING ..

2004-08-23 Thread Scott Hamm
SELECT associates.shift, concat(associates.firstname,',',associates.lastname) as Operator, mrdaily.kronoshours, mrdaily.pto LEFT JOIN mrcategories USING ( mrcategories.category='1', mrcategories.category='2',

Re: How to get the last record from the slected record set

2004-08-23 Thread Karl Pielorz
--On 22 August 2004 20:31 +0800 Manisha Sathe [EMAIL PROTECTED] wrote: I am having more than 10 records in a table. I want to select only first top 10 records (depending on one field score) and then want to select 10th position record. select * from table1 order by score desc LIMIT 10 This will

Re: Corrupt table, mysqld crashes, server crashes. Looking for a solution

2004-08-23 Thread Egor Egorov
Feedback [EMAIL PROTECTED] wrote: Well.. I had the same issue 2 weeks ago with another server from my DC. I told them it was their hardware, they didnt believe it, so i had to order a new server, and ... The same problem occurs... The axioma is: a user-land binary CANNOT hang the kernel. And

Re: Fulltext performance problem.

2004-08-23 Thread Thomas Spahni
Hi Fredrik, a LEFT JOIN could be faster (I'm not sure, try it). And you don't have a fulltext index on msg_header.list. What about this? SELECTmsg_header.bodyid, msg_header.id, msg_header.subject, msg_header.mfrom, msg_header.date, msg_header.list FROM msg_header LEFT JOIN

Re: Innodb table definitions

2004-08-23 Thread Egor Egorov
Mayuran Yogarajah [EMAIL PROTECTED] wrote: Each |MyISAM| table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An `.frm' file stores the table definition. The data file has an `.MYD' (MYData) extension.

Re: How to get the last record from the slected record set

2004-08-23 Thread Martijn Tonies
I am having more than 10 records in a table. I want to select only first top 10 records (depending on one field score) and then want to select 10th position record. select * from table1 order by score desc LIMIT 10 This will give me 10 records but then how to get the last record ? Cycle them

Re: problem with tables crashing

2004-08-23 Thread Egor Egorov
Johan Jonkers [EMAIL PROTECTED] wrote: and my table is marked crashed :-( Please please upgrade to latest version (4.0.20) in binary format (download from www.mysql.com) and check on it. Good chances are that everything will run fine. -- For technical support contracts, goto

Re: Mysqlcheck -r very slow on big tables

2004-08-23 Thread Egor Egorov
Konstantin Yotov [EMAIL PROTECTED] wrote: mysqlcheck -r is very slow when repair big tables (over 4GB data - repair it 1h and 40m). Is there any config option to fasten it. Check your hard drives setup and throughput, it's not related to MySQL. -- For technical support contracts, goto

Re: how to increase max allowed keys?

2004-08-23 Thread Egor Egorov
íÉÈÁÉÌ íÏÎÁÛ£× [EMAIL PROTECTED] wrote: Mihail, suda ne nado pisat' s russkim From :-) How i can increase max allowed keys in myisam tables? I find this sting in myisam.h: #define MI_MAX_KEY 32 /* Max allowed keys */ Is it so simple? Or I must correct somthing more?

Re: Kernel panic when mysql stop command issued

2004-08-23 Thread Egor Egorov
Demetrios Stavrinos [EMAIL PROTECTED] wrote: Has any one heard or seen anything like it? Sure. A hardware or kernel problem. Get a stock kernel from ftp.kernel.org and compile a clean kernel for your server if you know how to do it. -- For technical support contracts, goto

Re: Can't start mysql server automatically

2004-08-23 Thread Egor Egorov
Michael Stassen [EMAIL PROTECTED] wrote: O Well, clearly LD_LIBRARY_PATH isn't set at startup. That's one of the reasons LD_LIBRARY_PATH isn't really the Solaris way, and is not recommended. With a proper setup, you should never need LD_LIBRARY_PATH in Solaris. In any version of

second write process hangs if another one is writing already,!!bu t in another database!!] bug???

2004-08-23 Thread Beuter Daniel
From: root To: Subject: [second write process hangs if another one is writing already,!!but in another database!!] Description: We have this mysql-server with two databases internet and intranet.There are two data-collectors server1 and server2.Each writes in one database. Server1 in

RE: A new Machine

2004-08-23 Thread christopher . l . hood
Well Actually the current Red Hat Release is Fedora Core 2 , which works very well. You can find it here http://www.redhat.com/fedora/ Chris Hood Investigator Verizon Global Security Operations Center Email: [EMAIL PROTECTED] Desk: 972.399.5900 Verizon Proprietary NOTICE - This

Re: How to get the last record from the slected record set

2004-08-23 Thread Manisha Sathe
I want to select first 10 records out of 100. And then get the 10th position. If i make use of order by score asc limit 1 then I will get 100th record, How shall i pick up 10th position? regards Manisha - Original Message - From: Karl Pielorz [EMAIL PROTECTED] To: Manisha Sathe

Re: Why VARCHAR TO CHAR automatically when the length less than 4.

2004-08-23 Thread Egor Egorov
Emi Lu [EMAIL PROTECTED] wrote: I have a questions about varchar columns change to CHAR columns automatically. See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by

Re: release all mysql locks

2004-08-23 Thread Egor Egorov
Mayuran Yogarajah [EMAIL PROTECTED] wrote: Is there any command I can issue to release ALL locks held by any/all transactions ? I know that restarting the server does this, but is there a way to do this without restarting ? No. -- For technical support contracts, goto

Re: How to get the last record from the slected record set

2004-08-23 Thread Manisha Sathe
yes, but is there any better way of doing it ? regards Manisha - Original Message - From: Karl Pielorz [EMAIL PROTECTED] To: Manisha Sathe [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 23, 2004 8:34 PM Subject: Re: How to get the last record from the slected record set

Re: Why VARCHAR TO CHAR automatically when the length less than 4.

2004-08-23 Thread Martijn Tonies
I have a questions about varchar columns change to CHAR columns automatically. See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html In addition to that - it doesn't really matter as the CHAR datatype isn't properly implemented in MySQL and behaves the same as the VARCHAR

Re: How to get the last record from the slected record set

2004-08-23 Thread Roger Baklund
* Manisha Sathe I want to select first 10 records out of 100. And then get the 10th position. If i make use of order by score asc limit 1 then I will get 100th record, How shall i pick up 10th position? Try this: order by score desc LIMIT 9,1 -- Roger -- MySQL General Mailing

miving dbs etc from one machine to another

2004-08-23 Thread Hull, Douglas D
have MySQL 4.0.20 on my mac os x 10.3.x client machine. My question is, how do I go about getting my MySQL databases that I created to another computer. I have been told my databases are in /usr/local/mysql/data. When I try to get into the sub-directory /data it says I do not have

insert data from text file

2004-08-23 Thread Hull, Douglas D
Should mysql version 4.0.20 support the Insert data from a textfile into table which is shown at the bottom of the page while in phpmyadmin with a database and table selected? I am getting this error: #1148 - The used command is not allowed with this MySQL version. Thanks for any help, Doug

Re: How to get the last record from the slected record set

2004-08-23 Thread gerald_clark
Manisha Sathe wrote: I want to select first 10 records out of 100. And then get the 10th position. If i make use of order by score asc limit 1 then I will get 100th record, How shall i pick up 10th position? regards Manisha order by score desc limit 9,1 -- MySQL General Mailing List For list

showing dbs in terminal window opposed to phpmyadmin

2004-08-23 Thread Hull, Douglas D
How come when I am using the terminal on my mac os x 10.3.x and give the command show databases I only see one database (the 'test' database that is included in the install') as compared to viewing databases with my browser and phpmyadmin I can see 6 databases (that same 'test' database, a

Re: How to get the last record from the slected record set

2004-08-23 Thread Karl Pielorz
--On 22 August 2004 21:05 +0800 Manisha Sathe [EMAIL PROTECTED] wrote: I want to select first 10 records out of 100. And then get the 10th position. If i make use of order by score asc limit 1 then I will get 100th record, How shall i pick up 10th position? I'm not quite sure I follow what

Re: Question about [mysql defunct] processes

2004-08-23 Thread Egor Egorov
Ken Sorensen [EMAIL PROTECTED] wrote: I am stumped. I have a very busy MySQL db that we've run for about 3 years with no problems. A couple of months ago we upgraded the system to RH-3AS with RedHat's distro mysql-server 3.23.58-1.9. Recently I've started getting zombie processes ([mysql

RE: showing dbs in terminal window opposed to phpmyadmin

2004-08-23 Thread Victor Pendleton
Are you loggin into the terminal and PHPmyadmin as the same user? -Original Message- From: Hull, Douglas D To: Note To MySQL List (E-mail) Sent: 8/23/04 8:30 AM Subject: showing dbs in terminal window opposed to phpmyadmin How come when I am using the terminal on my mac os x 10.3.x and

MySQL query designer for *nix?

2004-08-23 Thread Egor Egorov
Hello. I'm looking for a schema designer / relations editor which is GUI, supports MySQL and runs on *nix, either commercial or freeware. Can you suggest me something? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net

RE: How to get the last record from the slected record set

2004-08-23 Thread Kerry Frater
Hi, I don'e know if this will help as I am probably only one step ahead of you here, but if it does great. If not you can just delete it. How are you going to access the data? Via a program, PHP, using queries? I am a newbie to this area myself, and use Delphi. I know that using Delphi with

Re: MySQL query designer for *nix?

2004-08-23 Thread Jens Bierkandt
Hi, you might want to try this: DBDesigner from FabForce. http://www.fabforce.net/dbdesigner4/ Regards, Jens Egor Egorov wrote: Hello. I'm looking for a schema designer / relations editor which is GUI, supports MySQL and runs on *nix, either commercial or freeware. Can you suggest me something?

mysqlhotcopy

2004-08-23 Thread Nuno Dias
Hi, I'm trying to use mysqlhotcopy to make a backup of some mysql databases. But when i try to run mysqlhotcopy I'm getting this error, [EMAIL PROTECTED] Temp]# mysqlhotcopy -u root dbxpto /root/Temp DBD::mysql::db do failed: You have an error in your SQL syntax near '` READ,

Re: How to get the last record from the slected record set - Thanks

2004-08-23 Thread Manisha Sathe
Thanks to all of, I could get it Thanks Manisha - Original Message - From: Karl Pielorz [EMAIL PROTECTED] To: Manisha Sathe [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, August 23, 2004 9:52 PM Subject: Re: How to get the last record from the slected record set --On 22

super-smack installation problem

2004-08-23 Thread Crouch, Luke H.
I'm trying to configure and install super-smack-1.2 and get a problem on configure. it's looking for mysql_real_connect and can't find it...where would this be located? I'm assuming it is in libmysqlclient.so, and I have that file in my /usr/lib/mysql folder, among other places...but it

into outfile

2004-08-23 Thread Scott Hamm
SELECT foo INTO OUTFILE '\\l030k12\qcda\2004-08-03.html' WHATEVER foo; Is that possible? I seem to be doing it wrong. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: into outfile

2004-08-23 Thread mos
Scott, At 11:58 AM 8/23/2004, you wrote: SELECT foo INTO OUTFILE '\\l030k12\qcda\2004-08-03.html' WHATEVER foo; Is that possible? I seem to be doing it wrong. select * into outfile 'p:\win2ktmp\mytest.txt' from mytable where order by Make sure the output

RE: into outfile

2004-08-23 Thread Victor Pendleton
If you wanted html output you could do this mysql -uuser -p -H -equery_to_run webFile.html ... The -H switch produces HTML output. -Original Message- From: mos To: [EMAIL PROTECTED] Sent: 8/23/04 12:11 PM Subject: Re: into outfile Scott, At 11:58 AM 8/23/2004, you wrote: SELECT

RE: into outfile

2004-08-23 Thread mos
At 12:59 PM 8/23/2004, you wrote: If you wanted html output you could do this mysql -uuser -p -H -equery_to_run webFile.html ... The -H switch produces HTML output. It would be real nice if they added this feature to the Select statement. :-) Mike -- MySQL General Mailing List For list archives:

How to Reset a field

2004-08-23 Thread Yusdaniel Rodriguez Espinosa
Hello I have a db with table usuarios I erased all data in this table but Id is a autoinc and he have the value of the last value. How I can Reset the field ID thanks --- Hola Yo tengo una db con una tabla usuarios, yo borre todos los campos de la db pero el campo

RE: How to Reset a field

2004-08-23 Thread Victor Pendleton
Try alter table usuarios auto_increment = 1; -Original Message- From: Yusdaniel Rodriguez Espinosa To: [EMAIL PROTECTED] Sent: 8/23/04 9:15 AM Subject: How to Reset a field Hello I have a db with table usuarios I erased all data in this table but Id is a autoinc and he have the value of

Re: How to Reset a field

2004-08-23 Thread V. M. Brasseur
You could also have done this: TRUNCATE TABLE usarios; That will drop the table completely and then recreate it anew (and empty). It will give you a fresh start. --V Victor Pendleton wrote: Try alter table usuarios auto_increment = 1; -Original Message- From: Yusdaniel Rodriguez

Testing for the existence of an index

2004-08-23 Thread Jesse Sheidlower
I have a database where, most of the time, I'm bulk-loading data into new tables from an external source, several million rows at a time. For this purpose, I create the tables without indexes, and then add all my indexes after the load is done, for efficiency purposes. I'd now like to add the

Re: about creation error of full text index

2004-08-23 Thread Koh Woojong
I think that it is not a OS problem or mysql built. I tested it in many version of mysql and I created the records from web by crawling. so whenever I test, the records are NEW. but the same error must occur to. I think it is so curious that it makes no error in small scale tables. I think

RE: Testing for the existence of an index

2004-08-23 Thread Victor Pendleton
Why don't you disable the indexes before the load and enable the indexes after the data load? -Original Message- From: Jesse Sheidlower To: [EMAIL PROTECTED] Sent: 8/23/04 3:33 PM Subject: Testing for the existence of an index I have a database where, most of the time, I'm bulk-loading

Re: Testing for the existence of an index

2004-08-23 Thread EWA Goodson-Wickes
Why don't you download navicat or use php admin and then just open the table up in design view? You can then see if it has an index or not and add one if you need? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: How to Reset a field

2004-08-23 Thread EWA Goodson-Wickes
Donde estas tratando hacer eso, en el command line cierto? O estas trabajando con mysql front o con algun otra programa? Perdon estoy muy nuevo no entiendo donde hacer alter table usuarios auto_increment = 1, mil gracias -- MySQL General Mailing List For list archives:

Connection pooling with C?

2004-08-23 Thread Jaye Mathisen
I have an app I'm using (I have source, but I'm not the programmer), that works pretty good, but it seems to be speed-limited because of the time to connect to the mysql server. I run with IP's only, no DNS lookups and such, and things are better, but I think it could improve. Is there a C

need help for a query

2004-08-23 Thread Claire Lee
Hi, Here's a table of mine namedate changeDate n1d1 cd1 n2d1 cd3 n2d2 cd1 n4d1 cd2 n1d2 cd5 n5d1 cd4 n6d2 cd2 I need to select every name for which the changeDate corresponding

anonymous localhost user in mysql user grant table

2004-08-23 Thread rusty
What's the purpose of the entry in the user table where it has host='localhost' and user='' (blank) and all of the permissions set to N? In other words, is this some sort of security safety net and it would be dangerous to delete it? Or is it an example of setting up an anonymous locahost

Re: Testing for the existence of an index

2004-08-23 Thread Jesse Sheidlower
On Mon, Aug 23, 2004 at 03:45:28PM -0500, Victor Pendleton wrote: Why don't you disable the indexes before the load and enable the indexes after the data load? If I'm bulk-loading a fresh install of data, then I'll be using un-indexed tables and index them afterwards. Otherwise, I want to keep

RE: MySQL query designer for *nix?

2004-08-23 Thread Logan, David (SST - Adelaide)
Hi Jens and Egor, This is a very nice little product unfortunately it only appears to compile on Linux not other *nixes. If anybody can get it to compile can they please let me know? It works great on shudder Windows shudder. However, it certainly connects with MySQL (is inbuilt) and is easy to

RE: Can't start mysql server automatically

2004-08-23 Thread Logan, David (SST - Adelaide)
Also you can also use the crle command to build a permanent set of library paths similar to ldconfig in Linux and other unices. There should be a man page for it on your system. You can simply add /usr/local/lib to there in the correct order and this resolves having to use LD_LIBRARY_PATH.

Figuring out the ranking position of an item on a table given its partnumber

2004-08-23 Thread C.F. Scheidecker Antunes
Hello All, I have a table that has a PartNumber and the Quantity of Items sold for each partNumber, that is: PartNumber Qty I need to get its sales raking given its PartNumber, that is. So if I order the table by Qyt in descending order the first record will be the partNumber that sold the

Re: Dynamic Queries followup

2004-08-23 Thread Stuart Felenstein
Thanks again for a wonderful detailed response. The part that was still bothering me was the multiple-same-category fields. I get locked into this thinking and well, it's difficult to let go. Then I tried something on a table that had MemID, Doc1, Doc2, Doc3 I had put Doc1 in a few hours

` question

2004-08-23 Thread Paul Metzger
Hit all, I have a question. I am working on a part inventory program for work. I'm writing it in PHP4. I got the connection ok, the form ok and all that. My problem came when I went to do the insert. I did INSERT INTO table VALUES 'val1', 'val2' etc well when I ran the page, it gave me a query

Re: Why VARCHAR TO CHAR automatically when the length less than 4.

2004-08-23 Thread Joseph Cochran
On Mon, 23 Aug 2004 15:25:21 +0200, Martijn Tonies [EMAIL PROTECTED] wrote: I have a questions about varchar columns change to CHAR columns automatically. See http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html In addition to that - it doesn't really matter as the CHAR

Re: need help for a query

2004-08-23 Thread Matt Warden
Hi Claire, On Mon, 23 Aug 2004 14:52:29 -0700 (PDT), Claire Lee [EMAIL PROTECTED] wrote: Hi, Here's a table of mine namedate changeDate n1d1 cd1 n2d1 cd3 n2d2 cd1 n4d1 cd2 n1d2 cd5 n5d1

Re: Figuring out the ranking position of an item on a table given its partnumber

2004-08-23 Thread Michael Stassen
You can use LIMIT. For the 123rd position: SELECT PartNumber, Qty FROM your table ORDER BY Qty DESC LIMIT 122, 1; With 2 arguments, LIMIT treats the first as the offset to the starting row (0 = first row, so 122 = position 123) and the second as the number of rows to show. This is

Re: ` question

2004-08-23 Thread Michael Stassen
If your insert really looks like what you have here, it's not complaining about the quote character. You have a syntax error. If you are inserting a value in every column, you need INSERT INTO table VALUES ('val1', 'val2', ...); You left out the parentheses. See the manual for correct

Replication eats 99% CPU

2004-08-23 Thread Chua Choon Keng
Hello everyone, The master is moderately busy with load average of 2-3. This has worked very well for a long time before I started replication (few months). When replication is started, both master and slave appear to work fine with no significant increase of load on either side. But, after a

Help me for my problem please

2004-08-23 Thread aidil
Hi All, Here's my table structure Table 1: STM (Store Master) STR_CODE Desc part_number Table 2 : MRC(Master Received) Ref_No Rec_date Table 3 : DRC (Detail Recived) Ref_no PO_No STR_CODE