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 si

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 helping

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 such

jdbc connection pool problem, help, thanks!

to me, 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 archi

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 backquote

Re: Really worried about DELETE statement - THANKS

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

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 owne

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

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

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 1

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!

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

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

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 l

Re: Query Help - Thanks

you. Michael P.S. Underscores seemed to come and go in your column names (probably I didn't read closely 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 re

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 i

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

ect to the db using the user and password, etc. And I can also use ODBC from 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 P

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

RE: SELECT DISTINCT question (Thanks it worked)

maybe 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

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: '[

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

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

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 leo:/v

Re: Thanks and SQL Syntax help

15 | 2003-02-17 | PA-211a | +-+++-+ 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 >

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

Re: E-Commerce, db-clustering and MySQL? Thanks to all!

Thanks to everybody who helped me with this! - Original Message - From: "Brian P. Austin" <[EMAIL PROTECTED]> To: "Dietrich Speer" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 08, 2002 9:01 AM Subject: RE: E-Commerce, db

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

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

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

riginal Message - 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 i

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 Wideniu

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 woul

Re: Thanks

> Sent: Thursday, June 06, 2002 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 (sinc

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 not

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

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

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

ce Project 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 o

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

text index on a > particularly large table I have and then setup a slave server with the > fulltext index and then do all the fulltext queries on the slave server? > > > Thanks, > Brian Bray > > > > [for the filter: sql,query] > > > ---

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 replie

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

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: '[

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 [root password]

nt 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' a

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

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 fir

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

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: problems under R.H. 7.1: THANKS

Andy De Paoli <[EMAIL PROTECTED]> writes: > I wanted to thank all the helpful e-mails I got ragrding problems with > MySQL bundled with RedHat 7.1. > > it was pointed out that the main problems were due to the following: > this release apparently installs the mysql files with root > permissi

problems under R.H. 7.1: THANKS

workaround is chown mysql.mysql 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] [EMAIL PROTECTED] (these are

RE: Adding fields--Thanks

Thanks for the great tutorial 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] Subject

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 PROTECTE

Re: Probs with AUTO_INCREMENT column - thanks

Right, only on an INTEGER col, as documented [sheepish grin] thanks all matt On Mon, 07 May 2001, Peter Pentchev wrote: > > On Mon, May 07, 2001 at 07:21:59AM -0700, [EMAIL PROTECTED] wrote: > > > > Hi all, > > > > I've started using MySQL for the f

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 at

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

Thanks

Just wanted to say thanks to all the people that help out here. I have seen more problems solved here than anywhere and not just on mysql. It has been so much fun to be on this list and see everyone cooperate to get these problems fixed. Thanks again. Alan Halls Adoption.com Webmaster

Fw: Duplicate entry error -THANKS!

ioned in the error message), and the entry "other_field = '88' and > > Ekey='252'" has already been used. > > > > Regards > > > > Quentin > > > > Thanks in advance for your help! > > > > How does one replace a sing

RE: The function of auto_increment and Premier Key? - Thanks!

Thanks you for your good explain of this all - now I have a good idea of how it works. Ps. I meant that I'm familiar to simple databases like MS Access etc. but not of course MySQL witch I think is great! :) Sumarlidi -Original Message- From: Carsten H. Pedersen [mailto:[

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