Hi Donna,
You have to include the column `type` in the SQL-statement, otherwise the
not specified column will have its indirect null translated to an empty
string or 0 (for strings/numeric).
A bug or a feature? Actually I've used it as a feature sometimes when using
MySQL to move large amount of
Hi,
I've a problem that I can't drop a certain table, always get back the error unknown
table.
Version: 4.0.21 (Debian Testing)
Table-Type: InnoDB
mysql show tables;
[...]
| produkt_kategorie|
mysql drop table produkt_kategorie;
ERROR 1051: Unknown table 'produkt_kategorie'
The
Hello, I have two installations of mysql on my computer a stable 4.x version
and the aplha 5.x version. I want to use a separate my.cnf file for my 5.x
version. But as soon as I start the mysqld_safe it tries to read /etc/my.cnf
which belongs to my 4.x server. This ofcourse is not what I want. I
Johan Pettersson wrote:
Hi Philippe,
how about this:
SELECTstrategyid, COUNT(marketid) cnt
FROMstrategies_markets
WHERE marketid in(selected markets here)
GROUP BY strategyid
ORDER BY cnt DESC;
The resultset should contain the best matches, in descending order. To
find strategies that
Hi Lenz
I could not download it. When I click on DOWNLOAD link, it takes me to some strange
website.
Prafulla
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 10:37 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
In article [EMAIL PROTECTED],
Dan Tappin [EMAIL PROTECTED] writes:
Hi Shawn,
First off thanks for the tip. I had read that page once already but after reading
twice again after your post I realized that the
answer was right there. Wrapping that concept around my brain really hurt but I get
I was wondering if there was some builtin mechanism I could use to
ensure that a field or row in my database could not be altered after it
was initially inserted. Is there anything in the database that would
allow this type of functionality? Thanks!!
--
Jesse W. Asher
CISSP, CISM, SCSA,
On 21 Sep 2004 at 10:14, Thomas Trutt wrote:
Hello all,
Ok i know this may be a simple question but i need a little help.
I am writing a program in VB.net that uses MySQL as a backend. My net admin
wants the log on to be encrypted??
This is currently how i am connecting:
- Original Message -
From: Jesse W. Asher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 6:34 AM
Subject: Having rows or fields that can't be modified once entered.
I was wondering if there was some builtin mechanism I could use to
ensure that a field or
Hello
We're having some locking problems with our vBulletin 3.0 forum.
Snapshots of mysql process list show that some simple queries linger too
much in the end state, locking subsequent updates:
Id UserHostdb Command TimeState Info
..
33753 rcgroups
I was wondering if there was some builtin mechanism I could use to
ensure that a field or row in my database could not be altered after it
was initially inserted. Is there anything in the database that would
allow this type of functionality? Thanks!!
You can give a user certain rights to do
Can anyone here tell me, what does it mean when a process when a Process goes into
Sleep State. I see this under the Process tap in the WiN Mysql
administrator.. Seems each time I open my database in a program, after it
executes and I close it, I have a Process in Sleep mode.
I have the following table definition for time series data:
ID (int) time (DATETIME)state (int)value (int)
I want to make a state based grouping and calculate the mean of
each grouping. The state based grouping should be done by creating a new
group whenever the state changes, from
Is there any way to find log of queries that returned errors. Syntax
errors or column not found, for example?
The General Log simply logs the query without giving any information as
to whether the query was successful or not
Thank you in advance.
Best regards,
TS
Use GROUP BY:
SELECT state, AVG(value) FROM yourtable GROUP BY state;
See the manual for all the details
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html.
Michael
[EMAIL PROTECTED] wrote:
I have the following table definition for time series data:
ID (int) time (DATETIME)
Thank you so much joe..
You have actually have been a great help...
Again thank you so much for your help,
Tom T
At 04:44 PM 9/21/2004, you wrote:
Thomas,
Because the db is lower than version 4 and doesn't support secure
connections, unless the db is on the same box as the web server, then
/etc/my.cnf is the *global* configuration file. Settings for a specific
mysql server do not belong there. Server-specific settings go in that
server's data directory. This is described in the manual
http://dev.mysql.com/doc/mysql/en/Option_files.html and
I'm back, trying to figure my way through a somewhat
confusing set of conditons.
Sort of doing a sanity check here.
First explanation:
I've put together a search (the database) form that
has 6 inputs.
Just to clarify, the fields are
1-JobTitle
2-City
3-Start
4-Industry
5-State
6-TaxTerm.
The
I think all you need is a GROUP BY. Here is a tutorial sample from the
manual:
http://dev.mysql.com/doc/mysql/en/Counting_rows.html
Here is page that describes the full SELECT syntax, including GROUP BY
http://dev.mysql.com/doc/mysql/en/SELECT.html
And here are all of the other functions you
Hi,
Actually i want mysql 4.0 classic version which donot support innodb engine.
As classic version is a commercial base one, i installed the mysql 4.0 standard one
(which includes innodb). Here my problem is , i have to inactivate the innodb engine.
For that what we need to do is
Actually it's not a total and can't be calculated.
The idea is that as users (with individual id_client keys) add rows the id of the row
is auto incremented for their key only.
Example:
If user A adds 3 rows:
id id_client
---
1 A
2 A
3 A
and then user B adds
Hi Stuart,
Getting your brains warped by logical statements, eh?
If I remember correctly AND has precedence over OR. That means that the
statement A or B and C evaluates to A or (B and C) which means that
the statement will be true if A is true or if both B and C are true.
Because of this
My brain is warped by web development in general ;)
Thanks for your response. After I sent this , I got
an email from the PHP list, with a good chunk of code
to show how it's done. Yes, scripting is the only way
for this type of query.
Thank you for the response.
Stuart
--- [EMAIL PROTECTED]
Hi,
Hi Stuart,
Getting your brains warped by logical statements, eh?
If I remember correctly AND has precedence over OR. That means that the
statement A or B and C evaluates to A or (B and C) which means that
the statement will be true if A is true or if both B and C are true.
When in
In article [EMAIL PROTECTED],
Dan Tappin [EMAIL PROTECTED] writes:
Actually it's not a total and can't be calculated.
The idea is that as users (with individual id_client keys) add rows the id of the
row is auto incremented for their key only.
Example:
If user A adds 3 rows:
id
-Original Message-
From: Harald Fuchs
Sent: Wednesday, September 22, 2004 9:39 AM
To: [EMAIL PROTECTED]
Subject: Re: Custom Auto-Increment Problem
The only difference is when you delete rows inbetween. In this case
id_calc will be less than id.
I stand corrected. Yes it can be
Hello there,
I was wondering how I could make a specific type of search when the string has more
than one word.
Ex.-
String = Green Apple
Select * from fruits
where
(fruits.color like '%Green Apple%'
or fruits.type like '%Green Apple%')
I am extremely frustrated with the root passwordproblem. I read the
manual and followed the instructions but it just won't work.
I tried setting a newpassword but then when I insert the new passoword
it says the password it wrong.
In any case...I want to uninstall MySQL and try a new clean
RuiSMonteiro [EMAIL PROTECTED] wrote on 22/09/2004 09:35:00:
Hello there,
I was wondering how I could make a specific type of search when the
string has more than one word.
Ex.-
String = Green Apple
Select * from fruits
where
(fruits.color like
Michael,
Thanks for the response. My query was kind of long, so I was just
trying to simplify. Should have included it anyways.
Here is my query:
select REFCLIENTS.sample, TRACKING.* from REFCLIENTS, TRACKING where
TRACKING.ccode LIKE 'ABC' AND REFCLIENTS.code = TRACKING.ccode AND
Hello List,
Recently I needed to alter a large innodb table (~200k rows) to add a
column on a live server. The alter table ran fine on the development
server with close to the same number of rows in the table so I didn't
anticipate too much trouble. The list archive and the documentation
We are looking at a disk subsystem for a high transactional
application. And management wishes
to use disk appliance (IPStore or NetAPP).
Does anyone know if placing the mysql MYISAM and INNODB datafiles on
IPStore or NetApp
disk applliances are supported? (We use almost all INNODB tables)
If
On Wed, Sep 22, 2004 at 01:52:36PM -0400, Debbie L wrote:
We are looking at a disk subsystem for a high transactional
application. And management wishes
to use disk appliance (IPStore or NetAPP).
Does anyone know if placing the mysql MYISAM and INNODB datafiles on
IPStore or NetApp disk
Depending on how exact the returned values need to be, and how much data
you have to
sift through, you could do. ( perl example )
$job=$dbh-quote($job.'%');
$city=$dbh-quote($city.'%');
$start=$dbh-quote($start.'%);
.
.
.
$select = SELECT * from myfile where jobtitle like $job and city like
Your right, I shouldn't say supported... Is it a wise to put datafiles
on a disk appliance?
Coming from other database background, it is not wise to do such a
thing and will cause
problems when the disk appliance has problems.
As for the transaction logs, I haven't reallly thought of it, but to
You still did not send your table definitions.
Jeremy Brown [InfoSend] wrote:
Michael,
Thanks for the response. My query was kind of long, so I was just
trying to simplify. Should have included it anyways.
Here is my query:
select REFCLIENTS.sample, TRACKING.* from REFCLIENTS, TRACKING where
On Wed, Sep 22, 2004 at 02:22:59PM -0400, Debbie L wrote:
Your right, I shouldn't say supported... Is it a wise to put
datafiles on a disk appliance? Coming from other database
background, it is not wise to do such a thing and will cause
problems when the disk appliance has problems.
Well,
Making all in sql
make all-recursive
Making all in share
../../extra/comp_err -C./charsets/ danish/errmsg.sys
Usage: ../../extra/comp_err [-?] [-I] [-V] fromfile[s] tofile
*** Error code 255
what's this error?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
The returned values should be exact. As far as how
much data, I'm assuming your talking about amount of
records ?
Potentially eventually maybe quite a bit.
Currently mysql statement is comprised of select and
from with all the proper joins.
But Im confused, when you say below actual SQL call
here,
Hi,
Yes ofcourse it is a primary key with two fields. The insert exists whenever it
has a duplicate entry, it doesn't continue with further records. Is there any
scope to resolve it.
Thanks
Suresh
Eldo Skaria wrote:
Hi,
Suresh may be expressing that he has a primary key with two fields.
Stuart.
If your queries must match _all_ of your input variables, you are in the
situation where you only need ANDs (no ORs needed). Just create one term
in your WHERE statement for each field they filled in and make sure that
there is an AND between each of them in the right places. This
Right, I thought the rules were mentioned in the first
post. Apoplogies. The user should be able to enter
one value or all 6 and with each additional value
added from none, the results should be more refined.
i.e. Alabama chosen only - all jobs in Alabama come
back
Alabama and Financing - all
Stuart Felenstein wrote:
The returned values should be exact. As far as how
much data, I'm assuming your talking about amount of
records ?
Potentially eventually maybe quite a bit.
Currently mysql statement is comprised of select and
from with all the proper joins.
But Im confused, when you say
Shutdown mysql, move data files, create symlink to datafile(s) on
other partition/disk/whatever..
- Original Message -
From: VijayKumar Dogra [EMAIL PROTECTED]
Date: Wed, 22 Sep 2004 11:22:55 +0530
Subject: MySQL data files
To: [EMAIL PROTECTED]
Hello All,
Is there any way
I do not know if this is the right way or not but this is how I have done
it:
Delete Mysql-Version folder, from where you installed MySQL. It is normally
in '/usr/local' folder. Then re-install MySQL.
Hope it works.
Kirti
-Original Message-
From: FayeC SQL [mailto:[EMAIL PROTECTED]
Hello,
I have a music database containing song BPM (Beats Per Minute) data values
stored as FLOAT. I need to pull a range of BPM values based on a
user-supplied integer. The range should pull all records which are 8%
higher and lower than the given integer.
I tried this query for
At 03:11 PM 9/22/2004, you wrote:
Hello,
I have a music database containing song BPM (Beats Per Minute) data values
stored as FLOAT. I need to pull a range of BPM values based on a
user-supplied integer. The range should pull all records which are 8%
higher and lower than the given integer.
Suresh wrote:
Hi,
Yes ofcourse it is a primary key with two fields. The insert exists whenever it
has a duplicate entry, it doesn't continue with further records. Is there any
scope to resolve it.
Thanks
Suresh
Eldo Skaria wrote:
insert ignore
--
MySQL General Mailing List
For list archives:
SELECT * FROM test
WHERE bpm ( 100 * 1.08 ) AND bpm (100*.92)
Stembridge, Michael wrote:
Hello,
I have a music database containing song BPM (Beats Per Minute) data values
stored as FLOAT. I need to pull a range of BPM values based on a
user-supplied integer. The range should pull all
FayeC SQL wrote:
I am extremely frustrated with the root passwordproblem. I read the
manual and followed the instructions but it just won't work.
I tried setting a newpassword but then when I insert the new passoword
it says the password it wrong.
In any case...I want to uninstall MySQL and
Warning: mysql_query() [http://www.mysql.com/doc]: Your query requires a full
tablescan (table bb1_designelements, 78 rows affected). Use EXPLAIN to optimize your
query.
I get this error on every products i tested
Hello there,
I was wondering how I could make a specific type of search when the string has more
than one word.
Ex.-
String = Green Apple
Select * from fruits
where
(fruits.color like '%Green Apple%'
or fruits.type like '%Green Apple%')
I'm trying to perform a query where I transpose cell values from a table
into column names with totals. For example, I have the following table and
I'd like to produce the view at the bottom:
SitePartQuantity
Site APart 15
Site A
At 04:17 PM 9/22/2004, you wrote:
Hello there,
I was wondering how I could make a specific type of search when the string
has more than one word.
Ex.-
String = Green Apple
Select * from fruits
where
(fruits.color like '%Green Apple%'
or fruits.type
Hey all, I have a question about indexing part of a date field. I
have a query that I run on a regular basis to retrieve monthly sales
numbers:
SELECT SUM(OrderSubTotal) FROM tblOrders
WHERE DATE_FORMAT(ShipDate, '%Y-%m') = '2004-09';
ShipDate is a date field. My question is how I can phrase
Ah, this is not as complex as I imagined. Thanks!
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 22, 2004 4:52 PM
To: Stembridge, Michael
Cc: [EMAIL PROTECTED]
Subject: Re: SELECT a percentage range of a given value
SELECT * FROM test
Still have GMail invites, for anybody that is interested. E-mail me.
(reply off list)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sven,
This warning is telling you there your query is going to execute
very slowly. The EXPLAIN that it talks about is mentioned in the
manual here:
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
You should also search the manual for sections on query optimization
and index usage.
Here is
You're probably going to need to create some indexes on your tables. If you
have no indexes, MySQL can only do a full tablescan.
See the manual for the syntax of the statement that creates an index.
Rhino
- Original Message -
From: Sven [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Sure you can. Just move your current data to the location you like to
use and then do either of the followings:
1) supply parameter --datadir during startup (or equivalent in my.cnf file)
2) Create a symlink from old location to new location
- Original Message -
From: VijayKumar Dogra
We have been using innodb tables on our systems and we use netapp to
store all the tables. It will be however wise to put transaction logs
into a different netapp or somewhere else so that even if the netapp
goes kaput (highly unlikely) totally you do not lose any data.
--
MySQL General Mailing
How do you start your mysql now ? In any case you need to supply the
--skip-innodb option either in the option file (which most likely you
don't have) or at the startup time. If you use safe_mysqld script to
start your installation just pass on --skip-innodb to it. And even if
you don't, it is not
Hello All,
For a new build I am seeing that mysql_install_db is putting entries in user table
where user= in addition to the correct entries for root. See below
mysql select * from user where user=;
Hi,
I juste installed mysq. 5.1 (alpha) and i guess i am facing some really stupid
issue :)
I logged in as root without probleme create a database xoops which shows when
i do a show databases
Now i try to give grants to a user on that datase via grant all on xoops.* to
[EMAIL PROTECTED]
If you want to use the index, you cannot put the column through any
function. You have to compare the column value, as is, to constants. For
example,
SELECT SUM(OrderSubTotal) FROM tblOrders
WHERE ShipDate BETWEEN '2004-09-01' AND '2004-09-30';
should do what you want.
Michael
Andrew
Hi,
I have a MyISAM-table with a couple of fields, and about half a million
rows (datafile is 15MB, indexfile is 10MB) . The server is running under
MySQL 4.0.21.
Creating an index on a field takes about two minutes. That's fully
expected, as the server has to perform an initial sorting for all
In the last episode (Sep 23), Peter Brodersen said:
I have a MyISAM-table with a couple of fields, and about half a million
rows (datafile is 15MB, indexfile is 10MB) . The server is running under
MySQL 4.0.21.
Creating an index on a field takes about two minutes. That's fully
expected, as
Well i think i found a bug or a change un behavior between mysql 5.0.0 ans
mysql 5.0.1
The behavior i describe does not happen.
Can anybody else confirm this ?
Thanks
Yann
On September 22, 2004 21:51, Yann Larrivée wrote:
Hi,
I juste installed mysq. 5.1 (alpha) and i guess i am facing
Hello everyone, I know Rhino gave me a link or something a month ago
but. can anyone give me a link to a tutorial on how to
...basically I have been creating my databases one command
entry at a time. I just thought if someone knew of a site off the top of
there list that could
69 matches
Mail list logo