What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-29 18:37:02
alter tablespace add datafile autoextend
SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'my_tbs' ORDER BY FILE_NAME; ALTER TABLESPACE my_tbs ADD DATAFILE '/path/to/my_file.dbf' SIZE 100M AUTOEXTEND OFF; -- Autoextend with max size: ALTER TABLESPACE my_tbs ADD DATAFILE '/path/to/my_file.... Add solution -
SQL 2021-09-29 18:26:02
mysql start of today
SELECT * FROM mytable WHERE created_at >= CURDATE() Add solution -
SQL 2021-09-29 06:36:02
mysql find missing values
-- Find missing t1 values in t2 (based on 'id' field) SELECT * FROM t1 WHERE t1.id NOT IN (SELECT id FROM t2); -- or SELECT * FROM t1 WHERE NOT exists ( SELECT NULL FROM t2 WHERE t2.id = t1.id ); -- or SELECT t1.* FROM t1 LEFT OUTER JOIN t2 ON t2.id =... Add solution -
SQL 2021-09-28 15:27:01
wp do sql query from function
<?php // 1st Method - Declaring $wpdb as global and using it to execute an SQL query statement that returns a PHP object global $wpdb; $results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}options WHERE option_id = 1", OBJECT ); Add solution -
-
SQL 2021-09-28 01:33:04
sql select most frequent value in column
SELECT col, COUNT(col) AS value_occurrence FROM m_table GROUP BY col ORDER BY value_occurrence DESC LIMIT 1; -- Oracle <= 11g SELECT * FROM (SELECT col, COUNT(col) AS value_occurrence FROM m_table GROUP BY col ORDER BY value_occurrence DESC) WHERE row... Add solution
Best helpers
Ranking is empty