SQL Help ?!?!

[Pho3nix]

Hi guys,

Need help with a query on SQL. Need to import all the rows from Column B into Column A, aslong as they aren't already there. Tried UPDATE but it is not working. Any pointers?
Just started learning..

 

[LithIX]

Something like the following maybe:

UPDATE

SET ColA =
CASE
WHEN (ColB <> ColA) THEN ColB
ELSE ColA
END

I don't have time to test it though, but I hope it helps

 

[Way69]

Update tablename set columna=columnb where culumna<>columnb

Sent from my GT-P7500 using MyBroadband Android App

 

[Pho3nix]

Tried it but still no luck , and have 500 entries to put in...really not looking forward to the Insert Method

Update tablename set columna=columnb where culumna<>columnb

Evern tried

Update tablename set columna=columnb where culumna!=columnb

 

[Way69]

What error does sql return?

Sent from my GT-P7500 using MyBroadband Android App

 

[Pho3nix]

No error, just that no new rows are added.

 

[Way69]

are you sure that you are connected to the database server?

 

[Pho3nix]

Running the queries direct from SQL Server management Studio so I'm pretty sure I'm connected to the database :?

 

[xrapidx]

If they're already in A then just ignore the where clause

UPDATE [Table] SET ColA = ColB

 

[Way69]

and you are sure that you haven't already updated the table? That query will only work once.

My understanding is that you want you data to look like this?

Before:
ColumnA ColumnB
x y
x y
x y

After:
ColumnA ColumnB
y y
y y
y y

 

[GreGorGy]

No error, just that no new rows are added.

UPDATE will not add new rows - it will update existing ones. I just tried this in mysql with a table with 10 rows, five of which had a != b:

UPDATE `colacolb` SET `cola`=`colb` WHERE `cola`<>`colb`

It fixed the five != rows without issue.

 

[Pho3nix]

So then how do I add new rows?

 

[Messugga]

You guys are misunderstanding him and my SQL's slightly rusty.

He has the following:
A B
X X
Y Z

The output should be as follows:
A B
X X
Y Z
Z

 

[ABCpt]

You guys are misunderstanding him and my SQL's slightly rusty.

He has the following:
A B
X X
Y Z

The output should be as follows:
A B
X X
Y Z
Z

For this you can try
Insert into <Table> (<cola>)
Select Distinct <Colb> from <table>
where <ColB> NOT IN (SELECT <ColA> from <Table>)

 

[Scooby_Doo]

For this you can try
Insert into <Table>
Select Distinct <Colb> from <table>
where <ColB> NOT IN (SELECT <ColA> from <Table>)

This...

 

[Way69]

Just remember to specify the column that you want to insert into (INSERT INTO TABLE(Column))

 

[GreGorGy]

You guys are misunderstanding him and my SQL's slightly rusty.

He has the following:
A B
X X
Y Z

The output should be as follows:
A B
X X
Y Z
Z

Oh

INSERT INTO `colacolb` (`cola`) SELECT `colb` FROM `colacolb` WHERE `cola`<> `colb`

 

[ABCpt]

Just remember to specify the column that you want to insert into (INSERT INTO TABLE(Column))

Thanks, updated my previous post. Late on a friday

 

[Messugga]

INSERT INTO Test1(A)
SELECT Test1.B
FROM Test1
WHERE Test1.B
NOT IN
(SELECT Test1.A FROM Test1)

 

[Pho3nix]

Will give it a try and report back