TIME NOW
World current time now,
CALENDAR
Calendar monthly, yearly
login CONVERT LENGTH
login CONVERT TEMPERATURE
login DICTIONARIES, LISTS
login SCIENCE EDUCATION RELIGION
login WORK CALCULATOR
login CALCULATE LIFE

MYSQL dabatase. How to, tutorial, examples

Previous articlePage bottomNext article  ALL TOPICS

Mysql. insert select query example

 
INSERT Into t_songs_tmp (`id_r`, `name`, `text`)
SELECT `t_songs`.`id_r`, `t_songs`.`name`, `t_songs`.`author`
FROM `t_songs`, `t_songs` AS `vtable`
WHERE trim(`vtable`.`name`) = trim(`t_songs`.`name`) and `vtable`.`author` = `t_songs`.`author` and `vtable`.`name` <> `t_songs`.`name`
 
Previous articlePage topNext article  ALL TOPICS



 Use username: Guest, Anonymous, Programmer






QUOTES:
Without music, life would be a mistake.
Friedrich Nietzsche
The ''kingdom of Heaven'' is a condition of the heart -not something that comes ''upon the earth'' or ''after death.
Friedrich Nietzsche
Honey, I forgot to duck.
Ronald Reagan