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 TERMINATED BY '\r\n';
sam rumaizan
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.
In the category of terrible, horrible, no good, very bad (but at least
documented) software behavior, I bumped into this today:
http://bugs.mysql.com/bug.php?id=14770
where the LOAD DATA INFILE command does not respect the default value of a
column if no value is supplied in the file. Instead, it
I found SQLyog Enterprise (www.webyog.com) to be the
best when importing data from ODBC to MySQL.
Karam
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
> Using a data modelling tool (like Dezign from
> Datanamic) or a scripting
> tool (like DbScripter), all you need do, I think
script.
PB
Paun wrote:
I use MySQL-Front 2.5 (freeware) for importing data from MSAccess databaase
in MySQL 4.1.7.
Of course, there is no possibility to import "foreign keys" from MSAccess.
Question: If I read properly documentation in MYSql is possible to use only
one "foreing key&
: mysql@lists.mysql.com
Subject: Importing data from MS Access
I use MySQL-Front 2.5 (freeware) for importing data from MSAccess databaase
in MySQL 4.1.7.
Of course, there is no possibility to import "foreign keys" from MSAccess.
Question: If I read properly documentation in MYSql i
I use MySQL-Front 2.5 (freeware) for importing data from MSAccess databaase
in MySQL 4.1.7.
Of course, there is no possibility to import "foreign keys" from MSAccess.
Question: If I read properly documentation in MYSql is possible to use only
one "foreing key" per ta
One reason may be due to your ON condition.
ON table2.ID=table2.ID_table1
You reference table 2 twice and I doubt that on the table2 table id equals
id_table1 very often. Because table2 is LEFT JOINed to table1, you will
only be able to update the rows that match your ON condition. Again, that
OK, now I really feel stupid. It helps to change the ownership of the
files to mysql:mysqlduh.
Curtis
Curtis Maurand wrote:
I didn't, but I'll give it a shot and see what happens.
Curtis
Michael J. Pawlowsky wrote:
Curtis Maurand wrote:
If I create one of the databases and then put the files
I didn't, but I'll give it a shot and see what happens.
Curtis
Michael J. Pawlowsky wrote:
Curtis Maurand wrote:
If I create one of the databases and then put the files for that
database from the old installation in place of the newly created
ones, the database is recognized, but i get errors say
Hi,
An SQL-statement that is conceptually equal to the following caused some
astonishment.
UPDATE table1
LEFT JOIN table2 ON table2.ID=table2.ID_table1
SET table2.value=table2.value-IF(table1.condition=7,1,0),
table1.condition=8
WHERE table1.ID=$id
My problem is the IF condition, which alway e
Curtis Maurand wrote:
If I create one of the databases and then put the files for that
database from the old installation in place of the newly created ones,
the database is recognized, but i get errors saying that the columns in
the tables are not recognized.
I'd really like to get this data ba
Hi,
I have done an incredibly stupid thing. I have a server that suffered
a bit of a failure. It wasn't a hard failure, but it was enough of one
to have to rebuild the server from scratch. I was and am running mysql
4.0.22 on Gentoo with a 2.6 kernel. It rocks. However, The dumb thing
th
quot;value3","value4"
change it to this: (on each line, search replace maybe?)
"","value1","value2","value3","value4",\n
phpninja
-Original Message-
From: Leonardo Javier Belén [mailto:[EMAIL PROTECTED]
Sent: Thursday
Hi all,
I am experiencing a fairly bizarre problem: in MySQL 4.1.7 (Windoze
version), when importing data from a file with semicolon-separated data, I
get random default values for the datetime fields. This turns the data
obviosly unusable.
The same import on the same machine but with the
t;
To: <[EMAIL PROTECTED]>
Sent: Monday, October 25, 2004 1:59 PM
Subject: Importing data from a file
> Hello,
>
> I am new in mysql and I woul like to ask what is the best way to import
> data from a file.
>
> Cheers,
>
> Manuel
>
> --
> MySQL Gener
e a program. But,
mysqlimport is the easiest way. If you're on a UNIX machine, run 'man
mysqlimport' for more information.
Good luck,
Brian
-Original Message-
From: Manuel J. Contreras Maya [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 10:00 AM
To: [EMAIL PROTECT
Brian
-Original Message-
From: Manuel J. Contreras Maya [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 10:00 AM
To: [EMAIL PROTECTED]
Subject: Importing data from a file
Hello,
I am new in mysql and I woul like to ask what is the best way to import
data from a file.
Cheers,
Man
Hello,
I am new in mysql and I woul like to ask what is the best way to import
data from a file.
Cheers,
Manuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In article <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> writes:
> Thanks, it is working for the mentioned format.
> Is there any method for importing directly the spooled file from oracle without
> changing the file format into the required format like using tab and newline.
I don't know Oracle,
[mailto:[EMAIL PROTECTED]
Sent: Thu 9/30/2004 2:01 AM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SOLUTIONS)
Cc: [EMAIL PROTECTED]
Subject: Re: importing data into mysql from oracle using a text file
Hi,
I did imported your data im
Hi,
I did imported your data im my server but I had to do some changes to sample.txt.
I have replaced in a text editor "\t" with empty string. is a real tab
while \t is just a text. Additional change was to replace "\n" (which is text but not
newline with empty string). The I did the following (b
Title: Re: importing data into mysql from oracle using a text file
The sample lines are like this in
alarm.txt
ARRIVED DETECTED
NAME
TYPE ALARMLEVEL V DISCLOSED CATEGORY_NUM
EVENTID
Can you post one or 2 sample lines from alarm.txt ?
Regards,
Andrey
P.S.
(i am not on [EMAIL PROTECTED] so add me to the CC:)
[EMAIL PROTECTED] wrote:
Hi,
I tried with the spool option to get the data from the tables in the oracle.
For this go to pl/sql editor, go to file menu, select
Title: Message
Hi,
I tried with the spool option to get
the data from the tables in the oracle.
For this go to pl/sql editor, go to file menu, select spool, asks for a
file name give the file name you want, later type the select command from
which you want t
Hi,
Could any one of you suggest me a better way to bump the data in oracle 7.3 to
mysql 4.0 classic.
Thanks,
Narasimha
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tue 9/28/2004 8:58 PM
To: martin fasani
C
Dear friends,
I import data to my table,from CSV file.CSV file has emails in each row.
While importing, A window pops up stating number of rows imported, however when I
see the table, nothing has been imported.
Version of mysql, gui and structure of table has been pasted.
Any guidance with rega
After a day of looking, I answered my own questions, and I'll post those
answers here in case anyone else was interested in the answer.
First, "LOAD DATA" + "ALTER TABLE ADD INDEX"... seems to be slower than
a "mysqldump" + "ANALYZE TABLE". Of course, you don't always have a
mysql dump file.
A
We have a somewhat large database, with a snapshot of the data that we
import into the database. Normally, we create a database, create the
tables, import the data with "LOAD DATA", add the indexes, and then the
foreign keys (we are using InnoDB, 4.0.18). We call this the
load-data-method.
Som
This is just my experience.
But if you are doing this sort of work, it may well pay to construct
your own import program. There are many ways of doing this, like
parsing an email message, or using a XML/SOAP server. This will
probably pay on the long run, as you can introduce filters, data che
Hello..
Im a new sql user so if this is a common prob
Please be kind
Im trying to set up mysql 4.0.13
With a database that contains 60k records…
The client wants to import 6 records a week
With near 4mill records in a database…
My problem is I don’t want to give ssh access to
The machine…
In a bit of a quandary here...
I have a user table and a registered serials table
Table data at end of email...
I have been given a large set of new data, but it is flat file, basically,
it looks just like the user table, with the addition of one field called
serial.
Somehow, I need to take the
In a bit of a quandary here...
I have a user table and a registered serials table
Table data at end of email...
I have been given a large set of new data, but it is flat file, basically,
it looks just like the user table, with the addition of one field called
serial.
Somehow, I need to take the
t the (non)
value NULL.
See
"Using AUTO_INCREMENT"
<http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html> and
"CREATE TABLE Syntax",
<http://www.mysql.com/doc/en/CREATE_TABLE.html>
and "mysqlimport, Importing Data from Text Files"
<http://www.my
Sorry in advance for the dumb newbie question but . . . I'm using a
content management system and want to avoid the hassle of entering data
by hand when I've already got it in a delimited text file. I get the
basic concept of using mysqlimport. However, the source file's data
doesn't match the ta
[snip]
How can i import table structure and data which is there in a text file
to database say test_database using phpmyadmin. I m asking using
phpMyadmin as i don have shell access and hence can't use mysql
commands.
[/snip]
What format is the table structure in?
As for the data it should be fai
Hi all,
How can i import table structure and data which is there in a text file to database
say test_database using phpmyadmin. I m asking using phpMyadmin as i don have shell
access and hence can't use mysql commands.
Plz help me ... its very urgent ..
Thanks in advance
Binay
* Trevor
> after a bit of help on how to import data from a pastel
> accounting database into mysql, i also need to remove some lines
> out of the pastel txt file before importing into mysql
You are defining your new problem to be something to be sorted out before
mysql is involved, in which case
Hi All
after a bit of help on how to import data from a pastel accounting database into
mysql, i also need to remove some lines out of the pastel txt file before importing
into mysql
eg 1
"*PC\CC-ABS533 ","COMPUCON Abacus Celeron/Pentium PC
",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""
has to end up
I have data that is in a progress database. I need to get
a copy of the data into my mysql database. What would
be the best approach ? I can dump the data in any specific
format, so.
Never tried ODBC with Progress (8.2C12), so don't know if
that can/will work.
thanks,
Darryl
--
MySQL Ge
Sorry hit the wrong reply button ;-)
> Hi Rajendra,
>
> In case you are new to mysql the easiest way would be to do it on the
> command line base :
>
> 1) shutdown the server
> 2) go to your data directory f.e /var/lib/mysql/dbname1
> 3) copy the table files to the folder of dbname2
>
> f.e c
Hello Sir,
thanks for the reply. i have one more doubt.
i want to import 2 tables from one database to
another database like the tables structure and as well
as its records.
have a nice day,
Naren.
--- Egor Egorov <[EMAIL PROTECTED]> wrote: >
Rajendra Kumar <[EMAIL PROTECTED]> wrote:
> >
Rajendra Kumar <[EMAIL PROTECTED]> wrote:
>
> i know little bit about mysql. i use mysql to use
> the webportal system of phpnuke. can anyone help me
> to import data in mysql. for exams i have a file
> nuke.sql which contains like tables design and there
> records.
>
> how to call this file w
Hello List, i am new to mysql. i use php-nuke web portal. i have a database.sql file
which contains my database. it contains tables & there records in .sql file which can
be opened with notepad. if i do a fresh installation of mysql how do i recover my
database using my backup file. i mean how
Hello List,
i know little bit about mysql. i use mysql to use
the webportal system of phpnuke. can anyone help me
to import data in mysql. for exams i have a file
nuke.sql which contains like tables design and there
records.
how to call this file when i am having sql prompt. i
use redhat lin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 27 May 2003 11:17:34 +0200, Emiliano Rustighini wrote:
>I can ask for the data in any data format, but I would like to get some
>advice on what is best to ask for.
>
I have found text format to be the most flexible method for transferring be
> Hi all,
Hi,
> I have a database in Pervasive and I want to import it to MySQL.
> I tried to convert the Pervasive data to a text file and then import it
> into MySQL but it failed.
> Is there any tool to do this directly?
> Does MySQLCC provide any export option through which I can get the dat
Hi all,
I have a database in Pervasive and I want to import it to MySQL.
I tried to convert the Pervasive data to a text file and then import it
into MySQL but it failed.
Is there any tool to do this directly?
Does MySQLCC provide any export option through which I can get the data
from Pervasive?
try this:
1. export the data from ms access to a file on
the windows box.
2. fire up ftp from the command line and set it
to ascii mode.
3. ftp the file from the windows box to the
linux box.
if the eol is the problem, the ftp protocol will
insure that the eol is correctly translated wh
-
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Wednesday, November 06, 2002 1:02 PM
To: Schroeder, Bradley (Contractor); 'Black, Kelly W [PCS]';
[EMAIL PROTECTED]
Subject: Re: Problem importing data from Access
Hi,
You must use a HEX editor to see this characters which are not printa
uot; <[EMAIL PROTECTED]>; "'Gelu
Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 9:41 PM
Subject: RE: Problem importing data from Access
> The text
[EMAIL PROTECTED]
- Original Message -
From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]>
To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
-Original Message-
From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com]
Sent: Wednesday, November 06, 2002 12:34 PM
To: 'Gelu Gogancea'; Schroeder, Bradley (Contractor);
[EMAIL PROTECTED]
Subject: RE: Problem importing data from Access
This is incorrect.
!google &
This is incorrect.
!google "new line character" linux windows
-Original Message-
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Wednesday, November 06, 2002 11:33 AM
To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor);
[EMAIL PROTECTED]
Subject: Re: Problem importing
PROTECTED]
- Original Message -
From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]>
To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 20
r 06, 2002 10:54 AM
To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED]
Subject: Re: Problem importing data from Access
Hi,
Are you sure that .txt file is OK?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
adley (Contractor)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 7:06 PM
Subject: Problem importing data from Access
> When I import data from the text file I exported out of Access it works
> correctly except that MySql seems to append and/or pr
When I import data from the text file I exported out of Access it works
correctly except that MySql seems to append and/or prepend some sort of
mystery character to the fields it imports. So, I can get the data into the
database, but I can't get it out (since the SQL statement can't match the
myst
Reformat your import file.
or
Add two columns , import, and drop the two columns.
or
Import to a six column temporary file and do an
insert into select from.
tl wrote:
>Hello,
>
>#If I have a file "t.txt"
>
>
>111 222 333 ddd 444 ddd
>111 222 333 ddd 444 ddd
>111 222 333 ddd 444 ddd
><<
>
Hello,
#If I have a file "t.txt"
>>
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
<<
# A table
>>
CREATE TABLE userdata (
a1 varchar(128) NOT NULL default '',
a2 varchar(128) NOT NULL default '',
a3 varchar(128) NOT NULL default '',
a4 varchar(128) NOT NULL default '',
tp://www.mobilink.com |
mailto:[EMAIL PROTECTED]| |
| 2 | 01 | Sandra | Bridget | 12th Aveneue No. 301 | 12548 |
Broklyn| (212)780101 10 | |
mailto:[EMAIL PROTECTED] | |
+---+--++-+--+---+--
On Thursday, Oct 10, 2002, at 02:26 America/Phoenix, Nasir Aziz Gill
wrote:
> Hi fellows,
>
> I got one text file of 9816 records (9816 lines) seprated by commas and
> enclosed by the inverted quotes and seprated by the end of lines. But
> when I
> import the file, it only gets half of recor
PROTECTED]
Subject: Urgent Help! Importing Data from Text File...
Importance: High
Hi fellows,
I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted quotes and seprated by the end of lines. But when I
import the file, it only gets half of records in the
Hi fellows,
I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted quotes and seprated by the end of lines. But when I
import the file, it only gets half of records in the table using below
mentioned command;
LOAD DATA INFILE 'user.txt' INTO TABLE userda
Hi guys,
I want to migrate data from SQL Server 2000 to Mysql.I have two
problems. First is easy one,
First problem is to migrate big fields which had type varchar(7900) or
so I tried using Text datatype of mysql, is that the right one or I
should have used BLOB. That field doesnt contain any i
Hi guys,
I want to migrate data from SQL Server 2000 to Mysql.
My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command
LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABL
Hi,
I want to migrate data from SQL Server 2000 to Mysql.
My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command
LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABLE
mai
Hi,
I am having two servers running Oracle and MySQL
database.
Views has been created for me in Oracle and I want to
import data from that Oracle table to my MySQL table.
I want a script like something main thing is I
want to import data from that Oracle database to MySQL
daily...like a sch
ble/writable by whomever the mysqld is
running as.
Harrison
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 04, 2002 1:41 PM
Subject: Newbee: importing data from .MYD .MYI .frm
> Hi all,
>
> A colleague has created a data
Hi all,
A colleague has created a database with MySQL. She has provided me three files
with the extensions .MYD .MYI .frm, to put them in the server. How can I
import
them into MySQL? I have MySQL 3.23.49 in Debian Linux 'potato'. I have used
myisamchk to check the database, but I do no
I am in the process of migrating our data from m$ SQL Server to MySQL. I
am having a heck of a time trying to figure out how to deal with m$ SQL
Server's data type called 'uniqueidentifier'. I have tried very large
varchar's and blob's and even longtext but I always get datatype
conversion errors
lin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: "Bing Du" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 9:03 PM
Subject: Re: importing data
> Please see section 6.17 of http://www.mysql.com/doc/index
essage -
From: "Kevin Fonner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 5:08 PM
Subject: importing data
> Is there an easy way or perhaps a utility to import a tab delimeted
text
> file of data into a mysql table
Please see section 6.17 of http://www.mysql.com/doc/index.html.
Bing
Bing Du <[EMAIL PROTECTED], 979-845-9577>
Texas A&M University, CIS, Operating Systems, Unix
>>> Kevin Fonner <[EMAIL PROTECTED]> 08/07/01 10:08AM >>>
Is there an easy way or perhaps a utility to import a tab delimeted
text
f
http://www.mysql.com/doc/L/O/LOAD_DATA.html
http://www.mysql.com/doc/m/y/mysqlimport.html
http://www.mysql.com/doc/L/o/Loading_tables.html
On Tue, 7 Aug 2001, Kevin Fonner wrote:
> Is there an easy way or perhaps a utility to import a tab delimeted text
> file of data into a mysql table
>
> T
; To: [EMAIL PROTECTED]
> Subject: importing data
>
>
> Is there an easy way or perhaps a utility to import a tab delimeted text
> file of data into a mysql table
>
> Thanks,
>
> --
> Kevin Fonner
>
>
>
> --
Is there an easy way or perhaps a utility to import a tab delimeted text
file of data into a mysql table
Thanks,
--
Kevin Fonner
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
I have a little problem. I'm trying to convert a fairly large database
from msql (v1.0.16) to MySQL. Using msqldump worked fine on the smaller
databases in this project, and MySQL imported them just fine. However on
the larger ones it chokes and segfaults. This is likely because of the
rather aged
Hello,
I am trying to transfer my Microsoft SQL Server to a MySQL Server running
under Linux.
Until now I have tryied the following methods.
I installed DBtools 1.0.8 in a third machine running Win98 and connected to
the MySQL server (Linux). I tried to import data from the Microsoft SQL
serv
I'm in the process of moving SQL data from one server to another (Linux) -
The tables on the new DBase server are not identical to the old - Is there a
way to import only specified fields data from the old to the new ?
Thanks in advance,
Regards,
MB
---
I'm looking for Outlook Express API's, I want to import data from a .dbx
file (archive outlook) into a MySql table.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
> I have to import Datas From FileMaker Pro to MySQL .
>
> Unfortunately, the FileMaker web site is speaking about plugins to export
> databases, but the access page gives error 500 (!).
Plug-ins? You don't need any plug-ins to export data to MySQL. The only
plug-in for Filemaker I've ever
Hi,
I have to import Datas From FileMaker Pro to MySQL .
Unfortunately, the FileMaker web site is speaking about plugins to export databases,
but the access page gives error 500 (!).
Then, I try this mailling list, and there is my question :
is there any defined tool to import datas into M
hi there,
is there a problem with importing data into a table with an auto_increment
field with a primary key, if the data contains values for the auto_increment
field?
I keep getting an error that it can't insert the value "1" more than once.
However, all the values for the
On Thu, 4 Jan 2001, TEXLID_SUPPORT wrote:
> Could anyone please let me know how I can transfer data from excel to
> a mysql database? If it is possible. The data is stored in an excel
> file on my PC. And I want to transfer the contents (about 500 records
> with 20 fields) of this excel file to
Hi,
Could anyone please let me know how I can transfer data from excel to a mysql
database? If it is possible. The data is stored in an excel file on my PC. And I want
to transfer the contents (about 500 records with 20 fields) of this excel file to a
mysql table on a remote linux server.
I have a table in my database, witch
have a column thas is float(12,3), when
i try to make a filter width that column
i get an error message that says "Column
PRPRVEND1 can't be used in criteria".
Can someone tell me how to solve this
problem?
---
87 matches
Mail list logo
