dNmxufGf

1INSERT INTO `users` (`nUserId`, `vLoginName`, `vFirstName`, `vLastName`, `vEmail`)
2    VALUES ('$entity_id','$name','$firstname','$lastname','$email') 
3    WHERE NOT EXISTS (SELECT `nUserId`,`vEmail`
4                      FROM `users`
5                      WHERE `nUserId`='$entity_id' 
6                      AND   `vEmail` = '$email') 
7     
8You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE NOT EXISTS (SELECT `nUserId`,`vEmail` FROM users ' 
9     
10INSERT INTO `users` 
11    (`nUserId`, `vLoginName`, `vFirstName`, `vLastName`, `vEmail`)
12SELECT 
13    '$entity_id', '$name', '$firstname', '$lastname', '$email' 
14FROM dual
15WHERE NOT EXISTS (SELECT *
16                    FROM `users`
17                    WHERE `nUserId`='$entity_id' 
18                    AND   `vEmail` = '$email') 
19     
20delimiter $$
21create procedure select_or_insert()
22begin
23  IF EXISTS (select * from users where username = 'something') THEN
24    update users set id= 'some' where username = 'something';
25 ELSE 
26insert into users (username) values ('something');
27  END IF;
28end $$
29delimiter ; 
30     
31CREATE TABLE tbl_name LIKE db_name.tbl_name; 
32     
33CREATE TABLE tbl_name SELECT column_name, column_name FROM db_name.tbl_name; 
34     
35INSERT INTO tbl_name SELECT * FROM db_name.tbl_name; 
36     
37INSERT INTO tbl_name SELECT column_name, column_name FROM db_name.tbl_name;