Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2015
    Posts
    1

    Unanswered: update table.\"value\" SET

    Hi

    I am modifying a script and I found this....

    > update table.\"value\" SET \"INFO\" = '$variable';

    I wounder whats the idea behind the \"xxxx\" syntax/names???

    The scripts failing and I wanted to use the "realnames" insted of the \"xxx\"


    Example: a "create table mytable.value" will not create a relation, but a "create table mytable" will work...
    So it makes no sense that the script wants to use mytable.\"value\"



    Tips?

    Eddie
    Last edited by eddiex666; 01-07-15 at 02:45.

  2. #2
    Join Date
    Jul 2015
    Posts
    7
    update table.\"value\" SET \"INFO\" = '$variable';

    update table.your_table_name SET your_column_name= '$variable';

    example

    tb_test has two columns id and name:

    id name

    1 first
    2 second

    update tb_test set id=5 where id=1;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •