What do you want to save?
Add Code snippet
New code examples
-
Other 2021-11-21 17:48:18
php-pdo-returning-single-row
$DBH = new PDO( "connection string goes here" ); $STH - $DBH -> prepare( "select figure from table1 ORDER BY x LIMIT 1" ); $STH -> execute(); $result = $STH -> fetch(); echo $result ["figure"]; $DBH = null; Add solution -
SQL 2021-11-21 09:43:23
create stored procedure mysql
-- MySQL -- example DELIMITER $$ -- Changes delimiter to $$ so can use ; within the procedure CREATE PROCEDURE select_employees() BEGIN select * from employees limit 1000; -- Use the ; symbol within the procedure END$$ DELIMITER ; -- Resets the del... Add solution -
SQL 2021-11-19 13:09:20
postgresql find biggest table
select schemaname as table_schema, relname as table_name, pg_size_pretty(pg_total_relation_size(relid)) as total_size, pg_size_pretty(pg_relation_size(relid)) as data_size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(re... Add solution -
SQL 2021-11-05 11:07:14
"teradata" avro "bigquery" "google analytics"
#standardSQL CREATE TEMP FUNCTION customDimensionByIndex(indx INT64, arr ARRAY<STRUCT<index INT64, value STRING>>) AS ( (SELECT x.value FROM UNNEST(arr) x WHERE indx=x.index) ); SELECT fullvisitorId, visitId, hit.hitnumber, customD... Add solution
Best helpers
Ranking is empty