Is there a way to only include certain matching conditions
in indexes?
Example if I have a row I want to index that is mysql dates
(2007-06-07) and I only want to include CURRENT and FUTURE
dates in the index and ignore any past dates. Is that
possible at all?
The issue I have is that the ratio
We have a statement that joins 8 different tables to pull
multiple rows from each table.
I have heard of people using triggers to create, update and
delete records in a table based on statements in other
tables.
The obvious result of this would be to SPEED up results
right? :)
I'd love to f
Here are some links for you...
http://www.howtoforge.com/mysql_master_master_replication
http://sequoia.continuent.org/
http://www.howtoforge.com/loadbalanced_mysql_cluster_debian_p5
--- Rilawich Ango <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I know it is an old question and I have read from
Rolando,
You are my hero! Thank you very much, this was extremely
helpful.
--- Rolando Edwards <[EMAIL PROTECTED]> wrote:
> 1) Are you opening connections and properly (explicitly)
> closing them ???
>
> If you are using PHP, Please make sure you close all
> mysql_query requests with two(2)
I'm having an issue where an application will open multiple
connections to mysql that will remain open.
Eventually, the server will get bogged down with these
connections or reach the max connections and stop allowing
new connections.
I'm working with the application vendor to resolve the
issue o
I use SQLBalance for MySQL.
It's got a couple of minor bugs, but it's been great for us.
http://www.dswsoft.com/sqlbalance.php
Steve Buehler <[EMAIL PROTECTED]> wrote: Is there a program out there that I
can use to compare two
databases? Just the structure, not the content.
Thanks
Stev
I've heard absolutely wonderful things about this transaction-safe storage
engine. We're using InnoDB now and are always looking for the best solution
as we scale our DB operations.
Has anyone tried the SolidDB for MySQL beta stuff yet?
What do you think of it?
Cory.
Omnipilot, the makers of the LASSO application server now offer a free
developer version of lasso professional. It has the best web-based database
browser and SQL utility that I've ever seen. It has native MySQL connectors,
it's a snap to get up and running.
Cory
Scott Bak
all the SAN disk lights
light up when that happens.
What do you use on your SAN? We're looking at deploying a SAN on our
Linux MySQL setup.
Cory.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tablename SET column='/realtors/This_Value/' WHERE
column='/realtors/Value/';
Should do the trick.
Cory
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Slightly new query.. Here's the new query and results of an explain..
I'm thinking that some indexing would help.. However, I don't really
know where to start.
---
EXPLAIN
SELECT
pnr.ID ID_pnr,
pnr.reservationdatetime,
pnr.conf_number,
pnr.created_by,
(
SELECT pnr.ID ID_pnr, pnr.reservationdatetime, pnr.conf_number,
pnr.created_by,
GROUP_CONCAT(pp.name_last,', ',pp.name_first ORDER BY name_last
DESC SEPARATOR '') names,
(SELECT SUM(pf.base_fare*(SELECT COUNT(1) FROM pnr_passengers pp
WHERE pp.ID_pnr=pnr.ID )) FROM pnr_fares pf
T COUNT... Is
there any way to get the query to only do this once?
ANY help will be greatly appreciated.
We're running MySQL 5
Cory.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there anything I can put into the my.cnf file to buffer connection
(leave it open) to give a similar effect as connection pooling?
Thanks in advance!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s with 1-9
(most likely ~70% '0's)
Cory
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Can you post the results of "SHOW CREATE TABLE pnr_segments", please
pnr_segments | CREATE TABLE `pnr_segments` (
`ID` bigint(20) NOT NULL auto_increment,
`ID_pnr` bigint(20) NOT NULL,
`ID_pnr_fares` bigint(20) NOT NULL,
`flight_number` int(10) unsigned NOT NULL,
`
gerald_clark wrote:
Cory at SkyVantage wrote:
*** 1. row ***
id: 1
select_type: SIMPLE
table: status
type: ALL
possible_keys: NULL
key: NULL
key_len: NULL
ref: NULL
rows: 100
Extra
f
possible_keys: PRIMARY
key: PRIMARY
key_len: 8
ref: W4_AirlineData.status.ID_segments
rows: 1
Extra: Using where
Any help you anyone can provide as to the best way to create these
index's that'd be great! This is an OFTEN used query in our software
and th
ering if anyone else running cluster has had any issues with
transactions??? Anyone? I'd _really_ like to get this working
since my work-around is in my web application until I can get it working...
Good to see you on this list too James! :)
Cory.
James Harvard wrote:
Hi Cory - nice t
rly or else I'll have orphaned
records all over the place...
Thanks in advance!
Cory.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UTF-8 is the encoding would want to use for Thai. Also see:
http://dev.mysql.com/doc/refman/4.1/en/charset-asian-sets.html
Cory.
Peter Lauri wrote:
I am in the situation to develop an web site for a Thai school and it will
be in Thai and English. How can I setup so that my tables understand
I have a similar question. How do you test if the field in question
isn't NULL or '' (empty string)? Is the LENGTH a good test or is
there a better way?
[EMAIL PROTECTED] wrote:
LENGTH does exist (as a function):
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
and here is h
PARATOR ''|.
>
> You can set a maximum allowed length with the
> |group_concat_max_len| system variable. The syntax to do this at
> runtime is as follows, where |val| is an unsigned integer:
>
>SET [SESSION | GLOBAL] group_concat_max_len = val;
>
What I need to do is take this query and this result:
SELECT segfees FROM fsf;
+-+
| segfees |
+-+
| FS=5.00 |
| AY=2.50 |
| XF=1.75 |
| ZP=3.20 |
+-+
I make it just return ONE row like this:
+-+
| segfees |
+--
MySQL AB offers great training! http://www.mysql.com/training/
In the long run, getting training right from the true experts is going
to be your best bang for your buck. Trust me, I know from experience
on this one.
Cory.
Jeffrey G. Ubalde wrote:
Anybody here who have conducted MySQL
I'm using MySQL-Cluster 5.0, and we're doing some research.
What is everyone's opinion as to what the best fieldtype to store an IP
address in?
varchar(16) ? because 16 is the max chars of an ip address...
char(16) ?
text(16)
Not quite sure how to get the best memory utilization...
--
MyS
We were storing relational data all in one field in XML. We now have a
need to search through that data and we're now doing fulltext searches.
And as you can imagine, this is getting painfully slow. We're now
designing a true normalized database (well, normalized within reason)
with table
this and get a reasonable combo of both.
Are there any tutorials for setting up MySQL Field Types (for a
somewhat-newbie to advanced database design) on the net?
Cory @ SkyVantage
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t a reasonable combo of both.
Are there any tutorials for setting up MySQL Field Types (for a
somewhat-newbie to advanced database design) on the net?
Cory @ SkyVantage
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t a reasonable combo of both.
Are there any tutorials for setting up MySQL Field Types (for a
somewhat-newbie to advanced database design) on the net?
Cory @ SkyVantage
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it possible to have cluster and replication? (ie clusters at each
location and replication to sync each location)
Alan Williamson wrote:
I've 10 server in differents locations, I want to make a broadcast, I
would like to have always datas synchronized between this network, each
database h
ny 'out of the box' MySQL package will do what
you want -- I could be wrong though.
It seems to me that this is something that is going to become more and more
popular so I'd be really surprised is MySQL-AB isn't already cooking
something up.
-Cory Robin, SkyVantage Corp
r overall ROI.
And with your budget, I'd definately strongly consider Dell.
Cory
SkyVantage Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
did you start mysql with --initial ??
Dotan Cohen wrote:
Hi list,
I just setup mysql and apache on my Fedora Core 4 machine. I intend to
use MySQL through php. I understand that I must first create a user,
but I can't find out how! Even on the mysql site the tutorial starts
off assuming that
'2005-10-02'
And so on until it finds >= 15 records or it searches through 5 days (+- 3
on search date)
I hope this makes sense.. I'm new to all this stuff.
Eventually I'm going to do the same thing for times as well..
Thanks in advance for any help!
Cor
I'm trying to return all records between two dates.. The fields are
datetime fields...
Which is better? The following or using BETWEEN? (A little lost here)
SELECT * FROM passengers WHERE
reservation_date_time >= '2005-01-01 12:10:00'
AND reservation_date_time <= '2005-05-01 12:10:00';
--
M
n the mailing list but haven't
found anything of interest other then MyReplicator
(http://www.myreplicator.com/service.htm).
Cory
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How about from the php api, or something similar:
mysql_num_rows()
Cory
On Thu, 2004-01-15 at 10:43, Alejandro D. Burne wrote:
> I'm testing store procedures, and I want to know the number of
> records returned from a query.
> There is a function or variable to get it through od
That did the trickthanks so much!
Cory
On Wed, 2004-01-14 at 12:50, Douglas Sims wrote:
> Would something like this do what you want?
>
> SELECT project_id, SUM(time_worked) AS total FROM time_daily WHERE
> user_id='clh' AND period_id='27' GR
GROUP BY project_id
However, having 'NULL' appear where the total is 0.00 doesn't do me much
good :-) How do I write this query to only show me the results where the
total is > 0.00...so where the results that total 0.00 don't appear at
all.
I am sure I am missing something..
Contents are Direct Alliance Corporation CONFIDENTIAL
-
Your best bet is to grab 4.3.1 or greater
Windows version even has gui installer...
http://us2.php.net/get/php-4.3.3-installer.exe/from/a/mirror
This message is for the designated recipient(s) only and contains Direct
Alliance Corporation p
ep getting the # errno.- Invalid use of group function -
I don't want to pull out any rows where the SUM of time_hours_worked is
'0.00'...
I would be most grateful if anyone has any suggestions
Many thanks!
Cory
--
Cory Hicks <[EMAIL PROTECTED]>
TRI Internat
looks like it's using the correct indicesI don't know what else
to do...
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 12:23 AM
To: Twibell, Cory L
Cc: [EMAIL PROTECTED]
Subject: Re: Table Query taking WAY TO LONG...HELP PLEA
out 1.5 million records.
Using MySQL 4.0.14-pro
Thanks,
Cory Twibell
Lockheed Martin Space Systems Company
Electronic Combat Development Systems
[EMAIL PROTECTED]
(303) 971-3184
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Contents are Direct Alliance Corporation CONFIDENTIAL
-
- For writing long sql statements I prefer mysqlcc,
and the tab feature is nice.
- Phpmyadmin also has some handy feature. Most of it is preference...
If learn to use both then all the better...
-Original Message-
From: Dathan
ot a float') as
type
From table
Thxs
Cory
This message is for the designated recipient(s) only and contains Direct
Alliance Corporation privileged and confidential information.
If you have received it in error, please notify the sender immediately and
delete the original.
Any oth
Hi,
I am trying select field / 1 as Number from table1 where id = 1;
I don't want any rounding taking place, but MySQL is currently doing it.
How can I ask for a specific number of digits with division?
The field contains 1234.5678, MySQL returns 1234.57, don't want that!
Tha
Contents are Direct Alliance Corporation CONFIDENTIAL
-
I have a table with 10 cols. 8 of which all need to be searched on
independently of each other.
Does creating 8 separate indexes for that table affect the speed of how
mysql searches each index?
In other words would keeping my indexes to on
Contents are Direct Alliance Corporation CONFIDENTIAL
-
Andrew,
I have setup all the environments you are talking about.
CF with MS SQL is much easier to setup and get going than PHP and mysql.
However I have see twice the speed and stability with my applications that
are written in PHP and
Contents are Direct Alliance Corporation CONFIDENTIAL
-
Duane,
Does mysql actually start back up? Or just get hung on step(4)?
I know I have had problems running scripts over ssh because the sudo
environment user wasn't being executed as root. (where a cron_tab was
actually execu
IL PROTECTED]
Subject: Re: Help with privilege tables - IMPORTANT
"Twibell, Cory L" <[EMAIL PROTECTED]> wrote:
>
> I have the user table which contains user record
> | Host | User| Pass | Select...|
> ---
> |% |
Did you flush the privileges after you gave root a password?
The error you get is a result of not using a password to login.
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 6:05 PM
To: [EMAIL PROTECTED]
Subject: Access Denied for User: [EMAIL PRO
Yes, I have the UPDATE for table B. I belive this is a bug.
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 4:47 PM
To: Twibell, Cory L; [EMAIL PROTECTED]
Subject: RE: Help with privilege tables - IMPORTANT
Hmm, if you have UPDATE privilege on
003 4:22 PM
To: Twibell, Cory L; [EMAIL PROTECTED]
Subject: RE: Help with privilege tables - IMPORTANT
Well, with that in mind, does the user have the appropriate INSERT
privileges?
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Twibell, Cory L [mailto:[EMAI
My user in the user table has NO privileges. All privileges for that user
are done in the db table. Using MySQL 4.1.0-alpha
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 3:41 PM
To: Twibell, Cory L; [EMAIL PROTECTED]
Subject: RE: Help with
7;.
When I changed the user table to allow the global update and select
privilege, it worked.
Is the multi table update correct for the privileges tables? I don't want
the user to have global access, only db access.
Thanks
Cory Twibell
Lockheed Martin Space Systems Company
Electronic Comb
After I use mysql_free_result(), I immediately set the resultset to NULL.
-Original Message-
From: Adam Lawrence [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 11:36 AM
To: [EMAIL PROTECTED]
Subject: C API - mysql_free_result
Stats: MySQL 4.0.13, under Windows98, using the C API
The below query is not good, due to the fact that if name and age aren't
unique, I'll be returning multiple ids with it. One should always use the
LAST_INSERT_ID() or after an insert, select max(id) from myTable.
-Original Message-
From: Carter, Scott [mailto:[EMAIL PROTECTED]
Sent: Wednes
Check out LAST_INSERT_ID() in the manual
-Original Message-
From: Jonas Geiregat [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 12:26 PM
To: 'Mysql'
Subject: probably a stupid question
Hey,
Here is what I want to do
I have 2tables
let's say table A and B for simplicity.
in tab
from the
client group?
I have a C++ wrapper around the MySQL C api and don't want to hardcode the
host and port. I also don't want to use an environment file. Will the
mysql_options do what I am asking?
Thanks,
Cory Twibell
Lockheed Martin Space Systems Company
Electronic Combat Deve
compiles, I and limited to 2GB files.
I can happily create files larger than 2GB outside of mysql. I have
also tried running with the "--big-tables" option.
Any help you could provide would be great.
Thanks
cory
-
Befo
Duh! I need '' around my datesorry for the traffic.
sql, query
Duh!
--
Cory Hicks
Texas Research International, Inc.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (
esult form the query, the id, but I get no results.
Advice? Helpful hints always welcome..
Many thanks!
Cory
--
Cory Hicks
Texas Research International, Inc.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.
Ken,
Here's one way:
>From a terminal window, logged in as root or su, run setup and then
select services and you can select mysqld to be automatically started.
HTH!
Cory
sql, mysql, select, query
On Wed, 2002-12-04 at 08:31, Ken Morley wrote:
> On my RedHat Linux 7.3 system with
Peter,
I would do something like this:
(UNIX_TIMESTAMP(Column Two) - UNIX_TIMESTAMP(Column One))/3600
to give you the hoursnot sure about the minutes, but this should get
you going!
HTH,
Cory
'$valid_user' ";
On Tue, 2002-12-03 at 10:45, Peter Abilla wro
Jeff,
Try a JOIN:
http://www.mysql.com/doc/en/JOIN.html
or for some good articles:
http://www.onlamp.com/pub/ct/19
HTH!
Cory
On Fri, 2002-11-01 at 10:01, jeff wrote:
> Hello
>
> I am having some trouble writing a query that will pull the information I
> need from the data
Chris,
This is how I do it:
SELECT UNIX_TIMESTAMP(time_sign_out) -UNIX_TIMESTAMP(time_sign_in)/3600
AS hours
HTH!
Cory
On Wed, 2002-10-30 at 13:50, Raymer, Chris wrote:
> Having trouble getting the syntax to calculate the time difference given 2 dates
>like so:
>
> A.) 2002
I'm using PHP with mySQL and I got very weird results when I ran a count. I
used "SELECT COUNT(*) FROM $TableName", with $TableName being my table's
name, for the Query. When I printed the result I got "Resource id #2", what
does that even mean. And what did I do wrong?
--
It would help if MySQL listed which database the slow query was coming
from in the slow query log.
Cory.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
mysqldump? Does anyone have any ideas for a way to
back up the database without having the site be down while it happens?
Cory.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
I have been happily using a program I developed that uses mysql to store technical
support articles that I ancounter regularily. A new person is starting work here
tomorrow, so suddenly, I need this to work over the network. The touble is, when I try
to connect from the other workstation, I get
Many thanks. Problem is cured
- Original Message -
From: "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]>
To: "Cory Whitesell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, February 24, 2001 4:26 PM
Subject: Re: Stumped
> > Thi
This should be very simple, but for some reason, my query does not return the desired
results
I have the following two tables:
CREATE TABLE Rank (
Rank CHAR(40) NOT NULL PRIMARY KEY,
ReportsTo CHAR(40) NULL
);
CREATE TABLE ROSTER (
EntryNumber INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY
I am experimenting with MySQL for both Linux and Windows 2000. The trouble is, I do
not Have Visual C to compile the BDB code under Windows 2K. Is there any place to
download them for Windows 2000 in a binary form? Or is there somebody who can compile
them for me?
I am terribly sorry to hear about your wookie.
> Has anyone seen my wookie?
>
> just that, I have a horrible feeling he's fallen off the internet
somewhere!
>
>
-
Before posting, please check:
http://www.mysql.com/manual.ph
Go to the MySQL Contributed page and go from there to get the Zeos MySQL
components. (They may be under Borland Delphi, but they come with components
for C Builder 4 and 5)
Either that, or you can just use the standard TDataSet components and use
MyODBC to create the data source.
- Original
76 matches
Mail list logo
