In the last episode (Dec 20), ads mysql said:
> Hi,
> I was looking to solution of same problem as Hans
> Kind.
>
> You have suggested to map network drive. Is it O.K.if SAMBA is
> ruuning on main server. Or can you guide to Documentation for mapping
> on Linux. I know it is out of topic but it wi
Hi,
I was looking to solution of same problem as Hans
Kind.
You have suggested to map network drive. Is it O.K.if
SAMBA is ruuning on main server. Or can you guide to
Documentation for mapping on Linux.
I know it is out of topic but it will help me great.
Thanks
--- Larry Brown <[EMAIL PROTECTE
Hello All,
> >person_tb contains mem_id, lname and fname
> >details_tb contains det_id and fin.
> >They both contain other fields, but I don't care about them at this time.
> > I'm trying the following
> >
> >select lname, fname
> >from person_tb, details_tb
> >where mem_id = det_id
> >and fin =
debug,
> is there any difference between:
> a)
>
> >>select lname, fname
> >>from person_tb, details_tb
> >>where mem_id = det_id
> >>and fin = "y";
>
> and
>
> b)
> select lname, fname
> from person_tb
> where mem_id in (select det_id from details_tb where fin = "y")
Yes, the first does give er
mysql 4.0.17 compilation fails during link phase, apparently due to problems
with libgthreads.so, one of the FSU pthreads libs.
mysql 4.0.16 compiles and runs without error.
SCO OpenServer 5.0.7 with maintenance and subscription SCO Update patches
GNU Development Tools 5.0.7Kj FSU Pthreads 3.9 (a
mysql 4.0.17 compilation fails during link phase, apparently due to problems
with libgthreads.so, one of the FSU pthreads libs.
mysql 4.0.16 compiles and runs without error.
SCO OpenServer 5.0.7 with maintenance and subscription SCO Update patches
GNU Development Tools 5.0.7Kj
FSU Pthreads 3.9 (a
I have two tables with a one to many relationship: boys and their toys.
I want to know if there are any advantages or disadvantages for each
of the following two ways to create the tables. I am mainly interested
in performance. Either way the insert and select queries aren't any
more difficu
You need to set up the initial privileges. Just follow the directions here:
http://www.mysql.com/doc/en/Default_privileges.html
Note: you shouldn't need to run mysql_install_db if you installed the rpm.
(I think)
-Original Message-
From: James Marcinek [mailto:[EMAIL PROTECTED]
Sent: Sa
Running MySQL (mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu
(i386)) on RedHat 9, and running into a rather serious (for me) problem.
Pretty much every business day, mysqld will at some point start to take
forever to finish queries. During this time, it uses tons of swap and
only 30 or so
Hello everyone,
I'm new to mysql so please forgive the basic question. I'm running redhat
8.0 with Mysql 4. The install was done with the mysql user. However every
time I try to get access, I get denied. Can someone tell me how to change
the password?
Thanks,
James
--
MySQL General Mailing Lis
Hi,
I am new to mysql. I have installed, created a database and also some created tables.
Now any one who can login to the host are able to drop the table or also the database.
How do I protect it?
-mysql
-
Do you Yahoo!?
New Yahoo! Photos - easier uploading
Thanks for you help, i have already check on google and i dont have found
any solution.
At 22:12 20/12/2003, mos wrote:
At 09:18 AM 12/19/2003, you wrote:
Hello,
I have upgraded win 2000 to 2003 and since this moment, MySQL 4.0.17 run
very slow. CPU usage is always between 60 to 100%.
Where i
At 09:18 AM 12/19/2003, you wrote:
Hello,
I have upgraded win 2000 to 2003 and since this moment, MySQL 4.0.17 run
very slow. CPU usage is always between 60 to 100%.
Where i can found a solution ?
Thanks a lot.
Rezo,
I remember reading threads where several others have had a
slowdown
Thanks to those that responded. The problem is solved there was a password
mismatch between MySQL (what I had set up) and jUDDI. I changed the password in MySQL
and it now works fine. BTW, to the person that asked, Axis worked fine all along.
VC Ramesh <[EMAIL PROTECTED]> wrote:
happyjuddi
The kind of processing you desired is easily accomplisches
with the following perl program:
#!/usr/bin/perl
while () {
if (/TO_DATE/) {
s/TO_DATE/STR_TO_DATE/;
s/(..)\/(..)\/()/$1-$2-$3/;
s/MM\/dd\//%m-%d-%Y/;
}
print $_;
}
[EMAIL PROTECTED] cat Landon.
On Sat, 2003-12-20 at 06:32, Marcelo Anelli wrote:
> Eric, please can you indicate how to write & use an UDF in php?
>
David Sklar wrote it, I have not used it.
http://www.sklar.com/page/section/projects
Cheers,
-- eric
> Thanks
>
> eric wrote:
> > If you have a need for User Defined Function
I have set up a script to recieve a pdf file and store it in a mysql db
using "update db set field=load_file('fileIncludingFile') where id=$id".
Afterwards I can see the file has been uploaded into the blob field
successfully and without errors. Now I want to get the file back out. I
set up a scr
You're trying to do a Sub-query, Sub-queries aren't supported until version
4.1.x
You could do a simple join/group to get these results:
SELECT
cities.id,
cities.name,
COUNT(images.city_id) as number_of_images
FROM cities
LEFT JOIN images ON(images.city_id = cities.id)
GROUP BY cities.id
-
sql from Oracle
insert into log_book values
(TO_DATE('08/12/1973','MM/dd/'),'C150','N5787G',1,1.8);
would like
insert into log_book values
(STR_TO_DATE('08-12-1973','%m-%d-%Y'),'C150','N5787G',1,1.8);
according to the manual, STR_TO_DATE is not until 4.0...I have 3.23.52
hate to write a
Am Saturday 20 December 2003 17:21 schrieb ads mysql:
> Yes I could uninstall mysql with
>
> rpm -qa | grep MySQL
> ("MYSQL" should be in Uppercase. I tried same with
> lower case earlier) Therefore has not worked.
> Anyway Thanks lot.
>
> I once again tried to install myssql with
>
> [EMAIL PROTEC
happyjuddi.jsp gives me the following error: (full text of the page enclosed at end of
message)
jUDDI DataSource Check
+ Got a JNDI Context!+ Got a JDBC DataSource (dsname=java:comp/env/jdbc/juddiDB)- DB
connection was not aquired. (Cannot create PoolableConnectionFactory)- SELECT COUNT(*)
FROM
I'm using 4.0.17. Isn't this SQL supported in this version?
Nuno Mendes
-Original Message-
From: Colleen Dick
Sent: Saturday, December 20, 2003 3:15 PM
To: Nuno Mendes
Cc: [EMAIL PROTECTED]
Subject: Re: Problem with sql sintax
What version you using?
Subselects are not supported in a
Yes I could uninstall mysql with
rpm -qa | grep MySQL
("MYSQL" should be in Uppercase. I tried same with
lower case earlier) Therefore has not worked.
Anyway Thanks lot.
I once again tried to install myssql with
[EMAIL PROTECTED] root]# rpm -i
MySQL-server-4.0.16-0.i386.rpm
[EMAIL PROTECTED] ro
Yes I could uninstall mysql with
rpm -qa | grep MySQL
("MYSQL" should be in Uppercase. I tried same with
lower case earlier) Therefore has not worked.
Anyway Thanks lot.
I once again tried to install myssql with
[EMAIL PROTECTED] root]# rpm -i
MySQL-server-4.0.16-0.i386.rpm
[EMAIL PROTECTED] ro
What version you using?
Subselects are not supported in any except the latest
Nuno Mendes wrote:
The sql bellow is giving a sql sintax error:
select
cities.id,
cities.name,
(
select
count(*)
from images
where ( images.city_id = cities.id )
) as number_of_images
from cities
Can you point me
This is what we did.
root [~] #rpm -qa | grep MySQL
MySQL-client-4.0.15-0
MySQL-embedded-4.0.15-0
MySQL-devel-4.0.15-0
MySQL-shared-compat-4.0.15-0
MySQL-shared-4.0.15-0
MySQL-server-4.0.15-0
# Now remove the RPM's
rpm -e --nodeps MySQL-server-4.0.15-0
rpm -e --nodeps MySQL-embedded-4.0.15-0
rpm -
Carlonie,
Use the UPDATE. I assume you mean by "database" here you mean the database table
named "members"... if so, try the following query.
UPDATE members SET user_name = 'john_doe' WHERE user_name = 'John Doe';
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publ
Hi,
I tried as you advised. But no luck.
[EMAIL PROTECTED] root]# rpm -qa | grep mysql
[EMAIL PROTECTED] root]# rpm -qa | grep mysql
[EMAIL PROTECTED] root]# ps ax | grep mysqld
854 ? S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql
884 ?S 0:00 /usr/sbin/mysq
If the servers are on the same local subnet, why not just map a network
drive so both servers have access to the file locally.
-Original Message-
From: Hans Kind [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 8:22 AM
To: [EMAIL PROTECTED]
Subject: load data in file
Hi,
We h
Eric, please can you indicate how to write & use an UDF in php?
Thanks
eric wrote:
> If you have a need for User Defined Functions in MySQL, now you can
> write them in java. (As well as C++, perl, python, or php, of course.)
>
> If you think java UDFs might be handy, please try it out and send
The sql bellow is giving a sql sintax error:
select
cities.id,
cities.name,
(
select
count(*)
from images
where ( images.city_id = cities.id )
) as number_of_images
from cities
Can you point me what am I doing wrong? Thank you!
Nuno
--
MySQL General Mailing List
For list archives: ht
... you can tell that this isn't going my way at all ...
I've got mysqld running. So, I go into the mysql shell and start
setting things up again, which is when I start getting some interesting
problems.
Firstly, 'SHOW DATABASES' doesn't work -
--
mysql> SHOW DATABASES;
ERROR:
No
Hi!
> "Chris" == Chris Man <[EMAIL PROTECTED]> writes:
Chris> Hi,
Chris> We have just installed MySQL 3.23.53 on Solaris 9. We were going through the
Chris> testing stages and it had produced an error.
Chris> Pasted below is the error that we received and also attached are the logs.
Chri
I have done following as advised :
[EMAIL PROTECTED] root]# rpm -qa | grep mysql
[EMAIL PROTECTED] root]# ps ax | grep mysqld
854 ?S 0:00 /bin/sh
/usr/bin/mysqld_safe --datadir=/var/lib/mysql
884 ?S 0:00 /usr/sbin/mysqld
--basedir=/ --datadir=/var/lib/mysql
8295 pts/0
Drago,
you only had the default InnoDB buffer bool, that is 8 MB. InnoDB row locks
CAN fill it in a big import if you have duplicate key errors in the inserted
rowset.
Also, tell us your MySQL version.
Regards,
Heikki
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <
Can the user the mysqld process run as (usually the mysql user) read/write
the /var/lib/data directory without problems?
Does your /etc/my.cnf file contain a
datadir = /var/lib/mysql
or is it pointing somewhere else?
Did adding skip-innodb to your my.cnf solve anything?
On Fri, 19 Dec 2003, lan
ads mysql <[EMAIL PROTECTED]> wrote:
>
> I tried as advised as follows :
> I tried to uninstall mysql rpm as
> rpm -e /var/lib/mysql
> It gives following.
> [EMAIL PROTECTED] root]# rpm -e /var/lib/mysql
> error: package /var/lib/mysql is not installed
/var/lib/mysql is not a package, it's MySQL
Mysql Mysql <[EMAIL PROTECTED]> wrote:
>
> I have a file which has Creation of tables and views.
Views currently are not supported in MySQL.
> How can I run the file in mysql prompt.
Use source (\.) command:
mysql> source /path/to/the/file/file.sql
http://www.mysql.co
Hi,
I have a file which has Creation of tables and views.
How can I run the file in mysql prompt.
-mysql
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.my
39 matches
Mail list logo
