Home
last modified time | relevance | path

Searched defs:sql (Results 1 – 25 of 5065) sorted by relevance

12345678910>>...203

/dports/chinese/phpbb-tw/phpBB2/install/
H A Dupdate_to_latest.php113 $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 Dupgrade.php541 $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 Dupdate_to_latest.php113 $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 Dupgrade.php541 $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 Dexample.php12 $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 Dinstall.php5 $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 DMRP.php95 $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 DCOGSGLPostings.php32 $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 DZ_ChangeLocationCode.php61 $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 DZ_CreateCompany.php11 $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 Ddomain_edit.php102 $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 Dworkplacemanager.php26 $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 DSimpleJdbcOperations.java87 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 DSimpleJdbcTemplate.java115 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 DJdbcOperations.java88 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 Dgroupedit.php56 $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 Dgroup_permissions.php61 $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 DNamedParameterJdbcOperations.java101 <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 Dcontact_delete.php50 $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 Dapp_defaults.php17 $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 Dtest_ddl_printers.py109 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 Dmydriver.cpp388 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 Dmydriver.cpp388 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 Dtst_parsertest.cpp97 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 Dadmin_groups.php73 $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 …]

12345678910>>...203