RE: LIMIT in MySQL

It is starting at record 30 and sending you the next 60 records. Maybe you want LIMIT 30, 30 ? David -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:56 AM To: [EMAIL PROTECTED] Subject: LIMIT in MySQL I must not be awake yet. Why is

SQL UPDATE question

Filter: SQL, UPDATE Is there a way to do the following in one single statement? I know I can get all of the info from the three tables in a single query using joins... // Start a transaction conn.setAutoCommit(false); // Do the work. stmt = conn.createStatement(); // Update general acct info sS

RE: input data which table first

Well, if you want your main table to have foreign keys into the tables that maintain your other data (Studios, Genres, Actors, etc) then you need to populate your other tables first. You will be referring to those tables when you perform your inserts into your main table to gain access to the corre