Dear Sirs and Madams,
I have installed mysqlgui-static on my PC. Please let me know how to start it, so that
I can use it.
2. Have you or anyone else developed any utility to make it easy to populate the
tables? The default method is too cumbersome. If so, kindly direct me to the links etc.
3.
On Sun, Jan 20, 2002 at 12:01:29AM +0100, Henning Sprang wrote:
Hy all,
i am just trying to tunnel a mysql client connection via ssh. i am
behind a firewall that doesn't let mysql connections through to the
outer world.
But i can do ssh to the host i want connect to. Tunneling http port
Hello Jeremy,
Thank you for keeping correspondence.
Kind regards
Emmanuel
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: 20 January 2002 08:22
To: Emmanuel van der Meulen
Cc: [EMAIL PROTECTED]
Subject: Re: Version 4 Schedule RE: Roadmap
On Sat, Jan
- Original Message -
From: Richard Burgmann [EMAIL PROTECTED]
To: Markus Lervik [EMAIL PROTECTED]
Sent: Sunday, January 20, 2002 9:53 PM
Subject: Re: Porting from MS SQL to MySQL
Hi Markus,
I'm an IT Consultant by trade and have been involved in lots of green
fields
projects and
Hello Mark,
Thank you for the note and feedback. BTW, it was not over a network. Both
on local PC. So all the time went into building the resultset in memory.
I'm surprised at the time that takes.
Further to why I'm desirous to do this query, twofold. One I get the record
count (rows in the
Hello Mark,
Thank you for the note and feedback. BTW, it was not over a network. Both
on local PC. So all the time went into building the resultset in memory.
I'm surprised at the time that takes.
Further to why I'm desirous to do this query, twofold. One I get the record
count (rows in the
Jeremy Zawodny wrote:
On Sun, Jan 20, 2002 at 12:01:29AM +0100, Henning Sprang wrote:
[...]
so fra , so good. Then doing
# ssh [EMAIL PROTECTED] -L 8:localhost:3306
and connecting to port 8 on my machine with telnet gives me
something like
Trying ::1...
Connected to localhost.
Hello Nick,
Does ROWNUM exist in MySQL?
Kind reagrds
Emmanuel
-Original Message-
From: Nick [mailto:[EMAIL PROTECTED]]
Sent: 19 January 2002 20:41
To: Shankar Unni
Cc: [EMAIL PROTECTED]
Subject: [OT] Re: Understanding throughput with JDBC
With Oracle, the *only* solution
Hello Dave,
Thank you. This works.
Kind regards
Emmanuel
-Original Message-
From: Adrian Monea [mailto:[EMAIL PROTECTED]]
Sent: 20 January 2002 15:08
To: 'Emmanuel van der Meulen'
Cc: [EMAIL PROTECTED]
Subject: RE: Understanding throughput with JDBC
Why not try to use
Dear sir,
I used mysql-4.0.1 running on Solaris-2.5.1 and
compile with Gcc-2.95.3. (package from www.sunfreeware.com)
I used command below.
CC=gcc CFLAGS=-O3 \
CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \
./configure --prefix=/usr/local/mysql --with-low-memory
Jeremy Zawodny wrote:
On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote:
Hi All,
I've just migrated from mysql-3.12 to 4.0.1 and despite a mysqld crash a
few minutes ago there is a strange problem I've never had in mysql
version 3:
mysql lock table .develop.Pseq read;
Rownum exists of a sort with the limit clause.
Rowid does not exist all at.
Tony
- Original Message -
From: Emmanuel van der Meulen [EMAIL PROTECTED]
To: MySQL Java List [EMAIL PROTECTED]; MySQL General List
[EMAIL PROTECTED]; Nick [EMAIL PROTECTED]
Sent: Sunday, January 20, 2002 12:46
Hi All,
Mysql-4.0.1-alpha crashes when updating privileges.
mysql select * from user where user = 'bmm';
I believe the correct command is LOCK TABLES with an 'S' at the end.
your quoted command says LOCK TABLE without the 'S'.
HTH
At 04:15 PM 1/20/2002 +, Arne Mueller wrote:
Jeremy Zawodny wrote:
On Sun, Jan 20, 2002 at 03:46:14AM +, Arne Mueller wrote:
Hi All,
I've just migrated
Hi,
I have a while loop pulling information into an editing form. It labels
variables dynamically as so:
name=schooling?php echo $counter?
Where $counter is augmented each time through the loop. In order to then
insert these, I need to do an insert of $schooling$counter. Below is the
statement
I have been reading 'MySQL' by Paul DuBois for some time now and have finally managed
to de-bug (or so I thought) the script called edit_member.php on page 378 - 385.
When I view the page in a browser I get the 'Member ID' 'Password' fields displayed
as expected, however, nothing works even
On Sun, Jan 20, 2002 at 01:08:04PM +0100, Henning Sprang wrote:
Try using localhost instead of my.local.hostname. Since you
didn't use the `-g' option for SSH, I wouldn't expect what you're
doing to work. See the SSH docs for why.
hmm, that won't work at all, as there is a real mysql
I hope you can answer the following question. I am
wondering how to create a table with a column named
key. I have RTFMed and that didn't help. I'm using
3.23.47-max-debug.
The following fails (after selecting a database):
mysql create table test (key varchar(255), value
varchar(255));
Dominique,
On Sun, Jan 20, 2002 at 12:18:45PM -0800, Dominique Plante wrote:
The following fails (after selecting a database):
mysql create table test (key varchar(255), value
varchar(255));
You should be able to do this by using back-quotes around
the column name:
create table test
I'm writing an application in VB6 (SP5/ADO 2.1) using MyODBC 2.50.39. When
selecting more then 9 fields out of a specific table I get:
Runtime Error -2147467259 (80004005), ODBC Driver Manager: Function
Sequence Error.
Can someone give me a clue or a direction where to look for.
Thanks in
Soory the last message wasn't explicit enough:
I'm writing an application in VB6 (SP5/ADO 2.1) using MyODBC 2.50.39. When
selecting more then 9 fields out of a specific table I get:
Runtime Error -2147467259 (80004005), ODBC Driver Manager: Function
Sequence Error.
It happens on the
Hi!
I have forwarded your questions to the MySQL public email list, so
that other people can benefit from my answer.
If you have any more questions about MySQL, please send them to
[EMAIL PROTECTED] instead directly to a MySQL developer or MySQL
user.
If you want to have guaranteed MySQL
Hi!
Emmanuel == Emmanuel van der Meulen [EMAIL PROTECTED] writes:
Emmanuel Hello Mark,
Emmanuel Thank you for the note and feedback. BTW, it was not over a network. Both
Emmanuel on local PC. So all the time went into building the resultset in memory.
Emmanuel I'm surprised at the time
Perhaps you read the wrong part(s) of the manual:
http://www.mysql.com/doc/R/e/Reserved_words.html
On Sun, 20 Jan 2002 12:18:45 -0800 (PST), Dominique Plante wrote:
I hope you can answer the following question. I am
wondering how to create a table with a column named
key. I have RTFMed and
Okay, does anyone know how long this will take?
22 million records, fulltext index on a single field, first 40 chars.
record length 768 chars, variable.
It's been running for 2 days, processlist quotes time at around 10.
Index file still growing occasionally, up to 3Gb.
Should I let it
A couple of reasons why they might go this route is, one they might already have
something similar to your needs based on mssql that they can customize quick and easy
for a fast delivery ( hows their time table their bid in comparison ). Or two they
just don't have the mysql expertise in
Pretty much as the subject states, I am not a member of this list yet, as I
am sure my mail server cant handle the amont of messeges that come through
so please reply directly at [EMAIL PROTECTED]
I need to limit the max size of a database in MySql that is created for a
user on a
few levels...
So far I have successful set up tables in mysql
InnoDB
with primary and foriegn keys. Unfortunately I am
having some difficulty in getting the proper
results
as I am new to sql and databases. I would be most
grateful if someone took a minute and explained or
helped with the
Hi!
I have forwarded your questions to the MySQL public email list, so
that other people can benefit from my answer.
If you have any more questions about MySQL, please send them to
[EMAIL PROTECTED] instead directly to a MySQL developer or MySQL
user.
If you want to have
So far I have successful set up tables in mysql
InnoDB
with primary and foriegn keys. Unfortunately I am
having some difficulty in getting the proper results
as I am new to sql and databases. I would be most
grateful if someone took a minute and explained or
helped with the following :
All,
I have searched the online manual in vain for mySQL system
requirements. Can anyone give me the precise URL? Is there one?
I want to play around with converting an existing FoxPro data base (about
65mb in all tables, 55mb in the largest table) to mySQL. And learning PHP
from square
that's no problem!
--
Zu Zhihui [EMAIL PROTECTED]
- Original Message -
From: Erv Young [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 21, 2002 11:56 AM
Subject: MySQL system requirements
All,
I have searched the online manual in vain for mySQL system
requirements.
The machine that is available without additional cost is a
dual Pentium
classic 166 with 128mb memory, 1.2G hard drive.
For a single user system for learning this will be MORE than enough. More
disk space is nice to install more optional packags in addition to the
MySQL--
that way you will
Hello Monty,
Thank you for your note and feedback.
After getting excellent assistance, I'm using JDBC setMaxRows rather than
LIMIT, which gives me portability.
I'll investigate SQL_CALC_FOUND_ROW option further. I notice I would need
to first upgrade to MySQL 4.x, though and then find / work
Hi,
Surely, the having clause is not redundant ( I misread it as 0).
Is it not the compound index (on mot,date,numresponse) which would
make the query fast instead of three single column indexes?
Thanks,
Anvar.
At 01:40 PM 19/01/2002 -0500, you wrote:
Anvar had some very good explanations
hello!
i'm with problem when i delete something from mysql, the table overhead a
few bytes
i'm running a sql query from a php page:
if($DEl $cid $sid $did) {
$d0-query(SELECT id FROM crd_favorites WHERE did='$did' AND
uid='$uid');
if($d0-num_rows()1) {
My experience (atleast with the 3.23 series) is that full text indexing is
not worth the hassle if you have an existing HUGE database... I let mysql
run for about a day or two on a 20gb database (dont remember exactly how
many rows it had) before giving up (note this was using 3.23.39). I found
On Friday 18 January 2002 17:30, you wrote:
We've requested a database from different companies, and specifically
said we wanted MySQL or PostgreSQL because of the open source angle
and we're a library.
One company offered MS SQL as the platform and said that they can later
on port it
Hi,
In fact I have a compound index on (mot,date,numreponse,topic), so I assume
(mot,date,numreponse) is also optimised if I correctly understand how indexs
work ;)
Anyway, I just wanted to run this query once, so it's not really my priority
to make speed faster on this particular query
hi 2 all!
does anybody knows an good ODBC like mysql driver for an java
application on an win2k proffessiona OS?
thanks!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
(food for ill-working-anti-spam-filters : database,sql,query,table)
Just wanted to thank everyone who got involved in this
(at times rather heated) discussion. You've given me
quite a few pointers to think about and stuff to concider
and take up with our project manager.
Cheers mates!
Markus
I really suggest you do a little homework and read the tutorials in both
the php and mysql manuals. They are really valuable and should give you
the examples you need.
Maintainer IPPlan (https://sourceforge.net/projects/iptrack/)
sql
Gary Lefko wrote:
Can someone writ eme an example of
Hello all,
I've been with MySQL for approx. a month now and have asked assistance with
several things, and;
I'm overwhelmed and acknowledge MySQl and the people of the mailing lists.
Thank you.
Kind regards
Emmanuel
-
Before
Saturday, January 19, 2002, 9:21:04 AM, Jeremy Zawodny wrote:
On Fri, Jan 18, 2002 at 10:38:43AM +0200, Dmitry Alyabyev wrote:
Hello
Time to time I see strange overload of MySQL on dedicated
server. The server is powerful enough to handle ~ 500 req/s. MySQL
version is 3.23.40 and runs on
44 matches
Mail list logo