Re: mysql development tools

2003-10-13 Thread Dwight Trumbower
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 automati

SQL Injections

2003-10-09 Thread Dwight Trumbower
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]

Re: SELECT only unique records

2003-09-12 Thread Dwight Trumbower
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

Numeric Types and display attribute

2003-09-12 Thread Dwight Trumbower
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. T