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
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
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 the
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
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) calls
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
Steve
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 Baker [EMAIL
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.
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,
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]
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 'br') names,
(SELECT SUM(pf.base_fare*(SELECT COUNT(1) FROM pnr_passengers pp
WHERE pp.ID_pnr=pnr.ID )) FROM pnr_fares
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]
: 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 the tables with have many rows.
Cory
--
MySQL General Mailing List
For list archives
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
[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,
(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]
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 to see a fellow Lasso user
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
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 |
;
If a maximum length has been set, the result is truncated to this
maximum length.
=
Best regards,
Cristi
Cory @ SkyVantage wrote:
What I need to do is take this query and this result:
SELECT segfees FROM fsf;
+-+
| segfees |
+-+
| FS=5.00 |
| AY=2.50
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...
--
.
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]
.
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]
.
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]
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
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
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 Corporation
-Original Message
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
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!
Cory Robin
SkyVantage
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
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';
--
and in 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 odbc?
I'll
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...thanks for any help!
Cory
--
Cory Hicks [EMAIL PROTECTED]
TRI
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' GROUP BY project_id HAVING total0;
Cory Hicks
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
.- 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 International
--
MySQL General Mailing List
For list archives
about 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
|
It 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 PLEASE
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:
') 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 other use of this email
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!
Thanks,
Cory
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
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
: Help with privilege tables - IMPORTANT
Twibell, Cory L [EMAIL PROTECTED] wrote:
I have the user table which contains user record
| Host | User| Pass | Select...|
---
|% || | N... |
The db record is
| Host | Db| User
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 Combat Development Systems
[EMAIL PROTECTED]
(303
: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:[EMAIL PROTECTED
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
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
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
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
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:
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 Development Systems
it 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
-
Before posting, please
, 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.mysql.com/manual.php
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 (the manual
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 MySQL 3.23, I
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 wrote:
Suppose I
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 database. I hope it's
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
the 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
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
This should be very simple, but for s
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?
70 matches
Mail list logo