Dear friends,
Load data infile 'abcd.txt' into table b.chicago;
This statement loads half of the data from file and gives error posted below.
Any guidance, please.
Thank you.
--
---
mysql> use b
Database changed
my
Take a look at SQLyog ( http://www.webyog.com )
Karam
--- [EMAIL PROTECTED] wrote:
> I posted this a little while ago, but it faded out
> with very few responses
> due to my not posting the necessary information, so
> I seek to rectify my err
> now.
>
> Info:
> OS: Windows XP
> PHP: 5
> Use: I
Yes, of course - I started from mysql binary and compiled the new one
only when it failed.
It was in the beginning of the thread
BTW - it compiled on Gentoo without a problem. Just
emerge mysql-4.0.20.ebuild
and it runs till the end. And works fine - but again - only on one CPU.
Mike
Donny Sim
I posted this a little while ago, but it faded out with very few responses
due to my not posting the necessary information, so I seek to rectify my err
now.
Info:
OS: Windows XP
PHP: 5
Use: I'm looking for something that can easily create and manage databases,
doing stuff like creating and edit
As mysql will tell you, have your tried to use the mysql supplied binary or
the mysql supplied rpm? I bet that will solve your problems.
One thing I learned from mysql a long time ago, don't compile yourself
unless you absolutely have too.
Donny
> -Original Message-
> From: Mike Blaze
Dear Friends,
There are 40 records of email entries in text file which I want to load to
table, however, When I enter
load data infile 'chicago.txt'into table b.chicago;
I see only 18 rows been updated with output pasted below.
Any insight what is happening and guidance, please.
mysql> load d
Thanks Pete!
I just recompiled mysql with the emerge installer with all gentoo.org
patches - same result.
Just one CPU works.
I'll report BUG to both mysql AB and Gentoo.
Thanks
Mike
Pete Harlan wrote:
> It would be nice if the manual were updated to say something about it,
> but here's the ans
Hi. Can u point me to the fixed file(s) please?
Or can u send me the diff if you have it?
http://bugs.mysql.com/bug.php?id=3933
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear friend,
I tried the IGNORE option so that data is loaded from the file to table,
still getting error pasted below. Any advice.
mysql> use b
Database changed
mysql> describe chicago
-> ;
+---+--+
In the last episode (Aug 20), Joshua Beall said:
> Is there any way in MySQL to have calculated fields? E.g., a make
> "expiration" equal to the "lastPaid" date, plus 1 year. Whenever
> lastPaid gets updated, expiration can be updated as well.
>
> Is this possible? I know it could be implemente
MySQL 4.0.20-standard, but willing to upgrade if I have to
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there any way in MySQL to have calculated fields? E.g., a make
"expiration" equal to the "lastPaid" date, plus 1 year. Whenever lastPaid
gets updated, expiration can be updated as well.
Is this possible? I know it could be implemented client side, but I am
wondering if it could be done direc
This example is from the manual:
innodb_data_file_path=ibdata1:10M:autoextend:max:500M
My question is, what happens when ibdata1 extends and
hits 500M? If that is the only data file configured, will
MySQL crash ?
thanks,
Mayuran
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
I now have multiple installations running on the same machine, and am also using
mysqld_multi. However, even though it's working, there's one thing I don't
understand. Why does the [mysqld_multi] section have to contain the pointers to
mysqld and mysqladmin? It seems to me that it should just
Scott Hamm wrote:
Ok. I'm looking into alternatives. I'm trying to figure out an alternative
to mysql exporting into xls file.
Gosh, what's wrong with CSV files? Surely Access can export a classic
CSV file format with fields separated by commas and enclosed by ""?
Then you can just use
LOAD DA
Has anyone ever encountered a problem where replication stops due to a
partially completed query on the master?
I am currently encountering this problem on my server and was wondering if I
need to resync the slave server to the master by copying all the data files
to the slave and then restarting r
Wow, so much different ideas. I noted all ideas down to experiment with. I
want to say that apologize for sounding "newbie" asking questions and all
that. I know that "no question is a stupid question", but you all have been
a big help. MyODBC sounds like more reliable answer and will try that with
Hi - I've read the threads about converting rows of data into columns,
but those threads assume the number of distinct rows is very limited
(say 7 for days of week).
Instead, I have a table like this:
iddate date type
1 ... a
1 ... b
2 a
2 d
Note that based upon this thread, I downloaded and installed MyODBC (simple
Google search), configured a DSN, created an Excel query, and loaded the DB
into the worksheet in under 5-minutes total time. While I don't use Excel
that much for anything, it was a very simple exercise and might prove han
I have installed MYSQL Administrator that will enables me to easily
administer my MySQL environment and better visibility into how my databases
is operational, but I wasn't able to find any helpful documents of how to
configure this GUI interface to connect to the server.
Any help?
Thanks,
Fran
100 quatloos to Chris for the simplest answer. Do that.
I'll add that you could also use mysqldump:
mysqldump -T /tmp test users
This would create /tmp/users.sql, containing the CREATE
TABLE, and /tmp/users.txt, containing a tab-delimited file
suitable for import. No header row, though.
And, ap
You could export the file as xml with either '--xml'
or '-X':
mysql --xml -u username -p db_name > dbfile.xml
http://dev.mysql.com/doc/mysql/en/mysql.html
HTH,
James
> - Original Message -
> From: "Scott Hamm" <[EMAIL PROTECTED]>
> To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]>
> Sent:
- Original Message -
From: "Freddie Sorensen" <[EMAIL PROTECTED]>
To: "'Rhino'" <[EMAIL PROTECTED]>; "'Scott Hamm'"
<[EMAIL PROTECTED]>; "''Mysql ' (E-mail)'" <[EMAIL PROTECTED]>
Sent: Friday, August 20, 2004 2:28 PM
Subject: AW: Brainstorming' time!
Rhino
| Get the free DBTools DBMana
Looks like I will need more than just MySQL and Php/ASP.net. I might even
look into perl. What else should I be using? (IIS is provided for) I'm
willing to learn new tricks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
Rhino
Get the free DBTools DBManager Pro from
http://www.dbtools.com.br/EN/dbmanagerpro.php - there is a cool CSV export
function there
Or get MyODBC and connect from Excel to your MySQL database
Or as Scott said, roll your own exporter if you have programming skills
Freddie
> -Ursprüngli
Ok unless I missed something here, wouldn't you just use the "SELECT ...
INTO OUTFILE" Syntax found here
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Just search for "outfile" and you can find it faster.
You can run a query against a table and save the output into a file and
in the case of cr
Use the -p option so that the server can prompt you for the password you
just created.
mysql -uroot -p
-Original Message-
From: Francois A. Atallah
To: [EMAIL PROTECTED]
Sent: 8/20/04 12:59 PM
Subject: Login problem
After Installed mysql on Windows I have entered a root password using
th
After Installed mysql on Windows I have entered a root password using the
command below
mysql> UPDATE mysql.user SET Password = PASSWORD('test')
-> WHERE User = 'root';
After saves had been made I get the erros below ? Any help
C:\>c:\mysql\bin\mysql -u root
ERROR 1045: Access denied for
Francois,
You didn't reply to the list, just to me. If you reply to the list, more
people will be able to help you. I'm quite new myself.
You need to set up user accounts. Download an admin program such as
MySQL Control Center. Maybe there are better ones, but that's what I
use. You can do a lo
- Original Message -
From: "Ramya Rajasekar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 17, 2004 10:20 PM
Subject: FW: P
Hi all,
I'm running a small mail archive and have a little problem with the
fulltext search performance.
I really appreciate any tips/design suggestions (even if it dont have to
do with the search problem ;) ).
Database schema:
mysql> describe msg_header;
+-+--+--+-+-
> May someone please send me the link to download mysql Binary distribution
> for the first time on windows XP, I have looked into mysql/downloads and
> they only have X86.
Windows XP, and every other windows platform, runs on X86 architecture.
That is the download you want.
Jeff
--
My
Use Perl:
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.04/lib/Spreadsheet/WriteExcel.pm
use strict;
use warnings;
use DBI;
use Spreadsheet::WriteExcel;
my ($user, $pass, $db, $table) = ('foo', 'bar', 'test', 'users');
my $dbh = DBI->connect("DBI:mysql:database=$db", $user, $pass);
May someone please send me the link to download mysql Binary distribution
for the first time on windows XP, I have looked into mysql/downloads and
they only have X86.
Thanks,
Francois A
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, August 20, 2004 12:02 PM
Subject: Brainstorming' time!
> Ok. I'm looking into alternatives. I'm trying to figure out an alternative
> to mysql exporting into xls file. I
Monet wrote:
I thought about this method before. But since there
are 6 sets of rows I want to update in one table and
they are common at some level, I am wondering whether
there is more efficient way to do it.
Thanks,
From what you've told us, I don't think so.
By "common at some level," do you mea
Ok. I'm looking into alternatives. I'm trying to figure out an alternative
to mysql exporting into xls file. Is there any another way you can export
into file and make it readable? What format do you use? I'm open to ideas
from experienced database programmers :) I'm upgrading the whole database
sy
As a newbie to MySQL, can folks explain to me what is 'overhead', and what
causes it? (I sometimes get a very small overhead on 1 table and feel the
urge to optimize it.)
Thanks,
Eve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
All:
I would like to run the "check table medium" statement on a
regular basis. We use InnoDB exclusively (go Heikki!).
My problem is that the documentation seems to indicate the data can be
changed. I am specifically referring to this phrase in the docs: So, these
are my questions:
"
On Friday 20 August 2004 15:58, Boyd E. Hemphill might have typed:
> The quick answer is to save your data as a comma delimited file with no
> headers. (I suggest actually using bang | since your data may contain
> commas.)
A properly comma delimited file will not have problems with commas in the
The quick answer is to save your data as a comma delimited file with no
headers. (I suggest actually using bang | since your data may contain
commas.)
Then look in the docs for the "load data in file statement."
Be careful to note the fields delimited by, lines terminated by and such.
Best Re
Hi Kerry,
> The problem is more fundamental with the scrolling through
> the records/rows of Master. [..] It is not sensible to allow
> 200 million pieces of data to be transferred to the Delphi PC
> to build a local Dataset to scroll through.
>
[..]
> Getting the first row is easy
>
> select
What would be the best method (using free tools, or Office suite) to export
an Excel spreadsheet into a format suitable for import into MySQL? I am on a
PC platform.
Thanks,
Eve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
Thanks everyone, y'all have been so resourceful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 20 Aug 2004 at 10:09, [EMAIL PROTECTED] wrote:
> >>> Hmm... I use ASP.net, is there any instruction that I can use to use
> ASP.net
> >>> to export into excel or is there another way?
>
> Well, I know nothing of ASP.net, but you should be able to select from
> mysql, then instantiate excel via
Yes, use the MyODBC driver to connect to MySQL directly from ASP.net .
Cheers
Andrew.
- Original Message -
From: "Scott Hamm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Scott Hamm" <[EMAIL PROTECTED]>
Cc: "'Mysql ' (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, August 20, 2004 3:03 PM
Subj
Another way to do this is to get the data as HTML then just open the file in
Excel.
The mysql client has a switch for HTML output. Just redirect the output of
your query to a file. Try the following:
mysql -h < query.sql > /path/result.sql
Best Regards,
Boyd E. Hemphill
MySQL Certified Pr
Alright, I will look into it.
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
> Sent: Friday, August 20, 2004 10:09 AM
> To: Scott Hamm
> Cc: 'Mysql ' (E-mail); Scott Hamm
> Subject: RE: excel
>
>
>
>
>
> >>> Hmm... I use ASP.net, is there any instructi
>>> Hmm... I use ASP.net, is there any instruction that I can use to use
ASP.net
>>> to export into excel or is there another way?
Well, I know nothing of ASP.net, but you should be able to select from
mysql, then instantiate excel via COM to write the binary.
Jeff
> > How do I export from
Hmm... I use ASP.net, is there any instruction that I can use to use ASP.net
to export into excel or is there another way?
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]
> Sent: Friday, August 20, 2004 10:02 AM
> To: Scott Hamm
> Cc: 'Mysql ' (E-mail)
> Subject:
> How do I export from mysql into excel format?
Directly - use SELECT INTO OUTFILE and set up as a CSV, and open in excel
Indirectly - use a programming language and library to write an Excel
binary (php or perl with spreadsheetwrite_excel)
HTH
Jeff
--
MySQL General Mailing List
For list
Two main ways:
1. Dump your tables to a file and import them using the text import filter.
2. Install MyODBC and open a connection to the MySQL tables in Excel.
Since Excel is a proprietary file format, MySQL does not support it. Also,
bear in mind that Excel has a 65,535 row limit hard coded into
How do I export from mysql into excel format?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Miles Keaton wrote:
Programming a new site that will be launched in a month.
We'd like to use MySQL 4.1 but aren't sure how "production-ready" it is.
Anyone heard how the development is coming along, or when it will be
officially released?
Last time I tried 4.1.3 it didn't pass tests after compilat
Thanks!!!
It works, the only change I needed was -
WHERE tbl2..another_id IS NULL
rgds,
- Manish
- Original Message -
From: "Johan Hook" <[EMAIL PROTECTED]>
To: "Manish" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, August 20, 2004 12:32 PM
Subject: Re: Select non-matching ro
Can you use the -w/--where option in mysqldump to dump only the records you
want?
-Original Message-
From: Tucker, Gabriel
To: Mysql General (E-mail)
Sent: 8/20/04 8:07 AM
Subject: Remotely dumping data to a file
Hi All
I would like to dump certain data remotely from a table.
I am unable
Hi All
I would like to dump certain data remotely from a table.
I am unable to use mysqldump because I do not want to dump the entire table.
The "select into outfile" will not work when the connection is remote.
I saw in the manual that "mysql -e" would do what I want. However, that is not true.
What is the current value for you id field? Approximately how many records
are you inserting?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/20/04 3:16 AM
Subject: load data infile
Dear freinds,
I am still getting errors.Load infile script. Guidance , please.
Hello everybody
I have the following problem:
I've created a Website for a Customer by using MySQL 4.0.x
Now I need to transfer the whole stuff to my Customer's ISP.
The ISP is using MySQL 3.23.x
Now I have the following Query which doesn't work on the 3.23 Server:
SELECT
hotelstammdaten.id_PK ,
Hi,
insert into 321st_stat select * from stat_in group by ;
did you try to use this query?
Best regards,
Mikhail.
- Original Message -
From: "matt ryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 19, 2004 6:06 PM
Subject: 1 day 28 min insert
> I think oracle
Hi all,
I don't think this is the right list for the question but I am hoping
someone in the list will be able to point me in the right direction.
I am testing the use of Delphi with MySQL (using Micoolap's DAC) to access
and manipulate a number of tables in a databse. Some of the more complex
str
Dear freinds,
I am still getting errors.Load infile script. Guidance , please.
Asif Qureshi
--
---
mysql> describe chicago
-> ;
+---+--+--+-+-++
| Field | Type
> SELECT id, titel, MATCH (titel) AGAINST ('moz*' IN BOOLEAN MODE) AS
> score FROM cmp_composities WHERE MATCH (titel) AGAINST ('moz*' IN
> BOOLEAN MODE)
> +--
> +---
> +---+
> | id | titel
> | score |
> +--
> +--
On Friday 20 August 2004 07:08, [EMAIL PROTECTED] might have typed:
> Is replication of database in MySQL is possible. Actually i want to
> replicate the changes to the database to different servers located at
> different locations.
A tiny bit of legwork would have answered it for you.
http://dev
Hi,
All
Is replication of database in MySQL is possible. Actually i want to
replicate the changes to the database to different servers located at
different locations.
Please tell me if any suggestions, or available resources for this
Replication Topic.
From:
Smitesh S. Damdoo
(Mob. No.) 922
Craig Hoffman wrote:
Hey Folks,
I have a query where it pulls random data and display's it.
SELECT route_photo, route, route_count, area FROM routes WHERE
ORDER BY RAND() LIMIT 1
The query works fine, however, the "route_photo" field is partially
populated. This results in just a "route" na
Hi,
you could try:
SELECT tbl1.id
FROM tbl1
LEFT JOIN tbl2 ON tbl2.another_id = tbl1.id
WHERE tbl2.id IS NULL
/Johan
Manish wrote:
This should be simple but I am stuck here. I need to select rows from table
1, which do not have matching ID in table 2.
Say each table has 100 rows each, and 90 rows f
67 matches
Mail list logo
