Just looked at MySQL today 1

[ITGL72]

Hi folks, hope you guys can help me answer some questions and let me know if I should turn down this particular project or not.

I have done mild work with COLD FUSION, SQL7 Server, and Access DB's. I am trying to help someone out with some simple cold fusion apps but all he has on his unix host is a MySQL database.

Anyone know if the same type of SQL code I use in a cold fusion template, can be used exactly the same with a MySQL database as it could with SQLServer and Access?

At this point, I really dont want to take something on that requires me to learn something new. Its just not a good time for me as far as that goes.

Lemme know folks!!

 

[devnull22]

Hi ITGL,
I'm assum'n your talking about the SQL statements and not
the cold fusion code. If you've stuck to the SQL92 standards, you should be "okay" for the most part. The major difference in mysql is inner selects which mysql doesn't support.

for more info on compatiblity :

http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#Compatibility

cheers
Ken devnull22

http://www.photoflux.com

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !

 

[petersJazz]

The most important things mySQL dont have that is standard SQL (Core-99, se

http://developer.mimer.com/validator/parser99/index.tml)

is subqueries, union and "real transaction". Examples:
+ subquery:
select *
from table1
where id in (
select id from table2);

update table3 a
set column1 = 'somevalue'
where not exists (
select *
from table4 b
where a.id = b.col);

+ "real transactions":
instead you have to use
lock tables table1, table2 write;
<change tables>
unlock tables;
Problem with this is performance (if there are a lot
of users on the same table) and is the server
breaks (&quot;half&quot; transactions in table)

 

[rycamor]

Don't forget views, foreign keys (they are finally at beta level in MySQL), and stored procedures. -------------------------------------------

&quot;Calculus is just the meaningless manipulation of higher symbols&quot;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-unknown F student

 

[rycamor]

Oh, and Triggers, also.

Basically, if you want a serious database to write serious applications, and you want it free and Open Source, PostgreSQL or Interbase/Firebird are your two best candidates. (I vote PostgreSQL --

http://www.postgresql.org)

-------------------------------------------

&quot;Calculus is just the meaningless manipulation of higher symbols&quot;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;-unknown F student