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
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:
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:
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:
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
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
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
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:
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 |
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
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
11 matches
Mail list logo