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
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 an open source DBMS which is built, supported and distributed by MySQL(ORACLE).
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
INSERT INTO`table2`(name, email)
SELECT name, email
FROM `table1`