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
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 |
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
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
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
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
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
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
- 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
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
10 matches
Mail list logo