Replacing Data in the Database is not working. Please check and review the
below syntax:
A) Type the following from the Command Prompt-
mysqlimport -r(replace)l(lock variables) (dbname) (fname) <E>
B) To Replace while in a Database-
1)Type the following- load data local infile "./(fname)" replace into
table (tname);
C)Another Optional Method of Replacing while in a Database-
1)Type the following- load data local infile "./(fname)" replace
-> into table id
-> fields
-> terminated by ','
-> enclosed by '"';
Terms:
<E> = Press the Enter Key (do not type the greater and less than
symbols)
(dbname) = name of the database (do not type the brackets)
(fname) = name of the file (usually placed in the working directory)
(tname) = name of the table (do not type the brackets)
thanks
---------------------------------------------------------------------
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
