What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-06 22:46:07
sql constraints
NOT NULL # Ensures a column cannot have a NULL value UNIQUE # Ensures all values in a column are unique PRIMARY KEY # Identifies a record in a table, is NOT NULL & UNIQUE FOREIGN KEY # References a unique record from another table CHECK # Ens... Add solution -
CSS 2021-11-05 02:45:18
frontend to backend fetching
mysql> use reactdb; mysql> CREATE TABLE `contacts` ( `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT, `name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `city` varchar(100), `country` varchar(100), `job` varchar(100) ) ENGINE=... Add solution -
SQL 2021-11-02 19:50:09
create proc usong flyway example
DELIMITER $$ DROP PROCEDURE IF EXISTS upgrade_database_1_0_to_2_0 $$ CREATE PROCEDURE upgrade_database_1_0_to_2_0() BEGIN -- rename a table safely IF NOT EXISTS( (SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=... Add solution