the non-development release (of MYSQL) does not support nested sub queries or stored procedures, which in my eyes is a reason not to use it. this means that the functionality is far less that you can expect from SQL server.... take an example
select * from table where id in (select id from table2) would have to be done in at least to queries... psuedo code: cfquery1 select id from table2 cfquery2 select * from table where i_id in (valuelist(cfquery1.id)) this is 2 queries where one should suffice, this is 2 connections where one should suffice. obviously this example isn't best, but use you imagination and you should be able to see where this could be problematic... Stored procedures are a fantastic way of using the data in the database as well... I prefer stored procedures as there is so much you can do with them, and they are definitely much more secure than writing queries... think about doing some data manipulation that you have to do with CF, and the write it back to the database, this shoudl be possible using a stored procedure. I am sure there are other reasons, but I am pretty new to MySQL and it's OK, but not nearly as powerful as SQL server... ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 23, 2002 11:48 AM Subject: RE: [ cf-dev ] Which SQL ?? > Thanks for all the info so far. > > Just wondering what the special functionality is that SQL2000 has over > mysql. > > It looks like sql2000 is what we need but he bods will ask why and will > want a non techy answer as to do we spend > > ************************************************************* > This email and any files transmitted with it are confidential > and intended solely for the use of the individual or entity > to whom they are addressed. If you have received this email > in error please notify [EMAIL PROTECTED] > > The views expressed within this email are those of the > individual, and not necessarily those of the organisation > ************************************************************* > > ---------------------------------------------------------------------------- ---- �xxxx or do we get mysql for much cheaper. Can anyone let me know why not to use mysql - all that head banging stuff etc.... Regards - Paul. ---------------------------------------------------------------------------- ---- > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
