Hello,
i installed mysql-max-4.
i need use czech sorting - i set
[mysqld]
default-character-set=czech
but
create table xx (t varchar(10));
insert into xx values('a');
insert into xx values('c');
insert into xx values('t');
insert into xx values('s');
insert into xx values('b');
insert into
Trying to get the benchmark 3.23.43 installed but it says I need
MYSQL-DBI-perl-bin which I can't seem to locate. Looked at cpan.org and
there was no module named that. I found plenty of modules when I did a
search on mysql, but nothing named specifically that, so I'm confused on
what to get.
Hi,
errno 13 is permission denied.
Possibly you installed mysql as root, and are trying to run as a normal
user? Change the permissions in you data directory so the user running the
mysqld server can read/write the files.
Quentin
Here is New Zealand!
-Original Message-
From:
Hi,
Is it possible to get all data; SELECT * FROM and still get some fields
filtered by DISTINCT?
Jari Mäkelä
database,sql,query,table
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello!
Is there any way to know how much space is used in the innodb data files?
So if I have for example :
innodb_data_file_path = ibdata1:200M;ibdata2:400M;
how much of the 600MB actually is used at the moment
Thx!
Elm
database,sql,query,table
Hi,
how much of the 600MB actually is used at the moment
I'm sure there'a a better way to do it, but this one works:
mysql show table status like 'your_innodb_table' \G
...
Comment: InnoDB free: 3739648 kB
Best Regards,
Sasa
Franck Collineau writes:
I have read the manual again.
I can connect as root (i type: mysql -u root -p then password and i have the
prompt)
But when i type: mysql --user=root mysql
i have the message:
ERROR 1045: Access denied for user: 'root@localhost' (using password NO)
mysql
Hai,
I'm Radha and i'm working with mysql my question is how to make a
database faster, because if i use mysql over a telephone line or
internet my database is hanging or it shuts down..
Maybe you can tell me how to make my database faster..
looking forward for your reaction
radha
select floor('5') = floor('6');
TK
-Opprinnelig melding-
Fra: Daniel James [mailto:[EMAIL PROTECTED]]
Sendt: 30. oktober 2001 04:32
Til: [EMAIL PROTECTED]
Emne: Comparing strings as ints
Hi Everyone,
After staring blankly at the mysql manual for a long time, I
thought it
Joel Rees writes:
Hi.
My coworker needs to check how well SSL is supported in which versions.
Any comments on SSL in v. 3? or about the stability of v. 4?
Joel Rees
[EMAIL PROTECTED]
SSL i supported in MySQL 4, which is now in alpha stability phase.
--
Regards,
__ ___ ___
Hi,
I'm not sure if this query is possible. I'm trying to look through a table
text field for a filter. So the text field would be a domain lookup and the
filter might be something like ns1.istorm.ca
I can get this too work, If the filter and the domain are the same :
SELECT
Hi all,
As explained in the archive, a connection on port 3306 via a standard 'open
socket' and
close again, creates connection errors, resulting in a blocked host.
However - since we replicate our servers, to ensure high availabity, we
like to poll if the
primary is up. We do this, because
Hi guys! I'm sorry if this is one of those questions that is
repeated but ... I must pose it :) .
I'm doing a database to support all of my companies activities,
for instance we have client information, order information, contacts,
suppliers, etc etc. Now, the structure is
use :
SELECT whois_domain.domain
FROM whois_domain, filter
WHERE (whois_domain.record LIKE concat('%',filter.filter,'%')
TK
-Opprinnelig melding-
Fra: abercrombie fitch [mailto:[EMAIL PROTECTED]]
Sendt: 30. oktober 2001 13:35
Til: [EMAIL PROTECTED]
Emne: LIKE '%%' with fields.
ehh .. forgot a ) on my sql.
the right one is below
SELECT whois_domain.domain
FROM whois_domain, filter
WHERE (whois_domain.record LIKE concat('%',filter.filter,'%'))
TK
-Opprinnelig melding-
Fra: abercrombie fitch [mailto:[EMAIL PROTECTED]]
Sendt: 30. oktober 2001 13:35
Til:
Hi!
At 11:27 AM 10/30/01 -, you wrote:
Sorry for the slow reply here, all has been exceptionally busy...
We have some tables as InnoDB and some as MyISAM... We upgraded to 4.0 and
the problem went away (we also wanted the ability to change the length of
the stopwords for the fulltext
I have a table:
CREATE TABLE vote_count (
id int(10) DEFAULT '0' NOT NULL auto_increment,
imageid int(6) DEFAULT '0' NOT NULL,
catid int(4) DEFAULT '0' NOT NULL,
count int(6) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
INDEX (imageid, catid)
);
and am
Hello Melvyn!
However - since we replicate our servers, to ensure high availabity, we
like to poll if the
primary is up. We do this, because when a host is down (not the mysql
Big Brother is a bit of an overkill for the 'one' thing you're asking for
but it's a dynamite generic 'server
Hi Jim,
At 08:48 10/30/2001 -0500, jim barchuk wrote:
Hello Melvyn!
However - since we replicate our servers, to ensure high availabity, we
like to poll if the
primary is up. We do this, because when a host is down (not the mysql
Big Brother is a bit of an overkill for the 'one' thing
Hi Jim,
At 08:48 10/30/2001 -0500, jim barchuk wrote:
Hello Melvyn!
However - since we replicate our servers, to ensure high availabity, we
like to poll if the
primary is up. We do this, because when a host is down (not the mysql
Big Brother is a bit of an overkill for the 'one' thing
Is there any pre-written code that allows users, authenticated over the
Web, to view MySQL tables in their database as HTML tables? Desirable
features for something like that would include:
- tables are displayed in row-and-column format, with a few blank rows at
the bottom where you can
http://www.phpwizard.net/projects/phpMyAdmin/ might be the place to start
It does not have hyperlinking, though
-Original Message-
From: Bennett Haselton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 8:16 AM
To: [EMAIL PROTECTED]
Subject: web-based interface for
I have a table setup with a varchar(20) column, I am using this column to
store a price, the reason I chose varchar(20) is because the prices I am
dealing with are fairly large and I wanted to guarintee 20 digits. There
are no characters like '$' or '.' stored in this column. Now, If I select
Hello,
sorry, this is the second post, caue I had no reaction.
Just wanted to talk about the MySql Query Optimiser.
After having performance problems with some queries, I arrived to
thoses conclusions:
- The order of joins with constants and column have no effect on the
speed of the query
-
Hi,
On Tru64 5.1, I am trying to install mysql 3.23.43. I follow
the steps in section 2.3 of running scripts/mysql_install_db.
It comes back with the error:
/usr/local/mysql-test/libexec/mysqld: unrecognized option `--password=reqid'
a password I never typed in. After that, it gives the usage
Sorry, semantic miscommunication. It's a heavily used table and the
performance of other queries done during the mass deletion slows, which
is a problem since this is a near-realtime system where delays in
queries cause performance issues in other dependent modules.
Jeremy Zawodny wrote:
On
Loud\ As\ A\ Whisper.aviMelvyn Sopacua wrote:
Hi Jim,
At 08:48 10/30/2001 -0500, jim barchuk wrote:
Hello Melvyn!
However - since we replicate our servers, to ensure high
availabity, we
like to poll if the
primary is up. We do this, because when a host is down (not the mysql
Big
At 9:51 AM -0500 10/30/01, Douglas B. Jones wrote:
Hi,
On Tru64 5.1, I am trying to install mysql 3.23.43. I follow
the steps in section 2.3 of running scripts/mysql_install_db.
It comes back with the error:
/usr/local/mysql-test/libexec/mysqld: unrecognized option `--password=reqid'
a
Douglas B. Jones writes:
Hi,
On Tru64 5.1, I am trying to install mysql 3.23.43. I follow
the steps in section 2.3 of running scripts/mysql_install_db.
It comes back with the error:
/usr/local/mysql-test/libexec/mysqld: unrecognized option `--password=reqid'
a password I never typed
I created one table with the command:
CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex
CHAR(1), birth DATE, death DATE, id INT UNSIGNED NOT NULL);
and another one with the command:
CREATE TABLE pet2 (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex
Description:
Configured and built mysql 3.23.43 without errors on a 9000/782
running HPUX 10.20. All tests pass except:
merge [ fail ]
rpl01 [ fail ]
rpl02 hangs
rpl04 [ fail ]
prl07 [ fail ]
Hi,
My /etc/my.cnf has the 'password' line commented out.
Also, according to the instructions, that files is
not copied over yet at the time one does the db
install command: mysql_install_db.
Any ideas?
Thanks,
Cheers,
Douglas
p.s.: I copied Sinisa on this since he also came
up with the same
Hello (again)
I have a rather weird problem. I have some service running in my application
that is updating some tables every hour.
Now this works after the first hour but after the second hour I suddenly get
an access violation on the query object.
This is the rather normal code..
SixK writes:
- MySql make all joins between tables before extracting the required
rows
How do you mean? It can only start returning rows when all
tables that are needed have been joined, but of course it
doesn't create a temporary table with the product of all
tables before it starts to
Hi!
When i type: mysql -u franck -p then my password, it's ok.
My machine's name is r-lx-collineau
When i type mysql - h r-lx-collineau -u franck -p then my password, i have
this message:
ERROR 1130: host 'r-lx-collineau' is not allowed to connect to this MySQL
server
Can anybody help me ?
Thank you for the tip Johnny, I'll copy that code to a snippet and use that
from now on.
(C:
From: Johnny Withers [EMAIL PROTECTED]
To: 'Curtis Gordon' [EMAIL PROTECTED]
Subject: RE: persistant insert trouble
Date: Tue, 30 Oct 2001 08:04:58 -0600
Next time, instead of banging your head on
We've just switched from compiling our own MySQL to using your binary
distribution. This is the first time we've run MySQL in production from
one of your binary builds. We had to switch to a binary distribution
because we were running into the 1000 threads issue with the GLIBC
library
I seem to be hitting a ceiling in MYSQL_RES (mysql_use_result). I select
2 or 3 items but only 2295 are returned. What might be the cause
of this?
Thanks,
--
,
M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121
A M A D O Rua Campo Alegre, 823 fax
At 10:32 AM -0500 10/30/01, Douglas B. Jones wrote:
Hi,
My /etc/my.cnf has the 'password' line commented out.
Also, according to the instructions, that files is
not copied over yet at the time one does the db
install command: mysql_install_db.
Any ideas?
It may be in another configuration
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
check mysql.user, you probably have permission for franck@localhost, which
succeeds when you omit the -h, but no permission for
[EMAIL PROTECTED], so you fail when you specify that is where you
are coming from.
John Barton
[EMAIL PROTECTED]
Trying to get the benchmark 3.23.43 installed but it says I need
MYSQL-DBI-perl-bin which I can't seem to locate. Looked at cpan.org and
there was no module named that. I found plenty of modules when I did a
search on mysql, but nothing named specifically that, so I'm confused on
what to get.
In the last episode (Oct 30), Bennett Haselton said:
I created one table with the command:
CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex
CHAR(1), birth DATE, death DATE, id INT UNSIGNED NOT NULL);
and another one with the command:
CREATE TABLE pet2
Please treat this as a fairly urgent problem. It's simple to fix, but the
effects of the bug are a severe loss of functionality under Win32.
Several options in the mysql client (--batch, --silent, etc.) have no
corresponding options to reverse that behavior (e.g. --no-batch,
--no-silent,
The difficulty you're having is that what you call alphanumeric, MySQL sees as just a
string. How about a computed field with some usage of MySQL's substring_index function
to parse the string into pieces, if you know they will always have the given delimiter
(the -, in your example), and then
Please treat this as a fairly urgent problem. It's simple to fix, but the
effects of the bug are a severe loss of functionality under Win32.
Several options in the mysql client (--batch, --silent, etc.) have no
corresponding options to reverse that behavior (e.g. --no-batch,
--no-silent,
I realize this is not the current version, but debian stable is stuck on:
3.22.32.
mysqld does not start when I enter
max_connections 200
although it reports max_connections 100
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
I was wondering if there is a way to download the MySql database hosted on a
UNix machine running Solaris, to my Windows computer and be able to view and
modify it from there? The Solaris version has .ISD and .ISM files wheras
Windows has .MYD and .MYI files. Any help would be greatly
On Tue, 30 Oct 2001, M. A. Alves wrote:
I seem to be hitting a ceiling in MYSQL_RES (mysql_use_result). I select
2 or 3 items but only 2295 are returned. What might be the cause
of this?
The probable cause is I was accessing the same table at the same time (but
thru different
Humm
Well could you make your unix box master and you microsoft box slave?
So letting one update the other..???
Or just run CDE?
Simon
-Original Message-
From: Ryan Winterbourne [mailto:[EMAIL PROTECTED]]
Sent: 30 October 2001 18:59
To: [EMAIL PROTECTED]
Subject: Can you
From: Patrick Nelson [EMAIL PROTECTED]
Trying to get the benchmark 3.23.43 installed but it says I need
MYSQL-DBI-perl-bin which I can't seem to locate.
Hmm, I couldn't find that either. Can you tell me where you've found benchmark, I'll
have a look at it and see if I can answer your
Thanks but it doesn't work...
Below is the extract of the configuration file it does not matter whether
I include spaces around the = or not, starting using mysql_safe results
in a failed There is no entry in the error log. Commenting out the
line results in a successful restart. I am
Hi all,
mysqld seems to 'hang' under certain circumstances when I'm doing a fairly large ALTER
TABLE -- adding or dropping an Index, repair etc. The server and client are still
'alive' and I can do simple things like show processlist, or selecting a count(0) from
another table, but other
Use a join query, rather than separate single-table queries:
SELECT a.*, n.url
FROM articles a, news_sites n
WHERE a.news_site_key = n.news_site_key;
-- Greg Johnson
-Original Message-
From: Bennett Haselton [mailto:[EMAIL PROTECTED]]
Hi!
R == R Talbot [EMAIL PROTECTED] writes:
cut
The following configuure line should have a big likehood to work:
rm config.cache
CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions
-fno-rtti ./configure --prefix=/usr/local/mysql --with-low-memory
Regards,
But PhpMyAdmin only use php3
At 12:39 p.m. 30-10-01 -0300, Ing. Gustavo Edelstein wrote:
If you have PHP installed, try phpMyAdmin. It's a very good tool, easy use
and installing.
Regards.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
I use phpmyadmin on a system with PHP4
-Original Message-
From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 2:39 PM
To: Ing. Gustavo Edelstein; [EMAIL PROTECTED]; Bennett Haselton
Subject: Re: web-based interface for manipulating MySQL tables?
But
Does anyone see anything wrong with the following code/query syntax? I'm
using the PEAR DB class for PHP. When this runs, it correctly inserts
the row to the table, but is failing to retrieve the last_insert_id().
function StartOrder()
{
global $dbhandle;
global $OrderID;
global
where I can find it? for php4?
Thanks
At 02:53 p.m. 30-10-01 -0600, Todd Williamsen wrote:
No PHPadmin has two versions PHP3 and PHP
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]]
Responding to my own email... sheesh. It's just that kinda day. :
I found reference in the archives to what seems to be the same problem.
Monty replied to a thread entitled I got it hanged ! on 2001-07-17, and agreed that
it shouldn't be happening. Unfortunately, I can't find a solution in
ok, ok, ok.
thanks...
At 02:53 p.m. 30-10-01 -0600, Todd Williamsen wrote:
No PHPadmin has two versions PHP3 and PHP
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
That won't work. The connection is being made through the PEAR DB class,
so the standard PHP functions won't work. (And yes, I did just test it.)
-Original Message-
From: rc [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 1:58 PM
To: Matthew Walker
Cc: [EMAIL PROTECTED]
Hello,
I'm losing precision when I send a double to a mysql database from a Java
program trough JDBC.
Code:
stmt.setDouble(i+3,((Double)value).doubleValue());
Ok, the problem was solved after I updated my MM.MySQL driver to the newest
version. Here you can get it:
here's my code that is working perfectly
$Conn is the connection object
$sql = INSERT INTO dp_survey_question (survey_id,question_type_id,question_text)
VALUES
( . $s_id . , . $qt_id . , . $Conn-quote($q_text) . );
$result = $Conn-query($sql);
if (DB::isError($result)) {
die(
I'm looking for instructions on installing the mysql GUI interface on a unix system.
Is that possible? Thank you,
Nathan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Tue, 2001-10-30 at 13:10, Bennett Haselton wrote:
I'm creating a database where one of the tables stores data about news Web
sites, and I'm using the URL of the site as a primary key field. This
field value might change occasionally. I'm wondering if this is bad
practice, especially
Does anyone know how to turn that annoying beeping off in the text mode
utilities such as mysql.exe?
Ben Pracht
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On 30-Oct-2001 Matthew Walker wrote:
Does anyone see anything wrong with the following code/query syntax? I'm
using the PEAR DB class for PHP. When this runs, it correctly inserts
the row to the table, but is failing to retrieve the last_insert_id().
function StartOrder()
{
global
David,
First of all, please post to the list in the future. I'm not always
available to help with problems, and others may benefit from the
problem/solution.
I would change your query to the following:
SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice
FROM archive a,
As subject what do I do if I want a field called (for example)
Competition ID?
I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no
avail.
I have tried enclosing it in quotes and 'single quotes' but neither
work. Can this be done?
Thanks lots
David Ayliffe
ICQ# 125646758
At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
Does anyone know how to turn that annoying beeping off in the text mode
utilities such as mysql.exe?
Ben Pracht
I don't believe mysql.exe has ever beeped at me. What are you doing
when it beeps at you?
I'm using the following query
SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice
FROM archive a, archive b
WHERE a.status='s' AND a.addrdsp IS NOT NULL
AND a.addrdsp = b.addrdsp AND a.solddate b.solddate
AND date_add(a.solddate, interval 1 year) b.solddate
ORDER BY
At 5:16 PM + 10/30/01, David Ayliffe wrote:
As subject what do I do if I want a field called (for example)
Competition ID?
I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no
avail.
I have tried enclosing it in quotes and 'single quotes' but neither
work. Can this be
Hello David!
As subject what do I do if I want a field called (for example)
Competition ID?
I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no
avail.
I have tried enclosing it in quotes and 'single quotes' but neither
work. Can this be done?
Wrong doc. :) Try
Paul DuBois wrote:
At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
Does anyone know how to turn that annoying beeping off in the text mode
utilities such as mysql.exe?
I don't believe mysql.exe has ever beeped at me. What are you doing
when it beeps at you?
Whenever there's an
As subject what do I do if I want a field called (for example)
Competition ID?
I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no
avail.
Section 6.1.2 is probably closer to what you need.
I have tried enclosing it in quotes and 'single quotes' but neither
work.
I'm using the following query
SELECT DISTINCT a.addrdsp,a.listdate,a.solddate,a.lpricea,a.sprice
FROM archive a, archive b
WHERE a.status='s' AND a.addrdsp IS NOT NULL
AND a.addrdsp = b.addrdsp AND a.solddate b.solddate
AND date_add(a.solddate, interval 1 year) b.solddate
ORDER
Paul DuBois wrote:
At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
Does anyone know how to turn that annoying beeping off in the text mode
utilities such as mysql.exe?
I don't believe mysql.exe has ever beeped at me. What are you doing
when it beeps at you?
Whenever there's an error.
At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
Does anyone know how to turn that annoying beeping off in the text mode
utilities such as mysql.exe?
Ben Pracht
I don't believe mysql.exe has ever beeped at me. What are you doing
when it beeps at you?
I figured out why I don't get
Ken Abe writes:
I am a student at NYU trying to install mysql on our department
machines. The fact
that I do not have root priviledges is probably part of the issue, but I
followed
the instructions regarding installation as a normal user.
A bit further down I see that you're installing
From: Patrick Nelson [EMAIL PROTECTED]
RH 6.2 with the following MySql stuff installed (by rpm)
Unfortunately, I could only find 'bench' in RPM. Since that requires me to install the
package (which I'm not willing to do without know what's going to happen), I can't
continue. I appoligize.
doesn't windows have some control panel that lets you turn sounds off and
on for certain functions and/or events?
On Tue, 30 Oct 2001, Paul DuBois wrote:
Paul DuBois wrote:
At 4:34 PM -0500 10/30/01, Benjamin J Pracht wrote:
Does anyone know how to turn that annoying beeping off in
We used to use phpmyadmin, but moved on to mysqltool last January. You
might want to check it out.
http://dajoba.com/projects/mysqltool/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Back a few years there was a nasty little virus that played Chops on your
WinDoDie box's and we had to unplug the PC Speakers on a couple dozen
becuase there was not fix for it at the time. Or was it cause they where to
cheap..hmm.
Does anyone know how to turn that annoying beeping off in the
I don't believe that the table is corrupt, I'm more inclined to believe
your zero theory.
create table crashme (a int(10) not null auto_increment primary key) type=isam;
insert into crashme set a=0; # actually inserts a = 1;
update crashme set a=0 where a = 1;
insert into crashme set a=0; #
I have a perl script that selects users dial-up usage based on month/year -
It works fine, but if the selected month/year does not contain any usage
data, the only way I can check is with the following code:
# $sth-execute() # Execute the query
$my_result = $sth-execute()
Hi,
When I do the following in a perl script I get back all the records I
want:
$prep = SELECT id,name FROM go.objectives WHERE subjects_id='1' AND
subjectHeadings_id='2' ORDER BY displayOrder;
$sth = $dbh-prepare($prep);
$sth-execute;
But when I add in the LIMIT statement it returns no
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
How to I put a users MySQL data into thier home dir? I have tried
moving thier database over and sym-linking it:
mv /var/lib/mysql/userdb /home/user
ln -s /home/user/userdb /var/lib/mysql/userdb
But mysql doesnt see the database.
I also tried to
But when I add in the LIMIT statement it returns no records
$prep = SELECT id,name FROM go.objectives WHERE subjects_id='1' AND
subjectHeadings_id='2' LIMIT 1,5 ORDER BY displayOrder;
$sth = $dbh-prepare($prep);
$sth-execute;
http://www.mysql.com/doc/S/E/SELECT.html
The LIMIT
Have you tried using the $rows = $sth-rows() after you execute to get the total
rows returned?
On Wed, 31 Oct 2001 00:43:00 +, Mark Worsdall [EMAIL PROTECTED] wrote:
Hi,
I want to alter this statement so it returns the number of records.
$prep = SELECT COUNT(*) FROM go.objectives WHERE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I dont have hard quota's, It is a script that looks at the userdir
and tells them if they are over the limit, then if they are xMb over
the limit the admin is notified.
Yes, I could modify this script, but I would rather have all the
user's data in
MYSQL
Hi!
When i type: mysql -u franck -p then my password, it's ok.
My machine's name is r-lx-collineau
When i type mysql - h r-lx-collineau -u franck -p then my password, i have
this message:
ERROR 1130: host 'r-lx-collineau' is not allowed to connect to this MySQL
server
I think the
At 12:54 AM + 10/31/01, Mark Worsdall wrote:
Hi,
When I do the following in a perl script I get back all the records I want:
$prep = SELECT id,name FROM go.objectives WHERE subjects_id='1' AND
subjectHeadings_id='2' ORDER BY displayOrder;
$sth = $dbh-prepare($prep);
$sth-execute;
But
Hi,
I'm newly acquinted with MySQL today, and made a very first attempt to
create a table with MySQLGUI. However, the Commands-Tables-Create Tables
menu option doesn't seemed implemented -- nothing happens. Is this something
that hasn't been implemented, or am I not using the tool correctly? I'm
Hi.
I have a query that determines the ranking of teams in a league by
several calculations on the table. Below is the query:
SELECT TeamName,TeamWins,TeamLosses,TeamSpirit,
(TeamSpirit/(TeamWins+TeamLosses)*100) AS AvgSpirit,
((TeamWins*2)-TeamLosses) AS TeamPoints
FROM Teams_1
WHERE
Hello all,
I have a problem. I am able to get a copy of a text file which resides
on another server for a task I am completing. What I need to do is
import this text into a database table on a nightly basis, and I am
trying to set this up via PHP so it is all automated. I have one
problem
I'm new to this list, and new to mySQL but used SQL with DB2 years ago, so
here goes my try at answering this: have you tried select count(*) as
your_variable_name From etc .etc.etc.
Anne
- Original Message -
From: Mark Worsdall [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent:
At 7:46 PM -0600 10/30/01, Camilo Rostoker wrote:
Hi.
I have a query that determines the ranking of teams in a league by
several calculations on the table. Below is the query:
SELECT TeamName,TeamWins,TeamLosses,TeamSpirit,
(TeamSpirit/(TeamWins+TeamLosses)*100) AS AvgSpirit,
Hey now, why would you want to turn it off, After all its a `feature'
[EMAIL PROTECTED] wrote:
Back a few years there was a nasty little virus that played Chops on your
WinDoDie box's and we had to unplug the PC Speakers on a couple dozen
becuase there was not fix for it at the time. Or
Some programming language in some platform could compare this string
numeric. But, Why not use it in real numeric value (no quote) or use
convert method before compare?
SF
At 13:24 30/10/2001 +0900, Joel Rees wrote:
I don't have any experience with SQL, but I'm thinking that zero filling
If this hasn't been answered yet, the PC speaker on/off switch is usually an
option in your system BIOS. I had the same problem on my Dell PE 2550 dev
server until I switched it in setup. The problem with cutting the cable is
that some motherboards have the speaker built in... n wires. :-)
#
1 - 100 of 120 matches
Mail list logo