sql query problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mayanktalwar1988
Forum Contributor
Posts: 133
Joined: Wed Jul 08, 2009 2:44 am

sql query problem

Post by mayanktalwar1988 »

Code: Select all

insert into distinctlinks select * from distinctfiller except select * from distinctlinks
is the above query the valid one or not? because it is not performing what i want it to perform

the tables structure are as follows

distinctfiller has one attribute checkinks(text)
distictlinks has one attribute precrawl(text)

just tell this query is the valid or not
altafhussain
Forum Newbie
Posts: 16
Joined: Sun Feb 07, 2010 9:42 am

Re: sql query problem

Post by altafhussain »

always sub queries written in () brackets so wrote in brackets ()
mayanktalwar1988
Forum Contributor
Posts: 133
Joined: Wed Jul 08, 2009 2:44 am

Re: sql query problem

Post by mayanktalwar1988 »

yup its working
Post Reply