Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Record Numbering
#7
joebordes Wrote:If you want to change all the records, completly eliminate the where condition, if you want to change a subset of the accounts then you put a condition the selects that subset. In other words I was trying to say that you can add a condition there to change only some records, not all.

Understood and thanks. Forgive my ignorance in SQL!

Unfortunatly after applying the UPDATE query without the condtion (as I need to apply the change to all the records) I ended up with the account_no column being like so: 000G1, 000G2 etc etc

[attachment=0]<!-- ia0 -->account_no.gif<!-- ia0 -->[/attachment]


Attached Files Image(s)
   
Reply


Messages In This Thread
Record Numbering - polanskiman - 05-20-2014, 10:13 AM
Re: Record Numbering - joebordes - 05-20-2014, 02:14 PM
Re: Record Numbering - polanskiman - 05-21-2014, 04:13 AM
Re: Record Numbering - Ekim - 05-21-2014, 06:11 AM
Re: Record Numbering - polanskiman - 05-21-2014, 07:06 AM
Re: Record Numbering - joebordes - 05-21-2014, 08:41 AM
Re: Record Numbering - polanskiman - 05-21-2014, 08:49 AM
Re: Record Numbering - joebordes - 05-21-2014, 09:06 AM
Re: Record Numbering - polanskiman - 05-21-2014, 09:10 AM
Re: Record Numbering - joebordes - 05-21-2014, 09:21 AM
Re: Record Numbering - polanskiman - 05-21-2014, 09:34 AM
Re: Record Numbering - joebordes - 05-21-2014, 09:40 AM
Re: Record Numbering - polanskiman - 05-21-2014, 09:51 AM
Re: Record Numbering - polanskiman - 05-26-2014, 06:25 AM
Re: Record Numbering - joebordes - 05-26-2014, 08:42 AM
Re: Record Numbering - polanskiman - 05-26-2014, 09:20 AM
Re: Record Numbering - joebordes - 05-26-2014, 09:45 AM
Re: Record Numbering - polanskiman - 05-26-2014, 09:52 AM

Forum Jump:


Users browsing this thread: 2 Guest(s)