Hi Jon,
you can :
DELETE FROM db_test.tbl_dbaddr;
This would delete all data in db_test.tbl_dbaddr by first dropping the
whole table and then rebuild it again.
You can of curse add a 'WHERE CLAUSE' to determin which rows shall be
deleted.
This is from the HTML-manual:
Duplicates indicates the number of rows that couldn't be inserted because
they would duplicate some existing unique index value. Warnings indicates
the number of attempts to insert column values that were problematic in some
way. Warnings can occur under any of the following conditions:
Inserting NULL into a column that has been declared NOT NULL. The column is
set to its default value.
Setting a numeric column to a value that lies outside the column's range.
The value is clipped to the appropriate endpoint of the range.
Setting a numeric column to a value such as '10.34 a'. The trailing garbage
is stripped and the remaining numeric part is inserted. If the value doesn't
make sense as a number at all, the column is set to 0.
Inserting a string into a CHAR, VARCHAR, TEXT, or BLOB column that exceeds
the column's maximum length. The value is truncated to the column's maximum
length.
Inserting a value into a date or time column that is illegal for the column
type. The column is set to the appropriate zero value for the type.
I think the warnings occur in the binary log-files (under the
MySQL-Server-root) , but I think , you must set a Server-variable to get
this.
I'd recommend to read the online-manual , which is really fine to read or
better - buy the fantastiv book of Paul DuBois , which is nice and easy to
read.
I think there are some people on the list (not me my dear) , that don't like
you to ask questions , that aren't difficult to find in
the manual or the faq's.
Just think of everyone on the list has more than 100 mails every day.
I miss Ed Carp for his ultimate statements when his blood-sugar was low ;-)
, his comments about people that didn't read the manual where extreme.
Prosit
Klaus
---------------------------------------------------------------------
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
