So sprach »Fredrick Bartlett« am 2001-12-26 um 07:30:44 -0800 :
> Explain how to configure the handlers for myperl under the win32 platform...
I don't know.
filter: sql
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.is
Dear Marek and all,
I only can find one file end with err (sune250.trasy.com.err) and I can't
find any error message on that file after I run the following command:
# ./bin/mysql
ERROR 2002: Can't connect to local MySQL server through socket
'path-for-socket-file' (2)
#
# pwd
/usr/local/mysql-3.
Hi,
I have a situation as follows:
There is a table that stores the user name.
One user name is 'David' and another is 'david'
I want to select only the user with the name
'david'(all small and not 'David')
MySQL is case insensitive in selecting records...
how to make it case-sensitive in selec
- Original Message -
From: "Shankar Unni" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 27, 2001 12:57 AM
Subject: Re: Stored Procedure
> [ obfilter: mysql database ]
>
> Sinisa Milivojevic wrote:
>
> > Cafetechno writes:
>
> >>When The Stored Procedure Capability
Dear Marek and all,
The directory for MySQL (/etc/local)as below:
lrwxrwxrwx 1 root other 34 Dec 5 16:32 mysql ->
mysql-3.23.46-sun-solaris2.8-sparc
drwxr-xr-x 13 root mysql512 Dec 5 16:30
mysql-3.23.46-sun-solaris2.8-sparc
Thanks and regards,
Kevin Chan
Sent: Thu
Hello
look at the permitions of mysql data directory.
- Original Message -
From: "Kevin Chan" <[EMAIL PROTECTED]>
To: "Phillip B. Bruce" <[EMAIL PROTECTED]>
Cc: "Michael Brunson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, December 27, 2001 7:4
It works the way you want with this data when your query is written:
SELECT nev FROM hosoktest WHERE nev = ('pokember' OR 'Pokember');
Regards,
Doug
On Thu, 27 Dec 2001 01:33:57 +0100, Barnabas BONA wrote:
>If I execute the following select:
> SELECT nev FROM hosoktest WHER
Dear Phillip and all,
I am installing from Binary Distribution and just follow the INSTALL-BINARY
file to install. I just did all the steps below:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s m
Kevin Chan wrote:
> Dear Michael and all,
>
> Hi Michael, do you mind to tell me where is the location of the my.cnf file
> in my michane (Sun Solaris2.8) beacuse I can't find it ?
>
> And what I should change on that file to solve the problem? ... thanks !
>
> Thanks and regards,
> Kevin Chan
>
Dear Michael and all,
Hi Michael, do you mind to tell me where is the location of the my.cnf file
in my michane (Sun Solaris2.8) beacuse I can't find it ?
And what I should change on that file to solve the problem? ... thanks !
Thanks and regards,
Kevin Chan
Sent: Thursday, December 27, 2001
Hi,
I have a situation as follows:
There is a table that stores the user name.
One user name is 'David' and another is 'david'
I want to select only the user with the name
'david'(all small and not 'David')
MySQL is case insensitive in selecting records...
how to make it case-sensitive in selec
Hi,
We have an application that uses JBoss 2.4.3 as an app server and mysql
3.23.36 as the database.
All the database tables are of type "BerkeleyDB" .
All our DB updations are done within a session bean, our application
executes
approx. 1000 db updations per minute for a period of 10 minutes.
On Thu, Dec 27, 2001 at 12:11:17AM +0100, [EMAIL PROTECTED] wrote:
> Hi everybody,
> I really hope that there will be somebody who will waste a
> bit of his time helping a very, very beginner.
>
> I have a front-end database in MS Access that gets data from a MySQL back-end.
>
> Whe
Just my two cents: have you tried the following?
SELECT nev FROM hosoktest WHERE (nev = 'Pokember') OR (nev = \
'pokember');
Bogdan
Barnabas BONA wrote:
> If I execute the following select:
>SELECT nev FROM hosoktest WHERE nev = 'pokember' OR nev = \
>
On Wed, Dec 26, 2001 at 05:34:34PM -0500, Jose Villanueva wrote:
> > I'm a beginner in MYSQL, please can anyone tell me the right command in
> > ORACLE equivalent to the EXEC SP of SQL Server, i'm working with ORACLE
> > SP, i will apreciate any hepl, thanks.
Sir, I'm confused. If you want the OR
* Stig Nørgaard Jepsen
> > select distinct
> > t1.textkey,
> > if(t2.textid,t2.languageid,t3.languageid) as languageid,
> > if(t2.textid,t2.textid,t3.textid) as textid,
> > if(t2.textid,t2.textvalue,t3.textvalue) as textvalue
> > from texts t1
> > left join texts t2 on
> > t2.textkey=t1.
On Thu, 27 Dec 2001 12:00:08 +0800, "Kevin Chan" <[EMAIL PROTECTED]> wrote:
[...]
| # ./bin/mysql
| ERROR 2002: Can't connect to local MySQL server through socket
| 'path-for-socket-file' (2)
[...]
You may want to edit your my.cnf file to have the path to the socket file.
:-)
Thanks,
Michael
Hello!
I use MySQL 3.23.37 for made small base with access by LAN trough Apache &
PHP.
I receive next message:
File 'c:\mysql\\share\charsets\?.conf' not found (Errorcode: 2)
Caracter set '#14' in not a compiled character set and not specified in the
'c:\\mysql\\share\charsets\Index' file
This me
Dear Stavros, Durga and all,
Thanks for Stavros and Durga reply my email so fast. Durga I can't find a
file mysql.sock from /var/lib/mysql directory and I restart the server it
still don't exist.
I may add more information form my MySQL server to help all of you to solve
my problem.
OS: Sun S
On Thu, 27 Dec 2001 11:19:18 +0800, cbsly <[EMAIL PROTECTED]> wrote:
| In my catalogs, there are many tables with the same structure. Every table is very
|large, several
| million records and about 1 GB size. It is impossible to merge them into single one.
| How can I "select" in all of them at
In my catalogs, there are many tables with the same structure. Every table is very
large, several
million records and about 1 GB size. It is impossible to merge them into single one.
How can I "select" in all of them at the same time but not "select * from table1 where
..." then
"select * fro
From: Niksa Jurinovic <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Bug in embedded libmysqld library or configuration problem
>Description:
mysql-4.0.1-alpha, Linux Mandrake 8.1, Kernel 2.4.8
I have configured and compiled source code as always, without any problems.
'make test' was succes
Thanks, Dan, that sounds eminently sensible.
In that case, the doc bug becomes:
http://www.mysql.com/doc/F/L/FLUSH.html
which says:
[[[You can also access each of the commands shown above with the
mysqladmin utility, using the flush-hosts, flush-logs, reload, or
flush-tables commands.]]]
righ
* Eldon Ziegler
>
> mysql is slow when finding the last value before a period of time (I'm
> plotting the temperature values during a period of time and want the last
> value before the period begins).
>
> The query is:
> select DateTime, Target, Value from log
>where DateTime < "2001-12-21 00
In the last episode (Dec 27), Steve Rapaport said:
>
> The command FLUSH TABLES WITH READ LOCK has an equivalent,
> supposedly, from mysqladmin.
I doubt it. If the manual says there is it should probably be fixed.
Table locks are only held for as long as the connection that created
them is act
Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> luhar-123 writes:
> > Hi guys,
> >i have installed red hat linux 7.2 and mysql server version 3.23.42. but i need
>mysql++ also.but it seems that gcc version 2.96 will give lot of problems for
>mysql++. can any one pls give me a solution to u
Description:
It seems that there's a bug on the case-sensitive / case
insensitive fields. I have a table created as follows:
CREATE TABLE hosoktest (
idx int(11) DEFAULT '0' NOT NULL,
nev varchar(20) binary DEFAULT '' NOT NULL,
jelszo varchar(8
The command FLUSH TABLES WITH READ LOCK has an
equivalent, supposedly, from mysqladmin.
But whatever it is, it's not documented!
I've unsuccessfully tried
mysqladmin flush-tables --with-read-lock
mysqladmin flush-tables --read-lock
What works? Anyone?
--
Steve Rapaport
World Citizen
-
Philip,
>On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote:
>: The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts
>: per second would not be possible. Did the table fit in the buffer pool of
>: InnoDB or the SGA of Oracle? Did you commit each insert individuall
Hi everybody,
I really hope that there will be somebody who will waste a
bit of his time helping a very, very beginner.
I have a front-end database in MS Access that gets data from a MySQL back-end.
When I execute a "Pass-through Query" it works fine if I write:
"SELECT Orders
>Description:
precise description of the problem (multiple lines)
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>C
> I'm a beginner in MYSQL, please can anyone tell me the right command in
> ORACLE equivalent to the EXEC SP of SQL Server, i'm working with ORACLE
> SP, i will apreciate any hepl, thanks.
>
> Jose Villanueva
-
Before posting, p
On Thu, Dec 27, 2001 at 12:18:38AM +0200, Heikki Tuuri wrote:
: The MyISAM table obviously fit in the OS file cache, otherwise 1750 inserts
: per second would not be possible. Did the table fit in the buffer pool of
: InnoDB or the SGA of Oracle? Did you commit each insert individually in
: InnoDB
Walt,
thank you for the test!
>This post is partially a reply to a request to share my MyISAM/InnoDB/Oracle
>comparison testing with you guys. In addition, I have a question about
>locking mechanisms in InnoDB which I'll ask at the end of the post.
>
>I've been comparison testing MyISAM, InnoDB,
Alex,
With reference to Dave's comments/suggestions:-
> > I've got a 700-question multiple choice quiz that I've got imported into
> > MySQL, with one small problem: the answers to the quiz are not a separate
> > column. I have three columns for each of the possible answers; the correct
> > answ
This post is partially a reply to a request to share my MyISAM/InnoDB/Oracle
comparison testing with you guys. In addition, I have a question about
locking mechanisms in InnoDB which I'll ask at the end of the post.
I've been comparison testing MyISAM, InnoDB, and Oracle for the past two
weeks or
> -Original Message-
> From: Kelvin King [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 26, 2001 6:29 PM
> To: [EMAIL PROTECTED]
> Subject: Can't Connect
>
>
> I am attempting to connect to a MySQL instance hosted by addr.com, and I
> receive the error
>
> Can't connect to MySQL
> I've just downloaded and installed the rpm (to RH7.1), thus:
>
>PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
>This is done with:
>/usr/bin/mysqladmin -u root -p password 'new-password'
>/usr/bin/mysqladmin -u root -h potty.coho -p password 'new-password'
There
No problem, Barbara.
No ODBC required, either. I wish all my problems were this easy.
Basically you need to go back to your PC.
Export your database as CVS files from
Access (use TAB between fields, single quotes around each field, and
newline at end-of record). Put each table into a file nam
Hi,
> -Original Message-
> From: Barbara Ferrell [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 26, 2001 10:11 AM
> To: [EMAIL PROTECTED]
> Subject: conceptual problem with ODBC and mysql
>
>
> i am following 'SAMS teach yourself MYSQL in 21 days.. i have a conceptual
> proble
You know what i download a different on. go to rpmfind.net do a mysql
search. also down load the client plus the common ...
it should work.
if you have trouble let me know ok ...
Luis
On Wed, 2001-12-26 at 10:09, Richard Lyons wrote:
> I've just downloaded and installed the rpm (to RH7.1),
I've just downloaded and installed the rpm (to RH7.1), thus:
# rpm -iv MySQL-3.23.46-1.i386.rpm
Preparing packages for installation...
MySQL-3.23.46-1
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing
> database,sql,query,table
Haven't been able to solve the "File DSN" problem yet (running into the
same
thing as you), but I'm able to connect using a system dsn. is there any
reason why you need a file based one?0.
>
-
Bef
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:ryan reynolds
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Rel
i am following 'SAMS teach yourself MYSQL in 21 days.. i have a conceptual
problem with how i am going to get the data from my microsoft Access
database and insert it into mysql tables. i thought i was going to use ODBC
but after reading lots of pages it looks like you use this program if you
cont
[ obfilter: mysql database ]
Sinisa Milivojevic wrote:
> Cafetechno writes:
>>When The Stored Procedure Capability will be
>>included in mySQL
> Take a look at myperl on http://freshmeat.net
Interesting start, of course.
What would be nice is to support a proper "create or replace
proced
I am attempting to connect to a MySQL instance hosted by addr.com, and I
receive the error
Can't connect to MySQL server on '209.249.147.203' (10060)
What does this error 10060 typically indicate?
Kelvin-
-
Before posting, pl
"is NOT NULL" in the whare close
26/12/2001 16:46:44, Gilles Missonnier <[EMAIL PROTECTED]> wrote:
>Hi !
>
>I need a help on the syntax.
>
>My table has over 100 different fields: I want to display only the
>"NOT NULL" fields and also the names of these "NOT NULL" fields.
>
>so the simple mysql
Hi !
I need a help on the syntax.
My table has over 100 different fields: I want to display only the
"NOT NULL" fields and also the names of these "NOT NULL" fields.
so the simple mysql command :
mysql> select * from tabID where tabID.login='john';
returns a long ... long line, with many item
Explain how to configure the handlers for myperl under the win32 platform...
Alexander Skwar wrote:
> So sprach »Cafetechno« am 2001-12-26 um 10:34:59 +0700 :
> > If mysql will include the stored procedure feature, what kind of langguage
> > to be used for the stored procedure ?
>
> If you use m
Steve,
There isn't an automated way, but you can at least semi-script this. To
switch the slave to the master after the old master has failed and then
brought back up do this:
Shut down MySQL on the NEW master
mysqladmin -u root -p shutdown
Snapshot all the data on your NEW master server.
Hi,
Is it first time in using library(*.jar) with WebApplication?
Put it in webappdir/WEB-INF/lib/ dir.
This is a easiest way.
Hari Yellina wrote:
>
> Hi Guys,
> I am using mm.mysql driver, to connect to mysql.
>
> I have placed in lid of tomcat and given classpath as well. But it
Steve,
Are the two servers roughly equal in terms of hardware?
Scott Helms
>
> Please help, I've read through the manual and this case is suggested but
> not really
> laid out. I'm using mysql 3.23.37 and can't upgrade to 4.0 yet.
>
> Okay, I've got replication on 2 machines with a on
Hi list,
This is the first time I am installing MySql on my machine. I downloaded the
latest tar version (3.23.46) from mysql.com and tried to install it. But when
I gave the command
./configure --prefix=/usr/local/mysql
It gave me the message that you don't need to configure this
Please help, I've read through the manual and this case is suggested but
not really
laid out. I'm using mysql 3.23.37 and can't upgrade to 4.0 yet.
Okay, I've got replication on 2 machines with a one-way failover setup:
Master fails, slave takes over.
Now the slave has been recording updates
Downgrade to 2.95.3
- Original Message -
From: "luhar-123" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 25, 2001 2:09 AM
Subject: How to make use of mysql++ with gcc 2.96
> Hi guys,
>i have installed red hat linux 7.2 and mysql server version 3.23.42.
but i ne
So sprach »Cafetechno« am 2001-12-26 um 10:34:59 +0700 :
> If mysql will include the stored procedure feature, what kind of langguage
> to be used for the stored procedure ?
If you use myperl, it will be perl.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to
Hi.
Just wondering if this is something that has been planned for MySQL...
If MERGE table are used, from the documentation, my understanding is that
they are searched in sequence when a SELECT is issued. However, would it not
be reasonably easy to implement a parallel search algorythm, so that
>hope you version came out better thn mine.. in my mail it was all out of
>shape.. maybe could attach a text file.. doubt the list allows that
>thoough "alot dont"
Upload it as your_code_name.txt to your website and send an URL to the list.
filter: mysql query sql
Bye,
B.
--
59 matches
Mail list logo
