Friday, March 28, 2008

Unpublished MySQL FAQ (2)

(continued from Unpublished MySQL FAQ)

Q: What motivates the people who develop MySQL?
A: MySQL is free!

Q: Who is responsible for the architecture of MySQL?
A: MySQL is free!

Q: Who decides what behavior changes are made in each new release?
A: MySQL is free!

Q: What does a "zero value date" mean?
A: MySQL is free!
Q: What happens when I add 1 to a date? e.g., SELECT CURTIME()+1?
A: MySQL is free!

Q: What is the range of the TIMESTAMP data type?
A: MySQL is free!

Q: Do the properties of the TIMESTAMP data type depend on the storage engine?
A: MySQL is free!

Q: What are "silent column specification changes"
A: MySQL is free!

Q: What is the difference between "strict SQL mode" enabled and disabled?
A: MySQL is free!

Q: Can I use DEFAULT CURRENT_DATE for a date column?
A: MySQL is free!

Q: Can I specify a DEFAULT value for BLOB and TEXT columns?
A: MySQL is free!

Q: What are "implicit default values"?
A: MySQL is free!
Q: Who do I talk to about getting an enhancement made?
A: MySQL is free!

Q: Do I need to read and understand the source code for MySQL itself?
A: MySQL is free!

Q: Do I need to modify and compile the source code for MySQL itself?
A: MySQL is free!

Q: What is the importance of MySQL being open source?
A: MySQL is free!

Q: How do I embed a MySQL database in my commercial software and/or hardware product?
A: MySQL is free!

Q: Can I hide the fact that my commercial product contains a MySQL database?
A: MySQL is free!

Q: How do I protect my intellectual property when I distribute a MySQL database to customers?
A: MySQL is free!

2 comments:

Anonymous said...

Q: how do i do select * from sometable limit 1000,10 in mssql

A: mssql is expensive!

Anonymous said...

Q: How do I do SELECT * FROM sometable LIMIT 1000,10 in MSSQL?

A: You use the ANSI SQL:2003 syntax, as follows:

WITH PagedSomeTable AS (
SELECT ROW_NUMBER() OVER (ORDER BY id) AS rownum, *
FROM dbo.SomeTable
)
SELECT *
FROM PagedSomeTable
WHERE rownum BETWEEN 1001 AND 1010;

This statement is supported on any ANSI SQL:2003 compliant database, including MSSQL, Oracle, DB and PostgreSQL.

Q: Does MySQL support ANSI SQL:2003 common table expressions or ranking functions?

A: MySQL is free!