I just discovered that one of my MySQL tables is
incomplete. I created it by importing a comma
delimited file I had made from a spreadsheet, but it
appears as many as 3,000 rows or so were missing.
So I decided to give it another try. MySQL Front
refused to import it because of some sort of error
I have redhat9. I removed the RPM install of MySQL, and instead installed 3
copies of MySQL-4.0.20 BINARY distributions into my /usr/local/ directory,
under the helpful instructions of Thierno Cisse.
However, it seems like now, the PHP RPM installation cannot find the mysql
extension. When I try
Sorry guys if I was not clear.
I have copied mysql-4.0.20a-win.zip to my computer. On the downloads page it is
suggested that I verify the integrity of the packages that I downloaded. I am trying
to fine out how to do this. I first have to unzip the file first. Do I copy the code
from MD5 Check
Hi,
I am using the following code but not getting a
connection. :( Can someone tell me what I am doing
incorrectly?
Thanks, Scott
package database_test;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.SQLException;
anyone know why the mysql daemon fails to start after I set the root
password according to this:
http://dev.mysql.com/doc/mysql/en/Default_privileges.html
I use the command:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');
This is
At 18:50 -0700 6/5/04, Daevid Vincent wrote:
> If you need it to work, I'm afraid you're out of luck. Think about
what a IN (x,y,z) means. It's basically the same as a = x or a = y
or a = z. So wifi_list IN (NULL) is like wifi_list = NULL,
which is never true.
Thanks for the reply Paul, and
> First off, I assume you are using a version of mysql able to handle
sub-queries. 4.1 or 5.0 (4.0.xx does NOT support sub-queries)
Ugh... I feel dumb :) I'm using 4.0
> FWIW, this is an easy query with a JOIN:
>
> SELECT id FROM work w
> INNER JOIN client_list cl ON cl.id = w.client_id
> WH
> If you need it to work, I'm afraid you're out of luck. Think about
> what a IN (x,y,z) means. It's basically the same as a = x or a = y
> or a = z. So wifi_list IN (NULL) is like wifi_list = NULL,
> which is never true.
Thanks for the reply Paul, and I get that NULL is a special case value,
On Sat, 5 Jun 2004 19:48:44 -0600
"Daniel Isenhower" <[EMAIL PROTECTED]> wrote:
> This is my first email to the list, so be nice ;-)
Welcome, this is a very helpful list...
> I'm having some difficulty with a subquery that I'm trying to do,
> and was wondering if anyone here can shed some light
This is my first email to the list, so be nice ;-)
I'm having some difficulty with a subquery that I'm trying to do, and was
wondering if anyone here can shed some light on the issue...
This query returns a result as expected:
SELECT id FROM client_list WHERE name="Some Company"
(the id returned
Hi,
Does anybody have experience with FreeBSD 5.x &
Mysql ?
FreeBSD 4.x and mysql seems to be awful combination due to threading , but I have no
tried FreeBSD 5.x with mysql under heavy load
Thanks,
Peter Zyumbilev
Project Manager
Mansion Productions Inc.
AIM: peterZmansion
YMS: pete
"Klaas Geldof" <[EMAIL PROTECTED]> wrote:
>
> I have a question about MySQL queries. First I will explain the situation,
> then I will provide an example.
>
>
> Situation:
>
> I have the tables 'offer', 'contact' and 'offer_contact'. Table 'offer'
> contains data about offers, table 'contact' a
I am converting a form that was originally designed to be Email
Submitted into a Submit-to-PHP-Page Form (which will then insert the
data into a MySQL Database).
I expect no problems in actually scanning the submission to extract
the data but I have some questions on the design of the Tables t
I think he's talking about download MySQL, and verifying the binary
using MD5.
There is a link right above the downloads for verification of the binary.
http://dev.mysql.com/doc/mysql/en/Verifying_Package_Integrity.html
The contents of the page @ that URL suggest using GNU Privacy Guard.
David
Pa
> Okay. What does the MySQL error log say. Anything?
Do you know where can I find it ?
Dates are old 031222 ! ...
[EMAIL PROTECTED] [/var/log]# tail mysqld.log
/usr/sbin/mysqld: ready for connections.
Version: '4.0.15-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306
031222 12:57:02
On 04.06.2004 20:46 (+0200), Sasha Pachev wrote:
Subquery optimizer is still is a very early stage in 4.1. Much more often than
not, a carefully crafted join, union, or a sequence of queries using a temporary
table will be faster. In fact, I wonder if it is even possible to write a
machine subqu
On 04.06.2004 21:09 (+0200), Mark Maggelet wrote:
Hi.
I'm having this problem on 4.1.2, when I run myisamchk -o on my table I
get a bunch of these lines:
[...]
Would you please not reply to a mail to create a new thread? This
message will be displayed somewhere deep inside another thread and
no-
At 20:05 +0200 6/5/04, pourave wrote:
> At 19:21 +0200 6/5/04, pourave wrote:
>Hi,
>
>I am on a redhat, i read a lot of doc on the problem I hav but noway to
>advance, mysql won't start and won't tell anything :
mysql is a client program.
The server is named mysqld.
I know under redhat a
> At 19:21 +0200 6/5/04, pourave wrote:
> >Hi,
> >
> >I am on a redhat, i read a lot of doc on the problem I hav but noway to
> >advance, mysql won't start and won't tell anything :
>
> mysql is a client program.
> The server is named mysqld.
I know under redhat a script call service is used t
I think that I'd look at postfix and dbmail. Postfix and dbmail both
allow userdata to be stored in MySQL databases. dbmail will also put the
message store in a mysql database. Very nice, very fast. RH9 has hit
eol. Gentoo rocks.
Curtis
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://ww
At 19:21 +0200 6/5/04, pourave wrote:
Hi,
I am on a redhat, i read a lot of doc on the problem I hav but noway to
advance, mysql won't start and won't tell anything :
mysql is a client program.
The server is named mysqld.
[EMAIL PROTECTED] [~]# service mysql start
[EMAIL PROTECTED] [~]# mysql
Hi,
I am on a redhat, i read a lot of doc on the problem I hav but noway to
advance, mysql won't start and won't tell anything :
[EMAIL PROTECTED] [~]# service mysql start
[EMAIL PROTECTED] [~]# mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
[EMAI
Hello,
The windows binary of 4.1.1 was around 20 MB. With
4.1.2 it has increased to 34 MB. Thats a big jump ?
Karam
__
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
MySQL General Maili
Hello:
I am posting this message on freeRADIUS, vpopmail & mysql lists. This may
get few people upset but please read
I am trying to install (on RH9), qmail, vpopmail, mysql, Courier-IMAP,
squirrelmail, etc., with backend data on MySQL. On another computer I have
installed RH9 & freeRADIUS se
Hi,
I have a question about MySQL queries. First I will explain the situation,
then I will provide an example.
Situation:
I have the tables 'offer', 'contact' and 'offer_contact'. Table 'offer'
contains data about offers, table 'contact' about contacts. Table
'offer_contact' tells which contac
At 22:54 -0700 6/4/04, jerome greene wrote:
Where do you run the verify programs from? Are they ran from the
command prompt? Do I copy the keys?
Thanks
What is the context of these questions?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General
SQL
Hi, all!
I have a problem after migration from 4.0.20 to 4.1.2
I have a table `analit`.
this is the result of show create table:
CREATE TABLE `analit` (
`d` date NOT NULL default '-00-00',
`service` binary(16) NOT NULL default '',
`price` char(50) NOT NULL default '',
`type` char(50
27 matches
Mail list logo
