# Copyright (C) 2008 Sun Microsystems, Inc. All rights reserved. # Use is subject to license terms. # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; version 2 of the License. # # This program is distributed in the hope that it will be useful, but # WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU # General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 # USA query: insert | update | select | delete | transaction ; select: SELECT _data , _field FROM _table ORDER BY RAND() LIMIT 1; insert: INSERT INTO _table ( _field ) VALUES ( _data ) ; update: UPDATE _table SET _field = _data ORDER BY RAND() LIMIT 1 ; delete: DELETE FROM _table WHERE _field = _data ORDER BY RAND () LIMIT 1 ; transaction: START TRANSACTION | COMMIT | ROLLBACK ;