xxxxxxxxxx
MySQL is an open source DBMS which is built, supported and distributed by MySQL(ORACLE).
xxxxxxxxxx
MySQL is an open source relational database management system. Where sql stands
for Sturctured Query Language And My is drived from the co-founder's daughter name 'My'
Name Of Co-founder : "Michael Widenius"
xxxxxxxxxx
MySQL is a database management system if u want to read more about here is the source https://en.wikipedia.org/wiki/MySQL
xxxxxxxxxx
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 ;
xxxxxxxxxx
SELECT list is not in GROUP BY clause and contains nonaggregated column
incompatible with sql_mode=only_full_group_by .
///in mysql write this and excute
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
xxxxxxxxxx
INSERT INTO`table2`(name, email)
SELECT name, email
FROM `table1`