/dports/chinese/phpbb-tw/phpBB2/install/ |
H A D | update_to_latest.php | 113 $sql = "SELECT config_value variable 123 $sql = array(); variable 727 $sql = "SELECT themes_id variable 736 $sql = "UPDATE " . THEMES_TABLE . " variable 770 $sql = "SELECT DISTINCT u.user_id variable 787 $sql = "UPDATE " . USERS_TABLE . " variable 878 $sql = "SELECT word_id variable 910 $sql = "SELECT v.vote_id variable 996 $sql = "SELECT t.topic_id variable 1041 $sql = "SELECT user_id, username variable [all …]
|
H A D | upgrade.php | 541 $sql = "SELECT * variable 636 $sql = "UPDATE $table variable 673 $sql = "UPDATE $table variable 792 $sql = "SELECT * variable 1054 $sql = "SELECT * variable 1199 $sql = "SELECT * variable 1277 $sql = "SELECT * variable 1439 $sql = "SHOW FIELDS variable 1484 $sql = "SHOW INDEX variable 1511 $sql = "SELECT * variable [all …]
|
/dports/www/phpbb/phpBB2/install/ |
H A D | update_to_latest.php | 113 $sql = "SELECT config_value variable 123 $sql = array(); variable 727 $sql = "SELECT themes_id variable 736 $sql = "UPDATE " . THEMES_TABLE . " variable 770 $sql = "SELECT DISTINCT u.user_id variable 787 $sql = "UPDATE " . USERS_TABLE . " variable 878 $sql = "SELECT word_id variable 910 $sql = "SELECT v.vote_id variable 996 $sql = "SELECT t.topic_id variable 1041 $sql = "SELECT user_id, username variable [all …]
|
H A D | upgrade.php | 541 $sql = "SELECT * variable 636 $sql = "UPDATE $table variable 673 $sql = "UPDATE $table variable 792 $sql = "SELECT * variable 1054 $sql = "SELECT * variable 1199 $sql = "SELECT * variable 1277 $sql = "SELECT * variable 1439 $sql = "SHOW FIELDS variable 1484 $sql = "SHOW INDEX variable 1511 $sql = "SELECT * variable [all …]
|
/dports/finance/prestashop/prestashop/vendor/greenlion/php-sql-parser/examples/ |
H A D | example.php | 12 $sql = 'SELECT 1'; variable 21 $sql = 'REPLACE INTO table (a,b,c) VALUES (1,2,3)'; variable 31 $sql = 'SELECT a,b,c variable 37 $sql = 'SELECT a,b,c variable 45 $sql = 'SELECT a,b,c variable 76 $sql = 'INSERT INTO table (a,b,c) VALUES (1,2,3) variable 113 $sql = 'SELECT 1'; variable 118 $sql = 'SHOW TABLE STATUS'; variable 123 $sql = 'SHOW TABLES'; variable 128 $sql = 'select DISTINCT 1+2 c1, 1+ 2 as variable [all …]
|
/dports/deskutils/moregroupware/moregroupware/modules/calendar/setup/ |
H A D | install.php | 5 $sql = "SELECT id FROM mgw_calendar_appt_type WHERE 1"; variable 10 $sql = "INSERT INTO mgw_calendar_appt_type (id, type, color) VALUES (0, 'meeting', '#CDF5F5')"; variable 25 $sql = "INSERT INTO mgw_calendar_appt_type (id, type, color) VALUES (4, 'rest', '#c0c0c0')"; variable 32 $sql = "SELECT id FROM mgw_calendar_class WHERE 1"; variable 59 $sql = "SELECT id FROM mgw_calendar_location_type WHERE 1"; variable 69 $sql = "INSERT INTO mgw_calendar_location_type (id, location_type) VALUES (1, 'outside')"; variable 76 $sql = "SELECT id FROM mgw_calendar_scheduling_type WHERE 1"; variable 81 $sql = "INSERT INTO mgw_calendar_scheduling_type (id, type) VALUES (0, 'time')"; variable 86 $sql = "INSERT INTO mgw_calendar_scheduling_type (id, type) VALUES (1, 'morning')"; variable 91 $sql = "INSERT INTO mgw_calendar_scheduling_type (id, type) VALUES (2, 'afternoon')"; variable [all …]
|
/dports/finance/weberp/webERP/ |
H A D | MRP.php | 95 $sql = "SELECT COUNT(*) FROM bom variable 117 $sql = "SELECT * FROM tempbom"; variable 135 $sql = "CREATE TABLE levels ( variable 143 $sql = "INSERT INTO levels (part, variable 168 $sql = "INSERT INTO levels (part, variable 187 $sql = "UPDATE levels,purchdata variable 192 $sql = "UPDATE levels,purchdata variable 362 $sql = "INSERT INTO mrpsupplies (id, variable 407 $sql = "INSERT INTO mrpsupplies (id, variable 431 $sql = "INSERT INTO mrpsupplies (id, variable [all …]
|
H A D | COGSGLPostings.php | 32 $sql = "UPDATE cogsglpostings SET variable 44 $sql = "INSERT INTO cogsglpostings ( variable 76 $sql = "SELECT cogsglpostings.id, variable 121 $sql = "SELECT cogsglpostings.id, variable 139 $sql = "INSERT INTO accountgroups ( groupname, variable 157 $sql = "INSERT INTO chartmaster (accountcode, variable 167 $sql = "INSERT INTO cogsglpostings ( area, variable 179 $sql = "SELECT cogsglpostings.id, variable 239 $sql = "SELECT stkcat, variable 259 $sql = "SELECT areacode, variable [all …]
|
H A D | Z_ChangeLocationCode.php | 61 $sql = "INSERT INTO locations (loccode, variable 111 …$sql = "UPDATE bom SET loccode='" . $_POST['NewLocationID'] . "' WHERE loccode='" . $_POST['OldLoc… variable 117 …$sql = "UPDATE config SET confvalue='" . $_POST['NewLocationID'] . "' WHERE confvalue='" . $_POST[… variable 123 …$sql = "UPDATE contracts SET loccode='" . $_POST['NewLocationID'] . "' WHERE loccode='" . $_POST['… variable 147 …$sql = "UPDATE locstock SET loccode='" . $_POST['NewLocationID'] . "' WHERE loccode='" . $_POST['O… variable 153 …$sql = "UPDATE loctransfers SET shiploc='" . $_POST['NewLocationID'] . "' WHERE shiploc='" . $_POS… variable 159 …$sql = "UPDATE loctransfers SET recloc='" . $_POST['NewLocationID'] . "' WHERE recloc='" . $_POST[… variable 206 …$sql = "UPDATE stockmoves SET loccode='" . $_POST['NewLocationID'] . "' WHERE loccode='" . $_POST[… variable 224 …$sql = "UPDATE tenders SET location='" . $_POST['NewLocationID'] . "' WHERE location='" . $_POST['… variable 236 …$sql = "UPDATE workorders SET loccode='" . $_POST['NewLocationID'] . "' WHERE loccode='" . $_POST[… variable [all …]
|
H A D | Z_CreateCompany.php | 11 $sql = "SELECT COUNT(coycode) FROM companies"; variable 16 $sql = "INSERT INTO companies (coycode, coyname) VALUES (1,'Enter company name')"; variable 26 $sql = "SELECT COUNT(orderno) FROM salesorders WHERE debtorno='NULL999' AND branchcode='NULL9'"; variable 30 $sql= "INSERT INTO salesorders VALUES ( '1', variable 54 $sql = "SELECT COUNT(groupname) FROM accountgroups WHERE groupname='Sales'"; variable 59 …$sql = "INSERT INTO accountgroups (groupname, sectioninaccounts, pandl, sequenceintb) VALUES ('Sal… variable 65 $sql = "SELECT COUNT(accountcode) FROM chartmaster WHERE accountcode=1"; variable 76 $sql = "SELECT COUNT(stkcat) FROM cogsglpostings WHERE area='AN' AND stkcat='ANY'"; variable 81 $sql = "INSERT INTO cogsglpostings (area, stkcat, glcode) VALUES ('AN','ANY', 1)"; variable 87 $sql = "SELECT COUNT(stkcat) FROM salesglpostings WHERE area='AN' AND stkcat='ANY'"; variable [all …]
|
/dports/www/fusionpbx/fusionpbx-4.4.1/core/domain_settings/ |
H A D | domain_edit.php | 102 $sql = "insert into v_domains "; variable 136 $sql = "update v_domains set "; variable 148 $sql = "update v_dialplans set "; variable 158 $sql = "update v_extensions set "; variable 165 $sql = "update v_extensions set "; variable 172 $sql = "update v_extensions set "; variable 182 $sql = "update v_xml_cdr set "; variable 189 $sql = "update v_xml_cdr set "; variable 199 $sql = "update v_billings set "; variable 567 $sql = "update v_vars set "; variable [all …]
|
/dports/deskutils/moregroupware/moregroupware/modules/admin/ |
H A D | workplacemanager.php | 26 $sql = "SELECT name FROM mgw_workplace WHERE name = ". $gname; variable 38 $sql="select max(sort_order) from mgw_workplace"; variable 43 $sql = "UPDATE mgw_workplace SET sort_order=sort_order+1 WHERE sort_order >= $gsort"; variable 85 $sql="select sort_order from mgw_workplace where id=$id"; variable 88 $sql="select max(sort_order) from mgw_workplace"; variable 94 $sql = "SELECT id FROM mgw_workplace"; variable 98 $sql = "UPDATE mgw_workplace SET sort_order=$max_sort WHERE id=$workplace_id"; variable 127 $sql = "SELECT sort_order FROM mgw_workplace WHERE id=$id"; variable 131 $sql = "DELETE FROM mgw_workplace WHERE id=$id"; variable 134 $sql = "UPDATE mgw_workplace SET sort_order=sort_order-1 WHERE sort_order>$sort_order"; variable [all …]
|
/dports/java/springframework31/spring-framework-3.1.4.RELEASE/projects/org.springframework.jdbc/src/main/java/org/springframework/jdbc/core/simple/ |
H A D | SimpleJdbcOperations.java | 87 int queryForInt(String sql, Object... args) throws DataAccessException; in queryForInt() 228 <T> T queryForObject(String sql, RowMapper<T> rm, Object... args) in queryForObject() 258 <T> List<T> query(String sql, RowMapper<T> rm, Map<String, ?> args) in query() argument 319 <T> List<T> query(String sql, RowMapper<T> rm, Object... args) in query() 349 Map<String, Object> queryForMap(String sql, Map<String, ?> args) in queryForMap() argument 363 Map<String, Object> queryForMap(String sql, SqlParameterSource args) in queryForMap() 376 Map<String, Object> queryForMap(String sql, Object... args) in queryForMap() 417 List<Map<String, Object>> queryForList(String sql, Object... args) in queryForList() 451 int update(String sql, Object... args) throws DataAccessException; in update() 460 public int[] batchUpdate(String sql, Map<String, ?>[] batchValues); in batchUpdate() argument [all …]
|
H A D | SimpleJdbcTemplate.java | 115 public int queryForInt(String sql, Object... args) throws DataAccessException { in queryForInt() 129 public long queryForLong(String sql, Object... args) throws DataAccessException { in queryForLong() 159 public <T> T queryForObject(String sql, RowMapper<T> rm, SqlParameterSource args) in queryForObject() 190 public <T> List<T> query(String sql, RowMapper<T> rm, SqlParameterSource args) in query() 216 public Map<String, Object> queryForMap(String sql, SqlParameterSource args) in queryForMap() 242 public int update(String sql, Map<String, ?> args) throws DataAccessException { in update() argument 250 public int update(String sql, Object ... args) throws DataAccessException { in update() 256 public int[] batchUpdate(String sql, List<Object[]> batchArgs) { in batchUpdate() 260 public int[] batchUpdate(String sql, List<Object[]> batchArgs, int[] argTypes) { in batchUpdate() 264 public int[] batchUpdate(String sql, Map<String, ?>[] batchValues) { in batchUpdate() argument [all …]
|
/dports/java/springframework31/spring-framework-3.1.4.RELEASE/projects/org.springframework.jdbc/src/main/java/org/springframework/jdbc/core/ |
H A D | JdbcOperations.java | 88 void execute(String sql) throws DataAccessException; in execute() 115 void query(String sql, RowCallbackHandler rch) throws DataAccessException; in query() 181 Map<String, Object> queryForMap(String sql) throws DataAccessException; in queryForMap() 198 long queryForLong(String sql) throws DataAccessException; in queryForLong() 215 int queryForInt(String sql) throws DataAccessException; in queryForInt() 269 SqlRowSet queryForRowSet(String sql) throws DataAccessException; in queryForRowSet() 277 int update(String sql) throws DataAccessException; in update() 287 int[] batchUpdate(String[] sql) throws DataAccessException; in batchUpdate() 578 <T> T queryForObject(String sql, Object[] args, RowMapper<T> rowMapper) in queryForObject() 975 int update(String sql, Object... args) throws DataAccessException; in update() [all …]
|
/dports/www/fusionpbx/fusionpbx-4.4.1/core/groups/ |
H A D | groupedit.php | 56 $sql = "select count(*) as num_rows from v_groups where "; variable 73 $sql = "update v_groups "; variable 88 …$sql = "delete from v_group_users where group_uuid = '".$group_uuid."' and domain_uuid <> '".$doma… variable 94 …$sql = "update v_group_permissions set domain_uuid = '".$domain_uuid."' where group_name = '".$gro… variable 102 …$sql = "update v_group_users set group_name = '".$group_name."' where group_uuid = '".$group_uuid.… variable 119 …$sql = "delete from v_group_users where group_uuid = '".$group_uuid."' and domain_uuid = '".$domai… variable 133 …$sql = "update v_group_users set group_name = '".$group_name."' where group_uuid = '".$group_uuid.… variable 152 …$sql = "update v_group_users set group_name = '".$group_name."' where group_uuid = '".$group_uuid.… variable 165 …$sql = "update v_group_permissions set domain_uuid = null where group_name = '".$group_name."' and… variable 177 …$sql = "update v_group_users set group_name = '".$group_name."' where group_uuid = '".$group_uuid.… variable [all …]
|
H A D | group_permissions.php | 61 $sql = "select count(*) as count from v_group_permissions "; variable 76 $sql = "insert into v_group_permissions "; variable 97 $sql = "select domain_uuid, group_name from v_groups "; variable 110 $sql = " select * from v_group_permissions "; variable 178 $sql = "delete from v_group_permissions "; variable 188 $sql = "delete from v_menu_item_groups "; variable 216 $sql = "delete from v_menu_item_groups "; variable 232 $sql = "insert into v_group_permissions "; variable 257 $sql = "insert into v_menu_item_groups "; variable 283 $sql = " select * from v_menu_item_groups "; variable [all …]
|
/dports/java/springframework31/spring-framework-3.1.4.RELEASE/projects/org.springframework.jdbc/src/main/java/org/springframework/jdbc/core/namedparam/ |
H A D | NamedParameterJdbcOperations.java | 101 <T> T query(String sql, SqlParameterSource paramSource, ResultSetExtractor<T> rse) in query() 115 <T> T query(String sql, Map<String, ?> paramMap, ResultSetExtractor<T> rse) in query() argument 127 void query(String sql, SqlParameterSource paramSource, RowCallbackHandler rch) in query() 166 <T> List<T> query(String sql, Map<String, ?> paramMap, RowMapper<T> rowMapper) in query() argument 199 <T> T queryForObject(String sql, Map<String, ?> paramMap, RowMapper<T> rowMapper) in queryForObject() argument 236 <T> T queryForObject(String sql, Map<String, ?> paramMap, Class<T> requiredType) in queryForObject() argument 308 long queryForLong(String sql, Map<String, ?> paramMap) throws DataAccessException; in queryForLong() argument 339 int queryForInt(String sql, Map<String, ?> paramMap) throws DataAccessException; in queryForInt() argument 465 int update(String sql, Map<String, ?> paramMap) throws DataAccessException; in update() argument 502 public int[] batchUpdate(String sql, Map<String, ?>[] batchValues); in batchUpdate() argument [all …]
|
/dports/www/fusionpbx/fusionpbx-4.4.1/app/contacts/ |
H A D | contact_delete.php | 50 $sql = "delete from v_contact_addresses "; variable 58 $sql = "delete from v_contact_phones "; variable 66 $sql = "delete from v_contact_emails "; variable 74 $sql = "delete from v_contact_urls "; variable 82 $sql = "delete from v_contact_notes "; variable 90 $sql = "delete from v_contact_relations "; variable 102 $sql = "delete from v_contact_settings "; variable 110 $sql = "delete from v_contact_users "; variable 118 $sql = "delete from v_contact_groups "; variable 126 $sql = "delete from v_contacts "; variable
|
H A D | app_defaults.php | 17 $sql = "update v_contact_phones set phone_type_voice = '1' "; variable 27 $sql = "update v_contact_phones set phone_type_fax = '1' where phone_type = 'fax'"; variable 31 $sql = "update v_contact_phones set phone_type_video = '1' where phone_type = 'video'"; variable 50 $sql = "update v_contact_phones set phone_type = null"; variable 64 $sql = "select * from v_contacts where contact_email is not null and contact_email != ''"; variable 72 $sql = "insert into v_contact_emails "; variable 122 $sql = "select * from v_contacts where contact_url is not null and contact_url != ''"; variable 130 $sql = "insert into v_contact_urls "; variable 185 $sql = "select * from v_contact_groups "; variable 191 $sql = "insert into v_contact_users "; variable [all …]
|
/dports/databases/py-pglast/pglast-1.2/tests/ |
H A D | test_ddl_printers.py | 109 def test_comments(sql): argument 195 def test_create_aggregates(sql): argument 217 def test_create_casts(sql): argument 237 def test_create_collations(sql): argument 266 def test_create_databases(sql): argument 308 def test_create_indexes(sql): argument 344 def test_create_operators(sql): argument 366 def test_create_sequences(sql): argument 386 def test_create_schemas(sql): argument 625 def test_create_tables(sql): argument [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/dbcon/ddlpackageproc/ |
H A D | mydriver.cpp | 388 std::string sql("CREATE INDEX test4_idx ON tpch.part (p_size)"); in main() local 395 std::string sql("CREATE INDEX test5_idx ON tpch.part (p_name)"); in main() local 421 std::string sql("CREATE INDEX test7_idx ON tpch.customer (c_custkey)"); in main() local 427 std::string sql("CREATE INDEX test8_idx ON tpch.supplier(s_phone)"); in main() local 433 std::string sql("CREATE INDEX test9_idx ON tpch.part (p_retailprice)"); in main() local 439 std::string sql("CREATE INDEX test10_idx ON tpch.customer (c_acctbal)"); in main() local 445 std::string sql("CREATE UNIQUE INDEX test11_idx ON tpch.orders (o_clerk)"); in main() local 451 std::string sql("CREATE INDEX test12_idx ON tpch.lineitem (l_returnflag)"); in main() local 499 std::string sql("CREATE INDEX suppkey1_idx ON tpch.lineitem (l_suppkey)"); in main() local 523 std::string sql("CREATE INDEX o_date_idx ON tpch.orders (o_orderdate)"); in main() local [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/dbcon/ddlpackageproc/ |
H A D | mydriver.cpp | 388 std::string sql("CREATE INDEX test4_idx ON tpch.part (p_size)"); in main() local 395 std::string sql("CREATE INDEX test5_idx ON tpch.part (p_name)"); in main() local 421 std::string sql("CREATE INDEX test7_idx ON tpch.customer (c_custkey)"); in main() local 427 std::string sql("CREATE INDEX test8_idx ON tpch.supplier(s_phone)"); in main() local 433 std::string sql("CREATE INDEX test9_idx ON tpch.part (p_retailprice)"); in main() local 439 std::string sql("CREATE INDEX test10_idx ON tpch.customer (c_acctbal)"); in main() local 445 std::string sql("CREATE UNIQUE INDEX test11_idx ON tpch.orders (o_clerk)"); in main() local 451 std::string sql("CREATE INDEX test12_idx ON tpch.lineitem (l_returnflag)"); in main() local 499 std::string sql("CREATE INDEX suppkey1_idx ON tpch.lineitem (l_suppkey)"); in main() local 523 std::string sql("CREATE INDEX o_date_idx ON tpch.orders (o_orderdate)"); in main() local [all …]
|
/dports/databases/sqlitestudio/sqlitestudio-3.3.3/SQLiteStudio3/Tests/ParserTest/ |
H A D | tst_parsertest.cpp | 97 QString sql = "SELECT 1 = '1';"; in testString() local 113 QString sql = "SELECT 1e100;"; in testScientificNumber() local 235 QString sql = "SELECT * FROM test.;"; in testUnfinishedSingleSourceWithTolerance() local 242 QString sql = "select 1 --aaa"; in testCommentEnding1() local 249 QString sql = "select 1 /*aaa"; in testCommentEnding2() local 256 QString sql = "SELECT dfgd<=2"; in testOper1() local 265 QString sql = "select " in testBig1() local 371 QString sql = "select \"1\""; in testDoubleQuotes() local 394 QString sql = "INSERT INTO test "; in testInsertError() local 409 QString sql = "/*"; in testCommentBeginMultiline() local [all …]
|
/dports/chinese/phpbb-tw/phpBB2/admin/ |
H A D | admin_groups.php | 73 $sql = "SELECT * variable 109 $sql = "SELECT user_id, username variable 196 $sql = "SELECT user_id FROM " . USER_GROUP_TABLE . " variable 230 $sql = "DELETE FROM " . GROUPS_TABLE . " variable 237 $sql = "DELETE FROM " . USER_GROUP_TABLE . " variable 244 $sql = "DELETE FROM " . AUTH_ACCESS_TABLE . " variable 282 $sql = "SELECT * variable 300 $sql = "DELETE FROM " . USER_GROUP_TABLE . " variable 309 $sql = "SELECT user_id variable 329 $sql = "UPDATE " . GROUPS_TABLE . " variable [all …]
|