how to auto_decrement a primary key?

Hi all, i want to keep the track of row numbers to display the results , say, five by five. the most common way to do this is defining a column which is auto_incrementing and not null. but htere is a problem with this approach. say, i have a table which stores the subject and contents of articles,

nested select queries

hi everybody, i have a simple problem, but somehow i couldn't solve it i hope someone overthere can help me. i have a select query as below: select no,subject,ndate from cat1 where news like '%"+search+"%' limit "+page_no+",5" i also want to find out how many rows are there in the result set. what

why doesn't prepared statement work?

Hi all, i have a strange situation here, i am trying to execute an sql insert via prepared statements. though it is a simple insert process, i am having a syntax error message. Doesn't mysql support this? can someone please tell me what is wrong with this query? String query="insert into temp(mem

why doesn't prepared statement work?

Hi all, i have a strange situation here, i am trying to execute an sql insert via prepared statements. though it is a simple insert process, i am having a syntax error message. Doesn't mysql support this? can someone please tell me what is wrong with this query? String query="insert into temp(mem

Re: why doesn't prepared statement work?

However, i am sure there are exactly 19 fieldnames and 19 "?"s, also in the database there are 19 columns exactly matching the filednames. what could be wrong now? - Original Message - From: "Hans" <[EMAIL PROTECTED]> To: "yilmaz" <[EMAIL PROTE

Re: why doesn't prepared statement work?

oundsException at org.gjt.mm.mysql.PreparedStatement.set(PreparedStatement.java:1192) at org.gjt.mm.mysql.PreparedStatement.setString(PreparedStatement.java:581) It is very strange , isn't it? - Original Message - From: "DL Neil" <[EMAIL PROTECTED]> To: &

Re: why doesn't prepared statement work?

Wouldn't it make our lives easier if MySQL had thrown a sensible and a logical error message so that developers need not to waste a lot of time on a fairly small problem? - Original Message - From: "yilmaz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tues

Re: number of connections keeps increasing

dvance best regards :) - Original Message - From: "TAKAHASHI, Tomohiro" <[EMAIL PROTECTED]> To: "yilmaz" <[EMAIL PROTECTED]> Sent: Sunday, November 25, 2001 8:02 PM Subject: Re: number of connections keeps increasing > > I want to know environment ab

Arrayoutofindexexception

hi all, first of all, since this is a jdbc specific question, you might say i should post to java mysql mailing list, but for some reasons my java mysql subscribtion seems didn't succeed although i got a confirmation and a welcome email. (of course i confirmed my subscribtion) Anyway my request is

Re: Getting to latest 5 Records

just to make it clearer: select * from your_table order by auto_increment_column desc limit 5 cheers :) - Original Message - From: "Luis Ferro" <[EMAIL PROTECTED]> To: "'Jack'" <[EMAIL PROTECTED]>; "'Mysql List'" <[EMAIL PROTECTED]> Sent: Monday, November 26, 2001 6:30 PM Subject: RE: Get

Re: Arrayoutofindexexception

for taking time cheers :) Original Message - From: "Joseph Roth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 26, 2001 9:41 PM Subject: Re: Arrayoutofindexexception > At 04:01 PM 11/26/2001 +0800, yilmaz wrote: > >hi all, >

Re: Too many connections (again) (could Mark answer this please)

Me , too, have the same problem. it seems that every opened page establishes a connection but those connections can't be closed, although i explicitly close in my code I posted a message related with this problem a few days ago, unfortunately couldn't get a satisfying answer. So, i request from M

Re: Too many connections (again) (could Mark answer this please)

thanks a lot Mark, now i figured it out, i should have used finally {} statements around close() functions. Best regards :) - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: ""yilmaz"" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTE

unicode charset support ?

hi mysql guru's, does anyone put light on the unicode charset support of MYSQL? i searced everywhere in the archives and the docs , but couldn't find a related thing.It seems that it doesn't support, however i am asking you to be sure. My application needs to save both japanese and chinese char

Re: Changing data

lets says the column your_column holds hte data to be changed. then: update your_table set your column=concat(substring(your_column,1,4),-,substring(your_column,5,8),-,subs tring(your_column,8,12)); this should work, if i am wrong please someone correct me cheers ) - Original Message - Fro

mysql forum, or a newserver

is there any newsgroup or a forum that i may join? sorry here is great but i cant handle with this maling list. i believe a forum or a news server will be great. thx in adv. - Before posting, please check: http://www.mysq