-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 01:09 pm, Jeff Smelser wrote:
On Wednesday 30 June 2004 12:46 pm, J S wrote:
Thanks for your reply.
By replication do you mean do I have tables with duplicate rows? If
that's the case then I do have one table
see that dir other then who could log in.
An idea.
Jeff
- --
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: My cat's been cashing my reality checks again
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:05 am, Mike Miller wrote:
Unless you have a specific need for it, you could save yourself a lot of
trouble by putting select tables or databases or even clients on each
server. This also means you don't incur the added
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 12:52 pm, Michael McTernan wrote:
Dear Mark,
The best way to fix this is by correctly setting your from address in your
mailer to [EMAIL PROTECTED]
Your email software seems to be wrong. All these people can't be doing
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 03:00 pm, Kairam, Raj wrote:
After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from
CPAN ), in the DBD-mysql-2.9003 directory I tried the following
mkdir /tmp/mysql-static
cp /usr/lib/mysql/*.a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:48 pm, Tom Williams wrote:
Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux
system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to).
The compile runs smoothly, but make test fails. Here is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 15 June 2004 10:43 am, Carlos Sunden wrote:
I am not completely sure what this is although I've read about it.
www.innodb.com.. Gives you all the info you can handle.
Jeff
- --
Not quite human any longer.
-BEGIN
.. Well the 001-018
doesn't exist on my server. So I get:
mysql PURGE MASTER LOGS TO 'mysql-bin.004';
ERROR:
Target log not found in binlog index
How do I get rid of the 000-018 files that don't belong there?
Thanks,
Jeff
- --
If you're going to walk on thin ice, you may as well dance
there
again to.. In case anyone else is reading this thread.
Thanks,
Jeff
- --
Help, I've fallen and I can't... Hey, nice carpet!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAz2Ewld4MRA3gEwYRAg3AAKCqBDO26SvuidzBYkSrNcAyrDb5ugCgyWJr
it71LmDG5caZyGrIzWwUMCE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 12 June 2004 09:12 am, François Schiettecatte wrote:
Hi
I am running into an interesting issue with replication speed. The
setup I have is very simple, one master and one slave. The master
processes a lot of inserts and updates all
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 10 June 2004 08:03 am, Josh Trutwin wrote:
Would you be willing to share your perl script? Perhaps offlist if you are
concerned about everyone seeing it?
I would like to see it as well.. If at all possible
- --
How
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 08 June 2004 01:56 am, Terence wrote:
We're looking for a client-server instant messaging system (opensource),
powered by MySQL if possible. Anyone know of one?
I've been taking a look at Gaim, Sim etc, but these all piggyback on Yahoo,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 08 June 2004 03:19 am, Terence wrote:
It appears as though Jabber does support MySQL. Thanks for the lead :)
its open source, it always can.. :)
Jeff
- --
Death? Life? I never did understand Zen.
-BEGIN PGP SIGNATURE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 08 June 2004 03:19 am, Terence wrote:
It appears as though Jabber does support MySQL. Thanks for the lead :)
Not true:
http://docs.myjabber.net/howto/mysql.htm
Just do a jabber+mysql from google, there are clients too, but thats the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 08:36 pm, starofframe wrote:
description like this : if now()-crea_dt 0 then delete
select date_sub(crea_dt, interval 1 day)
- --
If you're like me, and I know *I* am... -- Joel Robinson
-BEGIN PGP SIGNATURE-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 09:25 pm, starofframe wrote:
Hi Jeff,
you mean I can use sql like this
DELETE FROM table where date_sub(crea_dt, interval 1 day)
Add: crea_dt
- --
Anything worth fighting for is worth fighting dirty
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 09:22 pm, Jeff Smelser wrote:
On Monday 07 June 2004 09:25 pm, starofframe wrote:
Hi Jeff,
you mean I can use sql like this
DELETE FROM table where date_sub(crea_dt, interval 1 day)
Add: crea_dt
Could be .. Damn
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 10:03 pm, starofframe wrote:
but
delete from table where date_sub(crea_dt, interval 1 day)crea_dt
should delete all data right???
All I want is compared to date_now
eg : now is 2004-6-8 and all I want to delete is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 12:49 am, Emmanuel van der Meulen wrote:
I've looked in several books and searched Google but cannot get a way of
doing this. It seems Oracle has a 'FIRST' in their select which they use
for such a use case. But I do not
Is there a way to force the use of a specific index when issuing a
select querie?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 02 June 2004 01:57 pm, Oropeza Querejeta, Alejandro wrote:
Hi, two questions:
Is it possible to select data from different Databases on the same
server?
Select *
from db1.table
,db2.table blah blah..
Is it possible to
that unless this
is a read only database, this is going to give you a lot of problems.. Did
you not see this article?
Thanks,
Jeff
- --
Beer wants to be free.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAu3L0ld4MRA3gEwYRAsOTAJwPcv6AIOf3
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 28 May 2004 02:57 am, Martijn Tonies wrote:
Hi,
ok - I've checked.
Why not? What's wrong with this:
BORROWER
BorrowerID
BOOKS
BookID
BorrowerID (nullable)
FK from Books.BorrowerID to
know. IT
wasn't the foreign key part that was hanging him up..
I think we were on two different tracks and that could have been my fault.
Jeff
- --
Give me Liberty or give me... well, whatever you think is best for society.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 28 May 2004 11:50 am, Martijn Tonies wrote:
This makes perfectly sense.
So, once again I dare to ask: what's the problem with NULLable
Foreign Keys? It works fine :-)
(now, who was it that said that FKs should be entered/exist
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 27 May 2004 03:00 am, Martijn Tonies wrote:
Why not? What's wrong with this:
BORROWER
BorrowerID
BOOKS
BookID
BorrowerID (nullable)
FK from Books.BorrowerID to Borrower.BorrowerID
I haven't checked, but this _should_ be
to shut it down, just stop the db, and copy (and zip) the db
files.. If you can;t, you have to buy the mysql innodb backup tool from
mysql.com.. (I think its from there.. )
The hotbackup tool it pretty automatted from what I hear.
Jeff
- --
Mercifully free of the ravages
, and date returned would be
how I would know if its out or not..
Just thinking off the top of my head as there probably is a better way to do
it.
I am sure there are other ways to do this.. Foreign keys can't be null.
Jeff
- --
Calm down--It's only ones and zeroes.
-BEGIN
a 6 to any other digit, it
gets entered correctly. Any idea what is going on here!?
Version 4.0.15
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the explanations..
Jeff
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 2:41 PM
To: Jeff McKeon
Cc: [EMAIL PROTECTED]
Subject: Re: Very Strange data corruption
Jeff,
You are trying to exceed the limits of the INTEGER column.
INTEGERs
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 24 May 2004 02:01 pm, Kirti S. Bajwa wrote:
[client]
password
Is there some reason you cant look in the manual for this?
http://teaching.cs.uml.edu/MySQLdocs/MySQL_Manual/Connecting.html
-BEGIN PGP SIGNATURE-
Version: GnuPG
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 24 May 2004 02:28 pm, Free Grafton - CCB wrote:
Can someone show me how a configuration file (my.cnf) would look to
have dual MySQL masters. I know it can be done, as I have read about
others using it. I simply can't figure out how to
, populating, using, dropping a table every month won't impact
my database performance.
Is there any specific optimization or maintainence I should be doing
after dropping the table each month?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
.
Jeff
- --
Humans are just like you and me, except... they're humans.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAqN8Lld4MRA3gEwYRAsWDAJ48JvacK5At6qRqm0fv06XIlLK6DQCgs6y2
uJwBAUJFQGpwYV4UZDzPeEE=
=/d8B
-END PGP SIGNATURE-
--
MySQL General Mailing List
near 'password with grant option' at line 1
Copied and pasted the command direct from the manual and still ain't working :(
HELP!!!
Cheers,
Jeff
|
+---++--+-+-++---+--+
Is there an index I can add to improve the performance of this query? Any
help would be greatly appreciated.
Thanks.
Jeff Gunther
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Is there any way to fix a corrupted relay log on a slave?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this from relay-log.info;
Mysql: Slave Start;
Does anyone see a problem with this method?
Thanks,
Jeff
-Original Message-
From: Jeff McKeon
Sent: Thursday, April 08, 2004 8:54 AM
To: [EMAIL PROTECTED]
Subject: Corrupted relay log
Is there any way to fix a corrupted relay log
the record
last changed.
Any ideas would be very helpful.
Thank You
Jeff Cook
Network Administrator
Whatcom Educational Credit Union
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
feel it's a neat way to solve it.
Thanks in advance
Regards
Daniel Ek
--
Jeff Mathis, Ph.D. 505-955-1434
The Prediction Company [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6http://www.predict.com
Santa Fe, NM 87505
--
MySQL General Mailing
this is just my $0.02, but I would think $500/yr is certainly worth it.
you'll get a fully supported product, and the money goes to a good cause.
jeff
Kevin Williams wrote:
All,
I have a database where the tables are InnoDB. I am working on the
backup procedure, and would like to implement
id?
If you mean, can you have the insert statement itself return the ID,
no. Insert statements don't return records.
--
Jeff Mathis, Ph.D. 505-955-1434
The Prediction Company [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6http://www.predict.com
the table?
Thanks for the help!
Jeff
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 9:35 PM
To: Steve Edberg
Cc: Jeff McKeon; [EMAIL PROTECTED]
Subject: Re: Does Dropping a table affect it's indexes?
Steve Edberg wrote:
It's my
sorry, I don't know that one. Never have used any version of mysql lower
than 4.04. a suggestion might be to call your 4.0 column an unsigned
bigint, or if possible an unsigned int if the numbers can fit in 32
bits. unsigned means its always positive.
jeff
ps. you may want top reply all so
, then re-create it with the new data pull, will I need to
re-create the indexes as well?
Is there any performance cost/benefit to simply deleting all data from
the table and then re-populating it as opposed to droping and
re-creating it?
Thanks,
Jeff
--
MySQL General Mailing List
For list
yes it does. we use a bigint(20) for example.
[EMAIL PROTECTED] wrote:
Hi,
I would like to know whether MySql 4.0 supports bigint. If not what
is the corresponding data type that I ccould use if I am imoprting
tables from MySql 3.2 to MySql 4.0
Thanks,
Sharath
--
Jeff Mathis, Ph.D
that is not allowing you to see the file?
what user runs mysqld?
there must be an example of a my.cnf file somewhere on the mysql
website. grab it, set up innodb data files, and if you want, log files.
good luck
jeff
Rhino wrote:
I tried adding that space after the closing parenthesis in both Create Table
qualified to give you an answer.
also, you may want to reply all -- you seem to be sending mail to me
specifically. no doubt the rest of the list may want to comment.
jeff
Rhino wrote:
By it (in your first sentence), I assume you mean InnoDB as opposed to
MySQL. We've been using MySQL without
here it is:
http://www.mysql.com/news/article-111.html
its also all over the mysql reference manual, especially in the InnoDB
tables section.
Rhino wrote:
- Original Message -
From: Jeff Mathis [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Monday
have to move the cat.
--
Jeff Mathis, Ph.D. 505-955-1434
The Prediction Company [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6http://www.predict.com
Santa Fe, NM 87505
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
is technically an integer for mysql versions 4.1, but your API
call may need to be changed nevertheless.
my experience has always been to fix the problem right rather than do a
hork, even if it means down time.
jeff
Craig Jackson wrote:
On Thu, 2004-02-12 at 11:47, Keith C. Ivey wrote:
Craig Jackson
to do...
jeff
Lawrence Smith wrote:
I have recently dropped a database with a big innodb
table in it - but the data file (ibdata1) failed to
get smaller. It's pretty big (nearly 2GB) and I'd like
to
reduce it if possible. Is there any way to do this?
Thx
'SHOW SLAVE
STATUS' on this slave.
Skip_counter: 0
Exec_master_log_pos: 723207989
Relay_log_space: 14059362
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained in this communication is confidential. It
is intended
-ppassword database C:\file.sql
Is there possible something in my ini that is limiting the size of input file?
thanks in advance,
Jeff Surcess
[EMAIL PROTECTED]
Mobile: 0414 887 100
up for DB01_rep1.
Is replication System dependant or database dependant?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Tobias Asplund [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 11:21 AM
To: Jeff McKeon
Cc: [EMAIL PROTECTED]
Subject: Re: Replication Question
On Mon, 22 Dec 2003, Jeff McKeon wrote:
Is it possible to have 2 database on one server
Acme_Europe
What I now need to do is create an update statement that will match the
customer to the company by substring(Customer.ID,1,4) to Company.ID
I tried:
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained
set Company_ID=Company.ID where
substring(Company_ID,1,4) like Company.ID;
But it didn't work. Any suggestions?
Thanks for the help,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I should mention this anomaly in case it applies to your
situation, somehow.
--
-- Jeff -- http://www.wellnow.com
There's nothing left in the world to prove. All that's worth doing
is to love one another, using whatever means are available to serve.
--
MySQL General Mailing List
not written to the tables on disk, but still could be
written to those tables now...?
Thanks kindly,
--
-- Jeff -- http://www.wellnow.com
There's nothing left in the world to prove. All that's worth doing
is to love one another, using whatever means are available to serve.
--
MySQL
On Sat, Dec 13, 2003 at 06:39:08PM -0500, Jeff Gordon wrote:
24 hours ago I did a 'mysqlhotcopy' of a working database, then
inadverntently did an 'rsync' copy of that copy, _over_ the working
database tables.
Today, mysql is saying Can't read dir ./thedatabase/' when I start up
I'm trying to search a table for duplicate entries.
A record is a dup if fields Fee, Fie, Foe are equal in two records.
Would this query be correct to search the table for duplicates?
Select Fee,Fie,Foe
From TableFoo
Group by Fee,Fie,Foe
Having Count(*) 1;
Thanks,
Jeff
--
MySQL General
Hello Greg,
I think mySQL would work great for this application. Using PHP would
be another language to keep in mind when developing your project, but
it seems like it should be well within the capablities of mySQL.
Jeff Homan
JCS Web Hosting
http://www.jcswebhosting.com
On Tue, 9 Dec 2003 14
be
prevented from accessing tables for reads and writes while the
mysqlcheck process is running or will they simply suffer a performance
hit?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is slightly different or something and it causes
problems. Does anyone have any suggestions?
Jeff
maybe one more particle of information is that enums are actually
strings, not numbers, so you may have to do a conversion somewhere. this
is a pain for us, so we use tiny ints.
jeff
Mike [tmw] wrote:
I always gone with ENUMs b/c TINYINT(1) still allows you to insert a '2'
into the field
| 1 | 0.51
|
| 120 || test-decreasing | 0 | 3.003e-05 | 0 | 0.51
|
+-++-+---+---++-
-+
Why is this?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I understand how to use the Order By clause on a select, I'm trying to
better understand why does this happen on the insert.
Jeff
-Original Message-
From: Dan Wilterding [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 11:39 AM
To: [EMAIL PROTECTED]
Subject: Re: Strange
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm running mysql on a redhat system starting it from a script in
/etc/init.d/ as is the default with the rpm install. I can't seem to
set the timezone environmental variable to change nomatter what I put in
the /etc/my.cnf file.
Can anyone help me with this?
Jeff
-Original Message
using Innodb Tables but I Like to run this database without
creating any logfiles.
Is there a way that Mysql doesn't create any logfiles at all . I can
recover from a master system so this database can or is allowed to loose
the data
--
Jeff Mathis, Ph.D. 505-955-1434
doing something else wrong
here. How can I get it to display correctly when returned by a query?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RemoteStation.Name not like 'zz%' and CopyOf = '0'' at li
Is this a known bug or a setting I have wrong somehwere?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes there was a syntax error. I used an and instead of in the
where clause.
However, my concern is that the error message was truncated.
Jeff
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:53 AM
To: Jeff McKeon; [EMAIL
using
is 3.23.
Jeff Sawatzky
[EMAIL PROTECTED]
416-250-9111 x253
1-800-525-2568
Ontario Service Safety Alliance
4950 Yonge Street Suite 1500
Toronto, Ontario, Canada
M2N 6K1
Is there a way to abort a query after it's running?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is is possible to do a select query with a left join from a real table
to a temporary table? I'm trying it but keep getting unkown table
'tablename' in field list error.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
that mysql does not have, in particular DBA-specific tables, views, and
triggers, but you may not need these features.
happy to give you more information if you need it.
jeff
KEVIN ZEMBOWER wrote:
Nestor, thanks for your question.
The platform will actually be dictated by the SQL engine
PROTECTED]
http://www.ivritype.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Jeff Mathis, Ph.D. 505-955-1434
The Prediction Company [EMAIL PROTECTED]
525
I know I can issue show tables to give me a list of
tables from the
current database, how can I do the same thing with
temporary tables?
That is, is there a command to list the current temporary tables?
You can't.
RATS!!!
Jeff
-Original Message-
From: Egor Egorov
I know I can issue show tables to give me a list of tables from the
current database, how can I do the same thing with temporary tables?
That is, is there a command to list the current temporary tables?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Looking for an open source or commercial tool to help with database
visualization for a presentation we are to give. Can't seem to find a
simple way to generate a nice poster of our database design.
Any suggestions?
Thanks.
--
MySQL General Mailing List
For list archives:
It reads a MySQL database and will even form relationships based on
matching column names. Totally cool.
Thanks, Victor.
On Tuesday, October 21, 2003, at 09:13 AM, Victor Pendleton wrote:
Have you tried datanamic.com?
-Original Message-
From: Jeff Weeks [mailto:[EMAIL PROTECTED]
Sent
? (besides
translating all characters to LOWER which is IMHO no elegant solution).
TIA
Thomas Spahni
---
Listserv only address.
Jeff Shapiro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2002, 02, $25.00, $50.00, $10.00
2002, 03, $10.00, $25.00, $40.00
Etc..
Can this be done with a single query???
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
|
| row | blah | blew |
Jeff
-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:40 AM
To: Jeff McKeon
Cc: [EMAIL PROTECTED]
Subject: Re: Challenging query
I think the closest you can get is something like
|
| 2 | blah | blew |
| 3 | blah | blew |
| 4 | blah | blew |
+---+---+---+
Thanks,
Jeff
-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:40 AM
To: Jeff McKeon
be using PHP, but I'm a little fuzzy on
the logic you've set. What are aliased tables and how would I define,
use them in an loop?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
with a
minimal SQL
query and minimal application code.
Jeff
-Original Message-
From: Gabriel Ricard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 1:47 PM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: Re: Challenging query
Or you could just do one simply query
=mysql_fetch_row($data)) {
$revenues[ $query_data[0] ][ $query_data[1] ][ $query_data[2] ]
= $result['Revenue'];
}
Then I just need to retrieve the data out of the multi-dimensional array
and display it or write it to a file?
Jeff
-Original Message-
From: Gabriel Ricard [mailto
tables
and output's them in the correct order. Is this possible?
I'm outputing this data to PHP web page.
I know in ver 4.x there is table called a merge table for this type of
thing but we're stuck with 3.23 for now.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
I'm
merging or can I just grab the ones I want?
Jeff
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 10:54 AM
To: Rory McKinley; Jeff McKeon; [EMAIL PROTECTED]
Subject: Re: Data from two tables in one query
Two points about
'\c' to clear the buffer.
mysql show columns from SuperMailbox;
ERROR 1016: Can't open file: 'SuperMailbox.MRG'. (errno: 143)
[snip]
Any ideas what I've screwed up now?
Thanks,
Jeff
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 11:19
int(11), LLPages int(11), ExternalSerial text,
GPS tinytext, Price Double, User_ID int(11),Pay_ID int(11),
Tarif_ID int(11), CopyOf int(11), ShipID int(11), key(ID)) Type=MERGE
UNION=(Mailbox_Old,Mailbox);
Jeff
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday
Never mind,
I used the show create table Mailbox results as my create table
supermailbox query and it worked.
Thanks
Jeff
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 11:59 AM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: RE
I have two columns in a table, both timestamp(14). The first one holds
a start date and the second one holds an end date. Is there any built
in mysql function to subtrack timestamp1 from timestamp2 and get the
elapsed time between?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives
Put the full path to mysql in the script...
Jeff
-Original Message-
From: Mike Tuller [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 1:07 PM
To: [EMAIL PROTECTED]
Subject: Shell Script to Insert Data
I am trying to create a script that will insert data. Right
now
the command
./query Select_all.sql
This outputs the results to the standard out.
You could also
./query Select_all.sql /tmp/some_output_file
Hope this helps.
Jeff
-Original Message-
From: Mike Tuller [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 1:07 PM
To: [EMAIL
database features.
Any help is appreciated.
Gregory Hicks
Database Analyst Programmer
---
Listserv only address.
Jeff Shapiro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
very much for any help...
Jeff Neuenschwander
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable= key_buffer=350M
set-variable= max_allowed_packet=1M
set-variable= table_cache=256
set-variable= sort_buffer=4M
set-variable
301 - 400 of 828 matches
Mail list logo