Problem with 4.1.3 that I not had with 4.0.20

Good Morning Community! I have a problem with 4.1.3 that I not had with 4.0.20. Here is my table: CREATE TABLE url_cat_copy ( id int(11) NOT NULL auto_increment, url varchar(100) default NULL, domain varchar(100) default NULL, bytes bigint(20) default NULL, hits bigint(20) default N

Help me for my problem please

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

Replication eats 99% CPU

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 fe

Re: ` question

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 synta

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

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 doc

Re: need help for a query

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 > n5

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

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 th

` question

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 err

Re: Dynamic Queries followup

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 earli

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

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 most.

RE: Can't start mysql server automatically

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. Regards

RE: MySQL query designer for *nix?

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: Testing for the existence of an index

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 kee

anonymous localhost user in mysql user grant table

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 user

need help for a query

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

Connection pooling with C?

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 bas

Re: How to Reset a field

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: http://lists.mysql.com/

Re: Testing for the existence of an index

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 P

RE: Testing for the existence of an index

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: about creation error of full text index

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 there

Testing for the existence of an index

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 pos

Re: How to Reset a field

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 Espinosa

RE: How to Reset a field

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

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 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 c

RE: into outfile

At 12:59 PM 8/23/2004, you wrote: If you wanted html output you could do this mysql -u -p -H -e"query_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: ht

RE: into outfile

If you wanted html output you could do this mysql -u -p -H -e"query_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

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 directory

into outfile

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]

super-smack installation problem

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 doesn't

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

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 >

mysqlhotcopy

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, `dbxpto`.``cert

Re: MySQL query designer for *nix?

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?

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

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 the

MySQL query designer for *nix?

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 http:/

RE: showing dbs in terminal window opposed to phpmyadmin

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

Re: Question about [mysql ] processes

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 ([mys

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

--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 you

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 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 'mysq

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

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 ar

insert data from text file

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

miving dbs etc from one machine to another

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 permission

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

* 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 M

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

> > 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 VARCHA

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

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

Re: release all mysql locks

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 https://order

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

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: How to get the last record from the slected record set

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: A new Machine

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

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

From: root To: Subject: [second write process hangs if another one is writing already,!!but in another database!!] >Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended ema

Re: Can't start mysql server automatically

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

Re: Kernel panic when mysql stop command issued

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 https://

Re: how to increase max allowed keys?

íÉÈÁÉÌ íÏÎÁÛ£× <[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

Re: Mysqlcheck -r very slow on big tables

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,

Re: problem with tables crashing

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 https://or

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

> >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

Re: Innodb table definitions

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) extens

Re: Fulltext performance problem.

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 msg

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

"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 kern

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

--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 wil

LEFT JOIN table USING ..

SELECT associates.shift, concat(associates.firstname,',',associates.lastname) as Operator, mrdaily.kronoshours, mrdaily.pto LEFT JOIN mrcategories USING ( mrcategories.category='1', mrcategories.category='2', mrcategories.category

Re: query plan

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/ __ ___ ___ __

How to get the last record from the slected record set

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 adv

Re: A new Machine

"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 =

Re: LOAD DATA

[EMAIL PROTECTED] wrote: > I use following code > use databasea > > load data infile"abcd.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 carriag

Re: Re-installing db/tables from dumpfile

"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 i

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

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

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

"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:

distributed queries

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: about creation error of full text index

°í ¿ìÁ¾ <[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 |

Re: Table needs to be repaired once a week

"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: S

Re: select count(*)

"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 con

Table needs to be repaired once a week

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 s

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

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] >

Re: special order

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

query plan

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]

MySQL 4.1.3 won't autostart on Mac OS X?

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