SELECT and NULL

This my be a dumb question, but I have search the docs without finding the answer. What I want is something like: select * from table where some_field not null; But this gives me an error. I can do a 'where field is null', so I have tried different combination with 'not' etc, but without

Upgrading from 3.23.58 5.0.22?

Good morning, all - I've read for quite a while tonight, but still haven't been able to figure out - can I upgrade directly from 3.23.58 to 5.0.22? I've read that I'd have to do something like 3.23.58 4.0 4.1 5.0.22, but then also the 'mysql_upgrade' application which, as documented,

InnoDB database Lost

Hello, I am having a problem with one of my MySQL databases, the server was crashed, and then all InnoDB tables seem to be empty, when I click any innoDB table name in PhpMyAdmin i get the following error: #1016 - Can't open file: 'forums.ibd' (errno: 1) when I click the database name, I get a

RE: SELECT and NULL

SELECT * FROM table WHERE some_field IS NOT NULL; -Original Message- From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED] Sent: Sunday, June 25, 2006 2:24 PM To: mysql@lists.mysql.com Subject: SELECT and NULL This my be a dumb question, but I have search the docs without finding the

Re: mysqld refuses to run on boot

Hi Karl, Fredrik, all! Karl Larsen wrote: Joerg Bruehe wrote: Hi Fredrik, all! Fredrik Andersson wrote: Hi all I have problems getting MySQL autoboot on my RedHat installation. [[...]] In addition to permissions (see the other posts), there is another possible problem: [[...]] Try

Re: mysqld refuses to run on boot

Karl Larsen wrote: Duncan Hill wrote: On Saturday 24 June 2006 12:49, Karl Larsen wrote: Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in /etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start the system. But it has to be done every time I turn on the

Re-importing a mysqldump file

Hi, I need to auto re-import a mysqldump file, but when importing it I need to make a certain field a value for all information imported. For example my db looks like this: Id Name Value Serverid Now, on the remote server, name and value get exported, and when I re-import it here,

Re: Re-importing a mysqldump file

Ian Barnes wrote: Is this possible? Or would the best way be to import the dumped file into a temp table and then select out of the temp table into my correct table ? Anyway to use a trigger? -- Online library -- http://pueblonative.110mb.com 126 books and counting. -- MySQL General

RE: Re-importing a mysqldump file

Hi, No unfortunately not... Cheers Ian -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED] Sent: 25 June 2006 05:41 PM To: mysql@lists.mysql.com Subject: Re: Re-importing a mysqldump file Ian Barnes wrote: Is this possible? Or would the best way be to import the

Re: if else statement

fre 2006-06-23 klockan 01:52 -0400 skrev Michael Stassen: Thomas Lundström wrote: Not sure what you're aming for here and how your data is structured but why not use a join and alias and fetch all info in one select and then solve what you need in your code? Something in the line

Re: 3 Table Join question

Solved it with Union :) SELECT images.id,images.name, playlist.title FROM images,playlist WHERE playlist.image_id = images.id UNION SELECT images.id,images.name, media.title FROM images,media WHERE media.image_id = images.id ORDER BY id ASC On Jun 23, 2006, at 6:44 PM, Graham Anderson

Re: query slow

Hello friends Id like to thanks all friends that helped with this question Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: A lot of HD Writing

Hi, thanks for answering! I am using MyISAM tables. So, based in your answer i assume that is usual to have a lot of HD Writing, isn't it? Thanks! Santiago mos wrote: At 06:55 PM 6/24/2006, Santiago del Castillo wrote: Hi, is usual to have a lot of HD writing on a MySQL server where

Re: A lot of HD Writing

In the last episode (Jun 24), Santiago del Castillo said: Hi, is usual to have a lot of HD writing on a MySQL server where (according to mytop) there are between 800 and 1200 queries per second? my MRTG is showing a lot of HD Writing and i wanted to know if it's usual. The database is growing

How to deploy MYSQL db to client

Hi! I wrote small windows application which use MySql 5 databse. I want to make one installation pakage with which I will install application and database. What is procedure to deploy database to client? Regards Tomaz

create view and insert into problems

Hello NG, I have two tables in my mysql database created with phpmyadmin: t_authors: 1 authorid (primary key, auto_increment) 2 lastname 3 firstname And a table named t_books, fields inside: t_books: 1 bookid (primary key, auto_increment) 2 authorid (Typ:index, reference to authorid from

Funny connection problem

Hello, I'm running MySQL 5.0.22 x86_64 on CentOS 4.3 on one server and web apps on another server. Occasionally these web apps (PHP) will return error 1130, Host 'x' is not allowed to connect to this MySQL server. From my understanding of the documentation, this is an access denied