Newbie question: How to import data into a table?

Hello folks, What is the best way to import an excel spreadsheet, or text file for that matter into a table? Is there a way to do this with PHPMyAdmin? Thank you so much for your kind help. Joe

Re: SQL HAVING statement ?

- Original Message - From: "Brett Harvey" <[EMAIL PROTECTED]> To: Sent: Saturday, November 26, 2005 9:45 PM Subject: Re: SQL HAVING statement ? "Rhino" <[EMAIL PROTECTED]> wrote: Second, you're using the HAVING clause incorrectly in your query. HAVING only works with GROUP BY, i.e

Re: encrypt data

Jake Peavy <[EMAIL PROTECTED]> wrote on 11/26/2005 07:54:22 PM: > Also, do you know if there is any way at all to do the tiniest amount of > research on my own to find out even the most basic information about MySQL > without bothering an entire worldwide mailing list with my trivial > questions?

Re: Executing multiple queries at a time in Query Browser

Colin Shreffler <[EMAIL PROTECTED]> wrote on 11/26/2005 04:44:26 PM: > Does anyone know how to separate queries so that I can run multiple insert > statements at once? > > For example, from within MySQL Query Browser, I want to load a file > containing multiple inserts and then run it. It erro

Re: SQL HAVING statement ?

"Rhino" <[EMAIL PROTECTED]> wrote: Second, you're using the HAVING clause incorrectly in your query. HAVING only works with GROUP BY, i.e. you MUST have a GROUP BY to be able to use HAVING. (Note: You can have a GROUP BY without using HAVING but you cannot use HAVING unless a GROUP BY is prese

Re: SQL HAVING statement ?

Rhino, Thanks for all the info. It was as simple as %% in the statement... DUH! I can't believe I missed that. Sorry to have bothered. Thanks anyway. M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: encrypt data

Also, do you know if there is any way at all to do the tiniest amount of research on my own to find out even the most basic information about MySQL without bothering an entire worldwide mailing list with my trivial questions?

Re: SQL HAVING statement ?

- Original Message - From: "m i l e s" <[EMAIL PROTECTED]> To: "MySQL" Sent: Saturday, November 26, 2005 6:39 PM Subject: SQL HAVING statement ? Hi, Im having a bit of a problem with the following query: SELECT CONCAT(people2.First_Name, " ", people2.Last_Name) AS zNAME, events.na

SQL HAVING statement ?

Hi, Im having a bit of a problem with the following query: SELECT CONCAT(people2.First_Name, " ", people2.Last_Name) AS zNAME, events.name_short, events.date_start FROM people2 INNER JOIN event_people ON people2.ID = event_people.peopleID INNER JOIN events ON event_pe

Re: encrypt data

Hello. See: http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html Luiz Rafael Culik Guimaraes wrote: > Dear Friends > > is their any way to encrypt data saved to an mysql server? > > Regards > Luiz > -- For technical support contracts, goto https://order.mysql.com/

Re: full text table query issues

Hello. Please could you provide a repeatable test case for this issue? FT search works fine for me even if one of the columns has empty values. 'Yemi Obembe wrote: > using the a sql statement like ds: > select *, match(url, title, comment) against ('movies') as score from dir > whe

Re: Critical Error!

Hello. See: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html Zan wrote: > Hello all! I was going through my forums yesterday, when suddenly I got > a critical error. The message was 'could not connect to database' so I > went to restart MySQL by going into /usr/lo

Re: How to compose index?

Hello. In my opinion, something changes in how MySQL handles the query when you overrun the 100,000 number of rows. If EXPLAIN shows the difference for queries with LIMIT below and higher than 100,000? Do you have key_buffer (innodb_buffer_pool_size) big enough? Please send you queries to th

Executing multiple queries at a time in Query Browser

Does anyone know how to separate queries so that I can run multiple insert statements at once? For example, from within MySQL Query Browser, I want to load a file containing multiple inserts and then run it. It errors however on trying to run the following queries: insert into project_type (proj

encrypt data

Dear Friends is their any way to encrypt data saved to an mysql server? Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]