insert value 1 into customer table column stand (was "Very Basic Sql")

boing · #1 (**permalink**) 07-14-06, 05:04

Hello,

Bit of basic sql here for you:

I have a table called "customer" and there is a field in customer called stand.

Stand is also a seperate table that is joined to customer.

However i would like to add the value of "1" into STAND on the CUSTOMER table and i was wondering if someone could tell me the sql to do this. So basically where there is nothing insert a value of 1 into stand on customer.

Cheers

r937 · #2 (**permalink**) 07-14-06, 07:15

Code:

insert
  into customer (stand)
values (1)

boing · #3 (**permalink**) 07-14-06, 08:55

how do i tell it to only insert that into blank values?

r937 · #4 (**permalink**) 07-14-06, 08:59

ah, you're probably thinking of UPDATE, not INSERT

Code:

update customer
   set stand = '1' 
 where stand = ' '

boing · #5 (**permalink**) 07-14-06, 09:11

Thanks, i will give that a try

boing · #6 (**permalink**) 07-26-06, 04:54

why has someone gone and changed the title of my post?

Littlefoot · #7 (**permalink**) 07-26-06, 05:56

Moderator changed unapropriate title ("Very basic sql") into something more meaningful ("insert value 1 into customer table column stand"). As you can see, he indicated the original thread name.

Read more about How to ask questions the smart way, especially "Use meaningful, specific subject header" chapter.

boing · #8 (**permalink**) 07-26-06, 09:40

Ok thanks for the information

Internet Services

Web Development

Digital Marketing

Consumer Tech