Currently viewing the category: "SQL"

SQLException for zero DATETIME or TIMESTAMP column? Use zeroDateTimeBehavior

By On 03/04/2009 · Leave a Comment

from http://ondra.zizka.cz/stranky/programovani/java/index.texy

When working with MySQL over JDBC and the driver encounters a zero DATE, TIME, or DATETIME value (that is, e.g, ‚0000–00–00‘ for DATE), an exception is thrown:

java.sql.SQLException: Cannot convert value ’0000-00-00 00:00:00′ from column 4 to TIMESTAMP.

In this case, using SQL commands like

SET GLOBAL sql_mode = ‘NO_ZERO_DATE’;

does [...]

Continue Reading →

MySQL: Get Next Auto_increment

By On 28/01/2009 · Leave a Comment

from http://blog.jamiedoris.com/geek/560/ MySQL: Get Next Auto_increment Thursday April 24th, 2003

** It is not recommended to use this method for generating foreign keys for lookups. In a multiuser environment with simultaneous requests the results will be utterly useless and unreliable. OK? **

So I was working on the preview feature of [...]

Continue Reading →

SQL Sample for MSSQL

By On 04/11/2008 · Leave a Comment

select * from SYSOBJECTS where TYPE = ‘U’ order by NAME

equals to the one in mysql

show tables

Or we can use sp_help, for exmple:

exec sp_help database_name

refer to http://msdn.microsoft.com/en-us/library/aa933429.aspx

Continue Reading →