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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: elijah06
  • Content: Threads
  • Order by date
  1. elijah06

    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...
  2. elijah06

    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
  3. elijah06

    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 |...

Part and Inventory Search

Back
Top