Hello
CREATE TABLE deci (deci decimal(8,2));
INSERT INTO deci VALUES (-2427.88);
INSERT INTO deci VALUES (2427.89);
INSERT INTO deci VALUES (-0.01);
select sum(deci) as s from deci having s0;
+---+
| s |
+---+
| -0.00 |
+---+
Well for the values given above - monetary values -
Steven,
I had an experience the other day in a controlled test environment that appears
to be similar. An advantage is that i know precisely what was taking place.
Consider the following:
1) A servlet makes a single 'insert delayed' into a relation. (no auto increment
field - and just a simple
Hi Jorge,
you usually do something like
mysqldump -u USER -p TABLE FILE
where TABLE is dumped to the FILE. USER must have privileges to do so (I
usually take the superuser).
The other way around you simply have to do
mysql -u USER -p TABLE FILE
Should work then,
Tobias.
-Ursprngliche
- Original Message -
From: Radoslav Vasilev
To: [EMAIL PROTECTED]
Sent: Friday, March 09, 2001 12:24 PM
Subject: can't add remote user with mysql3.23
The problem I've never had before is that I can't add remote new user on mysql-server
3.23 (installed as freebsd port on freebsd
Hello
My selects still last several hours. Can anybody give me a hint which
parameters to tune when the main selects look like the following one on a
1.5GB big table with aprox 1 million affected rows?
join_buffer_size| 131072
key_buffer_size | 67104768
max_heap_table_size
If have a problem to connect to my MySQL-Server on the Internet:
the MySQL-Manager show me this error-message:
Connecting to Server MySQL ... (Host 'pD900A48E.dip.t-dialin.net' is not
allowed to connect to this MySQL server)
Give it a Work-Around or something else??
On Fri, Mar 09, 2001 at 02:05:42PM +0200, Richard Ellerbrock wrote:
Add another index on your timestamp column. Also, I think timestamp is a reserved
word. Maybe you should rename the column to something else.
...
PRIMARY KEY (timestamp,hostname,interfacename)
) TYPE=MyISAM PACK_KEYS=1;
I
no, they do not have the same structure,
someone said something about creating a loop using php
since idealy this will end up being a web published database
this sounds good to me, just i have no idea how i would do that
*claims being new to sql php*
I've scanned thru both of the manuals
Try setting the use manager cursors in the MyODBC panel for the database in
question.
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Uwe Hein" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 08, 2001 2:17 PM
Subject: Bug in MyODBC 2.50.36-nt ??
Hi everybody,
I
Adam,
The reason you don't find any info on it is because, while not technically
impossible, it is a very bad idea.
If all the tables are not of like structure then are you intending to search
through every field in every table?
if so, yes, you could do it in PHP.
Query for the list of
If you are ftp'ing make sure your set to binary transfer method.
Pat...
- Original Message -
From: "ALICE CHIAPPETTA" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 08, 2001 2:37 PM
Subject: Problem
I have downloaded the stable release for Solaris. Everytime I try
Hi,
I've installed MySQL (latest version from the web) on my Win
ME computer using OmniHTTPd.
MySQL worked fine for a whole day... (I experimented with
several commands, made tables in databases, etc...). Then I
turned off my computer and when I rebooted, I kept having
'red light' (mysqld.exe
Herve Gaudillat writes:
Hello,
Currently, I'm evaluating the last version of MySQL products :
mysql-3.23.33
mysql++-1.7.8
mysqlgui-1.7.4 (beta)
I have big pb to launch mysql++ and mysqlGui : it crashes during DB
connection
After spending many days trying to
On 09.03.2001 10:29:28 Christian Hammers wrote:
Is this a bug or is the decimal type just evil or how should *I* behave
when having such a table?
If I'm not mistaken, then decimal is handled internally like a float. And as
such, problems like yours are really expected, because there simply
On Fri, 9 Mar 2001, Cal Evans wrote:
You can't. SQL wasn't designed to do that.
Do all your tables have the same structure?
For a quick and dirty solution: what about using a shell script getting
table names from the data directory and launching the mysql client for
every table?
Thomas
Does anyone out there have any success with Mysql ODBC driver for a server
on Windows NT?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
I would suggest that if you really want help, you should at least supply
a little information for people to work with.
You might post the table schema, the line that won't insert, and the
query and results
that you ran that shows that the indicated key are not in the table.
Since there are
I think you meant
select sum(deci) as s where deci0;
Christian Hammers wrote:
Hello
CREATE TABLE deci (deci decimal(8,2));
INSERT INTO deci VALUES (-2427.88);
INSERT INTO deci VALUES (2427.89);
INSERT INTO deci VALUES (-0.01);
select sum(deci) as s from deci having s0;
+---+
| s
Read the privileges section of the MySQL manual, and GRANT some
privileges.
Peter Daum wrote:
If have a problem to connect to my MySQL-Server on the Internet:
the MySQL-Manager show me this error-message:
Connecting to Server MySQL ... (Host 'pD900A48E.dip.t-dialin.net' is not
allowed
On Fri, Mar 09, 2001 at 08:13:24AM -0600, Gerald L. Clark wrote:
I think you meant
select sum(deci) as s where deci0;
select sum(deci) as s from deci having s0;
No, I really meant my SELECT. MySQL counted the 3 values together but
instead of coming to the conclusion that the sum is zero it
There are many ways to handle this.
You might get the current quantity on hand, and compare to orderqty
update inventory set qtyonhand=qtyonhand - orderqty where
itemno='myitemno' and qtyonhand=myqtyonhand
If the query fails, repeat until qtyonhand orderqty or update
succeeds.
Every hour or so,
I've set up a site with ColdFusion and MySQL in win2k just a month ago. It
works great. No problems I know of.
About the setting up, the only pointer I have is that the DSN must be a
system DSN, or ColdFusion won't recognize it. Other than that, ODBC should
be smooth sailing.
-Original
For some strange reason, all HEAP table indexes only process WHERE clauses
with = and = operators ONLY. There's nothing you can do about it. I'm
pretty sure of that because I remember the MySQL mentions something like
this about HEAP tables.
-Original Message-
From: Jeff S Wheeler
Hello
I have installed the MySQL server on a Windows 2000 server, and set up passwords and
usernames. And one database with 3 tables. Each tables uses auto increment fields.
(these are marked as index fields as they should be).
And then i have inserted a few test records. When i do a standard
In using the application there is one feature I see missing.
1. Inability to execute multiple statements in sequence.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello friends.
I am using mysql 3.23.33 on win 98 and win Nt on 2 different disks.
On both the systems I need a sample database for importing into mysql so I
can learn
php4.
can anyone advise where I can find a database or a tab separated text file
which I can import into mysql after creating
Doug Poland wrote:
Hi,
I'm having a dickens of a time getting mysqldump to
work. No matter what I enter, mysqldump says...
/usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an
argument
The problem was the ~/.my.cnf file. I took
Hi, Does anybody out there know if MySQL supports the Thai language, and if
so how? If I try to insert Thai font into a MySQL database then I get an
error! (I don't have the same problem with Access)
Regards
Craig Riley
Web Developer
Reading Room
77 Dean Street
London
W1V 5HA
What application would that be?
Ciaka Flemister wrote:
In using the application there is one feature I see missing.
1. Inability to execute multiple statements in sequence.
-
Before posting, please check:
Hello All,
Where can I find Apache module for mySQL ??
--
Best Regards,
Winson Chang
3F, 2, 150 Lane, Sec. 5, Hsin I Rd., Taipei, Taiwan, R.O.C.
Tel: +886-2-27225333 ext 376
Fax: +886-2-27222330
Email: [EMAIL PROTECTED]
Hi,
In using the application there is one feature I see missing.
1. Inability to execute multiple statements in sequence.
If you are talking about the MySQL command-line client program, then you
definitely can execute multiple statements at once, just by making sure you
terminate each
Not sure exactly what you're after... MySQL isn't an Apache module, it's a
separate program.
You want MySQL to run on Apache? http://www.mysql.com/downloads/
You want Apache to run MySQL on? http://httpd.apache.org/
HTH
Jon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Another alternative is: http://www.intercession.net/specialoffers
That site provides Apache/PHP (3.0.7)/MySQL for $60 per year. Just keep
clicking through the links to get to the price list.
-Original Message-
From: Cally [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 12:10 AM
Hi,
Have a problem with big tables,
Cant get them over 2GB
Using mysql 3.23.33
and ReadHat Linux 6.0 Kernel: 2.2.5
Need to biuld a table atleast 70Gb so Anyone?
/roger
_
Get Your Private, Free E-mail from MSN Hotmail at
This bug has been around for some time. The script relies upon a certain
form of output from "hostname". However, it fails when a host is named,
for example, "machine.net". It then thinks the name is "machine". Where
it will work if the name is "machine.machine.net".
This should be
Hi,
I'm trying to load test an old application that was written using the gjt
jdbc drivers for mysql.
When I start hitting it with ~10+ concurrent application sessions (each of
which do multiple, short db queries) I start seeing things like this crop
up in the log file:
Roger Westin wrote:
Hi,
Have a problem with big tables,
Cant get them over 2GB
Using mysql 3.23.33
and ReadHat Linux 6.0 Kernel: 2.2.5
Need to biuld a table atleast 70Gb so Anyone?
switch to a file system that supports very large files
The problem should be with linux no mysql.
If all the databases are running in the same mysqld then it might be
possible, if you have select permission on all of them and you preface the
table names with the database name. (select * from database.table...) You
will have to use a JOIN clause to get them all into a single statement which
Hi,
I wanted to create a UDF for MySQL that can use the ASpell engine to
generate a string of spelling suggestions, given a single word
parameter. Thus, select aspell('wrd') should return Aspell's suggested
spellings.
I don't know C very well at all, so I began using an existing UDF
function
I wanna access to a DB via php but when I run it in a navigator y get the
following message
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/home/httpd/html/challa.php on line 10
Unable to connect to database
I can get
-Original Message-
From: Bob Vastine-Parker
Sent: Friday, March 09, 2001 10:32 AM
To: John Runnels
Subject: RE: status report
-Original Message-
From: John Runnels
Sent: Friday, March 09, 2001 10:28 AM
To: MY
Subject: status
Hej!
Using MySQL 3.22.32 on Tru64 4.0F patchkit 4. Compiled with Compaq CC.
Ran optimize on a table, and after 10 minutes :
010307 17:00:00 Out of memory; Check if mysqld or some other process uses
all available memory. If not you may have to use 'ulimit' to allow mysqld to
use more memory
isamchk order_stats
Checking ISAM file: order_stats
Data records: 264282 Deleted blocks: 0
- check file-size
- check delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check record
I had a column that was set to varchar(50) which ended up not being enough
space. So I went in and did a:
alter table main change description description varchar(255) not null;
It said everything went ok, I reimported the text file, but the words stop
after 50 characters still did I miss
Hello all,
I'm a third year uni student in Scotland doing a year long project which
involves a fair amount of MySQL. I have the following problem and would be
appreciative if I could get some advice on solving it:
- in the script I run to create a table how do I code one DateTime field
to
Jamie,
mySQL doesn't support triggers, and you'd need them (or a stored
procedure). Surely you could just set both A and B explicitly in your
application logic to the same value though ? Or am I missing your point
?
P
On Fri, 9 Mar 2001, Jamie S Buchanan wrote:
Hello all,
I'm a third year
Defaults can only be constants.
You might want to look at timestamp.
The first timestamp field in a row gets updated every time teh record
changes.
All other timestamps in a row only get updated automatically on insert.
Jamie S Buchanan wrote:
Hello all,
I'm a third year uni student in
I've been trying to understand how in the world the host table interacts
with the db table to provide permissions. None of the documentation seems
to help. I've been able to grant database/host specific access to certain
users. Unfortunately, the exact same configuration (between user/db/host)
Dear Sirs:
I am trying to install MySQL on Red Hat Linux 7.0. It seems to install correctly, but
I am unable to test it. I follow the instructions in the manual (starting on page
96), but I get an error after the command safe_mysqld --user=mysql . The following
is output to the scrreen:
I read the manual plus look on the site. I been having trouble setting up a
password for root.
here's the message i get.
First I run this
$mysql_install_db
$mysqladmin -u root -p password 'newpassword'
Enter password: I enter the password same as above
mysqladmin: connect to server at
Did you read chapter 6 in the manual?
Jeff Brewer wrote:
I've been trying to understand how in the world the host table interacts
with the db table to provide permissions. None of the documentation seems
to help. I've been able to grant database/host specific access to certain
users.
I've been over Chapter 6 quite a few times, however I don't see any actual
example of using the host table in conjunction with the db table. One
concrete example, I think, would be enough to get me on the right track, but
there just doesn't seem to be any and I certainly can't make heads or
I just went through this. I found that it would be better to download and
install the binary from mysql.com because there is scant information.
With the binary install you get specific instruction sheets.
Charles
On Fri, 9 Mar 2001, Randall Paulk wrote:
Dear Sirs:
I am trying to install
There should be no password for root@localhost initially. Try
$mysqladmin -u root password 'thisIsMyNewPassword'
instead. The password mysqladmin is asking for is the current password.
The one on the command line is the new one. In your situation the current
password is nothing.
-Jeff
Try
mysqldump -u username -p --opt databasename dumpfile.sql
to get it back into another mysql server you need to create the database you
want to put it in, and then
cat dumpfile.sql | mysql -u username -p databasename
Hope that helps.
ryan
- Original Message -
From: "Jorge Cordero"
You are expecting an awfull lot from mysql to remember data that it never
recorded. When you inserted something into the varchar(50) column that was
longer than 50 it dropped the rest of the string that would not fit.
Changing the column size will not bring back the data.
ryan
I had a column
Description:
The mysql_install_db script hangs when I try to install mysql. I've tried a
src rpm, a binary rpm and the binaries. When you run mysql_install_db, three
different mysqld's are started but none actually do anything. They are all just
sitting there.
How-To-Repeat:
I get an error when trying to configure. The configure command I am
useing is as follows:
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
--without-debug
The error I get is as follows:
checking return type of sprintf... configure: error: can not run test
program while cross
I had this same problem. I could connect via the mysql client if I was
ROOT, but not otherwise.
You may have a permissions problem. Ensure that /var, /var/lib, and
/var/lib/mysql are set to: drwxr-xr-x
That cured it for me.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Then run some GRANT commands, and see what they do to the privilege
tables.
Chapter 6 goes into quite a bit of detail on this topic.
Jeff Brewer wrote:
I've been over Chapter 6 quite a few times, however I don't see any actual
example of using the host table in conjunction with the db table.
I'm getting a warning that says "the supplied argument is not a valid MySQL
result resource."
Here is the SQL that I'm trying to write in a php document.
SELECT
IFNULL(IF(CMBYR=CMEYR,CMBYR,IF(CMEYR="+",CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,'
- ',CMEYR))),' - ')
FROM
TABLE;
Is it not possible to
I reimported the text file which should overwrite the data right which
did not work. If not how do I overwrite the data?
You are expecting an awfull lot from mysql to remember data that it
never
recorded. When you inserted something into the varchar(50) column that
was
longer than 50 it
I've already run quite a few GRANT commands. None of them have done
anything to the mysql.host table. I'm pretty familiar with the db and user
tables. Chapter 6 barely mentions that the host table exists. The
statements it makes about its (the host table) interaction with the db table
do not
When you reimported the text file, did you include REPLACE? For example:
LOAD DATA INFILE 'textfile.txt' REPLACE INTO TABLE table_name;
Tracy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of scott
Sent: Friday, March 09, 2001 4:19 PM
To: MySQL
Subject:
John Halladay wrote:
I'm getting a warning that says "the supplied argument is not a valid MySQL
result resource."
Here is the SQL that I'm trying to write in a php document.
SELECT IFNULL(IF(CMBYR=CMEYR,CMBYR,IF(CMEYR="+",CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,'
- ',CMEYR))),' - ')
FROM
I recently got MyODBC to run on Win2k and it works fine.
-Original Message-
From: Gerald Jensen [mailto:[EMAIL PROTECTED]]
Sent: March 9, 2001 6:53 AM
To: Dave Loisel; MySql
Subject: Re: ODBC
Dave:
Not sure I follow the question ... we have 50+ systems (WinNT Server or
WinNT
Please provide guidance!
I've been looking over the documentation, but haven't come across any
instructions for creating your own binary distribution. The MySQL source
distribution is installed and running on our development system. Now I want
to make it into a binary distribution for
On Fri, 9 Mar 2001, Jon Haworth wrote:
Not sure exactly what you're after... MySQL isn't an Apache module, it's a
separate program.
Where can I find Apache module for mySQL ??
maybe "mysql module for apache"?
regards
--
Bartosz Sienkiewicz
MULTINET SA
I believe it is also something that has to be enabled and configured in
the apache server.
Charles Hagen
On Fri, 9 Mar 2001 [EMAIL PROTECTED] wrote:
On Fri, 9 Mar 2001, Jon Haworth wrote:
Not sure exactly what you're after... MySQL isn't an Apache module, it's a
separate program.
Where
[EMAIL PROTECTED] wrote:
On Fri, 9 Mar 2001, Jon Haworth wrote:
Not sure exactly what you're after... MySQL isn't an Apache module, it's a
separate program.
Where can I find Apache module for mySQL ??
maybe "mysql module for apache"?
regards
--
You mean mod_auth_mysql,
Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
can you help?
with best regards,
Keneth
Read the manual, read
Charles L Hagen wrote:
I just went through this. I found that it would be better to download and
install the binary from mysql.com because there is scant information.
With the binary install you get specific instruction sheets.
Charles
On Fri, 9 Mar 2001, Randall Paulk wrote:
Dear
Anyone know an easy way to migrate a Database from Postgres to MySQL?
-Jason Bell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
I found the error. I was using "" around the "+" where I should have been
using '', like '+'.
SELECT
IFNULL(IF(CMBYR=CMEYR,CMBYR,IF(CMEYR="+",CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,'
- ',CMEYR))),' - ')
FROM
TABLE;
Thanks for your help.
John Halladay
-Original Message-
From: Boulat
I've searched the MySQL manual and can't figure out how to convert one (or
all) tables to MyISAM. (I'm upgrading a very large database from 3.22 to
3.23).
I think there's a way to do it from the ALTER TABLE command, but I can't
seem to find any examples.
Thx,
Tac
Try:
alter table [tablename] type = myisam;
There is a script that purports to do this for you, but the copy that I had wouldn't
run properly, so I just made a file of the SQL needed, and ran it through mysql...
Tac/Smokescreen Action Network wrote:
I've searched the MySQL manual and can't
On Fri, 9 Mar 2001 18:41:46 -0500, "Tac/Smokescreen Action Network"
[EMAIL PROTECTED] wrote:
I've searched the MySQL manual and can't figure out how to convert one (or
all) tables to MyISAM. (I'm upgrading a very large database from 3.22 to
3.23).
I think there's a way to do it from the
I must agree. I thought you were nuts at first but I've run several GRANT's
myself and can't find one that will affect it.
Possibly it's being depreciated as people start using GRATNs and not
manually adding people into the mysql database?
Cal
http://www.calevans.com
-Original
Hi,
Can somebody PLEASE help me
If I send a query to get a list of names, like this:
SELECT Name FROM users ORDER BY Name,
I get a list of users like this...
Bob
Jon
Mark
Sally
andy
lucy
mary
steve
when what I REALLY want is this...
andy
Bob
Jon
lucy
Mark
mary
Sally
Steve
Can someone
On Wed, Mar 07, 2001 at 07:49:22AM -0600, Mike Thompson wrote:
Yes, I've tries that here is the error I get.
Your MySQL connection id is 247 to server version: 3.23.33
mysql CREATE TABLE foo(
- id INT NOT NULL AUTO_INCREMENT,
- name BLOB NOT NULL,
- PRIMARY KEY(id),
Select Name, lower(name) as sortOrder from users order by sortOrder;
Not exactly what you wanted, but closer.
Cal
http://www.calevans.com
-Original Message-
From: Kif Henderson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 7:38 PM
To: [EMAIL PROTECTED]
Subject: Case
On Thu, Mar 08, 2001 at 10:30:18PM -0500, Justin wrote:
Typically, in a database backed website with a very high percentage
of selects to inserts, people do not "expect" update operations
(posts and so on) to complete very fast. But they do "expect" page
requests to be very fast.. the
Hello,
Thank you very much for your quick answer .
(I had forgotten to give my OS : solaris 2.7 on Sparc)
This has solved the connection problem. So, now I can launched mysqlgui because
I'm able to connect to mysqld .
Unfortunately, mysqlgui crashes on 'Select QUERY' when
* I chose
Hi
How can I get mysql.sock file, it has been deleted by accident? Please let me
know.
Syed
/var/lib/mysql/mysql.sock
People,
I am new in this mailing list and new to mysql, so sorry if this question
has been asked before repeatedly.
I am developing a user table where my highschool alumni can register and
set their own password to access the member function using php. I found
from the document that I can
the table was
created with the pwd as a VARCHAR(15) --- will this long enough to held
the encrypted password??
There's your problem. PASSWORD() returns a CHAR(16).
--jfarr
-
Before posting, please check:
The best way (for me) to make csv files...
Create the file in MS Excell
Save as csv file
Hope it helps.
Svmks
--- Floyd Baker [EMAIL PROTECTED] wrote:
Hi..
I have win32, mysql, php4. For mysql building, I've
been using the (dos)
environment and a simple windows admin program.
I think that you would have got the answer by now, but initally mysql does
not need a password. You can just login without the password, then change
it using mysqladmin newpassword.
Adrian
On Fri, 9 Mar 2001, Luis wrote:
I read the manual plus look on the site. I been having trouble
88 matches
Mail list logo