*/ $lang['menu'] = 'Simple MySQL-Client'; $lang['submit_button'] = 'Execute Query and Commit'; $lang['shortcutslabel'] = 'MySQL Helper:'; $lang['shortcut.1.text'] = 'MySQL-Keywords'; $lang['shortcut.1.sql'] = 'SELECT name FROM mysql.help_keyword ORDER BY name'; $lang['shortcut.2.text'] = 'List of Tables'; $lang['shortcut.2.sql'] = 'SELECT DISTINCT TABLE_NAME FROM information_schema.columns WHERE table_schema = \\\'#DATABASENAME#\\\''; $lang['shortcut.3.text'] = 'Columns'; $lang['shortcut.3.sql'] = 'SELECT COLUMN_NAME,COLUMN_DEFAULT,COLUMN_KEY, COLUMN_TYPE, IS_NULLABLE,DATA_TYPE, ORDINAL_POSITION FROM information_schema.columns WHERE table_schema = \\\'#DATABASENAME#\\\' and TABLE_NAME= \\\'___YOUR_TABLE__\\\''; $lang['shortcut.4.text'] = 'Table states'; $lang['shortcut.4.sql'] = 'SELECT * FROM information_schema.INNODB_SYS_TABLESTATS WHERE name like \\\'#DATABASENAME#%\\\''; $lang['shortcut.5.text'] = 'Table infos'; $lang['shortcut.5.sql'] = 'SELECT * FROM information_schema.INNODB_SYS_TABLES WHERE name like \\\'#DATABASENAME#%\\\''; $lang['shortcut.6.text'] = 'Prozesses'; $lang['shortcut.6.sql'] = 'SELECT * FROM information_schema.PROCESSLIST'; $lang['shortcut.7.text'] = 'Sessions'; $lang['shortcut.7.sql'] = 'SELECT * FROM information_schema.SESSION_STATUS'; $lang['templatesLabel'] = 'SQL-Templates:'; $lang['template.1.text'] = 'Select'; $lang['template.1.sql'] = 'SELECT * FROM WHERE ='; $lang['template.2.text'] = 'Update'; $lang['template.2.sql'] = 'UPDATE SET =,= WHERE ='; $lang['template.3.text'] = 'Delete'; $lang['template.3.sql'] = 'DELETE FROM WHERE ='; $lang['template.4.text'] = 'Insert'; $lang['template.4.sql'] = 'INSERT INTO ( ,, ) VALUES ( ,, )'; $lang['emptyresult'] = 'Query successfully executed -> empty result'; $lang['queryexecuted'] ='SQL was executed and data was changed: '; $lang['queriesnotexecuted'] = 'SQL(s) was not executed!'; $lang['errordbconnection'] ='Cancel: no database connection available!'; $lang['yes'] ='yes'; $lang['no'] ='no'; $lang['nextresult'] = 'Next result:'; $lang['firstresult'] = 'Result:'; $lang['missingpermission'] ='No permissions, access denied!'; //Setup VIM: ex: et ts=4 :