Beginner - Replacing Data in the Database

["raezor" <raezor@xxxxxxxxxxxx>]

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 <mysql-thread92262@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php