Browse SQL Code Examples

What do you want to save?

Add Code snippet

New code examples in category SQL

Awgiedawgie 2022-05-13 23:06:04
mysql smallint range
-- SIGNED UNSIGNED -- Min Max Min Max TINYINT -128 127 0 255 SMALLINT -32767 32767 0 65535 MEDIUMINT -8388608 ... Add solution
Awgiedawgie 2022-05-13 23:00:31
sql get most recent record
# Use the aggregate MAX(signin) grouped by id. This will list the most recent signin for each id. SELECT id, MAX(signin) AS most_recent_signin FROM tbl GROUP BY id # To get the whole single record, perform an INNER JOIN against a subquery which retu... Add solution
Awgiedawgie 2022-05-13 22:47:28
input in mysql
-- Example for MysQL: SET @my_Id:=30; SELECT * FROM my_table WHERE [email protected]_Id; -- Example in Oracle: SELECT * FROM my_table WHERE id = :my_id; Add solution
Phoenix Logan 2022-05-13 22:47:25
set nocount on sql server
DECLARE @NOCOUNT VARCHAR(3) = 'OFF'; IF ( (512 & @@OPTIONS) = 512 ) SET @NOCOUNT = 'ON'; SELECT @NOCOUNT AS NOCOUNT; Add solution
Krish 2022-05-13 22:40:40
mysql show create db
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name If the SHOW statement includes an IF NOT EXISTS clause, the output too includes such a clause. SHOW CREATE SCHEMA is a synonym for SHOW CREATE DATABASE. Add solution
Phoenix Logan 2022-05-13 22:35:29
azure sql server check foreign key
select schema_name(fk_tab.schema_id) + '.' + fk_tab.name as foreign_table, '>-' as rel, schema_name(pk_tab.schema_id) + '.' + pk_tab.name as primary_table, substring(column_names, 1, len(column_names)-1) as [fk_columns], fk.name as fk_c... Add solution
Krish 2022-05-13 22:16:11
sqlite3 read only
sqlite3 -cmd ".timeout 5000" "file:/pathto/mydb?mode=ro" Add solution
Awgiedawgie 2022-05-13 20:40:01
how to install mysql 8.0 windows service
Press CTRL+C to copy C:\> "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld" --install MySQL --defaults-file=C:\my-opts.cnf Add solution
Awgiedawgie 2022-05-13 19:57:01
mysql grant user privileges to database that has suffix and prefix
GRANT ALL PRIVILEGES ON `PREFIX\_%_\SUFFIX`.* TO 'USER'@'HOST' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION; Add solution
Awgiedawgie 2022-05-13 19:41:37
mysql loop
-- MySQL LOOP, ITERATE, LEAVE, loop label CREATE PROCEDURE LoopDemo() BEGIN DECLARE x INT; DECLARE str VARCHAR(255); SET x = 1; SET str = ''; loop_label: LOOP IF x > 10 THEN LEAVE loop_label; END IF; SET x = x + 1; IF (x mod 2... Add solution

Best helpers

Ranking is empty

Made with love

Create a Free Account

Sign up to unlock all of IQCode features:

Master useful skills
Improve learning outcomes
Share your knowledge

Create an account