/dports/databases/mariadb105-client/mariadb-10.5.15/storage/columnstore/columnstore/dbcon/ddlpackage/sql/examples/ |
H A D | alter-table.sql | 5 ALTER TABLE tbl_name ADD COLUMN col_name char(8); 7 ALTER TABLE tbl_name ADD COLUMN col_name bit; 8 ALTER TABLE tbl_name ADD COLUMN col_name bit(8); 9 ALTER TABLE tbl_name ADD COLUMN col_name bit(63); 19 ALTER TABLE tbl_name ADD COLUMN col_name int; 24 ALTER TABLE tbl_name ADD COLUMN col_name date; 34 ALTER TABLE tbl_name ADD col_name int; 35 ALTER TABLE tbl_name ADD col_name CHAR (4); 79 alter table tbl_name add unique(col_name); 145 alter table tbl_name set unused col_name; [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/dbcon/ddlpackage/sql/examples/ |
H A D | alter-table.sql | 5 ALTER TABLE tbl_name ADD COLUMN col_name char(8); 7 ALTER TABLE tbl_name ADD COLUMN col_name bit; 8 ALTER TABLE tbl_name ADD COLUMN col_name bit(8); 9 ALTER TABLE tbl_name ADD COLUMN col_name bit(63); 19 ALTER TABLE tbl_name ADD COLUMN col_name int; 24 ALTER TABLE tbl_name ADD COLUMN col_name date; 34 ALTER TABLE tbl_name ADD col_name int; 35 ALTER TABLE tbl_name ADD col_name CHAR (4); 79 alter table tbl_name add unique(col_name); 145 alter table tbl_name set unused col_name; [all …]
|
/dports/databases/spatialite/libspatialite-5.0.1/src/spatialite/ |
H A D | dbobj_scopes.c | 70 const char *tbl_name) in scope_is_spatial_table() argument 87 tbl_name); in scope_is_spatial_table() 109 const char *tbl_name) in scope_is_topology() argument 199 const char *tbl_name) in scope_is_topology_view() argument 346 const char *tbl_name) in scope_is_raster_coverage() argument 532 const char *tbl_name) in scope_is_topology_index() argument 1064 const char *tbl_name) in scope_is_network_index() argument 1432 const char *tbl_name) in scope_is_raster_coverage_index() argument 2000 xprefix, tbl_name); in scope_is_geometry_trigger() 2103 tbl_name); in scope_is_spatial_view() [all …]
|
/dports/www/piwigo/piwigo/include/ |
H A D | ws_functions.inc.php | 36 function ws_std_image_sql_filter( $params, $tbl_name='' ) argument 41 $clauses[] = $tbl_name.'rating_score>='.$params['f_min_rate']; 45 $clauses[] = $tbl_name.'rating_score<='.$params['f_max_rate']; 49 $clauses[] = $tbl_name.'hit>='.$params['f_min_hit']; 53 $clauses[] = $tbl_name.'hit<='.$params['f_max_hit']; 69 $clauses[] = $tbl_name."date_creation<'".$params['f_max_date_created']."'"; 73 $clauses[] = $tbl_name.'width/'.$tbl_name.'height>='.$params['f_min_ratio']; 77 $clauses[] = $tbl_name.'width/'.$tbl_name.'height<='.$params['f_max_ratio']; 81 $clauses[] = $tbl_name.'level <= '.$params['f_max_level']; 89 function ws_std_image_sql_order( $params, $tbl_name='' ) argument [all …]
|
/dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/vcol/inc/ |
H A D | vcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ vcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ vcol_index_name FIRST 53 --echo # HANDLER tbl_name READ vcol_index_name NEXT 56 --echo # HANDLER tbl_name READ vcol_index_name PREV 59 --echo # HANDLER tbl_name READ vcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-vcol=expr 65 --echo # HANDLER tbl_name READ FIRST where vcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-vcol=expr 71 --echo # HANDLER tbl_name READ NEXT where vcol=expr [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/vcol/inc/ |
H A D | vcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ vcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ vcol_index_name FIRST 53 --echo # HANDLER tbl_name READ vcol_index_name NEXT 56 --echo # HANDLER tbl_name READ vcol_index_name PREV 59 --echo # HANDLER tbl_name READ vcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-vcol=expr 65 --echo # HANDLER tbl_name READ FIRST where vcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-vcol=expr 71 --echo # HANDLER tbl_name READ NEXT where vcol=expr [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/vcol/inc/ |
H A D | vcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ vcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ vcol_index_name FIRST 53 --echo # HANDLER tbl_name READ vcol_index_name NEXT 56 --echo # HANDLER tbl_name READ vcol_index_name PREV 59 --echo # HANDLER tbl_name READ vcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-vcol=expr 65 --echo # HANDLER tbl_name READ FIRST where vcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-vcol=expr 71 --echo # HANDLER tbl_name READ NEXT where vcol=expr [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/vcol/inc/ |
H A D | vcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ vcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ vcol_index_name FIRST 53 --echo # HANDLER tbl_name READ vcol_index_name NEXT 56 --echo # HANDLER tbl_name READ vcol_index_name PREV 59 --echo # HANDLER tbl_name READ vcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-vcol=expr 65 --echo # HANDLER tbl_name READ FIRST where vcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-vcol=expr 71 --echo # HANDLER tbl_name READ NEXT where vcol=expr [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/vcol/inc/ |
H A D | vcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ vcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ vcol_index_name FIRST 53 --echo # HANDLER tbl_name READ vcol_index_name NEXT 56 --echo # HANDLER tbl_name READ vcol_index_name PREV 59 --echo # HANDLER tbl_name READ vcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-vcol=expr 65 --echo # HANDLER tbl_name READ FIRST where vcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-vcol=expr 71 --echo # HANDLER tbl_name READ NEXT where vcol=expr [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/vcol/inc/ |
H A D | vcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ vcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ vcol_index_name FIRST 53 --echo # HANDLER tbl_name READ vcol_index_name NEXT 56 --echo # HANDLER tbl_name READ vcol_index_name PREV 59 --echo # HANDLER tbl_name READ vcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-vcol=expr 65 --echo # HANDLER tbl_name READ FIRST where vcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-vcol=expr 71 --echo # HANDLER tbl_name READ NEXT where vcol=expr [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/gcol/inc/ |
H A D | gcol_handler.inc | 26 --echo # HANDLER tbl_name OPEN 35 --echo # HANDLER tbl_name READ gcol_index_name = (value1,value2,...) 50 --echo # HANDLER tbl_name READ gcol_index_name FIRST 53 --echo # HANDLER tbl_name READ gcol_index_name NEXT 56 --echo # HANDLER tbl_name READ gcol_index_name PREV 59 --echo # HANDLER tbl_name READ gcol_index_name LAST 62 --echo # HANDLER tbl_name READ FIRST where non-gcol=expr 65 --echo # HANDLER tbl_name READ FIRST where gcol=expr 68 --echo # HANDLER tbl_name READ NEXT where non-gcol=expr 71 --echo # HANDLER tbl_name READ NEXT where gcol=expr [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/vcol/r/ |
H A D | vcol_handler_aria.result | 15 # HANDLER tbl_name OPEN 24 # HANDLER tbl_name READ vcol_index_name = (value1,value2,...) 43 # HANDLER tbl_name READ vcol_index_name FIRST 47 # HANDLER tbl_name READ vcol_index_name NEXT 51 # HANDLER tbl_name READ vcol_index_name PREV 55 # HANDLER tbl_name READ vcol_index_name LAST 59 # HANDLER tbl_name READ FIRST where non-vcol=expr 63 # HANDLER tbl_name READ FIRST where vcol=expr 67 # HANDLER tbl_name READ NEXT where non-vcol=expr 71 # HANDLER tbl_name READ NEXT where vcol=expr [all …]
|
H A D | vcol_handler_innodb.result | 15 # HANDLER tbl_name OPEN 24 # HANDLER tbl_name READ vcol_index_name = (value1,value2,...) 43 # HANDLER tbl_name READ vcol_index_name FIRST 47 # HANDLER tbl_name READ vcol_index_name NEXT 51 # HANDLER tbl_name READ vcol_index_name PREV 55 # HANDLER tbl_name READ vcol_index_name LAST 59 # HANDLER tbl_name READ FIRST where non-vcol=expr 63 # HANDLER tbl_name READ FIRST where vcol=expr 67 # HANDLER tbl_name READ NEXT where non-vcol=expr 71 # HANDLER tbl_name READ NEXT where vcol=expr [all …]
|