from excel to the mySQL

2010-08-03 Thread HaidarPesebe
Dear All, I'm needs a way to upload data from excel to the mySQL database. Dear all, I need help is how to upload data from excel columns and load into mysql database using php? Thanks HaidarPesebe

Re: from excel to the mySQL

2010-08-03 Thread Marc Guay
I'm needs a way to upload data from excel to the mySQL database. Dear all, I need help is how to upload data from excel columns and load into mysql database using php? http://www.sqldbu.com/eng/sections/tips/mysqlimport.html -- MySQL General Mailing List For list archives:

Re: from excel to the mySQL

2010-08-03 Thread sam rumaizan
  visit this site :   http://www.daniweb.com/forums/thread119197.html   --- On Tue, 8/3/10, Marc Guay marc.g...@gmail.com wrote: From: Marc Guay marc.g...@gmail.com Subject: Re: from excel to the mySQL To: HaidarPesebe haidarpes...@gmail.com Cc: MySQL Lists mysql@lists.mysql.com Date:

RE: from excel to the mySQL

2010-08-03 Thread LIU YAN
hi HaidarPesebe, one way to do this is : 1. save the excel to xxx.csv 2. then use the mysql SQL statement LOAD DATA INFILE for example : LOAD DATA INFILE 'c:\\test\\xxx.csv' INTO TABLE tbl_name FIELDS TERMINATED BY ',' best regards liuyann From: haidarpes...@gmail.com To:

Re: InnoDB Tablespace

2010-08-03 Thread Johnny Withers
About the above - it is saying 6144 KB so it is 6.1 GB. Are you sure? I would think 6144KB = 6.144 MB, or 6144 * 1000 = 6,144,000 bytes. I think since InnoDB, by default, extends the table space by 8MB increments, this is reporting the free space in this increment. How can I tell total

Split string by regex

2010-08-03 Thread Adam Gray
Hello, I'm working on a library OPAC system with books classified using the Library of Congress classification system. This takes the format of either one or two letters followed by some numbers, i.e. R272 or RA440 etc. What I want to do is split the field that holds this classification into

Re: InnoDB Tablespace

2010-08-03 Thread Suresh Kuna
Hi Johnny, Sorry about that - i just overlooked and the simple way to calculate the sizes is to query the information_schema table called tables for data and index sizes. On Tue, Aug 3, 2010 at 8:55 PM, Johnny Withers joh...@pixelated.net wrote: About the above - it is saying 6144 KB so it

Re: Importing User credentials from mysql.sql file???

2010-08-03 Thread Nunzio Daveri
Thanks Paul, I guess then all I need to do is remove the root entries at the begining of the insert statement and then just insert the rest into 5.X since the column names are there it should just import with no problems right? Thanks again :-) Nunzio From:

RE: Split string by regex

2010-08-03 Thread Gavin Towey
Since your conditions are pretty specific you can do this: set @a='RA100'; select IF(@a REGEXP '[A-Za-z]{2}', SUBSTRING(@a,1,2), SUBSTRING(@a,1,1)) as letter, IF(@a REGEXP '[A-Za-z]{2}', SUBSTRING(@a,3), SUBSTRING(@a,2)); +++ | letter | number | +++ | RA |

Re: from excel to the mySQL

2010-08-03 Thread Miguel Vaz
Hi, Ive always used navicat for mysql and it does wonders for import/export (wether it be from excel or any other file type) and also general database management. Actually, too many features to list here, check the website: http://www.navicat.com/en/products/navicat_mysql/mysql_overview.html

RE: from excel to the mySQL

2010-08-03 Thread Martin Gainty
Vaz lecture start please do not insert bogus display names into the email display name (such as Vaz when your real name is haidarpesebe) most responsible mail-admins wont tolerate this type of spoofing or any type of email spoofing and if your name is VAZ use the email address created for VAZ