Paul
Sorry to be a pain. I'm not sure that I understand
Select an extra column in each SELECT. SELECT member, ... UNION
SELECT non-member, ...
Regards
John Berman
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 03:11
To: [EMAIL PROTECTED]
Cc:
Ryan A wrote:
/**
Somewhat new myself but I believe you can do something like SELECT
(whatever you need) FROM tbl_users WHERE (UNIX_TIMESTAMP(now()) -
($days_last*24*60*60)) UNIX_TIMESTAMP(dat_and_tim).
I will add the the PHP Cookbook and the MySQL Cookbook are godsends and
that's where
Thanks to anyone who was looking at this question. I have resolved the issue myself.
During a prior MySql installation (earlier version) I moved the LibMysql.dll to the
WINNT/system32 directory so that it was available throughout the system. After
upgrading to a newer version of MySql, all of
I hope you don't mind me butting in but your note was sent to the whole
group
The technique Paul is describing involves adding another expression to each
of the SELECT clauses in the UNION. Up to now, you've probably just used
column names or functions in a SELECT clause, for example:
select
Just to be sure that this question is not supressed here :)
Recently I've come around that mysql (4.1.0 at least) treats different
queries containing non-english characters (in my case characters from
cp1251 charset) as the same query and therefore returns wrong results.
For example the following
Hi,
I am currently experiencing a few problems getting mysql to run on my PC. I
have a windows XP machine P4 2.6 GHZ. I have downloaded the version mysql
4.0.15 from mysql.com and am struggling to get the program to work. I have follwed
the instructions listed in a book i purchased called
Rhino
This is great it works a treat
Thanks
Regards
John Berman
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: 29 February 2004 13:40
To: [EMAIL PROTECTED]; 'Paul DuBois'
Cc: [EMAIL PROTECTED]
Subject: Re: Query Help
I hope you don't mind me butting in but your note
Hi,
What can I do to find the cause / correct the following problem?
More often I get the following with Connector/J:
error com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
I'd like to add an alternate solution. All these subselects and unions
seem overly complicated to me, when you could accomplish the same thing
with a single join. Also, union requires mysql 4.0.x or higher and
subselects require mysql 4.1 or higher. (Of course, you are obviously
using 4.1+
Scott Plumlee wrote:
[EMAIL PROTECTED] wrote:
Hi,
(Please note: NEWBIE WARNING, below questions might sound stupid, but
feel free to flame.) ;-)
I have a table tbl_users with a field dat_an_time which is a
timestamp(14).
In that I have values such as:
2004022215
20040227042018
First of all, get rid of Windows and use Linux =)
Secondly, try downloading the newest version 4.0.18-nt from mysql.com. That
will help you out. I run both Windows, Mac, and Linux versions of MySQL and
haven't had any problems with the MySQL installer for any OS.
If you have any other questions,
Two things first, first of all you obviously don't have mysql correctly
installed, message a means mysql dead unexpectedly while trying to
start, mysql cannot start. Why? I just don't know you didn't detailed
your install procedure. Message b means that you cannot connect to the
db because
here is the updated select statement i came with but still needs improvement
SELECT Distinct (a.id)
From table1 a
INNER JOIN table1 b
USING ( p_id )
INNER JOIN table2 c
USING ( p_id )
INNER JOIN table3 d
USING ( out_id )
INNER JOIN table4 e ON ( d.name_id = e.name_id )
INNER JOIN table4 f
Hi All,
I am wondering if anyone can point me to a utility that will let me dump
the
result of a MySQL query to a file I can open in MS Excel or (preferably)
OpenOffice.org Calc.
phpMyAdmin lets you do this if you want to dump a SELECT * FROM
table,
but if I want to fine tune it I cannot (unless
Can you send us a new explain on this version?
Donny
-Original Message-
From: karthik viswanathan [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 29, 2004 4:12 PM
To: [EMAIL PROTECTED]
Subject: Re: optimizing a select statement over a database with 50
million recs
here is the
Hi all,
we have
rh 9.0 (kernel 2.4.20)
mysqld 4.0.15
php 4.3.3
apache 1.3.29
and a quite large (10.000 unique visitors/day) server and messageboard
(phpbb). every 2 or 3 days the server crashes (mysqld crashes, then all
myslqd_safe and httpd processes crashes one after one)
there is no
Thanks for looking at my problem. here is the explain for this version of select
b | ref | id,p_id,combine | combine | 4 | const | 5281 | Using where; Using index;
Using temporary |
c | eq_ref | PRIMARY,p_id | PRIMARY | 4 | b.p_id | 1 | | |
d | ref | name_id,out_id | out_id | 4 | c.out_id |
Hi,
I'm trying to make a connection via ODBC to a remote database.
On my client linux machine I installed unixODBC-2.2.8 and MyODBC-3.51.06.
I'm doing the configuration via ODBCConfig:
Driver properties:
Driver: /usr/local/unixODBC/lib/libmyodbc3.so
Setup:/usr/local/unixODBC/lib/libodbcmyS.so
From looking at this, you have a using temporary, on table b. Which may be
the biggest slow down, it's hard to somewhat tell. I assume you have
indexes on everything... I'm not sure where you are running explain from,
but when I run one it looks like below. You can easily see where problems
At 17:45 -0500 2/29/04, Joshua Beall wrote:
Hi All,
I am wondering if anyone can point me to a utility that will let me dump
the
result of a MySQL query to a file I can open in MS Excel or (preferably)
OpenOffice.org Calc.
phpMyAdmin lets you do this if you want to dump a SELECT * FROM
table,
but
Here is the command line explain, earlier i had used phpAdmin
+-++-+--+-+---
--+--+---+
| table | type | possible_keys | key |
At 9:42 -0500 2/28/04, Ed Leafe wrote:
Hi,
I'm trying to get a particular pattern to match, and a
pattern that works in Python and other languages is not working in
MySQL. I'm using 4.1.0 on RH Linux.
I archive messages from an email list, and we have a standard
that posts to the list that
Can anyboby tell me wheter exists an embeded MySQL server JDBC
implementation ???
Thanks
--
Luis Duran
signature.asc
Description: This is a digitally signed message part
Hi,
if I try a multi table update with a Berkley DB Table, where the updated
table is bigger than the joined table, the system produces the strange Got
error 22 from table handler error. The attached (zipped) script should
demonstrate the problem.
Gru,
Thomas Kathmann
[EMAIL PROTECTED]
So if this is your query and based on the explain this is what I would
recommend.
SELECT Distinct (a.id)
From table1 a
INNER JOIN table1 b
USING ( p_id )
INNER JOIN table2 c
USING ( p_id )
INNER JOIN table3 d
USING ( out_id )
INNER JOIN table4 e ON ( d.name_id = e.name_id )
INNER JOIN table4
MySQL Listers,
The ability to have utf-8 encoded data in my database is
important enough for me that I am considering upgrading to 4.1. I am a
beginner to MySQL, having only used it for not quite a year. My question
is whether or not MySQL 4.1 is stable enough for a beginner to use. On
the
MySQL Listers,
The ability to have utf-8 encoded data in my database is
important enough for me that I am considering upgrading to 4.1. I am a
beginner to MySQL, having only used it for not quite a year. My
question is whether or not MySQL 4.1 is stable enough for a beginner to
use. On
I am using MySQL 5 issuing the following query when the application died on
me three times.
Query: Select name, year_of_birth from players where year_of_birth =
ALL(select year_of_birth from players)
Note: If I only use the first part of the query it runs no problem. I do not
think it is because
Hi!!
No there isn't
Although, you can try bdb(www.sleepycat.com), it comes with a java
access class that will let you use bdb in a embeded environment, one
thing i must say, is that it does not use jdbc, instead it uses it's own
access methods, quite easy btw.
GUYS!, it would be really nice to
I had MySQL running just a couple days ago, but now it is not.
The command and error:
# /usr/local/mysql/support-files/mysql.server start
Can't execute ./bin/mysqld_safe from dir /var/lib
There is mysql directory under /var/lib, but I am not executing from
there. If i go to
I started using 4.1.0 in a production environment 2 weeks after it was
released. Then when 4.1.1 came out I started using it before it was even
posted on the mysql.com website. And I am sure I will do the same with
4.1.2. Is it stable? Yes. Are there bugs? Depends on what you are doing,
but
Hi everyone,
I want to create a table that will consistently have data added and removed
from it. Is there anything I should know/consider before doing this? Any
information you could provide would be GREATLY appreciated.
Thanks,
Paul
Hi,
I'm at the stage where I need to create redundancy in my network / DB
server. Am currently using MySQL 4.0.x, and have been trying to figure out
how I can safely replicate/synchronize between different machines. I know
there is a way to do a Master / Slave replication, but I'm looking more
Hello,
I have been having trouble with rebuilding a database from backup.
The backup consists of the MYD and frm files only. Therefore, I need
to rebuild the myi file. I am using MySQL4.0.14 on Mac OS X. I use the
myisamchk command to rebuild the database, in the following way
On Sun, 29 Feb 2004, Joshua Beall wrote:
I am wondering if anyone can point me to a utility that will let me dump
the
result of a MySQL query to a file I can open in MS Excel or (preferably)
OpenOffice.org Calc.
[...]
But before I spend any time working on doing that, I am wondering if
Yes,
Lets call the two serves A, and B. You set A as the master for B, and you set B as
the master for A. In this way you can insert/delete/update on either side and both
sides will be kept in sync. If you plan to actively use both at the same time you do
need to be weary of some
Really? I didn't know that a single machine could act as both a slave and a
master for the same DB. H This opens a whole new world of
possibilities. Okay - I can understand the issue for autoincrement columns
becoming a problem. UIDs per server would need to be used in that case.
37 matches
Mail list logo