DELETE - error_count

2008-10-17 Thread Reyna.Sabina
Hi, Running Environment: MySQL Server version: 5.0.45 OS is Red-Hat 64-bit The table 'junk' doesn't have a row with id=4. Two tests to trap 'errors' using DELETE follows: (1) linux>sqlstmt="USE test; DELETE FROM junk WHERE id =4; SELECT @@error_count;" linux>mysal -e "$sqlstmt" +--

LOAD - updates?

2008-10-16 Thread Reyna.Sabina
Hello, Running Environment: MySQL Server version: 5.0.45 OS is Red-Hat 64-bit A test using mysql -e "LOAD table ..." was ran to see if "LOAD' will give an error when loading a record with the same primary-key of an existing record in the table. LOAD acted as an UPDATE statement and it didn'

LOAD - failure for a non-admin user

2008-10-01 Thread Reyna.Sabina
Hi, I am using MySQL 5.0.45, for redhat-linux-gnu (x86_64). I created a new database called HYDRO (user: admin). I created a new user called 'hydro' in the 'localhost' ([EMAIL PROTECTED]) without a password. User 'hydro' has given all provileges except the ' Grant_priv'. As user 'hydro', I can d