this is for the reporting
does someone knows?
|
|
0
|
|
|
|
Reply
|
 nkapproach (7)
|
4/26/2007 4:39:39 AM |
|
On 25 Apr 2007 21:39:39 -0700, hi and hello wrote:
> this is for the reporting
> does someone knows?
Add an autoincrementing integer column. Use that. They make dandy
primary keys as well.
--
53. If the beautiful princess that I capture says "I'll never marry you!
Never, do you hear me, NEVER!!!", I will say "Oh well" and kill her.
--Peter Anspach's list of things to do as an Evil Overlord
|
|
|
0
|
|
|
|
Reply
|
 Peter
|
4/26/2007 4:27:06 PM
|
|
On Apr 26, 5:27 pm, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> On 25 Apr 2007 21:39:39 -0700, hi and hello wrote:
>
> > this is for the reporting
> > does someone knows?
>
> Add an autoincrementing integer column. Use that. They make dandy
> primary keys as well.
>
> --
> 53. If the beautiful princess that I capture says "I'll never marry you!
> Never, do you hear me, NEVER!!!", I will say "Oh well" and kill her.
> --Peter Anspach's list of things to do as an Evil Overlord
You can also do this:
mysql> set @N = 0;
mysql> SELECT @N := @N +1 AS number, * FROM my_table;
|
|
|
0
|
|
|
|
Reply
|
strawberry
|
4/28/2007 1:44:14 PM
|
|
On Apr 28, 2:44 pm, strawberry <zac.ca...@gmail.com> wrote:
> On Apr 26, 5:27 pm, "Peter H. Coffin" <hell...@ninehells.com> wrote:
>
> > On 25 Apr 2007 21:39:39 -0700, hi and hello wrote:
>
> > > this is for the reporting
> > > does someone knows?
>
> > Add an autoincrementing integer column. Use that. They make dandy
> > primary keys as well.
>
> > --
> > 53. If the beautiful princess that I capture says "I'll never marry you!
> > Never, do you hear me, NEVER!!!", I will say "Oh well" and kill her.
> > --Peter Anspach's list of things to do as an Evil Overlord
>
> You can also do this:
>
> mysql> set @N = 0;
> mysql> SELECT @N := @N +1 AS number, * FROM my_table;
Actually, if using ' * ', then it has to come before the counter.
Also, you have to remember to reset N afterwards!
|
|
|
0
|
|
|
|
Reply
|
strawberry
|
4/28/2007 1:48:51 PM
|
|
What you're asking for is "an un-natural act" in SQL. The point is
taht an SQL
|
|
|
0
|
|
|
|
Reply
|
ashore
|
5/1/2007 1:00:22 AM
|
|
|
4 Replies
273 Views
(page loaded in 0.159 seconds)
Similiar Articles: How to set column format for only one column in uitable - comp ...... and sort by one column ... ... as a column of the result set - comp ... I need ... I want to add the row number as a column of the ... to set column format for only one column ... Set size of JTable inside a JScrollPane - comp.lang.java ...... needs, and postthe result of ... You can enter any number of COLUMN commands ... ... I need change ... Set size ... The number of columns was low, and the row count would at most ... Y axis plot labeling? Want auto scaling, but want to format ...... however you like, and set() the YTickLabel property to the result. ... it transforms the row vector into a column ... Want auto scaling, but want to format ..... numbers ... Syntax error trying to return scalar value from query in stored ...You need to order the result set for this to ... A result set with one column and one row is still a result ... row in set (0.00 sec) mysql> SELECT Add_Working_Days(5.23 ... JTable Column with Multiple Types - comp.lang.java.guiI need a column of the table to ... How can I set the color (or font) on a specific cell (row, column) in a ... java.gui Limiting number of characters in a JTable columns ... How to change length of a num column - comp.soft-sys.sas ...How to change length of a num column - comp.soft-sys.sas ..... want to add the row number as a column of the ... to set column format for only one column in uitable ... Problems with JTable using fixed rows - comp.lang.java.gui ...... tablePanel.add(footerTable); > > but the result is ... only a fixed number of characters.The number of ... Selecting a row ... the last table>row ... i want to set each column ... JTable - Merging cells - comp.lang.java.guiDo you mean for example to add two rows together, putting the result in the first row ... Make a simple 4 row by 4 column scratch pad ... see below for JTable Knute: I want ... JTable and Enter key - comp.lang.java.gui(or even do nothing - same result ... comp.lang.java.gui Limiting number of characters in a JTable columns ... key action, since i dont want to move the the curser to next row ... matrix / arrays with row, column labels + alignment? - comp.text ...... to be able to add labels for the columns ... to display the result ... arrays with row, column labels + alignment? - comp.text ... I have a matrix of +- numbers that I want to ... ROW_NUMBER (Transact-SQL)Returns the sequential number of a row within a partition of a result set ... Add code samples and tips to ... specifies the column by which the result set is partitioned. How do I add a Column to an Access Query that shows row number i.e ...I need to figure out how to add a column at the begining of a query that will show me a sequential row number 1,2,3,4,5 ... is just the row number of the result set ... 7/20/2012 12:43:08 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
8 followers. 