Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the
release of MySQL for Excel version 1.3.7. This is a maintenance
release for 1.3.x. It can be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts
to very easily access and
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the
release of MySQL for Excel version 1.3.6. This is a maintenance
release for 1.3.x. It can be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts
to very easily access and
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.5. This is a maintenance release for 1.3.x.
It can be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access and
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.4. This is a maintenance release for 1.3.x.
It can be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access and
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.3. This is a maintenance release for 1.3.x.
It can be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access and
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.2. This is a GA release for 1.3.x. It can
be used for production environments.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access and
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.1. This is a RC release for 1.3.x.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access and manipulate MySQL data within Microsoft Excel. It
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of
MySQL for Excel version 1.3.0. This is a beta release for 1.3.x.
MySQL for Excel is an application plug-in enabling data analysts to very
easily access and manipulate MySQL data within Microsoft Excel. It
The MySQL Windows Experience Team is proud to announce the release of MySQL for
Excel version 1.2.1. This is a maintenance release for 1.2.x.
MySQL for Excel is an application plug-in enabling data analysts to very easily
access and manipulate MySQL data within Microsoft Excel. It enables
Hi
I passed Oracle SQL Expert and working on MySQL 5.6 developer exam. I work
5% of my job with SQL but I am searching for a full time SQL job.
http://shop.oreilly.com/product/0790145363466.do
Is the Excel exam (Microsoft Office Specialist - MOS) useful for getting a
junior SQL pro job? What do
Hi,
I have a fairly standard set of queries that I do then I save the resultset as
a CSV and send it off to a couple dozen folks. My understanding is that I can
build an Excel .iqy file that can do the queries (one for each query) and that
I need send that file but once to the users. Does
Thanks for your information, we have tried it and solve my problems.
Thanks.
- Original Message -
From: Miguel Vaz
To: HaidarPesebe
Cc: MySQL Lists
Sent: Wednesday, August 04, 2010 1:40 AM
Subject: Re: from excel to the mySQL
Hi,
Ive always used navicat for mysql
Hi!
Data Wizard for MySQL allows you to import data from Excel (as well as
from CSV, DBF, XML and text files) in a few mouse clicks. The app also
provides a flexible task scheduler.
http://www.sqlmaestro.com/products/mysql/datawizard/
- Original Message -
From: "HaidarPesebe"
Thanks for your information, we are sorry about this.
- Original Message -
From: Martin Gainty
To: pagong...@gmail.com ; haidarpes...@gmail.com
Cc: mysql@lists.mysql.com
Sent: Wednesday, August 04, 2010 6:20 AM
Subject: RE: from excel to the mySQL
Vaz
please
: from excel to the mySQL
> From: pagong...@gmail.com
> To: haidarpes...@gmail.com
> CC: mysql@lists.mysql.com
>
> 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
&g
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
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
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
> 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
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
Note : if you table name it will export all tables from given database;
eg:*
mysqldump -u user -ppassword wordpress --no-data > Dumpdata.txt *
It will export all tables from db wordpress.
On Mon, Apr 19, 2010 at 8:57 AM, Prabhat Kumar wrote:
> use can use mysqldump with option *-no-data*
> eg.
use can use mysqldump with option *-no-data*
eg.
*mysqldump -u user -ppassword wordpress user --no-data > Dumpdata.txt *
where wordpress is my database and user is my table.
Thanks
On Sun, Apr 18, 2010 at 9:48 PM, Shawn Green wrote:
> Vikram A wrote:
>
>> Hi,
>>
>> I would like to export my t
Vikram A wrote:
Hi,
I would like to export my table structure from MYSQL from a particular db. Is there any tool for doing this?
There are several ways to get "structure" information from within MySQL:
the SHOW COLUMNS... command
the SHOW INDEXES... command
the SHOW CREATE TABLE... command
Or MySQL Connector :)
On Apr 8, 2010 10:11 AM, "Carsten Pedersen" wrote:
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is there any...
> !DSPAM:451,4bbd65f93304
2010 08:18
To: Vikram A
Cc: MY SQL Mailing list
Subject: Re: Mysql - Tables Export to Excel!
Hi Vikram,
You can use toad for mysql ( It's a free tool) to export table structure or
data.
Even you can use mysqldump also.
Krishna
On Thu, Apr 8, 2010 at 10:42 AM, Vikram A wrote:
> Hi,
>
Hi Vikram,
You can use toad for mysql ( It's a free tool) to export table structure or
data.
Even you can use mysqldump also.
Krishna
On Thu, Apr 8, 2010 at 10:42 AM, Vikram A wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular db.
> Is there any tool for d
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is there any tool for doing this?
>
> Please guide me.
>
> Thank you
>
> VIKRAM A
>
>
>
>
Hi,
I would like to export my table structure from MYSQL from a particular db. Is
there any tool for doing this?
Please guide me.
Thank you
VIKRAM A
> -Original Message-
> From: ishaq gbola [mailto:ishaq...@yahoo.co.uk]
> Sent: Tuesday, January 05, 2010 7:18 AM
> To: mysql@lists.mysql.com
> Subject: Exporting the result of a Query into excel
>
> Hi all,
>
> I would like to know if there is a tool or c
ere.
On Tue, Jan 5, 2010 at 1:50 PM, Carsten Pedersen wrote:
> Is there any particular reason not to use the MySQL ODBC driver to import
> the data directly into Excel?
>
> / Carsten
>
> Jim Lyons skrev:
>
> A command to convert the table mytab in database mydb int
Carsten:
Can you demonstrate this?
~Lawrence
Carsten Pedersen wrote:
Is there any particular reason not to use the MySQL ODBC driver to
import the data directly into Excel?
/ Carsten
Jim Lyons skrev:
A command to convert the table mytab in database mydb into a
tab-delimited
file
Is there any particular reason not to use the MySQL ODBC driver to
import the data directly into Excel?
/ Carsten
Jim Lyons skrev:
A command to convert the table mytab in database mydb into a tab-delimited
file mytab.txt might be:
mysql -e'select * from mydb.mytab' -sss > m
viced me not to use a msqlclient for it, that it could break the database???
>
> --- On Tue, 5/1/10, sureshkumar...@gmail.com wrote:
>
> From: sureshkumar...@gmail.com
> Subject: Re: Exporting the result of a Query into excel
> To: "ishaq gbola" , mysql@lists.mysql.com
> Da
: Jay Ess
> Subject: Re: Exporting the result of a Query into excel
> To: "mysql@lists.mysql.com >> Mysql"
> Date: Tuesday, 5 January, 2010, 13:22
>
> ishaq gbola wrote:
> > Hi all,
> >
> > I would like to know if there is a tool or command in myS
We have to use outfile with select stmt, not with show.
Suresh Kuna
Sent from BlackBerry® on Airtel
-Original Message-
From: ishaq gbola
Date: Tue, 5 Jan 2010 13:45:44
To:
Subject: Re: Exporting the result of a Query into excel
As test i tried this and I got the result below
mysql
Ok. In windows, Use winscp tool, connect to the server and copy the file to
local machine and import it in excel.
Thanks
Suresh Kuna
Sent from BlackBerry® on Airtel
-Original Message-
From: ishaq gbola
Date: Tue, 5 Jan 2010 13:42:20
To:
Subject: Re: Exporting the result of a Query
r
'into outfile "trial.txt"' at line 1
mysql>
--- On Tue, 5/1/10, Jay Ess wrote:
From: Jay Ess
Subject: Re: Exporting the result of a Query into excel
To:
Cc: mysql@lists.mysql.com
Date: Tuesday, 5 January, 2010, 13:35
ishaq gbola wrote:
> Thanks a lot for that,
: sureshkumar...@gmail.com
Subject: Re: Exporting the result of a Query into excel
To: "ishaq gbola" , mysql@lists.mysql.com
Date: Tuesday, 5 January, 2010, 13:37
Hi
What is the OS you are using on the remote and local server.
Is there a mysql client on local server?
Thanks
Suresh Kuna
Hi
What is the OS you are using on the remote and local server.
Is there a mysql client on local server?
Thanks
Suresh Kuna
Sent from BlackBerry® on Airtel
-Original Message-
From: ishaq gbola
Date: Tue, 5 Jan 2010 13:31:59
To:
Subject: Re: Exporting the result of a Query into excel
ishaq gbola wrote:
Thanks a lot for that, but where does this file get saved in and how can i copy
it to my local host if the database is on a remote server
If you don't specify the absolute location it can be find in
"DATADIR/DatabaseName/". And after you located the file you have a
multit
Thanks a lot for that, but where does this file get saved in and how can i copy
it to my local host if the database is on a remote server
--- On Tue, 5/1/10, Jay Ess wrote:
From: Jay Ess
Subject: Re: Exporting the result of a Query into excel
To: "mysql@lists.mysql.com >> M
You can use the --xml option to the mysql command to get xnl output. You
can also get a tab-delimited output file that can be read into Excel (this
is what I usually do).
To get a tab-delimited file, you can use the --tab option of mysqldump or
start up the mysql program with the -sss option and
ishaq gbola wrote:
Hi all,
I would like to know if there is a tool or command in mySQL that allows one to
export the result of query into excel formart
select * from table into outfile "thefile.txt";
That can be imported into excel using CSV and using "TAB"
Hi all,
I would like to know if there is a tool or command in mySQL that allows one to
export the result of query into excel formart
Save the excel file as a CSV text file, then use LOAD DATA INFILE
command to import. See the mysql manual for usage and example.
On May 8, 2008, at 4:49 AM, Lord Gustavo Miguel Angel wrote:
Hi!
How i do for transfer data from excel file to mysql?
Some example?
Thanks
--
MySQL General
Hi!
How i do for transfer data from excel file to mysql?
Some example?
Thanks
Hi, sam
You can try to export table to file from Excel in CSV format.
And then import data from this file to mysql.
Something like this should help you:
LOAD DATA INFILE 'yourtabledata.txt' INTO TABLE yourtable FIELDS
TERMINATED BY ',' ENCLOSED BY '"' LINES T
I have created table in mysql with 12 fields
Field1Field2 Field3 Field4
Field12
I have an excel sheet with 12 columns and 150 rows.
My question is how can I import all of the columns from the excel sheet to my
table without losing any information
Always being the last to input, there are lots of other
database tools out there that let you do this.
One in particular is DBTools Professional (which is what I use). You can ADO
IMPORT Excel, MS-Access, and others like FoxPro and PostgreSQL.
Another is Database Workbench
al Message-
> From: Roberto William Aranda-W Roman [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 18, 2006 8:37 AM
> To: MySQL List
> Subject: excel and Mysql?!
>
>
> hello .
>
> anybody knows how to export from excel to mysql in order to
> create or fill a da
needed. Position yourself at cell A1.
2. Using Excel functions, build an entry like
=CONCATENATE("INSERT INTO mytable SET col1 = ",'Sheet1'!A1,", col2 =
",'Sheet1'!A2, ...)
You can use Excel's click to build the cell links to the othe
If you have the Max Binaries of MySQL, do the following:
1) Export Excel Data to a CSV file (mydata.csv)
2) Goto MySQL and create table, without indexes to
accept the data (CREATE TABLE myImportCSV)
3) Change the table layout to accept CSV
i.e., ALTER TABLE myImport ENGINE = CSV;
Please note that
Sure, it's usually fairly straightforward to transfer data. You can
export to a CSV or other delimited file, then use MySQL's LOAD DATA
INFILE command to read it in. See
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
I haven't ever tried creating tables from som
hello .
anybody knows how to export from excel to mysql in order to create or fill a
database table??
tanks for your help and patience
cheers
C.R.Vegelin wrote:
Thanks JR, Shawn, Scott, ... for your replies.
I choose to make use of the SELECT ... INTO OUTFILE.
This works fine, but I also want a header-line in the CSV file.
So I made the following statement:
SELECT `ID`, `Code`, `Name`
UNION
SELECT `ID`, `Code`, `Name` INTO OUTFILE 'D:
a real header-line ?
TIA, Cor
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Saturday, December 10, 2005 5:17 PM
Subject: RE: from MySQL to MS Excel ...
There is at least one other option that JR didn't mention... at least some
versions o
There is at least one other option that JR didn't mention... at least some
versions of Excel have the menu option Data->Get External Data which
allows you to link through ODBC to run queries directly from within Excel.
I have barely used it and I have never tried it with MySQL so
Here's the skinny -- YES and NO.
NO in that it won't export directly, YES in that you have to do a little leg
work in order for it to be done.
You have 3 options -- ODBC, Code and CSV.
ODBC -- Excel has the ability to use ODBC connections to the MySQL database.
Run your MySQL quer
numbers with me, after scrubbing
against the dnc registry, i get back results for 3000 numbers which means 1000
numbers have to be deleted from the list of 4000, how do i do this, can i get
this done in excel.,
pls help.
regards
Parker
--
Sent from the MySQL - General forum at Nabble.com:
http
this may help you
test> create table d (
-> date date );
Query OK, 0 rows affected (0.45 sec)
test> insert into d values(now());
Query OK, 1 row affected (0.12 sec)
test> select * from d;
++
| date |
++
| 2005-09-10 |
++
1 row in set (0.00 sec)
O
i want to put a value in a column that is the date of today .
IS there a solution to do that in sql way ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks to all for your help. I solved my problem the
quick and dirty way. Here's what I did:
1. Created my Excel spreadsheet to look the way I
wanted it, saved it as an XML spreadsheet.
2. Used PHP to pull the desired data from the MySQL
server on our iSeries machine.
3. PHP writes the XML
Hi,
I had to do the same thing on a project and the problem was that if
you use CSV you will not be able to make a formated excel document.
I am using now *Spreadsheet_Excel_Writer
(
*http://pear.php.net/package/Spreadsheet_Excel_Writer ) and it does
everything I need, including
et me know.
If rs.State = adStateOpen Then rs.Close
On Error Goto 0
cn.Close
Set rs = Nothing
Set cn = nothing
<--End Code-->>
HTH,
Arjan.
-Original Message-
From: Nick Jones [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 01, 2005 08:23 PM
To: mysql@lists.mysql.com
Subjec
e are
> those
> >>on this list that know
> >>much more than I.
> >>
> >>I do know that you can export the values into tab
> >>delimited format and then
> >>import it into Excel.
> >>
> >>I think that you may want to do thi
e PHP strings to add ContentType (or similar call) =
"application/vnd.ms-excel"
3) (optional) Write PHP echo strings for adding XML tags. (You can find
these at http://msdn.microsoft.com, although I'll be damned if I can find
them now. Ask for them and I will get them from my other comp
Nick Jones wrote:
--- "J.R. Bullington" <[EMAIL PROTECTED]> wrote:
Automatically populate??
Not that _I_ know of, but of course there are those
on this list that know
much more than I.
I do know that you can export the values into tab
delimited format and then
import i
now
> > much more than I.
> >
> > I do know that you can export the values into tab
> > delimited format and then
> > import it into Excel.
> >
> > I think that you may want to do this via ASP or PHP.
> > It would make life a
> > lot easier.
>
--- "J.R. Bullington" <[EMAIL PROTECTED]> wrote:
> Automatically populate??
>
> Not that _I_ know of, but of course there are those
> on this list that know
> much more than I.
>
> I do know that you can export the values into tab
> delimited format
Nick Jones wrote:
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do
Automatically populate??
Not that _I_ know of, but of course there are those on this list that know
much more than I.
I do know that you can export the values into tab delimited format and then
import it into Excel.
I think that you may want to do this via ASP or PHP. It would make life a
lot
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do You Yahoo!?
Tired of
No, I don't have Windows.
I need some one to load my tables, export to excel and email me the
excel docs.
On Jun 7, 2005, at 11:54 PM, [EMAIL PROTECTED] wrote:
if you want to use excel i suppose you have also windows with more
than 3 GO
free disk.
install win32 mysql
put the files i
if you want to use excel i suppose you have also windows with more than 3 GO
free disk.
install win32 mysql
put the files in the data directory of one existing database
connect and use that database
export data to an outfile by :
select * from yourtable into outfile csv fields terminated by
I recently received some old database files from my ISP. I'm trying to
convert the documents to excel format. When I try to load the .frm,
.MYI and .MYD files on my OS X MySQL databases I get the following
error.
#5 - Out of memory (Needed 3024898224 bytes)
Unfortunately I can't
[snip]
Don't be so hasty to criticise. I took the original question to mean
"While I have an existing spreadsheet open in EXCEL, can I cause a
selected
row in a MySQL table to be updated?". This is quite a different
question
than "How can I convert one sheet from an E
Thank you for your reply. Can you provide more details on how to write
to a MySQL table from Excel? I am a newbie to MySQL. Thanks.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Friday, April 22, 2005 3:00 PM
To: Huang, Ou; mysql@lists.mysql.com
Subject: RE
Oh well, I am just not smart as you are. Sorry, I am a new comer in the
Geek's world.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Friday, April 22, 2005 3:12 PM
To: Huang, Ou; mysql@lists.mysql.com
Subject: RE: Write to a mysql table from Excel
[snip]
Get a beginners book then rather than posting messages.
-Original Message-
From: Huang, Ou [mailto:[EMAIL PROTECTED]
Sent: Friday, April 22, 2005 5:17 PM
To: Jay Blanchard; mysql@lists.mysql.com
Subject: RE: Write to a mysql table from Excel
Oh well, I am just not smart as you are
[snip]
Thank you for your reply. Can you provide more details on how to write
to a MySQL table from Excel? I am a newbie to MySQL. Thanks.
[/snip]
You must be new to mailing lists too...
http://catb.org/~esr/faqs/smart-questions.html
You can save the excel as a CSV file and import that into
At 03:12 PM 4/22/05, Jay Blanchard wrote:
[snip]
Thank you for your reply. Can you provide more details on how to write
to a MySQL table from Excel? I am a newbie to MySQL. Thanks.
[/snip]
You must be new to mailing lists too...
http://catb.org/~esr/faqs/smart-questions.html
You can save the excel
[snip]
Is it possible to write to a MySQL table from Excel?
[/snip]
Sure.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
One problem I've encountered in the past creating CSV files from Excel is with
fields that exceed 256 or 258 characters. The fields end up truncated in the
CSV file. A script to directly access the data in Excel and move it to MySQL is
appropriate, but can be a lot of work if you only ne
Is it possible to write to a MySQL table from Excel?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fargo Services
-Original Message-
From: Huang, Ou [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 1:33 PM
To: mysql@lists.mysql.com
Subject: Error when importing mysql table into excel via ODBC
Hello,
I have a mysql ODBC driver 3.51.11.00 installed on a xp machine in order
to
Hello,
I have a mysql ODBC driver 3.51.11.00 installed on a xp machine in order
to connect to mysql server (on unix) remotely via the ODBC driver. The
ODBC driver was working well. What I am trying to do is to import one of
the mysql table into excel through New Database Query option in Excel
Hi Dan,
Sorry for causing additional work to getting the test setup, I will take
your advice should I need to post these type of details again
With regards to your solution, it works perfectly!!! Great thanks for
putting the time and effort in to help sort this problem. Much appreciated.
I
Dan Wareham wrote:
Hey Dan,
Thanks for the post and the code ideas. Unfortuantely I still can't
get the thing to work even when trying the CONCAT and CAST functions.
As per your request, here is the details of what I have got so far:
I'm running MySQL 4.1.9 with MyODBC 3.51. The table in question
Hey Dan,
Thanks for the post and the code ideas. Unfortuantely I still can't get the
thing to work even when trying the CONCAT and CAST functions.
As per your request, here is the details of what I have got so far:
I'm running MySQL 4.1.9 with MyODBC 3.51. The table in question is the Users
tabl
Dan Wareham wrote:
Hello,
I have a table in my database with two fields set as Time types.
The issue I seem to have is when I use an ADO connection in VBA for
Excel to select the two fields.
Instead of the expected format HH:MM:SS held within my recordset, I
get the current date in the format
Hello,
I have a table in my database with two fields set as Time types.
The issue I seem to have is when I use an ADO connection in VBA for Excel to
select the two fields.
Instead of the expected format HH:MM:SS held within my recordset, I get the
current date in the format DD/MM/. Then
I forgot one element
LOAD DATA LOCAL INFILE 'a.csv' INTO TABLE Users
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(id,firstName,lastName);
Brad ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Steve Grosz <[EMAIL PROTECTED]> writes:
>Can anyone tell me a good way to import individual column data into a
>table? Is there a tool to assist with this?
If your data is a .csv file [a.csv] similar to:
1,"Steve","Grosz"
2,"Brad","Eacker"
C
PM
To: mysql@lists.mysql.com
Subject: Import Excel data into table
Can anyone tell me a good way to import individual column data into a
table? Is there a tool to assist with this?
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
NaviCat
Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183
-Original Message-
From: Steve Grosz [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 13, 2005 2:56 PM
To: mysql@lists.mysql.com
Subject: Import Excel data into
Can anyone tell me a good way to import individual column data into a
table? Is there a tool to assist with this?
Thanks,
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;s First ISP
there are just two issues that I would look at if his solution
- Original Message -
From: "Ian Sales" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Patrick Sherrill" <[EMAIL PROTECTED]>
Sent: Thursday, December 09, 200
David Ziggy Lubowa wrote:
On Thursday 09 December 2004 14:33, David Ziggy Lubowa wrote:
On Wednesday 08 December 2004 05:07, Patrick Sherrill wrote:
David,
Please provide the complete LOAD DATA INFILE command you used.
mysql -e "LOAD DATA INFILE '/home/dlubowa/clients.csv' INTO TABLE
ed to all the columns of the table. What could i
> be doing wrong here.
>
>
>
> cheers
>
> > thats what i did ...
> >
> > > Pat...
> > >
> > > [EMAIL PROTECTED]
> > > CocoNet Corporation
> > > SW Florida's Fir
EMAIL PROTECTED]
> > CocoNet Corporation
> > SW Florida's First ISP
> >
> >
> > - Original Message -
> > From: "David Ziggy Lubowa" <[EMAIL PROTECTED]>
> > To: "Eric Bergen" <[EMAIL PROTECTED]>
> > Cc: <[EMAIL
1 - 100 of 220 matches
Mail list logo
