(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?Q: Who do I talk to about getting an enhancement made?
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!
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:
Q: how do i do select * from sometable limit 1000,10 in mssql
A: mssql is expensive!
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!
Post a Comment