Jump to content

cachobong

Members
  • Posts

    4
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

cachobong's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. hi guys! is there an SQL statement where in you duplicate a table and its structure but has a different name and is empty? your help is deeply appreciated! thanks!
  2. Hi guys! agen i need ur help! Update columns in TMP_TABLE where in the condition holds a relation between CUSTOMER.name equates to TMP_TABLE.name. How do i do this with one SQL statement? columns in TMP_TABLE and CUSTOMER are : name varchar(32), primary key address varchar(64) state char(2) zip char(5) tel char(10) remarks varchar(64) it's like copying a CUSTOMER table to TMP_TABLE but TMP_TABLE is not blank. pls help.. thanks!
  3. [!--quoteo(post=335818:date=Jan 12 2006, 06:29 PM:name=LazyJones)--][div class=\'quotetop\']QUOTE(LazyJones @ Jan 12 2006, 06:29 PM) 335818[/snapback][/div][div class=\'quotemain\'][!--quotec--] With this lack of information, helping would be just like shooting in the dark... What exactly are you trying to do? Insert new value, update, search? What are those values? Are you trying to add two intergers? or maybe doubles? Or trying to concat two strings? Try to place yourself in our position and think if you could manage to help with that kind of question. m sori for the lack of information TMP_TABLE.state is varchar TMP_TABLE.zip is also varchar m trying to concat the 2 strings and put it into the TMP_TABLE.remarks of the same record. m trying to update the record... m sori agen for the lack of information... thanks..
  4. Hi guys! can u help me with my SQL? here's what i want to happen... TMP_TABLE.remarks = TMP_TABLE.state plus TMP_TABLE.zip that is for all fields..how do i do it with only 1 SQL statement?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.