Reaching the unique id after inserting with auto increment

2002-05-19 Thread Gyulay Gabor
Hi ! This is a basic problem. I need an unique id in a table, so I choosed integer with auto increment. (it is so simple...) After inserting a record, I have to display the created unique id to identify that record later. But how can I select it ? If I select the last record, I should get ano

Re: About huge numbers

2001-11-15 Thread Gyulay Gabor
23456.12); mysql> select * from try; +-+ | money | +-+ | 1234567890123456.00 | +-+ 1 row in set (0.00 sec) Of course this is the biggest number we plan to handle, and this is the worst case we would like to convert, and this could be only a sub

About huge numbers

2001-11-15 Thread Gyulay Gabor
Please let me know, how to handle huge numbers. The problem is that I need to store numbers with lot more than 16 decimal digits - e.g. 1234567890123456789012345.12 I already tried a decimal type but it caused errors (I mean MySQL simply cutted the end of the numbers and stored only the first 16