Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update query help...
SandieJ, Thank you for the help. That worked great. Dan- elijah06
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Update query help...
Hello all, I have the following table and would like to perform an update on the newacct field. I need to copy the newno value to newacct. But the caveat is that if a group in acct (like rows having 12's, 57's and 66's) in the acct field then the value of the first newno should be the same for...- elijah06
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
query translate
All, I posted the above query on the official MySQL forum and received a response on how to work around updating the table being selected. The code is as follows: UPDATE test SET NewAcct = NewAcct - (SELECT COUNT(*) FROM (SELECT * FROM test) AS t2 WHERE t2.Acct = test.acct AND t2.NewNo <... -
query translate
Well that is no good for me. No wonder I kept getting that error no matter what I tried... Thank you for all the help, Dan -
query translate
The above query is in microsoft sql server syntax and i need to translate it over to mysql syntax... If I attempt to run this query i get the following error message from mysql engine: 1093 you can't specify target table 'patacct' for update in FROM clause... Hope this helps... Thanks, Dan -
query translate
I have the following ms sql query but having problems translating it over to mysql: update t set NewAcct = NewAcct-(select count (*) from t t2 where t2.Acct = t.acct and t2.NewNo < t.NewNo) from t your help is appreciated. Thank you, Dan -
LOAD DATA INFILE
Hello folks, Is it possible to update a column using LOAD DATA INFILE, So the following is an example: LOAD DATA LOCAL INFILE 'c:/test.txt' INTO TABLE test FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (lname, fname, zip); Results: id | fname | lname | zip 1 | kurt | russell | 45678 2 |...
