ANN: Code Factory for MySQL 12.3 released

2012-03-09 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of Code Factory for MySQL 12.3, a powerful Windows GUI solution aimed at the MySQL queries and scripts development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/codefactory/ Please also note that

A Blob That's a String??

2012-03-09 Thread Jack Hatterly
Hi; I have loaded an image from a form into MySQL using Python as a longblob. Here is my table: mysql describe pics; +-++--+-+-++ | Field | Type | Null | Key | Default | Extra |

Re: A Blob That's a String??

2012-03-09 Thread Reindl Harald
Am 09.03.2012 13:28, schrieb Jack Hatterly: Even when I hard code in the correct values I get this error. However, when I select * from pics, where there is only one longblob in the table, it prints out a tremendous load of data which indicates to me that a binary file has indeed been

RE: A Blob That's a String??

2012-03-09 Thread Jack Hatterly
Date: Fri, 9 Mar 2012 13:43:11 +0100 From: h.rei...@thelounge.net To: mysql@lists.mysql.com Subject: Re: A Blob That's a String?? where is the difference of binary and string after fetch it from DB? the result IS a binary safe string! However, when I change this line in my code: content

query problem with null

2012-03-09 Thread Richard Reina
When I do the following query: SELECT * FROM geo_trivia WHERE city IS NULL; certain columns that DO have 'NULL' value for city and not a '' (blank) value do not show up. I have even gone to the extent of reseting these records value as ='NULL' with UPDATE and they are still are not selected

Re: preg_replace in update statement

2012-03-09 Thread Baron Schwartz
You may find this helpful: http://www.mysqludf.org/lib_mysqludf_preg/ On Thu, Mar 8, 2012 at 4:11 PM, Hank hes...@gmail.com wrote: I have a simple problem: I have a varchar field in the database, and I want to remove all text between WordA and WordB, including WordA and WordB, leaving all

RE: query problem with null

2012-03-09 Thread David Lerer
Have you tried to set city = null (i.e. without the quotes)? David. -Original Message- From: Richard Reina [mailto:gatorre...@gmail.com] Sent: Friday, March 09, 2012 4:24 PM To: mysql@lists.mysql.com Subject: query problem with null When I do the following query: SELECT * FROM

Re: query problem with null

2012-03-09 Thread Richard Reina
Ahhh... Thank you, that was exactly what the problem was. I will fix the code that is setting the value of these new records to 'NULL'. Thank you. 2012/3/9 David Lerer dle...@us.univision.com Have you tried to set city = null (i.e. without the quotes)? David. -Original

Re: query problem with null

2012-03-09 Thread Johan De Meersman
- Original Message - From: David Lerer dle...@us.univision.com Have you tried to set city = null (i.e. without the quotes)? Spot on, I'd think. NULL values are not a string with NULL in it - that's only what it looks like in query results :-) An empty string ('') is to strings

RE: preg_replace in update statement

2012-03-09 Thread David Lerer
Try with a combination of functions LOCATE and SUBSTR. Locate will return the positions for WordA and WordB within the original text, and, SUBSTR will allow you to string what you you need all together. David. On Thu, Mar 8, 2012 at 4:11 PM, Hank hes...@gmail.com wrote: I have a simple