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 x
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. A
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: BungyJump
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)
ht
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
>
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 whois_domain.doma
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 wh
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 beginnin
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
> T
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 in
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 moni
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
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
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 fill
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 manipulating
> 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 sel
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
- MyS
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 (no
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
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 ]
rpl00
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 i
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..
con->sele
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 ret
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 yo
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 w
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 351+2
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 configurati
-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]
http://jb
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. A
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 p
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, etc.)
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, etc.)
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 appreciat
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 conn
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 qu
If possible, update your UNIX DB to 3.23, and convert the tables to MYISAM -
the tables can then be freely copied between platforms.
Alternatively, you could use ODBC to update the UNIX tables directly.
Otherwise, you would have to use mysqldump to copy the data to windoze and
back again, assumi
Mario,
Can you send a sample of the code that is causing this to happen? I have a couple
ideas, but I would need to see the actual code to be sure.
You mention a "probable cause". Have you done anything to verify this (like get rid
of the update and see what happens)? When you run the same
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 p
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 since foreign keys in other tables might point to the
news
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 selec
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.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [
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]]
Se
Hi!
> "R" == R Talbot <[EMAIL PROTECTED]> writes:
>> 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-mem
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 PhpMy
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 $CustomerID
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, October 30, 2001 2:39 PM
To: Ing. Gustavo Edelstein; [EMAIL PROTECTED]; Bennett Hasel
You can download either, php or php3.
>>On Tue, 30 Oct 2001 14:47:01 -0600, Rick Emery <[EMAIL PROTECTED]> wrote:
>>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
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 PROTEC
Mysql_Insert_ID($dbhandle->connection);
gets the last id of the last insert statement - if you do any db activity
after the insert, this won't work.
On Tue, 30 Oct 2001, Matthew Walker wrote:
> Does anyone see anything wrong with the following code/query syntax? I'm
> using the PEAR DB class f
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: Tue
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]
Subjec
funny that. i'm using PEAR, and that is working for me perfectly.
have you tried it?
On Tue, 30 Oct 2001, Matthew Walker wrote:
> 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.)
>
> -Origin
> 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:
http://www.then
rc wrote:
> Mysql_Insert_ID($dbhandle->connection);
>
> gets the last id of the last insert statement -
> if you do any db activity
> after the insert, this won't work.
In other words:
> $res = $dbhandle->query("select
last_insert_id()");
> $dbhandle->query("UNLOCK TABLES");
> $res
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( $re
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)
http://lists.my
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, especiall
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()
> {
> globa
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, archive
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
download phpmyadmin from sourceforge
-Original Message-
From: Gonzalo Valenzuela [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 2:56 PM
To: Todd Williamsen; 'Gonzalo Valenzuela'; 'Ing. Gustavo Edelstein';
[EMAIL PROTECTED]; 'Bennett Haselton'
Subject: RE: web-based interface f
To: [EMAIL PROTECTED]
Subject: installation problem[50 character or so descriptive subject here
(for reference)]
Hi,
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 instructi
>Description:
I have found some inconsistencies (one may call them bugs ;-) in the
current MySQL 3.23 version. I tested this on Linux and Solaris 2.8
so this should not be platform specific...
The result differs, if one uses the constant value "-00-00" or
I've recently upgraded from 3.22.32 to 3.23.43 and I'd like to convert my
tables to the MyISAM format.
According to the docs regarding the upgrade
(http://www.mysql.com/doc/U/p/Upgrading-from-3.22.html),
this is the procedure:
ALTER TABLE table_name TYPE=MyISAM
On one of my tables, I receive t
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 a.add
At mysql site here (down in the Linux downloads section):
http://www.mysql.com/downloads/mysql-3.23.html
here is the link:
http://www.mysql.com/Downloads/MySQL-3.23/MySQL-bench-3.23.43-1.i386.rpm
RH 6.2 with the following MySql stuff installed (by rpm)
MySql 3.23.43
MySql Client 3.23.43
MySql Sha
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 th
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. :) T
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
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 done?
I beli
Correct me if I am wrong. You are using Linux correct? I seen your post
before but was leaving for awhile and could not help.
Using the Linux theroy: Everytime you use anything you still get a beep
correct?
If so, you have sound enabled on all system functions therefore when you
open close or in
Hello,
I'm the Associate Publisher with New Riders Publishing and I've recently
published a book with Paul DuBois titled "MySQL and Perl for the Web." (You
may know Paul's work from his previous book with us "MySQL.")
Earlier this year we also published "MySQL: Building User Interfaces" by
Matt S
> 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
> w
> 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
At 3:43 PM -0700 10/30/01, [EMAIL PROTECTED] wrote:
>Correct me if I am wrong. You are using Linux correct? I seen your post
>before but was leaving for awhile and could not help.
If he's using mysql.EXE, he's no doubt using Windows. I believe you're
correct that it's not a mysql issue, though.
> Does anyone know how to turn that annoying beeping off in the text mode
> utilities such as mysql.exe?
Cut the speaker cable.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
--
You might have a corrupt table. For 3.22 format, you'll need to use
isamchk, I think... It's been a long time since I've worked with ISAM
tables.
Now that I look closer at your email, though, it is probably the fact
that your id's start with 0, not 1. The alter table actually dumps the
data in
>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?
>
>
>Wheneve
>>> 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 fig
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 install
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.
1 - 100 of 146 matches
Mail list logo
