Dear Everybody,
Today I received the following error message in my web site (which is in php with
mySql in UNIX environment), but it worked half a year until Today:
Database allasajanlat
Error
SQL-query:
SELECT TEHinserted, INFfoglalkozas, KEPmihezertek, KEPszakvizsgak, id FROM on
I've download the tar.gz file off of mysql.com, then I modified
the Makefile for the mm.mysql.jdbc program so that it pointed
to my java binary directory. When I run "make all" it gives
me about 50 or so errors (one included as attachment) but
basically consists of
.PreparedStatement should
On Fri, Jun 01, 2001 at 10:00:01AM -0700, Kenneth Kopelson wrote:
>
> I am hoping there are people who use MySQL for serious business
> applications on this list.
We're occasionally serious here. Other times, it just depends on the
sort of mood that people seem to be in. :-)
(I just think it's d
On Sat, Jun 02, 2001 at 04:30:29PM +0200, Nimeesh Patel wrote:
> i want to know is there any size limit(no. of rows) for mysql
> created table. In my case table contain only four cloumn
> date,ip_address(varchar[20],tx_bytes(integer),rx_bytes(integer). i
> want to maintain a huge database of t
On 03-Jun-01 Derby wrote:
> Dear Everybody,
>
> Today I received the following error message in my web site (which
> is in php with mySql in UNIX environment), but it worked half a year
> until Today:
>
> MySQL said: Got error 127 from table handler
>
> I suppose too many records are in
On Fri, Jun 01, 2001 at 11:43:25AM -0700, Kenneth Kopelson wrote:
>
> Thank you Steve, I appreciate your response :) I have considered
> modifying MySQL to do what I have asked for, but I didn't want to do
> that until I verified it wasn't already available somewhere. I'll
> bet this feature is s
Hi again,
(Posting this once again because I didn't ever get this back from list server)
I have five tables in the database: customers, orders, ordercontents, products and
payments. The problem is that I should get a list which shows some kind of a ledger
list (shows who has paid and so on).
Dear Kenneth,
did you ever consider looking at other technologies than the database
driven one? Javaspaces seems to me a very interesting solution for
handling distributed storage, and your case seems to be difficult to
handle from a database-centric point of view.
If you're interested, these ur
Chris Cameron writes:
> Hi,
>
> Seems I've never had any luck with MySQL and OpenBSD, and I'm hoping I can
> finally get some help now that I've finally got around to recompiling it
> again.
>
> I'm running OpenBSD 2.7 and am compiling MySQL 3.23.38. I'm using the
> configure options;
> "CXXFLAG
Gary Huntress writes:
> Hi,
>
> I've started mysql with the parameter -O wait_timeout=1000 and verified
> that it is set using show variables. Yet I routinely see lingering
> processes with times over 1100 and higher. I have about 1000 active
> database users at the moment, most are connect
Ben Escoto writes:
> Hi, I think I found a bug in mysql. I tried the mysqlbug thing but it
> didn't work right away. I hope this message will be detailed enough.
> I am not subscribed to the mailing list.
>
> In the following sections are the output of, respectively:
>
> mysql -e "SHOW VAR
dear everybody,
i've got error message when test ./mysqladmin -u root
-h my-host version, but if ./mysql -u root -p , it's
ok.how to solution?.
tank you
=
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year!
Did you try using binary build? One which I use locally here, I just have to
un-tar
the tar file and then add the .jar file in the classpath!
You can try downloading binary build from this place:
http://mmmysql.sourceforge.net/
That's it!
...Rohit
- Original Message -
From: Nico D <
Hi all,
I hava a little problem for developping a windows mysql client program in
C++.
I compile it using cygwin. there is no problem during the compilation but
when I execute it, it seems that when I execute a select query and retrieve
the data, it access memory that it shouldn't. I tested my pr
On Sat, 2 Jun 2001, Jens Luedicke wrote:
> I'm using MySQL through the Perl DBI and I want to merge
> two SQL statements that would simplify my code:
>
> 1. SELECT * FROM filters WHERE folder != '$folder'
> 2. SELECT * FROM mails WHERE folder_name = '$folder' AND x$filters->{type} LIKE
>'%$filt
Thankx! I found the jar file.
ta
-nico
On Sun, 3 Jun 2001, Rohit Peyyeti wrote:
>
> Did you try using binary build? One which I use locally here, I just have to
> un-tar
> the tar file and then add the .jar file in the classpath!
>
> You can try downloading binary build from this place:
> http
Hi
I have just started to look at mysql as a database for use with kylix,
using Linux Mandrake 8.0. One thing I would like to be able to do is store
data in a directory of my choice, but their seems to be no infomation on
this. The only infomation is on a procedure in windows, but the comm
On Sun, Jun 03, 2001 at 05:39:57AM -0700, bulls wrote:
> dear everybody,
> i've got error message when test ./mysqladmin -u root
> -h my-host version, but if ./mysql -u root -p , it's
> ok.how to solution?.
> tank you
There are two differences between your commands (aside from the fact
that one
Kenneth,
there was discussion about Parallel MySQL on the internals mailing
list 3 months ago. I have pasted at the end of this message what
I then wrote there about a parallel InnoDB.
I think Jeremy Zawodny is right in suggesting that you create several
application server processes on several c
Unsure on the Paths, but I know someone else will help there, but Kylix doe
not support the current version of MySQL with the libmysql.10 only version
.6 or the 3.23.32 version.
Cheers
-Original Message-
From: simon [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 02, 2001 3:41 PM
To: [E
At 9:27 PM +0100 6/2/01, Tommy Beavitt wrote:
>In response to a recent question I posted regarding installing
>MySQL/PHP/Apache on a G4 tibook I was recommended to get a copy of
>Mac OS X as this was condsidered to be the most stable and easily
>configurable option at my disposal.
>
>I am fairl
Current FreeBSD. What stupid thing have I done now?
# make
gcc innovcheck.o -o innovcheck /usr/local/lib/vrx/libvrx.a /usr/local/lib/mysql/
libmysqlclient.a /usr/lib/libc.a /usr/lib/libm.a
/usr/libexec/elf/ld: Warning: size of symbol `rtime' changed from 9 to 571 in rt
ime.o
/usr/libexec/elf/ld:
Hi!
>With mysqldump which uses the following query to do this:
>
>SELECT * INTO OUTFILE '/spylog/test/g00hits.txt' FROM g00hits
>
>It takes:
>real1m23.177s (first time)
>real1m20.934s (second time)
The dump speed is 45000 rows or 5 MB per second. I think best disks
today can write 1
> "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
> wrote the following on Sun, 3 Jun 2001 14:52:44 +0300 (EEST)
>> Hi, I think I found a bug in mysql. I tried the mysqlbug thing
>> but it didn't work right away. I hope this message will be
>> detailed enough. I am not subscribed
Ben Escoto writes:
> Thank you for the response. In which cases does DESC disable indexed
> sorting? Perhaps there is a a way around this for the time being?
> For instance, I noticed that although:
>
> SELECT * FROM sqmail.sequence_data WHERE sid = 16 ORDER BY sid DESC,id
> DESC LIMIT 10
>
>
> does not and is quite fast. Somehow the optimizer is getting confused
> by the "sid = 16". I was thinking that perhaps there is some magic
> way of rephrasing the problem that MySQL would understand better.
> Failing that, what is the recommended way of making this query
> quicker? Should I i
On Sun, Jun 03, 2001 at 11:01:50AM -0700, Ben Escoto wrote:
> > "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
> > wrote the following on Sun, 3 Jun 2001 14:52:44 +0300 (EEST)
>
> >> Hi, I think I found a bug in mysql. I tried the mysqlbug thing
> >> but it didn't work right away. I
Howdy:
I'm a bit new to MySQL ( and unix in general ), and I have a couple of
questions:
We're using the command:
/usr/local/bin/safe_mysqld &
to startup MySQL on a Mac OSX Server 1.2.x system.
We would like to add the ability to have it do an auto check/recover
of the
> "SM" == Sinisa Milivojevic <[EMAIL PROTECTED]>
> wrote the following on Sun, 3 Jun 2001 21:31:48 +0300 (EEST)
>> Thank you for the response. In which cases does DESC disable
>> indexed sorting? Perhaps there is a a way around this for the
>> time being? For instance, I noticed
Hi
How would you set it up so that each server uses different auto numbers?
Could I do it so that server A's auto numbers start with A, and B's with B,
etc etc etc?
Thanks
Warren
~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, S
If you are uncomfortable with RPM try
the following:
rpm -qa | grep mysql
rpm -qa | grep MySQL
rpm -ql MySQL-client*
Also red the maximum rpm manual:
slocate RPM; slocate rpm | grep pdf
I think mysqladmin might be under /usr/sbin.
And to find out where a file came from do
rpm -qf path-to-file.
On Sun, Jun 03, 2001 at 12:37:50PM -0700, Ben Escoto wrote:
>
> JDZ> Did you try (sid > 15 and sid < 17), or something that means
> JDZ> the same thing as (sid = 16) if sid is an int?
>
> JDZ> Don't know if it'll help, but you never know...
>
> Yep, I thought that was worth a try and atte
Is this new syntax? It seems to be different from your book, Paul.
Z
On Friday, June 1, 2001, at 10:50 PM, Paul DuBois wrote:
> At 10:13 PM -0400 6/1/01, daddius wrote:
>> hello everyone... I am very new to mysql and I needed some help
>> creating 1
>> admin account for 4 computers.
>> This
Howdy:
( sorry if this is a second post, but I'm not sure if the 1st. one I sent
went out OK )
I'm a bit new to MySQL ( and unix in general ), and I have a couple of
questions:
We're using the command:
/usr/local/bin/safe_mysqld &
to startup MySQL on a Mac OSX Server 1.2.x
At 4:39 PM -0400 6/3/01, Zachary Burnham wrote:
>Is this new syntax? It seems to be different from your book, Paul.
Yes, the quoting rules changed a little subsequent to publication of
the book. The safest way to specify the account name is to quote both
the user and host parts, but you must qu
On Saturday, June 2, 2001, at 04:27 PM, Tommy Beavitt wrote:
> In response to a recent question I posted regarding installing
> MySQL/PHP/Apache on a G4 tibook I was recommended to get a copy of Mac
> OS X as this was condsidered to be the most stable and easily
> configurable option at my di
>Description:
If a SET coumn contains values with , (comma), it's impossible to
distinguish values with a , from multiple values.
>How-To-Repeat:
mysql> alter table test add SetCol SET ('BLONDE', 'TALL', 'BLONDE,TALL');
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
Hello.
On Sun, Jun 03, 2001 at 11:27:46PM +0200, [EMAIL PROTECTED] wrote:
> >Description:
> If a SET coumn contains values with , (comma), it's impossible to
> distinguish values with a , from multiple values.
Yes, this is the documented behaviour:
-- http://www.mysql.com/doc/S/E/SET.ht
hola amigos, tengo el siguiente problema con mysql,
Cuando ejecuto mysql me sale el siguiente mensaje:
Can´t connect to local MySQL server through socket
'/usr/lib/mysql/mysql.sock/ (111)
¿Por ke me sale esto?
Espero ke me ayuden. Gracias
_
Hi,
I am using my sql CAPI.I am able to access the
database well but there is one performance issue that
came into my mind.
Is it better to have a single query on multiple tables
using joins?
(OR)
Multiple queries without joins on each table,in a
sequential order .
If I use jo
So sprach Benjamin Pflugmann am Sun, Jun 03, 2001 at 11:42:34PM +0200:
> Hello.
Nabend!
> Yes, this is the documented behaviour:
Oh, I must have overlooked the last sentence. Thanks for pointing it out.
> Regardless, this is an interesting proposal which should be
> considered. Only problem i
>Description:
InnoDB crashes when a ROLLBACK of multiple "LOAD DATA INFILE 'file'
REPLACE INTO 'table' commands.
mysqld will not startup again because InnoDB attempts the rollback
and crashes again.
>How-To-Repeat:
#create a data file (100,000 lines of 3 integers from 0 to 99)
Here the situation. I need to develop some database applications that will
run under Apache Web server. That in itself is not to tough. But, I must
be able to access the information stored in the database files from a
windows 2000 workstation and use Crystal reports to generate the necessary
ma
I do something like this, where $result is the result of a mysql_query():
This is to fill one column on screen. Now I would like to do the same for
the second column: if ($row[col] == 2). But the $result pointer has moved
to the end. How to move it back to the start again? reset() won't work,
On Sun, Jun 03, 2001 at 04:59:24PM -0600, Rick Hanzlik wrote:
> Here the situation. I need to develop some database applications
> that will run under Apache Web server. That in itself is not to
> tough. But, I must be able to access the information stored in the
> database files from a window
I've just joined this list as I'm considering using mysql. My databases are
in Access format, and I don't wish to convert to SQL just yet (although long
range plans are indeed to do just that), but I need to be able to read them
in Perl CGI scripts, which is why the interest in mySQL. Is this a fe
>Hi there,
>
>I have five tables in the database: customers, orders,
>ordercontents, products and payments. The problem is that I should
>get a list which shows some kind of a ledger list (shows who has
>paid and so on).
>
>My first try looks like this:
>SELECT orders.OrderID, customers.Name, S
bulls wrote:
>
> dear everybody,
> i've got error message when test ./mysqladmin -u root
> -h my-host version, but if ./mysql -u root -p , it's
> ok.how to solution?.
> tank you
>
> =
>
Bulls:
Try mysqladmin -p -u root version
Van
--
=
> Sir, your query doesn't work on my machine. I either have to GROUP BY
> orderID, or drop orderID and Name from the SELECT clause. I'm not
> sure what you're trying to do, so I don't know which to suggest.
Oh, sorry, I didn't check out what did I wrote... ;) Anyway, I got this work after
GROU
Yep, that's the way you do it. Put it into a 2D array or even better, a
class. That's if you are familiar with OOP.
- Original Message -
From: "Marco Bleeker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 6:57
Subject: PHP and MySQL result set navigation
> I d
Perl works beautifully with MySQL, as do PHP and Java, and
$SCRIPTING_LANGUAGE. Choose your poison.
Z
On Sunday, June 3, 2001, at 08:36 PM, Gary Bonham wrote:
> I've just joined this list as I'm considering using mysql. My databases
> are
> in Access format, and I don't wish to convert to SQL
Hi all
I installed the following version on redhat 6.2 but failed on installing
apache finally!
Please teach me
apache 1.3.19
php-4.0.5
mysql-3.23.38-pc-linux-gnu-i686.tar.gz
mysql can start: /usr/local/mysql/support-files/mysql.server start
php nothing error: when make and make install
./con
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
hello,
i'm trying to install mysql 3.23.38 for linux. the bin directory didn't
expand when i untarred the mysql installation tarball? is this a known issue?
tia
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
--
hello,
i'm looking for a good online mysql tutorial. any suggestions?
tia
if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server *
javascript }
-
Before posting, please check:
http://www.mysql.com/manual.
Hello,
Can anyone tell me if the MySQL database has a defualt user ID and
password? I am trying to access a remote DB with my application, but am
experiencing difficulties. This may be because I need correct user access
details. Are there such details, and if so, what are they please?
If your not the admin of the DB, you'll have to ask the DB's admin for your
login and password. If you are the admin, you'll need to RTFM about DB
security and the GRANT and REVOKE statements. And no, it's not a good idea
to allow connections using the root user to perform anything else other th
If you use IE which associate to PDF file, it may be take a long time to
display when you click on the link. Try to use download feature instead
display (click right mouse on link and choose save target as or download
with getright/if you have one installed)
Sommai Fongnamthip
At 09:20 2/6/2
58 matches
Mail list logo
