Re: THANKS

Am 18.05.2013 17:56, schrieb Last Hacker Always onpoint: Hey sir thanks for adding me to the list but if I want to send a question where do i send it to? mysql-subscr...@lists.mysql.com or mysql@lists.mysql.com what about read the welcome message or the text on the subcribe site? http

Re: BLOB Filed - Image Store [THANKS]

Dear Sir, Thank you for advising me generally, how to approach/in what cause we need to approach! I will follow your advise very strictly here after. I will try to find out solutions my self first and if not, i ll write to the experts. Thank you so much for making me to understand the

Re: Problems After MySql 5.1.34 - THANKS

Thanks to everyone that offered all the valuable suggestions. SImply replaced the shared-community with shared-compat and all seesm fine. Will live with, or deal with, the missmatch in php libraries later, but for now everything seems to work. Thanks again to everyone that offered

jdbc connection pool problem, help, thanks!

, any recommendations are much appericated! PS: I posted this question on Java section but no replys :( Ray -- View this message in context: http://www.nabble.com/jdbc-connection-pool-problem%2C-help%2C-thanks%21-tp15673813p15673813.html Sent from the MySQL - General mailing list archive

Re: Error, thanks!

Thank you so much, that worked! -- Steve M. on 1/15/08 3:17 PM Rolando Edwards ([EMAIL PROTECTED]) wrote: ORDER is a reserved word in standard SQL Example : SELECT FirstName,LastName FROM Names ORDER BY LastName,FirstName; If the column name in the table is ORDER, then put backquotes

Re: Really worried about DELETE statement - THANKS

geodesic_user_data FROM geodesic_user_data LEFT JOIN subscriber ON geodesic_classifieds_userdata.id=subscriber.GeoClassID WHERE subscriber.GeoClassID IS NULL; Our hosting company uses MySQL 4.0.17 so the subquery approach is not possible. Thanks in advance - Miles Miles, It looks fine but you

Re: Really worried about DELETE statement - THANKS

of eyes would be appreciated. DELETE geodesic_user_data FROM geodesic_user_data LEFT JOIN subscriber ON geodesic_classifieds_userdata.id=subscriber.GeoClassID WHERE subscriber.GeoClassID IS NULL; Our hosting company uses MySQL 4.0.17 so the subquery approach is not possible. Thanks in advance

Re: Help Thanks!

On 8/22/06, Karl Larsen [EMAIL PROTECTED] wrote: $ mysqladmin -U make new password for root doesn't work. can you copy the error? if you want to set the root password you can use mysqladmin -u root password newpwd -- http://www.obed.org.mx --- blog -- MySQL General Mailing List For list

Help Thanks!

I got a lot of good help from people on this list. Some of them got pissed at me because I was slow to use their suggestions. My reason was I could not believe someone would release a rpm(s) that required the user to make a directory not mentioned in the referance manual and change it's

RV: Same question, better example / SOLVED, thanks!

Hi Sheeri, you are correct in both the MySQL tips and in your suggestion that I should include my test when I think something doesn't work ;) Thanks a lot! I realize now that when I've sent a thank you note, I have only sent it to the responder instead of all the list; my problem was sorted

Thanks for the help

Thanks for the help, I'll give some of these examples a try~!!! Thanks, Matt Babineau Criticalcode 858.733.0160 [EMAIL PROTECTED] http://www.criticalcode.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: why does this query work??!!! - THANKS!!!

Thanks everyone!! It was just a typo and everything was updated :( That's okay, I got my Admin guy to restore backup files. I'll just Have to get in the habit of using commit and rollback. -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 17, 2005 10

RE: Can someone explain???? strange query!! THANKS!!

Ahh okay the column was cut off or something \G shows it! Thanks!! -Original Message- From: Rich Lafferty [mailto:[EMAIL PROTECTED] Sent: Friday, April 29, 2005 10:28 AM To: mysql@lists.mysql.com Subject: Re: Can someone explain strange query!! On Fri, Apr 29, 2005 at 10:46:16AM

Re: How to do a simple fulltext match? Thanks!

is successfully made, and I attempt to match my little search (for the word short) contained in the variable $searchterms. However, I get back the message that $peeky (below) is not a valid MySql resource. Can someone tell me what I am doing wrong? Thanks so much! Cheers! -Warren === Errant

How to do a simple fulltext match? Thanks!

, and I attempt to match my little search (for the word short) contained in the variable $searchterms. However, I get back the message that $peeky (below) is not a valid MySql resource. Can someone tell me what I am doing wrong? Thanks so much! Cheers! -Warren === Errant Code follows

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

RE: Query Help - Thanks

Rhino This is great it works a treat Thanks Regards John Berman -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: 29 February 2004 13:40 To: [EMAIL PROTECTED]; 'Paul DuBois' Cc: [EMAIL PROTECTED] Subject: Re: Query Help I hope you don't mind me butting in but your note

Re: Query Help - Thanks

enough). In any case, I kept the underscore at the end of your table names but left it out from your column names. You'll have to modify my example queries to fit your real table and column names. John Berman wrote: Rhino This is great it works a treat Thanks Regards John Berman -Original

ID kewuq... thanks

Yours ID afccvi -- Thank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL and PHP - At last and Thanks

a windows box to connect. any ideas on how to set this beginner (me) straight Thanks, eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

Thanks to All

Thanks to you all, In regards to my question about the retreiving the last few rows in a database your help was really appreciated. Chris thanks for that tip and YEP work for me we will read it into a array then read it back in reverse. Thaks again GUYS and I can't wait to be of help to some

RE: SELECT DISTINCT question (Thanks it worked)

the solution can be the list. Thanks, Hector -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: What would be an efficient way to accomplish this ( Statistic s/Trends in a table?) Thanks!

Thanks for your help, just what I needed. I will play around but if you have a chance and know how, how would I order the results by count? (ie. highest counts first..) -Original Message- From: Mike Knox [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 5:09 AM To: '[EMAIL

RE: What would be an efficient way to accomplish this ( Statistic s/Trends in a table?) Thanks!

Paul How about select FIRST_NAME, count(*) from a table group by FIRSTNAME having count(FIRST_NAME) 1 Mike -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person

What would be an efficient way to accomplish this (Statistics/Trends in a table?) Thanks!

my nap I dreamed up something like selecting all FIRST_NAME ordered by same, and them some kind of script to do counts. Any other/further suggestions appreciated. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Subject: Re: Problem with data import from text file (part two) Thanks

Thanks for the advice - and your patience in giving it to me. The recommended changes in the ini file worked (but only along with removing the word local from the load data local infile instruction) [since I have a localhost Apache server as testing environment] thanks again to those more

How can I get the number of entries retrieved by a SELECT - FROM Thanks!

Dell 4500, mem 1g, disk 45g, mhz 2g, Mysql-3.23.54a-linux-i686, PHP-4.30, httpd_2.0.44 Thanks to Paul DuBois, Roger Davis, Helen Sallee, Ronan Chilvers, and Edward Dudlik for thier response to my question. I've included the a (one of many?) snippit of code that I've decided to use as a pattern

timestamp solved - thanks

timestamp solved - thanks... -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] addisonellis.com THIS E-MAIL AND ANY

Re: Need help installing mysql - Thanks a lot

What does mysqld.log say? Manuel Velasco wrote: I'm getting the following messages after running safe_mysqld (as root): leo:/usr/bin # ./safe_mysqld [1] 4798 leo:/usr/bin # Starting mysqld daemon with databases from /var/lib/mysql 030121 19:38:15 mysqld ended [1]+ Done

Need help installing mysql - Thanks a lot

I'm getting the following messages after running safe_mysqld (as root): leo:/usr/bin # ./safe_mysqld [1] 4798 leo:/usr/bin # Starting mysqld daemon with databases from /var/lib/mysql 030121 19:38:15 mysqld ended [1]+ Done./safe_mysqld leo:/usr/bin # cd /var/lib/mysql

Re: Thanks and SQL Syntax help

| +-+++-+ 2 rows in set (0.00 sec) Hope this helps... On Sat, 2003-01-11 at 16:25, Steve Lefevre wrote: First of, thanks to all who replied to my questions earlier! Now I have another problem. I have a table of Classes and Workshops. Each Class has a number of workshops. Each workshop has

Thanks and SQL Syntax help

First of, thanks to all who replied to my questions earlier! Now I have another problem. I have a table of Classes and Workshops. Each Class has a number of workshops. Each workshop has a date. I have a query that gives me the date range of a class - the min and max dates of its workshops

Thanks! Re: Can MySQL handle 120 million records? - Ok, If you guys really can handle tens of millions records, you have to help me to enjoy MySQL too :-)

Well, thanks to all of your great help! I am able to speed up the query {select count(*) from NEW_Sequence s left join NEW_Sequence_Homolog h on s.Seq_ID = h.Seq_ID;} from 1 min 52.61 sec down to 20.62 sec now. The only thing I changed so far was the Seq_ID from type varchar to bigint. The Seq_ID

Fw: Thanks

Thanks to all who recently answered some of my MySQL questions, although I am still having some problems with the concept of joins, but what I have figured out certainly does make it more efficient and versatile. I have managed to eliminate two tables (actually combine them into one) which made my

Re: Returning an Auto-Increment Field/Thanks

Thanks to all for the responses. Especially to those who pointed my to documentation. Regards -tim- * Cliff [EMAIL PROTECTED] [021108 08:32]: You can use the function : mysql_insert_id() to get the value you've just added. Please see http://www.mysql.com/doc/en/mysql_insert_id.html for more

Re: mysql socket problem in win98 (thanks for the help!)

First of all, thanks to everyone for no reply and no help! If someone is interested, I've found that i Win9x systems, if there are persistent connections open, the system instead of used the same opened connection for the same session, it opens a new connection for each script call, and, because

Re: Re: mysql socket problem in win98 (thanks for the help!)

of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: First of all, thanks to everyone for no reply

Re: Thanks to MySql and it's Developers

- From: Terence [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 15, 2002 9:38 PM Subject: Thanks to MySql and it's Developers To MySql AB and it's developers, I am from Sunway College in Malaysia, and we implemented MySql about a year and a half ago. It was a shift from

Re: build under Win32 - thanks

Thank you very much for help. Nick. sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Thanks SV: Need help how to make Directory system in MySQL with 6.5 mill subscribers ?

Thanks to Dan Nelson and Mike Hillyer, Indexing brought the search downto 2.03 sec compared to 3 min and 16 sec ! Thanks again. Rgs Steinar Kolnes -Opprinnelig melding- Fra: Dan Nelson [mailto:[EMAIL PROTECTED]] Sendt: August 14, 2002 1:14 AM Til: Steinar Kolnes Kopi: Mysql List Emne

Re:Speed Issue - Thanks

Thanks to all who responded to this posting. The problem was due to ODBC logging turned on. When this was rectified the system flew along like a greyhound! I appreciate the other helpful suggestions given. The reason for moving from Access to MYSQL is that I am moving a GIS application

Thanks for the solution of Chinese character problem

Dear Monty, At the beginning, I missed doing the step of setting default character-set. After I have done what you said about setting default character set, the correct chinese characters are stored in mysql database. Thank you very much! Best regards, Henry. From: Michael

Thanks

Thanks Charles for your patience and help. I removed winmysqladmin from startup and ALL problems went away! When winmysqladmin started up on the other user accounts it would somehow block connections to MySQL (since before I uninstalled, on normal [non-admin] user accounts, I could

Re: Thanks

10:59 PM Subject: Thanks Thanks Charles for your patience and help. I removed winmysqladmin from startup and ALL problems went away! When winmysqladmin started up on the other user accounts it would somehow block connections to MySQL (since before I uninstalled, on normal [non-admin] user

Re: Thanks

You are very welcome. I am glad I was able to help. Charles Q. At 03:58 PM 6/6/2002 -0500, k wrote: Thanks Charles for your patience and help. I removed winmysqladmin from startup and ALL problems went away! When winmysqladmin started up on the other user accounts it would somehow block

Thanks to whomever... for the tip on mySQLMan...

the fulltext queries on the slave server? Thanks, Brian Bray [for the filter: sql,query] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: Thanks to whomever... for the tip on mySQLMan...

Manager Mountain Top Herbs -Original Message- From: Andrew Lietzow [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: Thanks to whomever... for the tip on mySQLMan... Helo list, I don't recall if it was here that I heard of this mySQLMan

RE: Thanks to whomever... for the tip on mySQLMan...

- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:52 PM To: Andrew Lietzow; [EMAIL PROTECTED] Subject: RE: Thanks to whomever... for the tip on mySQLMan... I just went in looked at mySQLMan, and I must say, I'm not very impressed with it. If you like that package

Thanks in advance

Hi, How to take part in a mail list for Redhat and FreeBSD such as this one. Thanks, Dominic sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

thanks

Thanks to all who responded to my message from yesterday re: the text field (or column) sizes available in MySQL. I've now gotten the download of the manual and will be pouring over that today in order to pursure further answers to questions specific to our project. Your quick replies

RE: command mysql -u $user without typing it SORTED THANKS ALL !!!!

of whats going on. I thank everyone for their time on this problem. one thing though, I am surprised that grant did not alter the db table ? does this surprise anyone else. Thanks, Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 10 January 2002 14:00 To: '[EMAIL

Thanks for the help with MyODBC

Through the responses, links, and a little concern (and a really smart and helpful web Host, he did most of the hard stuff), I got MyODBC working like a charm. Made up a file DSN and can use it in Visual C++, Visual Basic, and Access. Also thanks to whomever put MyODBC out there... database

THANKS for: Failing to connect to MySQL via unixODBC/PHP

Thanks to all who helped with this problem. As it turns out, it was much stupider than one could suppose, just yet another demonstration that nobody should code more than a very few hours in a row... The odbc_connect statement is nested in the whole PHP code in such a way (thanks to include

Thanks!

Hi all, On the subject of licensing: I've seen the discussions around this topic and would like to approach it from another angle. Until recently I were a student and if it weren't for the free distribution of mySQL I would have had problems. On the other hand I will be the

Re: Thanks!

Joyce Vermeulen writes: Hi all, On the subject of licensing: I've seen the discussions around this topic and would like to approach it from another angle. Until recently I were a student and if it weren't for the free distribution of mySQL I would have had problems. On the

Thanks [root password]

to thank all at Snitz Forum 2000 forum and the mysql maillist for all there help! Thanks, eeehaah BTW, the info returned by mysql_install_db about setting root password is wrong, there must be no space between u and root; /mysqladmin -uroot -p password 'yourdesiredpassword' and /mysqladmin

THANKS for having fixed DISTINCT ... HAVING bug...

... you are really very kind and helpful! Now I can avoid managing temp tables. Thanks very much, Nico Sabbi - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: THANKS for having fixed DISTINCT ... HAVING bug...

nsabbi writes: ... you are really very kind and helpful! Now I can avoid managing temp tables. Thanks very much, Nico Sabbi You are welcome. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL

problems under R.H. 7.1: THANKS

and a workaround is chown mysql.mysql path-where-mysql sock file located apparently my info was outdated, to install the initial database files the command line is: service mysqld start Again, thanks to everyone. -- Andy De Paoli emails: [EMAIL PROTECTED] [EMAIL PROTECTED

RE: Adding fields--Thanks

Thanks for the great tutorialg I added it to my MySQL notes database. I like the way you explained it start to finish.. TIA M;-) -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 6:13 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED

THANKS! RE: GRANT ANNOYANCE REVISITED

Thanks to all of those who lent their advice. Seems that when you initialize MySQL using the --skip-grant-tables option enabled, it disallows the ability to use the GRANT command. I guess that makes perfect sense. I also forgot the use the PASSWORD() function when I used SQL to update my root

Thanks for help!

Thanks for advices. As I got the error message, I thought the server has not been started. It runs really! Frank Tu From: Miguel Angel Solórzano [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED],tu tuande [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Mysql and Windows ME? Date: Sat, 26

RE: Can anyone help with a search? (Thanks)

Thanks everyone for the help, you are an awesome crowd. We got it :) Alan -Original Message- From: Peter Pentchev [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 10:19 AM To: Alan Halls Cc: [EMAIL PROTECTED] Subject: Re: Can anyone help with a search? On Tue, Apr 24, 2001

Thanks for: Outer and left join definition

Hello, I just wanted to thank everybody who helped me to understand the topic below. I am going to unsubscribe from this list now, so please address any further message, if any, to: [EMAIL PROTECTED] Thank you for your time Marco On 2001/04/14 20:37:15 +0100,

Re: Still unable to auto_increment!!! Thanks!

Thanks to those who replied. The solution was to drop the table and then rebuild it. It was originally populated with a negative number (yes, we know about the negative problem with auto incrementation), which caused the max value to show up. I did not know that you cannot simply delete