Re: mysql development tools
At 02:55 PM 10/11/2003, cppaddict wrote: Hi, I'm just starting out with mysql and would like to know if there are any good database diagramming and development tools for mysql. Something that would allow me to create a db and all the relationships graphically and then have the sql code automatically produced. Ideally I'm looking for something opensource or free. For diagraming databases, I recommend Dezign for Databases. http://www.datanamic.com/. It is very affordable design tool. There are some open source software but none that have the features Dezign does. Also, I'm going to use mysql with php. Does anyone have any recommendations about development tools for integrating the two together? I'm just trying to get an idea of what's out there, so I don't have to reinvent the wheel. Eclispe work good. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL Injections
Are there any SQL injection threats for MySQL less than 4.1? Dwight Trumbower T Systems Corp Custom Database Solutions [EMAIL PROTECTED] 920-667-4438 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Numeric Types and display attribute
I'm sure this has been discussed before, I just haven't found it. When creating numeric data types you have the option of putting a display attribute. After reading the docs, I'm not really sure why you would want to do this. From a DBA point of view, I don't care how the number is displayed. That is up to the ui designer. Is there any performance gain to using the display attribute? Dwight [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SELECT only unique records
At 01:02 PM 9/12/2003, Comcast wrote: I am sure this is a slam-dunk, but I am new to this and stumped ... thanks. I have the following statement, but I need it to pull only unique listings - I get repeated items. SELECT state_ID FROM financial_master WHERE category_ID = '1' SELECT DISTINCT state_ID FROM financial_master WHERE category_ID = '1' -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]