sql - Getting the values of table2.column1 into table1.column1 -


what want values of 'script' column table 'item_db3' 'script' column of table 'item_db2'

i tried script

update item_db2 set item_db2.script=item_db3.script item_db2 join item_db3 on (item_db2.script=item_db3.script)

interchange join , set statement like

update item_db2  join item_db3 on item_db2.script = item_db3.script set item_db2.script = item_db3.script

** not sure trying updating column on joining. that's bit strange


Comments

Post a Comment

Popular posts from this blog

python - What's the Pythonic way to report nonfatal errors in a parser? -

a parser created reads recorded chess games file. api used this: import chess.pgn pgn_file = open("games.pgn") first_game = chess.pgn.read_game(pgn_file) second_game = chess.pgn.read_game(pgn_file) # ... sometimes illegal moves (or other problems) encountered. pythonic way handle them? raising exceptions error encountered. however, makes every problem fatal, in execution stops. often, there still useful data has been parsed , returned. also, can not continue parsing next data set, because still in middle of half-read data. accumulating exceptions , raising them @ end of game. makes error fatal again, @ least can catch , continue parsing next game. introduce optional argument this: game = chess.pgn.read_game(pgn_file, parser_info) if parser_info.error: # appears quite verbose. # can @ least make best of sucessfully parsed parts. # ... are of these or other methods used in wild? actually, are fatal errors -- @ least, far being able repro...
Read more

sql server - Deadlock occuring in Clustered Columnstore index -

Image
we using clustered columnstore index in our transaction table holding order fulfillments. table regularly updated different sessions. but, every session specific order job number , so, not trying update same row @ same time. but, facing deadlock issues due below scenarios between sessions. row group locking & page lock row group locking & row group locking this not specific stored procedure. due multiple stored procedures updating table, sequentially 1 one, part of order fulfillment. the sample schema of table simple: create table orderfulfillments ( orderjobnumber int not null, fulfilledindividualid bigint not null, isindividualsuppressed bit not null, suppressionreason varchar(100) null ) i have given sample deadlock graph reference. please let me know, approach can take avoid deadlock situation. need clustered columnstore index in table, doing aggregation operations see how many times individual been fulfilled already. ...
Read more

php - curl: (35) OpenSSL SSL_connect: SSL_ERROR_SYSCALL in connection to domain.com:443 -

i'm hitting curl on ubuntu terminal , getting response curl: (35) openssl ssl_connect: ssl_error_syscall in connection domain.com:443 . can't understand why happens. tried show curl's error number did not revert no. hitting server. below command : ./curl -i --tlsv1.2 -kv -h "content-type: application/xml" --verbose -x post --data /var/www/html/xml.xml --cacert /root/curl_ssl/curl-7.54.1/src/cert_org.crt domain.com/otp please suggest help.
Read more