thank you, this makes sense.
On Thu, Jul 29, 2010 at 11:29 PM, Dan Nelson wrote:
> In the last episode (Jul 29), Norman Khine said:
>> I don't know what I am missing, but I have this:
>>
>> mysql> SELECT url FROM product WHERE url IS NULL;
>> Empty set (0.05 sec)
>>
>> mysql> SELECT url FROM prod
In the last episode (Jul 29), Norman Khine said:
> I don't know what I am missing, but I have this:
>
> mysql> SELECT url FROM product WHERE url IS NULL;
> Empty set (0.05 sec)
>
> mysql> SELECT url FROM product WHERE product_Id = 67;
> +--+
> | url |
> +--+
> | |
> +--+
> 1 row
blank is not null... I'll bet if you did
SELECT url FROM product WHERE url = '';
you'll get a row or three. If the field was NULL, your product_id
select would look like:
+--+
| url |
+--+
|NULL |
+--+
andy
Norman Khine wrote:
Hello,
I don't know what I am missing, but I h
Hello,
I don't know what I am missing, but I have this:
mysql> SELECT url FROM product WHERE url IS NULL;
Empty set (0.05 sec)
mysql> SELECT url FROM product WHERE product_Id = 67;
+--+
| url |
+--+
| |
+--+
1 row in set (0.00 sec)
what goes with this, how can i ensure that thi
Yes, I do it all the time.
download TAR archive at the bottom of the download list.
untar in a custom dir.
use dedicated user
watch the my.cnf location, its kind of css style, if you have side
effects its cause your mysql installation is picking it up also from the
wrong location
remove /etc
You could try it inside a "here" document:
mysql < Date: Thu, 29 Jul 2010 14:29:55 -0500
> From: todd_...@ssiresults.com
> To: mysql@lists.mysql.com
> Subject: Variable Expansion Using MySQL Client and .sql Files
>
> Hey all,
>
> I've found many packages that sit on top of MySQL for various clien
Hello Gurus, I am trying to see if there is a no install version of MySQL
5.1.4X
for Cent OS 4.8? We got a copy for Solaris x86 and it works AWESOME, I cant
seem to find one for Cent OS? We wanted to install several flavors and test a
200 MB query script file against it to see how the perform
Hey all,
I've found many packages that sit on top of MySQL for various clients.
For the purposes of consistency I'd like to automate these installs.
I've been directed towards using .sql files and they work great.
The trouble I'm having now is that I would like to secure the
installation but
Hi All, I was running slamdb against one of our QA boxes and noticed that the
innodb database is 190Gb in size BUT the worrying issue is that the indexes are
30GB in size!!! When I hit this server hard, it tanks on memory but still
performs, slower of course ;-) Any suggestions on what I shoul
With some databases such as MySQL, subqueries have to be explicitly named. For
example
select * from (select * from (select * from table) sub1) sub2;
If not, you will see an error like: "ERROR 1248 (42000): Every derived table
must have its own alias"
If
I understand your problem correctly,
To answer both emails...
My first install is Puppet :)
1) I have many clients (schools with Macs/Linux) that could use this
package. This is in the works - good call.
For the sake of DRP (Disaster Recovery Planning) I automate all of my
installs on the 1% off-chance that my backups are parti
11 matches
Mail list logo
