-do you have any index covering this query?
-this is not a good practice to have function call(s) in the where
clause, since mysql will make the fucntion call for every rows scanned.
select count(*) as c
from users_table
where user_regdate 2002-06-01 00:00:00
-furthermore, in the where clause, =
I have a database on MySql divided into 3 tables
books (idbook, and other fields)
author (idauthor, and other fields)
bookauthor (idauthor,idbook)
This is to have more than 1 author for every book
How can I make a query to select on one row all the authors of abook?
Thanks
Antonio
Hi,
I already had a similar problem. I did the following things:
I zipped my master database to unzip it on the slave and then I did a reset
master,that's it.
The reason why you have this problem it's certainly due to the fact that
your master and slave database are not identical.
you didn't
I have a database on MySql divided into 3 tables
books (idbook, and other fields)
author (idauthor, and other fields)
bookauthor (idauthor,idbook)
This is to have more than 1 author for every book
How can I select with a query on one row all the authors of abook?
Thanks
Antonio
Hi Shahzad,
I also want to know whether mySQL support Unicode, utf-8 or not.
If you know anything about this please answer me as soon as possible,
Sincerely,
Mehdi Zare
-Original Message-
From: shahzad sarwar [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 8:35 PM
To: [EMAIL
* Tom Jones
I have a table with 2 columns StartDate and EndDate.
I can't seem to figure out how to write a select statement that will
tell me if the date I'm searching on is between the Start and the End
date.
Like, I want to know if 7/4/2002 is between 6/1/2002 (startDate) and
8/1/2002
* Harald Fuchs
In article [EMAIL PROTECTED],
Roger Baklund [EMAIL PROTECTED] writes:
Yes... that is strange. There could be a bug in the crashme
report, or the limit may have been lowered after 3.23.39, but
neither of those seems very likely (to me, anyway)... anyone
got a clue?
I
Anelia,
Thursday, June 06, 2002, 12:25:25 AM, you wrote:
AT Description:
AT I have problem with a Cyrillic when I use clauses ORDER BY
AT and LIKE.
AT They didn't work correctly.
What character set do you use? Change you charset to cp1251 or win1251 or koi8_ru.
--
For technical
Hi!
I store firstname, lastname, telephone etc in a table
Is there any drawback with using tinytext?
As I can see when I store strings that differ in length, the
best would be to use tinytext, or?
http://www.mysql.com/doc/n/o/node_369.html
In terms of fulltextsearch/index etc.
What is the
Mehdi,
Thursday, June 06, 2002, 11:27:24 AM, you wrote:
MZ Hi Shahzad,
MZ I also want to know whether mySQL support Unicode, utf-8 or not.
MZ If you know anything about this please answer me as soon as possible,
Unicode support will come in 4.1. Unicode in 4.1 will use UTF-8 and UCS2
with a
I think what you're getting at is that you're trying to consider both
'contactInfo' and 'entity' to be superclasses, with subclasses like
'phoneContactInfo', 'addressContactInfo', etc. and you'd like other tables
to have fields which reference the superclass. Inheritance relationships are
a
Jetaime,
Wednesday, June 05, 2002, 11:45:56 PM, you wrote:
J how can i setup a mysql server on a machine that is on the network to accept
J connections from my machine. I downloaded the client and there is currently
J a server running on a nother machine on the LAN. I inputed it's ip address
J
Good Day
I will attempt to give you as much information about the software as I can
before I ask the question.
OS : RedHat 7.1
MySQL : Version 3.23.49a for Linux - binary distribution for pc-linux
I want to insert into longblob column very big large data.
but.. I have strange Errors...
Is View supported by MySQL?
if not supported, is there any other way to achieve it?
I have a table of history data
because the table is growing too much
so I will divide it into 12
but I therefore have to modify all the programs
if I can have a view of the original name that select from all
* Borus.Kung
Is View supported by MySQL?
no.
if not supported, is there any other way to achieve it?
I have a table of history data
because the table is growing too much
so I will divide it into 12
but I therefore have to modify all the programs
if I can have a view of the original
Hi all
How do i create users in mysql..
After installing i just start mysql and connect to it..
Whats the default username and password it uses..
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi!
A little effort please
http://www.mysql.com/doc/A/d/Adding_users.html
and
http://www.mysql.com/doc/D/e/Default_privileges.html
EG
Hi all
How do i create users in mysql..
After installing i just start mysql and connect to it..
Whats the default username and password it uses..
* marc malacarme
I can¹t seem to make any of the describe or show queries work
when I apply a search statement:
Query=show table status from demo;
Works fine. Now I¹m trying to get info from only one table:
Query=show table status from demo where name like user_access;
Does no work.
The
Hi!
There have been some new additions on the MySQL++ page.
First of all, thanks to the efforts of Clint Savage [[EMAIL PROTECTED]]
and Arturs Aboltins [[EMAIL PROTECTED]] we have two new
files :
* mysql++1_7_1win32_borland_1_2.zip a new version of MySQL++ for
Borland C++ with many bug
[snip]
Lastly only a few people will be able to use you application before MS
Access fails... Therefore limiting access to your mission critical
applicaiton
I do not really think MS Access is for Mission-Critical databases...but I
guess that depends on ther definition of mission critical. Most
(first some info and 'things that I want', then a few questions)
Hi
I'm actually using MySQL 4.0.1-alpha in a production system now. Only using
MyISAM tables. ( http://www.gnist.no )
The only problem I have is that sometimes the database crash with some
fulltext searches... And with only some
If you include the following flag in the startup command, the logfile will
be generated in the given location:
--log=/var/log/mysqld.log
Eivind
sql, query
- Original Message -
From: Ritu Singla [EMAIL PROTECTED]
To: Eivind A. Sivertsen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Grant select, insert, delete ... on db.tb || db || * to username@host
identified by password
Alexander
-- Mensagem Original --
Hi!
A little effort please
http://www.mysql.com/doc/A/d/Adding_users.html
and
http://www.mysql.com/doc/D/e/Default_privileges.html
EG
Hi all
How do i
Dear all,
it's our first time to realize a project, based on mySQL Database and now
we have a problem i hope we can solve easily.
There are different partners in this project and the actual solution is
based on a MS-Access Fronten (arrrggh!). Now the partner have to do some
input and they all
If you include the following flag in the startup command, the logfile will
be generated in the given location:
--log=/var/log/mysqld.log
Eivind
sql, query
- Original Message -
From: Ritu Singla [EMAIL PROTECTED]
To: Eivind A. Sivertsen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Arul,
Thursday, June 06, 2002, 1:35:26 PM, you wrote:
A How do i create users in mysql..
A After installing i just start mysql and connect to it..
A Whats the default username and password it uses..
Check our manual:
http://www.mysql.com/doc/A/d/Adding_users.html
Erlend,
Thursday, June 06, 2002, 2:53:02 PM, you wrote:
EHS I'm actually using MySQL 4.0.1-alpha in a production system now. Only using
EHS MyISAM tables. ( http://www.gnist.no )
EHS The only problem I have is that sometimes the database crash with some
EHS fulltext searches... And with only
Peter,
Thursday, June 06, 2002, 12:29:53 PM, you wrote:
PE I store firstname, lastname, telephone etc in a table
PE Is there any drawback with using tinytext?
PE As I can see when I store strings that differ in length, the
PE best would be to use tinytext, or?
PE
I need some help... The query below runs
fine in access, when running it in mysql it tells me the column wrainfo.wuc
doesn't exist in the having clause.. can't figure out why its giving me this
error. the column is in the select statement... any ideas? The column does
exist.. I'm looking at
When I try to change the id field in the parent table below, I get the
error: 1217 - Cannot delete a parent row; a foreign key constraint fails.
What have I got wrong? Shouldn't it cascade the changes that were made to
the parent down to the child table?
This is done with Mysql 3.23.50-max
I've not looked over your query in-depth so I may be off-base here. Try
removing the parentheses from the FROM clause and see if that makes it work.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Scott Raley [mailto:[EMAIL
Hi!
don't think ON UPDATE is supported.
The manual : http://www.innodb.com/ibman.html doesn't mention anything about
it except :
Starting from version 3.23.50 you can also associate the ON DELETE CASCADE
or ON DELETE SET NULL clause with the foreign key constraint.
EG
When I try to change
EMS HiTech company is announcing the next version (1.76) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.76?
1. An ability to
Actually it was the alias, but the query is producing the wrong results. It
should produce 3 results which I get in Access I cut and paste this query into
mysql and get 12371 results. Same databases.
Cal Evans [EMAIL PROTECTED] on 06/06/2002 08:50:51 AM
Please respond to [EMAIL
hello,
I hav compiled and installed mysql++ without automake or autoconf just by
typing
./configure
make
make install
(Typing auto... bevore compiling makes everithing worse and make does not
work - I don't know if that is the reason for following issues...)
I want to build a program with
I've asked this question once before with no response (and have asked on other
lists), I'll give it one more try before giving in to semi-Gates domination (my
last holdout is the Apache server I'm running):
Upon installing MySQL as a service, why will it not start for all users? Only
my
I studied the MySQL and InnoDB manual, but I did not find anything about
the internal usage of foreign keys.
I mean if I define a foreign key it is good for me, because the InnoDB
engine does not let the database to get integrity errors. But I think the
foreign key definitions could be used in
[snip]
I've asked this question once before with no response (and have asked on
other
lists), I'll give it one more try before giving in to semi-Gates domination
(my
last holdout is the Apache server I'm running):
Upon installing MySQL as a service, why will it not start for all users?
Only
my
Borus,
Thanks for responding. I am attempting to
install a binary release not build from source.
Do you have any information regarding the errors
in my original post?
Thanks
Morris Ford
--- é¾?æf æ¨?(Borus.Kung)
[EMAIL PROTECTED] wrote:
FYI
this may help
Borus
- Original
Maybe
if (!($result)) {
Try
print STDERR RESULT=$result\n;
to see what you are comparing to.
Chris Hohimer wrote:
thanks for all the replies!! but it is not working.
here is the loop:
if($result == EMPTY SET){
$Scheduled = NULL;
}
else{
$Tech = mysql_result($result, 0,
No you can't, but check out LIMIT.
Marco Stagno wrote:
IMHO, The Right Thing to do this, is to create the additional data in
your application (as you said you won't change the table).
(...)
thank you!
If you want this with SQL for sure, using user-defined variables will
work:
cool.
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO)
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document
Hello
I think, there's a better solution:
Use one database - field for sorting (for example SORT). Then you need to fill in
values in this field, that satisfy your needs:
Root - Item
1. Hello You
1.1. test1
1.2. test2
2. cool
2.1 cool i
2.2 cool ii
...
The values of the
hello,
I hav compiled and installed mysql++ without automake or autoconf just by
typing
./configure
make
make install
(Typing auto... bevore compiling makes everithing worse and make does not
work - I don't know if that is the reason for following issues...)
I want to build a program with
Hi,
I've observed some table corruption:
How-To-Repeat: no idea, but maybe you might have one ;)
$ mysql -hxxx Escherichia_coli_O157_H7
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in
Hi all,
I have tried several times to integrate the
lookup functiction into mysql but with no luck. :(
I have REDHAT 7.3
with
gcc 2.96
and with
mysql-3.23.49
I compiled udf_example.so and copied into /usr/lib folder.
When I try to do
CREATE FUNCTION lookup RETURNS STRING SONAME
Hello
I think, there's a better solution:
Use one database - field for sorting (for example SORT). Then you need
to fill in
values in this field, that satisfy your needs:
Root - Item
1. Hello You
1.1. test1
1.2. test2
2. cool
2.1 cool i
2.2 cool ii
...
The values of the
I have a question about how to rotate replication logs in MySQL V 3.23.49.
I've tried to use the command purge master logs to 'logname', however, I'm
unclear what to specify for 'logname'. On my master, I have several old
log files which are no longer being used (by issuing the command show slave
ok, rebooting didn't fix it, reinstalling myodbc didn't fix it, creating a
user ODBC@localhost fixed it.
all off a sudden i need a user named ODBC@localhost, and last i checked, i'm
the only one here that knows anything about how to use mysql here at the
office. so what might have been
Morris,
Thursday, June 06, 2002, 6:17:57 AM, you wrote:
MF I am having a problem installing version 3.23.50
MF on AIX 4.3.3. When I execute mysql_install_db or
MF try to start mysqld I get errors like
MF 0509-036 Cannot load program
MF ./bin/my_print_defaults because of the following
MF errors:
Roger,
Thursday, June 06, 2002, 12:08:13 PM, you wrote:
I just tried a multiple self join on 4.0.1 and got the following
DBD::mysql::st execute failed: Too many tables. MySQL can only
use 31 tables in a join at ./x2.pl line 47.
RB Me too, running 3.23.30-gamma on w2k:
mysql desc select *
Ray,
Thursday, June 06, 2002, 4:39:11 PM, you wrote:
R Error Occurred While Processing Request
R Error Diagnostic Information
R ODBC Error Code = S1000 (General error)
R [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO)
R The error occurred while processing an
¼ÛÅÂÈ£,
Thursday, June 06, 2002, 1:08:07 PM, you wrote:
¼ I will attempt to give you as much information about the software as I can
¼ before I ask the question.
¼ OS : RedHat 7.1
¼ MySQL : Version 3.23.49a for Linux - binary distribution for pc-linux
¼ I want to insert into longblob column
This problem is already solved in Oracle. It it the CONNECT BY PRIOR
statement which recursively queries a table.
The good news is that I read in the MySQL manual, that this feature will be
implemented in MySQL in the Real Near Future :-).
(MySQL manual: 1.8.2 Things That Must be Done in the
It appears the v4.0.1 mysqlhotcopy perl script has been modified and broken.
When using cp for the backup it's passing a null value for the file(s) to be
copied. Below is a session clipping of an execution with --debug turned on:
#
Hi Everyone.
I need to run an extract of some data from our Oracle DB's. One of the
restrictions is that I need to write a SQL script that will parse through a
particular field for a /
and if found, I have to remove it and output the data without the slash.
I have minor experience with selecting
Dear listmembers,
I've got 2 hosts running Linux: hostnames are 'hegel' and 'fidel'
me@hegel:~mysqladmin version
mysqladmin Ver 8.21 Distrib 3.23.39, for pc-linux-gnu on i586
me@fidel:~mysqladmin version
mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686
When logged in to
Hello,
I was wondering if there was a better way to speed up
my update statement in my perl script. It goes through all the
entries in the database , which is around 800, 000, and then updates the email
field. The problem is that it takes to long.
thanks in advance for any help
here
Hello,
I am trying to develop a back-up procedure for our MySQL database.
The database is housed on our production Web server. My thought is to
simply make a slave on our file server that is backed up. I use InnoDB
type tables and my application uses transactions. I am wondering how
On Thursday 06 June 2002 9:51 am, Greg D. wrote:
I was wondering if there was a better way to speed up
my update statement in my perl script. It goes through all the
entries in the database , which is around 800, 000, and then updates the
email field. The problem is that it takes to
On Thursday 06 June 2002 08:53 am, you wrote:
On Thursday 06 June 2002 9:51 am, Greg D. wrote:
I was wondering if there was a better way to speed up
my update statement in my perl script. It goes through all the
entries in the database , which is around 800, 000, and then updates
[snip]
I've asked this question once before with no response (and have asked on
other
lists), I'll give it one more try before giving in to semi-Gates domination
(my
last holdout is the Apache server I'm running):
Upon installing MySQL as a service, why will it not start for all users?
Only
my
in the DSN settings, each datasource has a different username and password.
and looking over the DSNs, none of them should be using the username
ODBC@localhost.
On Thursday 06 June 2002 9:18, you wrote:
Ray,
Thursday, June 06, 2002, 4:39:11 PM, you wrote:
R Error Occurred While
hello,
I hav compiled and installed mysql++ without automake or autoconf just
by typing
./configure
make
make install
(Typing auto... bevore compiling makes everithing worse and make does not
work - I don't know if that is the reason for following issues...)
I want to build a program with
[snip]
All of this is occuring on the same W2K machine (with Apache, MySQL, etc).
When
I log off admin and log on as a power user (same machine) I have the
aforementioned problems.
[/snip]
Kirk,
OK, this makes sense. The power-user(s) needs to be given permissions to
start and stop services on
In SQL DDL, what are the maximum sizes of the various BLOB and TEXT column
types? TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB and the corresponding TEXT
types? I've searched the
manual but couldn't find these specs. At what point should I choose BLOB
over TINYBLOB, and so on?
TIA,
Arthur
Kirk,
I am somewhat confused by your question.
I must misunderstand what it is that you are trying to ask, because what it
appears that you are asking makes no sense. Once MySQL was installed as a
service, why does it matter which account starts it? Are you not the admin
on the box? Are
I'm a bit confused by what you mean here; are you just updating the
'ktjnews' column, or are you attempting to reset the 'email' column as well?
(The source says the first, your comments suggest the second.)
Further, exactly which part of this is too slow? Obviously, each query will
require
[snip]
In SQL DDL, what are the maximum sizes of the various BLOB and TEXT column
types? TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB and the corresponding TEXT
types? I've searched the
manual but couldn't find these specs. At what point should I choose BLOB
over TINYBLOB, and so on?
[/snip]
[snip]
WHERE ap_type='Original Movie Poster'
ORDER BY sort_title ASC
HAVING sort_title LIKE 'G%'
ORDER BY sort_title ASC
You may have to swap the HAVING and ORDER BY lines of the query,
[/snip]
Thanks so much. There was a slight syntax change, replacing your first ORDER
BY with a GROUP BY, but
* Victoria Reznichenko
[...]
RB So... is the crashme report wrong? Or was the limit really 32
RB in 3.22.39, got lowered to 31 in later versions (like 3.23.30-
RB gamma), raised to 63 in version 3.23.39, and then lowered to
RB 31 again (at least in versions 3.23.47 and 4.0.1)...?
RB URL:
Summary: On AIX 4.3.3, using xlc_r/xlC_r compiler, configured with
--with-debug, make all in client directory fails with:
ld: 0711-317 ERROR: Undefined symbol: ._db_enter_
ld: 0711-317 ERROR: Undefined symbol: ._db_return_
ld: 0711-317 ERROR: Undefined symbol: _db_on_
ld: 0711-317 ERROR:
Only users of the Administrators group on NT can start system services by
default.
Have a look in your user manager for domains, policies, user rights
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From:
No you can't, but check out LIMIT.
Ops, but I did it! grin
Using a variable and a temporary table as Benjamin and Keith wrote in the
prev. messages
ciao ciao!
MAS!
--
I love MySQL :-)
-
Hello Greg,
maybe it can be of some help:
- Try ( if memory is not a problem ) to read the entire file in memory,
inside an array, and use foreach() in the array. It is quicker than
reading line by line from the HD;
- And you may try to mount your
I don't think this makes sense either, but you will see what I mean:
FOR MY ADMIN ACCOUNT
C:\netstat -a -p tcp
Active Connections
Proto Local Address Foreign AddressState
TCPdynamic:http dynamic:0 LISTENING
TCPdynamic:epmap
It would seem strange to implement one and not the other? The help does say
that you can use it and does keep the create options now.
Does anyone know if this will be implemented in the next .5x release?
Ross
Me writes:
Hi!
don't think ON UPDATE is supported.
The manual :
FOR MY ADMIN ACCOUNT
C:\netstat -a -p tcp
TCPdynamic:3306 dynamic:0 LISTENING
FOR THE REGULAR USER ACCOUNT
C:\netstat -a -p tcp
TCPdynamic:3306 dynamic:0 LISTENING
Problem Solved.
Thx!
Mateus Begossi
- Original Message -
From: Mateus Begossi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED]
Sent: Wednesday, June 05, 2002 10:27 PM
Subject: SQLPrepare problems
Hello everyone,
I´m writing a VC++ 6.0 App that among many other
Lo all,
are sub-queries supported on mysql-max 3.23.49 ??
If they are, what's wrong with the following statement?
SELECT monitorhosts.HostID
FROM monitorhosts
WHERE monitorhosts.HostID NOT IN
(SELECT HostID
FROM monitorhostgroupdetails
WHERE
I'm sorry to disappoint you, but subqueries are NOT supported int any MySQL
version, yet.
You can read the MySQL manual about it. You can find there when and how it
will be implemented.
Bye
Daniel
At 21:39 2002.06.06. +0200, you wrote:
Lo all,
are sub-queries supported on mysql-max
Fair enough (and also what I thought)
Does anyone have any idea how I can implement the below in a similar
fashion then?
I have a list of items, and a list of groups. I want to retrieve all the
items from a table that is not in a specific group...
- Original Message -
From: Kiss
SELECT monitorhosts.HostID
FROM monitorhosts, monitorhostgroupdetails
WHERE monitorhosts.HostID = monitorhostgroupdetails.HostID
AND monitorhostgroupdetails.HostGroupID != '1');
Gruss
Sabine
Chris Knipe wrote:
Lo all,
are sub-queries supported on mysql-max 3.23.49 ??
If they are,
Select monitorhosts.HostID
from monitorhosts left join monitorhostgroupdetails on
monitorhostgroupdetails.HostID = monitorhosts.HostID
where monitorhostgroupdetails.HostGroupID !='1';
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
*MWAH*!!!
Thanks a million, tested and working beautifully Can't believe in two
days I didn't think of this...
--
me
- Original Message -
From: Sabine Richter [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002 10:14 PM
Hey all,
I've been searching for references on the web and even been to stores ;)
regarding the above subject. But I am reluctant to purchase ATM because there
are so many books out there on the subject.
So I figured I'd go to the list and ask the question. What are peoples
opinion's on the
Hi,
I have a design question for mysql database that I am wanting to create a
my movies collection. I was going to do as one-to-one database, but I see
now that I need to do as a one-to-many. I have never done a one-to-many but
I see that is the way to go.
I guess then is can someone show me
Ok, I spoke to soon... And this is starting to drive me up the walls now...
i.e. getting REALLY irritating and frustrating.
mysql DESCRIBE monitorhosts;
+--+--+--+-+-+--
--+
| Field| Type | Null | Key | Default |
Thanks Charles for your patience and help. I removed winmysqladmin from
startup and ALL problems went away! When winmysqladmin started up on the other
user accounts it would somehow block connections to MySQL (since before I
uninstalled, on normal [non-admin] user accounts, I could not
Strange indeed...
Might be worth checking if this can be reproduced... This can perhaps be
something worth mentioning in winmysqladmin (possible bug?)
- Original Message -
From: Kirk Brannan Babb [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002
Can you backup/restore just one MySQL database with InnoDB hot backup? From
what I gather it's an all or nothing proposition. As I understand it,
there's only one tablespace (with any number of data files) and all
database tables of type 'InnoDB' are comingled in the one tablespace.
Therefore, if
Dear list,
After doing a good bit of reading, the details are still hazy.
I have a web-based application (about 20 tables, with up to 100,000 records
per table - but most tables are much smaller). 99% of select queries are
very very fast.
However, there is the occasional select query that
You are very welcome. I am glad I was able to help.
Charles Q.
At 03:58 PM 6/6/2002 -0500, k wrote:
Thanks Charles for your patience and help. I removed winmysqladmin from
startup and ALL problems went away! When winmysqladmin started up on the
other user accounts it would somehow block
We have a situation that I was wondering if anyone had an answer to. We
have a situation where we have multiple mysql boxes being used in random
order for load balancing and fault tolerance. Basically the app chooses
one of the machines at random, and if it can't get a connection, it
tries
On Thu, Jun 06, 2002 at 02:49:05PM -0700, Shakeel Sorathia wrote:
we start up mysql. Mysql binds to the port, then it takes about 15
seconds for innodb to startup and get ready to start serving requests.
Problem is that in this 15 seconds a few hundred connections have
queued up to
Hi all,
I ve got some errors while making a query that managing match (full text)
and union,
both on boolean mode and the other mode.
When I m working with like i get no error.
I m working with mysql 4.01 4.02.
Tables have the sames number of fields ...
Indexes seems to have been created ...
Chris,
sounds like you're looking for an exclusive left outer join.
You want to see records from monitorhosts, where there is no corresponding
record
in monitorhostgroupdetails, right?
Use:
Select *
from monitorhosts left join monitorhostgroupdetails on
monitorhosts.HostID =
- Original Message -
From: Kevin Fries [EMAIL PROTECTED]
To: 'Chris Knipe' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, June 07, 2002 12:38 AM
Subject: RE: sub-queries
Chris,
sounds like you're looking for an exclusive left outer join.
You want to see records from
Hello,
I want to set quota to mysql database by every database or by every user, I
can not find any issues from mysql official website, and I don't think the
Linux or FreeBSD File System quota solution is effective, who can help me?
Thank you in adanced.
Regards,
Asong.
i want to know where a can write my script in running and use mysql.
recently i save in a file a two statement and it work what i expect to be done,
i'm wondering what is the most easiest programming language could i use to write my
script.
for ur info
i'm using win98
mysql 3.29.49
1 - 100 of 123 matches
Mail list logo