Re: 1 day 28 min insert
matt ryan wrote: The table is 9 gig, and the index is 8 gig unfortunately the primary unique key is almost every column, if I were to make it one using concat, it would be huge. I tried making those fields a hash, but it did not work, I had duplicate hashes for non duplicate records!! Matt If I well understood, You have in Your index almost all data, You have in Your table? Why not add field for unique key (auto increment if You want less work)? It reduces size of Your primary index and thus speed up working with it! Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOAD DATA INFILE
Dear Friends, I am trying to pull lots of data in text file into database table. Their is single field in table/ The data in text file has been placed in mysql data directory. Any guidance for this error mysql is giving, please mysql use b Database changed mysql LOAD DATA INFILE - 'chicago.txt' INTO TABLE - b.chicago; ERROR 1062: Duplicate entry '' for key 2 mysql -- --- +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | email | varchar(150) | | PRI | || +---+--+--+-+-++ 2 rows in set (0.02 sec)
RE: 1 day 28 min insert
Matt, I know you have gotten a lot of recommendations, I have 3 for you that I don't think anybody has mentioned. 1. Try a merge table. We had 1 table with about 750 million rows in it, and every once in a while we would need to do something crazy to it and it would be locked up for hours. We decided to break it up into 10 different tables, based on the last digit of one of the fields. So whenever we did inserts they went directly into one of the 10 tables, but whenever we did a select if we didn't know which table to search in we used the merge table and it was just fine. This definitely helped us. 2. Get MySQL to come to your office and have them do some consulting. Or have them do it online, personally I recommend onsite consulting. It's not very expensive especially if you can solve your problem. We have MySQL coming out to our office in right over a week from now and the consultant is staying for 3 days. Do I really need the consultant to come in, not really, but if they can tweak, improve, or help us with just a few things, it's worth every penny. For example, two weeks ago, I was about to buy another quad Xeon 3.4ghz machine and before I ordered it I contacted our consultant just to ask their opinion and he told me to go with a 64bit machine. So now I have a quad AMD 64 2.2 with 32gigs of memory coming in next Wednesday for me to play with. You can find the information on the mysql site somewhere. 3. The last option, is a cheaper option than #2, but it can sometimes work just as well. Find the next time mysql will be holding a training class in your area, and go to the class. Then while you are in the class have the instructor look at your tables, queries, etc... and see what they think. Now, I've been to 3 of them now, some of the instructors can baffle you with how much they know. And some of them are more book taught. As one instructor asked me, if you can write a 12 table join without looking at your table structure, why are you here? My response, I have this problem, want to take a look. My problem was resolved by the end of the session. So it's up to you, but personally I recommend #2. You can have them come in and you can have a list of 100 questions, and go right down the list and have them answer everyone of them. I may even have them setup my new little toy when he comes in, you never know. Donny -Original Message- From: Remigiusz Sokoowski [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 1:12 AM To: matt ryan; [EMAIL PROTECTED] Subject: Re: 1 day 28 min insert matt ryan wrote: The table is 9 gig, and the index is 8 gig unfortunately the primary unique key is almost every column, if I were to make it one using concat, it would be huge. I tried making those fields a hash, but it did not work, I had duplicate hashes for non duplicate records!! Matt If I well understood, You have in Your index almost all data, You have in Your table? Why not add field for unique key (auto increment if You want less work)? It reduces size of Your primary index and thus speed up working with it! Best regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: anyone heard an ETA for MySQL 4.1? is it steady?
I've been using it since 4.1.0 was released. Works great for me. Wouldn't use 4.0 or 3.x because it's missing so many features that 4.1 has. And we have servers that use 4.0.x and 3.x and everytime I have to deal with them I cringe. We have one mysql server pushing over 3500 queries/second right now using 4.1.3. And about 15 others running 4.1.x. So in my opinion it's stable. Does it have bugs? Yes, but so does 3.x and 4.0.x. So does, php, apache, perl, windows? But are the bug's usually off the wall bugs, yes. But even if you find a bug with 4.1.x, usually there are other ways to do solve the problem anyway. Just my 2 cents. Donny -Original Message- From: Miles Keaton [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 12:17 AM To: [EMAIL PROTECTED] Subject: anyone heard an ETA for MySQL 4.1? is it steady? 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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Select non-matching rows
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 from table 1 have matching 90 rows in table 2. SO I want to find remaining 10 rows. Simple query such as select tbl1.id from tbl1, tbl2 where tbl1..id = tbl2.another_id; returns me the matching 90 rows, but my job is now to find out remaining 10 rows, how do I do it. I have done this before but can't recall it now, simply replacing = with naturally returns Cartesian product. Any help will be highly appreciated. TIA, - Manish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select non-matching rows
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 from table 1 have matching 90 rows in table 2. SO I want to find remaining 10 rows. Simple query such as select tbl1.id from tbl1, tbl2 where tbl1..id = tbl2.another_id; returns me the matching 90 rows, but my job is now to find out remaining 10 rows, how do I do it. I have done this before but can't recall it now, simply replacing = with naturally returns Cartesian product. Any help will be highly appreciated. TIA, - Manish -- Johan Höök, Pythagoras Engineering Group - MailTo:[EMAIL PROTECTED] - http://www.pythagoras.se Pythagoras AB, Stormbyv. 2-4, SE-163 55 SPÅNGA, Sweden Phone: +46 8 760 00 10 Fax: +46 8 761 22 77 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORDER BY rand()
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 name appearing but no photo. How can I change the query to only pull up routes that have a route_photo listed in the DB? Thanks, CH Maybe you should add something like this in your WHERE clause : AND route_photo IS NOT NULL -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication Problem
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.) 9223256591
Re: Replication Problem
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.mysql.com/doc/mysql/en/Replication.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MATCH (Full Text) IN BOOLEAN MODE
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 |
+--
+---
+---+
| 3422 | Variaties en Fuga op een thema van Mozart, opus 132a, voor
piano. | 1 |
| 2692 | 11F?nf Variationen ?ber das Lied 'Komm, lieber Mai' von
Mozart. | 1 |
+--
+---
+---+
Now, the score is 1 no matter what (boolean) search i do the score now
always return 1
This seems not the intended behavior? is is not possible to get the
score on BOOLEAN searches? That would explain why it doesn't sort on
score... but perhaps the documentation should say you don't get scores
with boolean searches...
or am i mistaking, in which case i take back my words...
runnning mysql 4.0.20 on os x server 10.3.5
thx 4 any help
Hi there,
The problem you are seeing is that full text searches require a
pattern of 4 characters or more, so moz will not be sufficient to
allow a full text search.
You can drop this to however many characetrs you want, see the section
on tuning full text searches in the manual.
However, once you do that you will still notice that the relevance
returned by match is not much use for sorting when using a boolean
search (again, it might always be 1)
The way around this is to sort by a non-boolean version of the same
match, but limit by the boolean one.
SELECT id, titel, MATCH (titel) AGAINST ('moza' IN BOOLEAN MODE) AS
score FROM cmp_composities WHERE MATCH (titel) AGAINST ('moz*' IN
BOOLEAN MODE) ORDER BY MATCH (titel) AGAINST ('moza')
--
-S
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
load data infile
Dear freinds, I am still getting errors.Load infile script. Guidance , please. Asif Qureshi -- --- mysql describe chicago - ; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | email | varchar(150) | | PRI | || +---+--+--+-+-++ 2 rows in set (0.02 sec) mysql LOAD DATA INFILE - 'CHICAGO.TXT' into table - B.CHICAGO; ERROR 1062: Duplicate entry '0-' for key 1 mysql
newbie question on scrolling through a table one record at a time
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 structures I want to do are quite clear on how to implement them with many papers and books published. My problem is the technique on implementing a far more fundamental issue. Let us say I have a couple of tables with a large number of rows (Master and Detail) with a common (indexed for performance) column MasterRef. Getting the rows from table Detail is straight forward by using a Query select * from Detail where Master.MasterRef = Detail.MasterRef The problem is more fundamental with the scrolling through the records/rows of Master. Reading previously posted information, it comes to light that if I open a table to scroll through using an application navigator then the app creates and uses a local dataset. Not a big issue if the database is local, on a high speed connection, or has a relatively small number of rows. But what if Master has 1 million rows with 200 columns. 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. I note there is the concept of LIMIT. This looks good until I try to see how to implement its usage in the real world. The concept of creating an app that only works on one (or a small number of rows) at a time is eluding me at the moment. Getting the first row is easy select * from Master order by MasterRef limit 1; but getting the next record isn't as straight forward. Mainly because I have no idea of what the next value of MasterRef is. All I know is that I want to get the next row in sequence. None of the papers I have or have seen addresses this issue. Either this concept is not required in SQL programming or it is so obvious that it doesn't need explaining. Either way I can't see the wood for the trees. If MasterRef is a unique value column then the next record would be: select * from Master order by MasterRef limit 1 where MasterRef MyCurrentMasterRefValue; This simply raises questions 1) how to get the previous row (presume you use the DESCENDING keyword of the table, 2) how to test for Begining and End of Table and 3) what to do if the column being ordered on is not unique. Are there any known papers, documents, references, books etc that go through these issues. Or can someone tell me that the posts I have been reading are no longer applicable and that when I program using Table components that it doesn't download a complete large dataset and that I only get one row at a time which takes away the concern, and the need to manage the data scroll directly. JOIN is not an option because in my project one form can have up to 9 DETAIL tables showing with the Master table. I am at the point where I have done a lot of reading and now want to look at the reality of implementation. Which means I have a little knowledge which is a dangerous thing. I want to change that status. Many thanks Kerry
Re: 1 day 28 min insert
Hi, insert into 321st_stat select * from stat_in group by primary key fields from 321st_stat table; 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 parallel query is calling me 110,832,565 stat records 77,269,086 on weekly update, I get small daily files, but daily sql's dont work very well, and miss records, in this case it missed 563 records. mysql update stat_in set ctasc='321ST'; Query OK, 77269086 rows affected (24 min 17.60 sec) Rows matched: 77269086 Changed: 77269086 Warnings: 0 mysql insert ignore into 321st_stat select * from stat_in; Query OK, 563 rows affected (1 day 28 min 35.95 sec) Records: 77269086 Duplicates: 77268523 Warnings: 0 I just cant deal with speeds this slow, an insert onto a table with a primary key that tosses out almost all records shouldnt take this long to do -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
query problem after transfer from 4.0.x to 3.23.x
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 , hotelstammdaten.hotelname , hotelstammdaten.name , hotelstammdaten.vorname , hotelstammdaten.strasse , hotelstammdaten.plz , hotelstammdaten.ort , hotelstammdaten.bundesland , hotelstammdaten.land FROM hotelstammdaten INNER JOIN relation_hotelthema ON hotelstammdaten.id_PK = relation_hotelthema.hotelid_fk INNER JOIN hotelthema ON relation_hotelthema.hotelthemaid_fk = hotelthema.id_PK INNER JOIN relation_hotelausstattung ON hotelstammdaten.id_PK = relation_hotelausstattung.hotelid_fk INNER JOIN hotelausstattung ON relation_hotelausstattung.hotelausstattungid_fk = hotelausstattung.id_PK INNER JOIN relation_hoteldienstleistung ON hotelstammdaten.id_PK = relation_hoteldienstleistung.hotelid_fk INNER JOIN hoteldienstleistung ON relation_hoteldienstleistung.hoteldienstleistungid_fk = hoteldienstleistung.id_PK INNER JOIN relation_hotelfreizeit ON hotelstammdaten.id_PK = relation_hotelfreizeit.hotelid_fk INNER JOIN hotelfreizeit ON relation_hotelfreizeit.hotelfreizeitid_fk = hotelfreizeit.id_PK WHERE hotelstammdaten.status = 'aktiv' AND hotelstammdaten.sterne_fk = '3' AND hotelstammdaten.ort like 'Bern' AND (hotelstammdaten.bundesland LIKE 'Oberösterreich' ) AND relation_hotelthema.hotelthemaid_fk = '2' AND relation_hotelausstattung.hotelausstattungid_fk IN (50, 96) AND relation_hoteldienstleistung.hoteldienstleistungid_fk IN (42) AND relation_hotelfreizeit.hotelfreizeitid_fk IN (5, 34) GROUP BY hotelstammdaten.id_PK HAVING count(DISTINCT relation_hotelausstattung.hotelausstattungid_fk) = 2 AND count(DISTINCT relation_hoteldienstleistung.hoteldienstleistungid_fk) = 1 AND count(DISTINCT relation_hotelfreizeit.hotelfreizeitid_fk) = 2 The Error Message I get is: Unknown column 'relation_hotelausstattung.hotelausstattungid_fk' in 'having clause' I can't figure out what is wrong. Can anyone put me in the right direction ? Regards Olivier -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: load data infile
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. Asif Qureshi -- --- mysql describe chicago - ; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | email | varchar(150) | | PRI | || +---+--+--+-+-++ 2 rows in set (0.02 sec) mysql LOAD DATA INFILE - 'CHICAGO.TXT' into table - B.CHICAGO; ERROR 1062: Duplicate entry '0-' for key 1 mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Remotely dumping data to a file
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. The output from this is formatted, I want it unformatted, like the mysqldump command. I could take the output from the mysql -e command and formatted the way I would like. Before doing this, I wanted to know if there is another option. Thanks! There are no problems, only solutions. Gabe Tucker Bloomberg LP (609) 750 6668 - P (646) 268 5681 - F -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Remotely dumping data to a file
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 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. The output from this is formatted, I want it unformatted, like the mysqldump command. I could take the output from the mysql -e command and formatted the way I would like. Before doing this, I wanted to know if there is another option. Thanks! There are no problems, only solutions. Gabe Tucker Bloomberg LP (609) 750 6668 - P (646) 268 5681 - F -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Select non-matching rows
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 rows 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 from table 1 have matching 90 rows in table 2. SO I want to find remaining 10 rows. Simple query such as select tbl1.id from tbl1, tbl2 where tbl1..id = tbl2.another_id; returns me the matching 90 rows, but my job is now to find out remaining 10 rows, how do I do it. I have done this before but can't recall it now, simply replacing = with naturally returns Cartesian product. Any help will be highly appreciated. TIA, - Manish -- Johan Höök, Pythagoras Engineering Group - MailTo:[EMAIL PROTECTED] - http://www.pythagoras.se Pythagoras AB, Stormbyv. 2-4, SE-163 55 SPÅNGA, Sweden Phone: +46 8 760 00 10 Fax: +46 8 761 22 77 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: anyone heard an ETA for MySQL 4.1? is it steady?
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 compilation on Amd64/gcc3.4.1. Disabling UTF-8 helped a little bit, but than it hang on test named keys. So, my advice would be: check if it passes all tests on your platform first. Best Wishes, Viktors -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
excel
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]
Re: excel
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 it - which means if you want column headings you are limited to 65,534 rows. Cheers Andrew. - Original Message - From: Scott Hamm [EMAIL PROTECTED] To: 'Mysql ' (E-mail) [EMAIL PROTECTED] Sent: Friday, August 20, 2004 2:53 PM Subject: excel 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: excel
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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: excel
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: Re: excel 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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: excel
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 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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: excel
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 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 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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: excel
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 Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From: Andrew Pattison [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 8:01 AM To: [EMAIL PROTECTED] Subject: Re: excel 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 it - which means if you want column headings you are limited to 65,534 rows. Cheers Andrew. - Original Message - From: Scott Hamm [EMAIL PROTECTED] To: 'Mysql ' (E-mail) [EMAIL PROTECTED] Sent: Friday, August 20, 2004 2:53 PM Subject: excel 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: excel
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 Subject: RE: excel 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: Re: excel 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 archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: excel
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 COM to write the binary. Jeff How do I export from mysql into excel format? There is also a method of exporting to excel via HTML tables. The following: table tr tdRow1 cell1/td tdRow2 cell2/td /tr /table When saved with a .xls extension ( or sent to a browser via mime type *application/vnd.ms-excel* ) will be opened directly by Excel. You can also include styles / text formating / functions etc within the cells. I ues this as a method for customers to download data easily. You will still have to write your own code to do the export though. Regards Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
excel
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]
Best method to export Excel data into MySQL?
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.com/[EMAIL PROTECTED]
RE: newbie question on scrolling through a table one record at a time
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 * from Master order by MasterRef limit 1; It is, but LIMIT mostly is executed after getting all records meeting the WHERE-condition. That might be quite slow. but getting the next record isn't as straight forward. Mainly because I have no idea of what the next value of MasterRef is. All I know is that I want to get the next row in sequence. None of the papers I have or have seen addresses this issue. Either this concept is not required in SQL programming or it is so obvious that it doesn't need explaining. Either way I can't see the wood for the trees. If MasterRef is a unique value column then the next record would be: select * from Master order by MasterRef limit 1 where MasterRef MyCurrentMasterRefValue; This simply raises questions 1) how to get the previous row (presume you use the DESCENDING keyword of the table, 2) how to test for Begining and End of Table and 3) what to do if the column being ordered on is not unique. I ran through the same problem the last days (still). This is how i did it: At first you need a unique key (auto-increment). I name it id. If you have records that are non-unique by the column you want to sort them, try to add other columns to sort on to get them as unique as you can. Having non-unique records isn't a problem as long there are not many beeing equal. How to move through records: Starting with a value of '', always SELECT the record having a higher value in that columns you sorted on than the last one. As you said, that's all, if there all records are unique. You will need LIMIT to get through equal records. It's quite easy having an example: record key 1a 2a 3b 4b 5c Get the first record (assuming your id starts with 0): SELECT key FROM table WHERE key='' AND id-1 ORDER BY key,id LIMIT 0,1 Store these: old_key = key old_id = id Get the next record: old_key = SELECT key FROM table WHERE key=old_key AND idold_id ORDER BY key,id LIMIT 1,1 The LIMIT has to be 1 here to get the second record. As long as key stays equal to old_key, increase the limit by one for each record fetched. When getting a new value for key, set the limit to 1 again. You need to find a good relation between the amount of equal records and the columns you use to sort and move on. 500 records having the same key will make things slow, but using a long WHERE- clause will do, too. I tested this for upto 3 records. If there is an index on all columns used in the SELECTs, speed seems to be stable upto that size. hth, TomH -- PROSOFT EDV-Loesungen GmbH Co. KGphone: +49 941 / 78 88 7 - 121 Ladehofstrasse 28, D-93049 Regensburg cellphone: +49 174 / 41 94 97 0 Geschaeftsfuehrer: Axel-Wilhelm Wegmann [EMAIL PROTECTED] AG Regensburg HRA 6608 USt.183/68311http://www.proSoft-Edv.de -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Best method to export Excel data into MySQL?
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 Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -Original Message- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 8:53 AM To: [EMAIL PROTECTED] Subject: Best method to export Excel data into MySQL? 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.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Best method to export Excel data into MySQL?
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 fields, because the fields will be quoted and escaped (and the load infile parser supports all of this too). Text::CSV_XS for perl is a good validator :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
check table
All: I would like to run the check table tablename 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: Note: In some cases, CHECK TABLE will change the table! This happens if the table is marked as ``corrupted'' or ``not closed properly'' but CHECK TABLE doesn't find any problems in the table. In this case, CHECK TABLE marks the table as okay. 1. What causes this statement to change data? I think what is being said is that if, during the check, the table is found to be corrupt or not closed properly, it will be changed. This leads to the next question: 2. What are the nature of the changes to the data? 3. What information do I get about data that has changed from the server? 4. The doc is unclear about what is performed for InnoDB specifically. I am assuming it the same operation as for MyISAM but would like to have this clarified. Best Regards, Boyd E. Hemphill MySQL Certified Professional [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is overhead and what causes it?
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.mysql.com/[EMAIL PROTECTED]
Brainstorming' time!
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 system from stupid Access database into SQL variant, whether it be MySQL or SQL server (MeowSoft) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question about Update multiple columns at once
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 mean that they are similar in form? That
is, you are doing the same update on each set, but what varies is the column
names, Q1x, Q2x, ..., Q6x? I think the problem is that you are thinking
like a programmer (normally a good thing) rather than a SQL coder. In a
program, you might step through your data one row at a time, compare values
to your conditionals, and branch into different operations based on that.
With a db, however, we want to use indexes to avoid stepping through data
one row at a time. That is, we can quickly find, and operate on, only those
rows we want. In that case, as a programmer, what you want is 1 function
called 6 times, one for each set.
Here's what I suggested before (option 1):
UPDATE temp
SET Q1E = 6, Q1F = 5, Q1G = 999
WHERE Q1A = 1 AND Q1E = 1 AND Q1F = 1 AND (Q1G IN ('', 'NA'));
UPDATE temp
SET Q2E = 6, Q2F = 5, Q2G = 999
WHERE Q2A = 1 AND Q2E = 1 AND Q2F = 1 AND (Q2G IN ('', 'NA'));
Note how this parallels a function called twice, once for Q1 and once for Q2.
For comparison, here's how you could do that in 1 update (option 2):
UPDATE temp
SET
Q1E = IF(Q1A = 1 AND Q1E = 1 AND Q1F = 1 AND (Q1G IN ('', 'NA')),6,Q1E)
Q1F = IF(Q1A = 1 AND Q1E = 1 AND Q1F = 1 AND (Q1G IN ('', 'NA')),5,Q1F)
Q1G = IF(Q1A = 1 AND Q1E = 1 AND Q1F = 1 AND (Q1G IN ('', 'NA')),999,Q1G)
Q2E = IF(Q2A = 1 AND Q2E = 1 AND Q2F = 1 AND (Q2G IN ('', 'NA')),6,Q2E),
Q2F = IF(Q2A = 1 AND Q2E = 1 AND Q2F = 1 AND (Q2G IN ('', 'NA')),5,Q2F),
Q2G = IF(Q2A = 1 AND Q2E = 1 AND Q2F = 1 AND (Q2G IN ('', 'NA')),999,Q2G)
WHERE (Q1A = 1 AND Q1E = 1 AND Q1F = 1 AND (Q1G IN ('', 'NA')))
OR (Q2A = 1 AND Q2E = 1 AND Q2F = 1 AND (Q2G IN ('', 'NA')));
Aside from that being ugly (hard to read/maintain), I would be stunned if it
weren't an order of magnitude slower than option 1, for two reasons:
* With proper indexes {probably one on (Q1A,Q1E,Q1F,Q1G) and one on
(Q2A,Q2E,Q2F,Q2G)}, finding the matching rows in option 1 will be very fast.
In option 2, however, using OR to combine compound conditionals using
different columns will largely prevent using indexes. That is, mysql won't
be able to pare down the possible rows very much using indexes, so it will
have to compare the contents of the rows to the WHERE clause to find
matches. This may even be a dreaded full table scan.
* In option 1, once we've found a matching row, we simply update it (set 3
column values). In option 2, we have to recompare the column values to
determine which subgroup the row falls in, once for each column to be set,
for a total of 6 times! Note that the only point of those comparisons is to
divide the resultset into the 2 sets from option 1.
Now, if I understand you correctly, you actually have 6 sets of these, Q1 to
Q6. Option 1 scales nicely into 6 simple, quick updates. Option 2 turns
into an ugly monstrosity with a giant WHERE clause that will almost
certainly force a full table scan, and 18 IF comparisons (3 per set) to be
done for each matching row (with 15 out of 18 IFs resulting in do
nothing). I'd bet the farm that option 1 will be much more efficient.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Brainstorming' time!
- 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. 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 system from stupid Access database into SQL variant, whether it be MySQL or SQL server (MeowSoft) How do you export a MySQL table into an XLS file? ;-) You raised an interesting point - the whole issue of exporting data from MySQL - so I took a quick glance and couldn't see *anything* that looked like an export utility of the kind I've seen in many other programs and relational databases. Just about the only thing I saw was the mysqldump utility which basically generates the SQL needed to re-create and re-populate a table on another system. But I don't think that's what you're looking for and it clearly won't generate an XLS file. So I'm not sure how you'd even export to XLS. In the absence of an actual export utility - assuming I haven't missed one in the manual somewhere! - you are hosed. Unless of course you have programming skills; in that case you could write your own export utility to export data in any format you like. If you do that, you might consider sharing it with the rest of us when it is done, even if it isn't a full-function ultra-slick piece of code; it might still be useful to some of us if we ever need to export data. Or maybe there are some export utilities floating around for MySQL that are described somewhere other than the manual. I could well imagine users developing their own homegrown utilities and donating them to MySQL. I can also imagine professional developers writing a full-function export utility for MySQL; a Google search might turn those up. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql 4.0 windows XP Downloads
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
Re: Brainstorming' time!
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);
my $workbook = Spreadsheet::WriteExcel-new($table.xls);
my $worksheet = $workbook-add_worksheet();
my ($col, $row) = (0, 0);
for (@{ $dbh-selectall_arrayref(SHOW COLUMNS FROM $table) }) {
$worksheet-write($row, $col, $_-[0]);
$col++;
}
for (@{ $dbh-selectall_arrayref(SELECT * FROM $table) }) {
$col = 0;
$row++;
for (@{ $_ }) {
$worksheet-write($row, $col, $_);
$col++;
}
}
Eamon Daly
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: 'Mysql ' (E-mail) [EMAIL PROTECTED]
Sent: Friday, August 20, 2004 11:02 AM
Subject: Brainstorming' time!
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
system from stupid Access database into SQL variant, whether it be MySQL
or SQL server (MeowSoft)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql 4.0 windows XP Downloads
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fulltext performance problem.
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;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| id | int(11) | | PRI | NULL| auto_increment |
| parent | int(11) | YES | MUL | NULL||
| bodyid | int(11) | YES | | NULL||
| list| varchar(80) | YES | MUL | NULL||
| mfrom | varchar(80) | YES | | NULL||
| mto | varchar(80) | YES | | NULL||
| subject | varchar(200) | YES | MUL | NULL||
| mcc | varchar(80) | YES | | NULL||
| sdate | varchar(45) | YES | | NULL||
| batch | varchar(80) | YES | MUL | NULL||
| msgid | varchar(90) | YES | | NULL||
| date| datetime | YES | MUL | NULL||
+-+--+--+-+-++
12 rows in set (0.00 sec)
mysql describe msg_body;
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| id| int(11) | | PRI | NULL| auto_increment |
| body | text| YES | MUL | NULL||
+---+-+--+-+-++
2 rows in set (0.00 sec)
index from msg_body;
*** 1. row ***
Table: msg_body
Non_unique: 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name: id
Collation: A
Cardinality: 295996
Sub_part: NULL
Packed: NULL
Null:
Index_type: BTREE
Comment:
*** 2. row ***
Table: msg_body
Non_unique: 1
Key_name: id
Seq_in_index: 1
Column_name: id
Collation: A
Cardinality: 295996
Sub_part: NULL
Packed: NULL
Null:
Index_type: BTREE
Comment:
*** 3. row ***
Table: msg_body
Non_unique: 1
Key_name: body
Seq_in_index: 1
Column_name: body
Collation: A
Cardinality: 295996
Sub_part: NULL
Packed: NULL
Null: YES
Index_type: FULLTEXT
Comment:
3 rows in set (0.00 sec)
The search querys using fulltext indexes takes around 1minute and no
one want to use a search that slow :/
The Query is the following:
SELECT msg_header.bodyid,msg_header.id,
msg_header.subject,msg_header.mfrom, msg_header.date, msg_header.list FROM
msg_header,msg_body WHERE msg_header.bodyid=msg_body.id AND
match(msg_header.list) against('LISTNAME')
AND match(msg_body.body) AGAINST('WORD');
For a couple of month ago the msg-body and msg-headers parts where in
the same table and the fulltext search was really fast 1 sec, but
everything else just became slower so i splitted it upp in two tables.
But now i need to match msg_header.bodyid against msg_body.id to be able
to now witch body that belongs to with header and i think thats where
things get slow..
I ran an explain select query and the following result turned upp
++--+-+-+-+---+--+-+
| table | type | possible_keys | key | key_len |
ref | rows | Extra |
++--+-+-+-+---+--+-+
| msg_header | fulltext | list_4 | list_4 | 0
| |1 | Using where |
| msg_body | eq_ref | PRIMARY,id,body | PRIMARY | 4 |
msg_header.bodyid |1 | Using where |
++--+-+-+-+---+--+-+
Does this means that the fulltext index on msg_body.body is'nt being used?
The machine is an Intel PIII 500Mhz, 512MB memory and IDE disks running
NetBSD 1.6.3, mysql 4.0.20.
The database contains about 300 000 rows and the size is ~1GB.
// Fredrik Carlsson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Please Do Not Delete Without Reading
- 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: Please Do Not Delete Without Reading From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Please Do Not Delete Without Reading Date: Sat, 14 Aug 2004 22:39:45 +0200 The following is an email sent to you by an administrator of TAMILTORRENTS.COM ]. If this message is spam, contains abusive or other comments you find offensive please contact the webmaster of the board at the following address: [EMAIL PROTECTED] Include this full email (particularly the headers). Message sent to you follows: A couple of days ago, my daughter, she's 6years old, her name is Fatima. Well, she was playing on the street, in front of our house, and then out of no where, this car came out and crashed into her! I was so frightened and angered at the driver, but it ended out to be, that the drivers brakes had been shot, and he wasn't able to stop. Luckily, my daughter, was able to avoid death, but she is in very serious condition. Right now, as I speak, she's in the hospital, but the thing is, she has a serious injury. It's internal bleeding, and it's bad to say,but we don't have any health insurance, and we don't have enough money to pay for the operation. So I made a deal with a company, BCC inc and they told me, for every person that will foward this email, they will donate 3 cents to the operation THIS IS NO JOKE. We attached encoding, that tracks how many times this message is fowarded. SO PLEASE, FOWARD THIS LETTER TO EVERY PERSON ON YOUR LIST. IT WILL BE VERY MUCH APPRECIATED!!! THANK YOU SO MUCH!!! Regards, Harlina shahrazad Hamzah (Ms) Philips Medical Systems - Malaysia No 76 Jalan Universiti 46200 Petaling Jaya Selangor Darul Ehsa Tel. : 603-750.5561 Fax : 603-755.2661 E-mail address : [EMAIL PROTECTED] Please forward this message to everyone you know. Thanks. No matter this message is true or false, I rather believe it to be true as if you don't believe it, YOU MAY DESTROY A LIFE OF A LITTLE GIRL... _ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql 4.0 windows XP Downloads
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 lot of stuff with this and save your self from having to type at the command line. MySql Control Center http://dev.mysql.com/downloads/other/mysqlcc.html Julian Francois A. Atallah wrote: Y I'm getting this error every time I want to access the mysql database ERROR 1044: Access denied for user: '@localhost' to database 'mysql' I can only bypass this error if I use -u root ? Thanks, Francois A -Original Message- From: Julian [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 12:04 PM To: [EMAIL PROTECTED] Subject: Re: Mysql 4.0 windows XP Downloads That's it. You had it. x86 refers to the Intel chip family not the operating system. I'm using that quite happily on XP. Julian Francois A. Atallah wrote: 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 . -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Login problem
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 user: '[EMAIL PROTECTED]' (Using password: NO)
C:\c:\mysql\bin\mysqlshow mysql
c:\mysql\bin\mysqlshow: Access denied for user: '@localhost' to database
'mysql'
Thanks,
Francois A
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Login problem
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
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 user: '[EMAIL PROTECTED]' (Using password:
NO)
C:\c:\mysql\bin\mysqlshow mysql
c:\mysql\bin\mysqlshow: Access denied for user: '@localhost' to database
'mysql'
Thanks,
Francois A
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Brainstorming' time!
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 creating excel type data, just save it into a file with the fields separated by commas, a CSV file in other words. Then use excel to open the file. Chris Hood Investigator Verizon Global Security Operations Center Email: [EMAIL PROTECTED] Desk: 972.399.5900 Verizon Proprietary NOTICE - This message and any attached files may contain information that is confidential and/or subject of legal privilege intended only for the use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error and that any dissemination, copying or use of this message or attachment is strictly forbidden, as is the disclosure of the information therein. If you have received this message in error please notify the sender immediately and delete the message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 11:30 AM To: Scott Hamm; 'Mysql ' (E-mail) Subject: Re: Brainstorming' time! - 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. 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 system from stupid Access database into SQL variant, whether it be MySQL or SQL server (MeowSoft) How do you export a MySQL table into an XLS file? ;-) You raised an interesting point - the whole issue of exporting data from MySQL - so I took a quick glance and couldn't see *anything* that looked like an export utility of the kind I've seen in many other programs and relational databases. Just about the only thing I saw was the mysqldump utility which basically generates the SQL needed to re-create and re-populate a table on another system. But I don't think that's what you're looking for and it clearly won't generate an XLS file. So I'm not sure how you'd even export to XLS. In the absence of an actual export utility - assuming I haven't missed one in the manual somewhere! - you are hosed. Unless of course you have programming skills; in that case you could write your own export utility to export data in any format you like. If you do that, you might consider sharing it with the rest of us when it is done, even if it isn't a full-function ultra-slick piece of code; it might still be useful to some of us if we ever need to export data. Or maybe there are some export utilities floating around for MySQL that are described somewhere other than the manual. I could well imagine users developing their own homegrown utilities and donating them to MySQL. I can also imagine professional developers writing a full-function export utility for MySQL; a Google search might turn those up. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Brainstorming' time!
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üngliche Nachricht- Von: Rhino [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 20. August 2004 18:30 An: Scott Hamm; 'Mysql ' (E-mail) Betreff: Re: Brainstorming' time! - 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. 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 system from stupid Access database into SQL variant, whether it be MySQL or SQL server (MeowSoft) How do you export a MySQL table into an XLS file? ;-) You raised an interesting point - the whole issue of exporting data from MySQL - so I took a quick glance and couldn't see *anything* that looked like an export utility of the kind I've seen in many other programs and relational databases. Just about the only thing I saw was the mysqldump utility which basically generates the SQL needed to re-create and re-populate a table on another system. But I don't think that's what you're looking for and it clearly won't generate an XLS file. So I'm not sure how you'd even export to XLS. In the absence of an actual export utility - assuming I haven't missed one in the manual somewhere! - you are hosed. Unless of course you have programming skills; in that case you could write your own export utility to export data in any format you like. If you do that, you might consider sharing it with the rest of us when it is done, even if it isn't a full-function ultra-slick piece of code; it might still be useful to some of us if we ever need to export data. Or maybe there are some export utilities floating around for MySQL that are described somewhere other than the manual. I could well imagine users developing their own homegrown utilities and donating them to MySQL. I can also imagine professional developers writing a full-function export utility for MySQL; a Google search might turn those up. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Brainstorming' time!
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/[EMAIL PROTECTED]
Re: Brainstorming' time!
- 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 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 | Thanks for the suggestions, Freddie! Actually, I don't need to export MySQL data to Excel format; I was just remarking that I hadn't seen a real export utility in MySQL when I was replying to Scott's original question. I had forgotten about SELECT ... INTO OUTFILE altogether and didn't hit it when I searched the MySQL manual. The free tool you suggested - or MyODBC - would probably be good options if I really needed to export MySQL data to Excel so I'll keep them in mind if I need to do that. As for programming skills, I'm pretty familiar with Java so I feel sure I could write a suitable utility with that. In fact, unless I had a really urgent need, I would prefer to write my own stuff just because I like writing code ;-) Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Brainstorming' time!
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: Friday, August 20, 2004 11:02 AM Subject: Brainstorming' time! 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 system from stupid Access database into SQL variant, whether it be MySQL or SQL server (MeowSoft) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Brainstorming' time!
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, apparently, my perl solution completely reinvented the wheel. See pp.527-530 MySQL Cookbook, 1st ed. for a better script. Eamon Daly - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 20, 2004 1:24 PM Subject: RE: Brainstorming' time! 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 creating excel type data, just save it into a file with the fields separated by commas, a CSV file in other words. Then use excel to open the file. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Administrator
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, Francois A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Brainstorming' time!
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 handy for some things. Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters USA Central Time Zone 636-922-9158 ext. 8652 fax 636-447-4471 [EMAIL PROTECTED] www.nisc.cc - Original Message - From: Eamon Daly [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 20, 2004 13:55 Subject: Re: Brainstorming' time! 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, apparently, my perl solution completely reinvented the wheel. See pp.527-530 MySQL Cookbook, 1st ed. for a better script. Eamon Daly - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 20, 2004 1:24 PM Subject: RE: Brainstorming' time! 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 creating excel type data, just save it into a file with the fields separated by commas, a CSV file in other words. Then use excel to open the file. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rows to columns - not crosstab
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 Where the number of distinct id values is in the 100,000 range but the distinct date types are limited to about 20. I want to get a table (not a view) like this: iddate a date b date d .. 1 x y null 2 z null w (based on the values in the first table above) So...I can't think how to do this. Help would be appreciated. TIA. dmh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Brainstorming' time!
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 MySQL and Php/ASP. Appreciate it very much. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Transaction Replication Problems
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 replication. Is this my best action? The error I am receiving is: 040820 14:51:56 Slave: query 'BEGIN' partially completed on the master and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; . Error_code: 1158 040820 14:51:56 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with SLAVE START. We stopped at log 'intranet-bin.007' position 16980559 MySql: ready for connections. Thanks for any help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Brainstorming' time!
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 DATA INFILE file.csv INTO TABLE whatever FIELDS TERMINATED BY ',' ENCLOSED BY ''; Of course, you still have the problem of creating the appropriate equivalent tables in mysql, but I'm sure you can dump the schema in Access and massage the output to create the schema in MySQL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld_multi
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 go right to the section that's tied to the parameter given to the start script, i.e. mysqld_multi start 1 should go right to the [mysqld1] section and get the info it needs from there. However, until I put both variables in the [mysqld_multi] section, it didn't work and gave me an error that it was looking for mysqld and mysqladmin in the /var/lib/mysql directory. Here is my my.cnf file. [mysqld_multi] mysqld = /usr/local/mysql420/bin/mysqld mysqladmin = /usr/local/mysql420/bin/mysqladmin [mysqld1] basedir= /usr/local/mysql420 mysqld = /usr/local/mysql420/bin/mysqld port = 3307 socket = /usr/local/mysql420/mysql420.sock pid-file = /usr/local/mysql420/my420.pid [mysqld2] basedir= /usr/local/mysql500 mysqld = /usr/local/mysql500/bin/mysqld port = 3306 socket = /usr/local/mysql500/mysql500.sock pid-file = /usr/local/mysql500/my500.pid
innodb data file question
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.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Calculated fields - is there any way to do this?
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 directly in MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Calculated fields - is there any way to do this?
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]
Re: Calculated fields - is there any way to do this?
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 implemented client side, but I am wondering if it could be done directly in MySQL? Not until views (will be in 5.0) or triggers (targeted for 5.1) are implemented. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: LOAD DATA INFILE
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 - ; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | id| int(11) | | PRI | 0 | | | email | varchar(150) | | PRI | | | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql LOAD DATA INFILE IGNORE id - 'chicago.txt' INTO TABLE - b.chicago; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server ver 'chicago.txt' INTO TABLE b.chicago' at line 1 mysql - This is how I had done it before - mysql use b Database changed mysql LOAD DATA INFILE - 'chicago.txt' INTO TABLE - b.chicago; ERROR 1062: Duplicate entry '' for key 2 mysql -- --- +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | email | varchar(150) | | PRI | || +---+--+--+-+-++ 2 rows in set (0.02 sec)
Bug #3933
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]
Re: mysql 4.0.20 uses just one CPU on Gentoo (now: glibc patches)
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 answer I got when I asked a similar question a few weeks ago. HTH, --Pete Egor Egorov [EMAIL PROTECTED] writes: ...skipped ... -- == Mike Blazer [EMAIL PROTECTED] == -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
LOAD DATA---------- (HALF LOADED WHY?)
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 data infile 'chicago.txt'into table b.chicago; ' for key 1 Duplicate entry '[EMAIL PROTECTED] mysql table structure mysql describe chicago; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | email | varchar(150) | | PRI | | | +---+--+--+-+-+---+ 1 row in set (0.00 sec) mysql
RE: mysql 4.0.20 uses just one CPU on Gentoo (now: glibc patches)
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 Blazer [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 7:06 PM To: Pete Harlan Cc: [EMAIL PROTECTED] Subject: Re: mysql 4.0.20 uses just one CPU on Gentoo (now: glibc patches) 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 answer I got when I asked a similar question a few weeks ago. HTH, --Pete Egor Egorov [EMAIL PROTECTED] writes: ...skipped ... -- == Mike Blazer [EMAIL PROTECTED] == -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is a good MySQL database manager for newbies?
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 editing tables. Something simple for newbies like me not seeking to do really complicated things. There that should be better.
Re: mysql 4.0.20 uses just one CPU on Gentoo
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 Simonton wrote: 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 -- == Mike Blazer [EMAIL PROTECTED] == -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good MySQL database manager for newbies?
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'm looking for something that can easily create and manage databases, doing stuff like creating and editing tables. Something simple for newbies like me not seeking to do really complicated things. There that should be better. ___ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
