Vaz
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 instead of
h
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
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 | 1
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:
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 wrote:
> About the above - it is saying 6144 KB so it is 6.1 GB.
>
> Ar
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 tw
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
remain
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
>
visit this site :
http://www.daniweb.com/forums/thread119197.html
--- On Tue, 8/3/10, Marc Guay wrote:
From: Marc Guay
Subject: Re: from excel to the mySQL
To: "HaidarPesebe"
Cc: "MySQL Lists"
Date: Tuesday, August 3, 2010, 7:34 AM
> I'm needs a way to upload data from excel to th
> 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: http://lists.m
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
11 matches
Mail list logo
