Re: Returning an Auto-Increment Field

2002-11-08 Thread Nikolas Galanis
-- - - Nikolas Galanis - - Computer Engineering & Informatics Department - - University of Patras - - http://www.ceid.upatras.gr- - 061 99

Re: timestamp updated on select

2002-11-07 Thread Nikolas Galanis
is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated. That seems fairly strange. Let's see an example. On Wed, 6 Nov 2002, Paul D

Re: timestamp updated on select

2002-11-06 Thread Nikolas Galanis
Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. - Bef

mysql server with different character sets per user

2002-11-04 Thread Nikolas Galanis
Hello I was wondering about the following: I am hosting an application with a web hosting company and the character set doesn't satisfy me because I am doing some sorting of greek names and the hosting company uses the default character set for the mysql server. Is it possible that they let my

character set when you don't manage the server

2002-10-18 Thread Nikolas Galanis
Hi I have written a web application that is hosted in a server which uses the default character set. This causes problems in the sorting that MySQL does because most of the data is in Greek. When developing it locally, I run the MySQL server with the greek character set and sorting works fine.

update and data manipulation

2002-10-16 Thread Nikolas Galanis
Hello When I want to update a value, I can use numerical functions like +,* etc. Can I do the same with strings? For example, when I want to append a string in an existing value, how (if of course) can I do it inside the update query? Thanks. Nikolas p.s: I know I can do it with PHP, I was j