mysql
SELECT CONCAT(first_name, ' ', last_name) AS 'Name', dept FROM users;
Source: gist.github.com
mysql
DELETE FROM table_name;
mysql
UPDATE mysql.user SET host='%' WHERE user='root';
Source: stackoverflow.com
MYSQL
delimiter $$ create procedure select_or_insert() begin IF EXISTS (select * from users where username = 'something') THEN update users set id= 'some' where username = 'something'; ELSE insert into users (username) values ('something'); END IF; end $$ delimiter ;
Source: dba.stackexchange.com
mysql
sudo mysql -u root -p
mysql
GROUP_CONCAT(IF(column1='', null, column1))
Source: stackoverflow.com
MySQL
INSERT INTO`table2`(name, email) SELECT name, email FROM `table1`
Source: www.getsolved.com
mysql
DELETE FROM `utilisateur` WHERE `id` = '2';
Source: openclassrooms.com
mysql
json_extract(bms, '$.cell_voltage_1')