Re: HEPL: LOAD DATA LOCAL skips recors
In addition I would suggest to verify that your text file does not end with a CR or LF character. This happens very often on Windows systems when for instance saving an Excel sheet as a text file. If you do not remove this last character(s), you risk inserting a blank row in the DB. Ignatius - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Sebastian Stan [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 14, 2003 4:02 PM Subject: Re: HEPL: LOAD DATA LOCAL skips recors At 11:50 +0200 3/14/03, Sebastian Stan wrote: i have 2 DBFs and i'm doing the same thing on both of them : (i'm transforming the DBFs in TXTs) (in foxpro) copy to file.txt delimited with '^' with character '#' When : LOAD DATA LOCAL INFILE 'file.TXT' into table table on mysql fields terminated by '#' OPTIONALLY ENCLOSED BY '^'; is executed i get 2 different results: 1. from the 1st .txt file ALL the recors are loded 2. from the 2nd it loads only the records 1,3,5,7,9 etc. are loaded. (and i really need all of them , too :)) ) If the txt files i make are with constant leght and i do LOAD DATA LOCAL INFILE 'file.TXT' into table table on mysql fields terminated by ' ' it works just fine, but i need the first way. This is typically a problem of not indicating correctly what the end of line character sequence is. How do your lines end? Linefeeds? Carriage returns? Carriage-return/linefeed pairs? If it's something other than linefeeds, you'll need a LINES TERMINATED BY clause. Please help me. Thank you. -- Sebastian Stan [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Finding an ID between two dates
Quotes missing around dates. WHERE 2003-03-14 ... Ignatius - Original Message - From: Cory Hicks [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 9:05 PM Subject: Finding an ID between two dates Hey folks! I am stumpedbeen reading the online manual, google groups, to no avail. I have a very simple table: time_period_id int(11) NOT NULL auto_increment, time_period_start date NOT NULL default '-00-00', time_period_end date NOT NULL default '-00-00', PRIMARY KEY (time_period_id) I am trying to get the ID that relates to a date falling between the range of time_period_start(2003-03-01) and time_period_end(2003-03-15): $sql = SELECT time_period_id FROM time_periods WHERE 2003-03-14 BETWEEN time_period_start AND time_period_end; I should get one result form the query, the id, but I get no results. Advice? Helpful hints always welcome.. Many thanks! Cory -- Cory Hicks Texas Research International, Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Exclude CREATE TEMPORARY TABLE from log-bin / replication?
It would be nice to have the possibility to exclude CREATE TEMPORARY TABLE statements from the log bin. Because such statements are really used not for updating a DB, but for constructing intermediary statements that eventually derive in a final INSERT/ UPDATE. I believe only this final statement should belong to the log bin. I have set up a replicated system, and the large number of CREATE TEMPORARY TABLE performed on the Master DB is a needless drag on the system. Anybody can enlight me on this subject? Thanks Ignatius MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql problem
Syntax errors. Try: SELECT studenti.* FROM studenti LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid WHERE ISNULL( valutazioni.sid ) Ignatius - Original Message - From: Francesco [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 4:55 PM Subject: mysql problem Hello, I tried to execute the following query: SELECT studenti.* FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid WHERE valutazioni.sid IS NULL; and give me the following error message: ERROR 1066: Not unique table/alias: 'valutazioni' I have the Mysql 4.0.1 alpha version. I want to know what is the problem. - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php