Subqueries

Hello, I'm using MySQL 4.1.7 and want to use subqueries (very useful !). All the queries i'm trying (with subqueries) give the correct results, but have so bad performances that it is impossible to use it. I did many tests, and it seems to be a general comportement for MySQL, not particular to

Re: Concatinating Two Columns

SELECT AttID ,SessionDate , CONCAT( FirstName, " ", LastName ), Present FROM myTable - Original Message - From: "GH" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 14, 2004 5:32 AM Subject: Concatinating Two Columns > I would like to know how I can make two columns o

Re: Importing Excel Data in MySql

Thanks to all for your suggestions just have to try all now Thanks! > -- > 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 To u

Re: Importing Excel Data in MySql

> You could do a find & replace and change every ; to some other symbol > directly in excel before importing I'm not sure our clients will appreciate if I modify their ponctuation everuwhere :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

Importing Excel Data in MySql

Hello We have clients sending us xls file. We export them as csv files, using commas or semi-colons. as delimiters and then make an import in mysql. Problem : some of the fields, containing texts, have sometimes already a comma or a semi-colon in them...and when we import, of course MySql thin

Re: match a fulltext search with a "-" dash, can't match if - exist

earch, the search string must be at least 4 characters ? Otherwise, Mysql ignore it ? Bertrand. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Need help

; Repair your table.. > see: http://www.mysql.com/doc/R/E/REPAIR_TABLE.html > > Gurhan > > -Original Message- > From: Bertrand TACHAGO [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 21, 2002 9:16 AM > To: [EMAIL PROTECTED] > Subject: Re: Need help > > &g

Re: Need help

? Thanks in advance -- ****** Bertrand TACHAGOE_mails: [EMAIL PROTECTED] / [EMAIL PROTECTED] Network / information specialist SDNP SchoolNet Cameroon Phone: (237)221 25 53 Web site:

How to add mysql to my startup

Hi, i'm using Linux Red Hat 7.0 and i want to know how to add mysql to my startup. Thanks in advance -- Moise Bertrand TACHAGO Computer scientist Volunteer DBMS Specialist SDNP Cameroon, 506 Hajal Center Building Yaounde CAMEROON (237)22 24 90 E_mail [EMAIL PROTECTED] [EMAIL PROT