Re: deadlocks on concurrent INSERTS

tatement.RETURN_GENERATED_KEYS); ResultSet rsRecordsInsert = mysqlStatement.getGeneratedKeys(); while (rsRecordsInsert.next()) { recordID = rsRecordsInsert.getInt(1);

deadlocks on concurrent INSERTS

h to diagnose this problem and also fix it? Thanks in advance, -- James Neff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: optional date field and NULL

e', (SELECT IF(LENGTH('{date_of_birth}') = 0, NULL, '{date_of_birth}'))) Thanks again, Jim James Neff wrote: I have a table like so: enrollments - ID - INT Name - VARCHAR(45) DateOfBirth - DateTime The DateOfBirth

optional date field and NULL

ng: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') = 0, NULL, '')), Is there a better way to handle optional dates that I am missing? Constructive criticism welcome. Thanks, -- James N

Re: CPUs not being utilized

I don't know the MailWatch application either but I'll share my experience with a multi-threaded application that uses MySQL. I wrote a Java app that uses several threads to process data (we're validating a set of data according to our business rules). Each thread has its own connection to th

Re: How can I do a SELECT without locking the table against updates?

I have this problem too on large tables. Currently my table is 5 million or so but could easily grow to 10 to 50 times that. I ended up adding a field called Status, and then adding an index for the primary key and status fields. Then I do my UPDATES or DELETES for a particular status value

SELECT duplicate set of rows

to do in one SELECT statement, or should I just iterate through a resultset in my application? Thanks in advance, -- James Neff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]