Running mysqld on certain interface
How do I set mysqld hears only on eth0? i am using FC linux. -- God Bless Us -- __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Group by base on latest time field, possible?
not works. it's still show same result. any idea? - Original Message - From: Quentin Bennett [EMAIL PROTECTED] To: The Nice Spider [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday, August 10, 2006 12:43 PM Subject: RE: Group by base on latest time field, possible? Try select thread, subject, max(time) from jos_sb_messages group by thread order by 3 -Original Message- From: The Nice Spider [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 August 2006 4:10 p.m. To: mysql@lists.mysql.com Subject: Group by base on latest time field, possible? I want the group by result take the latest field, but my query result look like get the random row. Here I described: Thread SubjectTime - 5 Re:test 33 1155203794 5 test 33 1155203772 8 test 4441155203882 8 Re:test 444 1155203897 note: time field is INT(11) to store datetime in integer value QUERY - select thread, subject, time from jos_sb_messages group by thread order by time RESULT -- 5 Re:test 33 1155203794 8 test 4441155203882 What do I need is: -- 5 Re:test 33 1155203794 8 Re:test 4441155203897 I am using 3.23.58 for Windows. How to get the result as I expected? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Group by base on latest time field, possible?
I want the group by result take the latest field, but my query result look like get the random row. Here I described: Thread SubjectTime - 5 Re:test 33 1155203794 5 test 33 1155203772 8 test 4441155203882 8 Re:test 444 1155203897 note: time field is INT(11) to store datetime in integer value QUERY - select thread, subject, time from jos_sb_messages group by thread order by time RESULT -- 5 Re:test 33 1155203794 8 test 4441155203882 What do I need is: -- 5 Re:test 33 1155203794 8 Re:test 4441155203897 I am using 3.23.58 for Windows. How to get the result as I expected? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
I believe the answer is that there isn't a way to fix the syntax for 3.23, because 3.23 simply doesn't support multi-table deletes. An alternative solution is needed. One option would be to do this programmatically. Collect the sectionids with a SELECT, then delete them with a separate query. Another option would be to select the good rows into a new table, then use this new table to recreate table A. Something like CREATE TABLE A2 SELECT A.* FROM A JOIN B ON A.sectionid = B.id; then DELETE FROM A; INSERT INTO A SELECT * FROM A2; or RENAME TABLE A TO A_old, A2 TO A; Michael it's work, thanks mike! __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?
This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? Probably if you post the error message you get. DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null error message on 3.23 is: You have an error in your SQL syntax near 'USING USING A RIGHT JOIN B ON B.id = A.sectionid' at line 1 SQL=DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null BUT this query run ok in 4.0.25. i need to find error free syntaks for 3.23 version. any help? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to convert this DELETE command from MySQL 4.0.25 to 3.23?
Hi, This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null This task is deleted any row in A that have no items on B. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to SUM every row for SubTotal?
If I have table like: CODE QTY 100 30 200 20 300 25 and I want a result like: CODE QTY SUBTOTAL 100 30 30 200 20 50 (this come from 30+20) 300 25 75 (this come from 50+25) How to write query like that? - Yahoo! FareChase - Search multiple travel sites in one click.
Assigment sign not work on Delphi
Using Delphi to with this query: SELECT TOTAL := PRICE * QTY FROM INV_PRODUCT will caused error Parameter object is improperly defined. Inconsistent or incomplete information was provided. because Delphi look it as Parameter (a parameter of query in Delphi using : at the beginning). Is it better for MySQL using = rather than := ? Or is there any setting to set MySQL to accept the = sign? __ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does MySQL Support '=' Sign?
Does MySQL support: SELECT ID_TAG= ID FROM TABLE rather than select ID TAG_ID from Table. I need this for MS SQL Compabilty. - Yahoo! FareChase - Search multiple travel sites in one click.
Re: Delete all but the newest 100 records?
On Nov 7, 2005, at 11:04 AM, Scott Noyes wrote: delete from x where ID not in (select ID from x order by timestamp desc limit 100); It's a good suggestion, I'm just shying away from it because it seems more resource intensive than using an offset, and my ISP is super anal about resources. I'd love to get the offset working if possible. Have you try the query above, I've got: This version of MySQL doesn't yet support 'LIMIT IN/ALL/ANY/SOME subquery' I am using 5.0.15. __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]