SELECT MAX(consumer_id) AS maxID FROM oauth_consumers INSERT INTO oauth_consumers (consumer_id, name, fullname, email, ckey, csecret, editor_id, datecreated) VALUES ( , , , , , , , CURRENT_TIMESTAMP ) SELECT consumer_id, name, fullname, email, ckey, csecret, editor_id, datecreated FROM oauth_consumers WHERE ckey = UPDATE oauth_consumers SET #sComma# name = #sComma# fullname = #sComma# email = #sComma# csecret = #sComma# ckey = #sComma# editor_id = #sComma# datecreated = CURRENT_TIMESTAMP WHERE consumer_id = DELETE FROM oauth_consumers WHERE consumer_id = SELECT consumer_id, name, fullname, email, csecret, ckey, editor_id, datecreated FROM oauth_consumers ORDER BY consumer_id ORDER BY name ORDER BY fullname ORDER BY email ORDER BY ckey ORDER BY csecret ORDER BY datecreated ORDER BY editor_id ORDER BY datecreated, consumer_id ASC SELECT COUNT(consumer_id) AS consumerCount FROM oauth_consumers