Having gotten TONS of such, I've unsbuscribed twice in vain so far.
Jeremy Zawodny wrote:
>
> I'm getting duplicate messages separated by several hours. Am I alone
> in this, or are others seeing it too?
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
The list seems having some problems. I've rereceived many emails, like
this one, which were sent via the list last week!!
Anyone else has the same problem?
Trond Eivind Glomsrød wrote:
>
> "Vernon A Webb" <[EMAIL PROTECTED]> writes:
>
> > Anyone know the difference between MySQL and PostgreSQL
When you are told to fill in fuel and turn the key to drive, I suppose
you don't care how the fuel runs the car. Do the same things in any lib
you use, pushing the "buttons" in told order would work. Well, you may
dig deeper if you like since the code is available.
Alex Shi wrote:
>
> Yesterday
select a.* from a left join b on a.id = b.id
where b.id is null;
Ken Kinder wrote:
>
> Is there a way I can filter OUT records referenced in another table?
>
> With Subselects it would be this, but I'm using 3.23:
>
> select
> a.*
> from
> a
> where
> a.id not in (select id from b)
>
Michael Brunson wrote:
>
> On Fri, 04 Jan 2002 00:58:19 +0200, "P.Agenbag"
> <[EMAIL PROTECTED]> wrote:
>
> | Hi
> | I have two tables, one contains a persons name and an ID number. The
> | other table contains the ID number and another field. Is there a way of
> | moving this collumn to the fir
Henning Sprang wrote:
>
> Am 21 Dec 2001 15:57:13 +0100 schrieb Carsten H. Pedersen:
> >
> > > I would like to know if there is a possibility to get all allowed
> values
> > > of an enum field out of the database.
> > >
> > > I know there are methods to get the field type and those give me back
>
Jinghua Tang wrote:
>
> It is a newbie question. I am wondering if there is a way to write
> out a table in plain text form. Thank you in advance!
select [select_options] select_list
[into outfile 'file_name' export_options]
[from tbl_list]
[where where_expr]
[g
Etienne Marcotte wrote:
>
> maybe you can add a small value to be sure it rounds up.
>
> select round(9.065+.001,2);
The rounding in 1 on odd and 0 on even is dealing only 5, to make the
round more accurate or even, as you mentioned. 6-9 always round in 1
while 1-4 always round in 0.
select ro
The rounding rule I learnt many years ago said, rounding in 1 if
previous digit is odd but discarding it if even.
so 9.065 -> 9.06, 9.055 -> 9,06, ...
Attila Soki wrote:
>
> hi,
>
> is this bug already in buglist, maybe in newer verisons of mysql is already
> corrected?
> if yes then please le
Jens Vonderheide wrote:
>
> > Message From To
> >
> > Exampel 1 2
> >
> > UserID UserName
> >1 Me
> >2 You
> >
> > Message From To
> > ExampelMe You
>
> SELECT
> u.Message, u1.UserName AS From, u2.UserName AS To
> FROM
> Messages AS m,
>
select t1.name, t2.name from messages left join Users as t1 on
mesagges.From = t1.UserID left join Users as t2 on messages.To =
t2.UserID;
Jonas Jonsson wrote:
>
> Hi
>
> I have a table named Messages
> It looks like this
>
> Message From To
>
> Exampel 1 2
>
> And I also
Error code 13: Permission denied
Venu Allavatam wrote:
>
> Hello All:
> I am working on a particular database, which I created
> some days ago in mysql ver. 3.23.36. I am quite sure
> that I have not made any changes to the system (Dell
> WS with Red Hat Linux 7.1) either. What I see is
> this
"Mike(mickalo)Blezien" wrote:
>
> On Tue, 20 Nov 2001 10:14:52 +0100, Giuseppe Maxia <[EMAIL PROTECTED]> wrote:
>
> >>You can export using
> >>SELECT fieldlist INTO OUTFILE "filename" FROM table;
> >>
> >>This will create a file with tab separated fields. It is Excel default separator.
> >>Wit
Benjamin Pflugmann wrote:
>
> Hi.
>
> On Fri, Nov 09, 2001 at 08:21:34AM -0500, [EMAIL PROTECTED] wrote:
> > Years ago I worked on an RDBMS that had a feature to allow execution of
> > 'sections' of a command file, avoiding others. I am still ign scanning the
> > docs, but have not found anythi
Should not reply to such non-existing guy/email ... But how can one know
before he/she puts time in?
Original Message
Subject: Returned mail: see transcript for details
Date: Fri, 27 Jul 2001 14:43:29 -0500 (CDT)
From: Mail Delivery Subsystem <[EMAIL PROTECTED]>
To: <[EMAIL PROT
SixK wrote:
>
> Hello ,
>
> here is a strange result I obtain,
> could someone tell me if it's a bug or if my request is wrong
>
> I'd like to obtain the number of times the word 'liste' is found in
> column page and the number of times the word 'piece' is found, all in
> a single request...
>
Well, it's a feature not a bug, and you are right too. auto_increment
remembers the last value and keeps increasing it, no matter how many
"holes" are created. So when use it, better to create a status column to
change flag as deleted other than real delete it.
"William N. Zanatta" wrote:
>
>
did everyone on the list get those spam emails? I got 6 too, within 15
minutes, at 5am my local time. And I don't remember sending anything at
that time, I was sleeping :)
Sinisa Milivojevic wrote:
>
> Justin Farnsworth writes:
> > [EMAIL PROTECTED] wrote:
> > >
> > > Your message cannot be post
where date like '2001-07%' ... would find all 2001-07-??.
[EMAIL PROTECTED] wrote:
>
> Hello,
>
> I am still a beginner, but I am trying to learn MySQL. If you have a
> date field, and you are using the date field in your where clause, I
> understand how to use :
> WHERE date="-mm-dd";
Don't know your "where", but you probably want to something like ...
select USERS.name as name1, USERS.user_id as id1, USERS.name as name2,
USERS.user_id as id2 ...
where id1 = USERLIST.user_id and id2 = STUDENTLIST.user_id ...
4 tables join?
Mike Sosteric wrote:
>
> >
>
> Thanks Dibo but I d
Should people without a clean mouth or hands be expelled from the list?
A mouse (or anykind) shit can ruin a whole dinner!
Kris Amy wrote:
>
> Maybe it's about time you stopped being a fuckwit and read the whole message
> dip shit.
>
> file://Kris
>
> -Original Message-
> From: Gerald
Mike Sosteric wrote:
>
> Hi all
>
> I' wondering if someone can help me out here.
>
> I need to do a three table join. Normally not a problem but in this case I have to
>select usernames from a users table twice. One for each of two other tables. I'll
>need to use a user_id (int) to do the se
No, MySQL does not support subquery so you need work around (not use)
it, by creating temp tbl and/or join etc. Think it a diff. SQL style.
Yan Zhang wrote:
>
> Please help me here, and let me know if MySQL can do it or not. All people
> around me told it should work in SyBASE.
>
> Yan Zhang
>
You must have 8001 - 1 - 2788 NULLs for kword_10. Please confirm it.
Jakub Wasielewski wrote:
>
> Hello!
>
> Could somebody explain me why it's like that:
>
> mysql> select count(*) from docs where kword_10 LIKE '%Ukraina%';
> +--+
> | count(*) |
> +--+
> |1 |
> +-
use 'select/insert/... db1.tbl2.fields3, ... db2.tbl3.fld4 from
db1.tbl2, db2.tbl3 ... ' etc. in your query.
"Andrey F. Mindubaev" wrote:
>
> Hi,
>
> How to create query to get data from tables of two different databases ?
>
> Best regards, Andrey
> [EMAIL PROTECTED]
>
> -
Remi Catherinot wrote:
>
> >Description:
>I have a table that stores only dates, no other fields. Whenever the date value
>is set to '0001-06-01', even if the row appears in my SELECT queries, no UPDATE,
>DELETE or REPLACE can alter that row.
>I've tested it with other date as well, lik
use 'mysql -h server_machine -u user_name -p ' to connect/query your
MySQL server. You don't need telnet.
sanborn wrote:
>
> Thanks for your many answers. (mysql port default = 3306) . I can't seem
> to telnet to port 3306 however, I get a message saying '... not allowed to
> connect to t
Manuel Dugué wrote:
>
> Hi,
> I created some Scripts of the Type *.sql. In these Scripts there are pure
> SQL Statements, seperated by a ';'. How can I execute those Scripts
> (automated) in mySQL?
mysql -u ... -p.. -h ... < scr1.sql
etc.
> Is there a possibility to make one Script, that start
Boryniec Adam wrote:
>
> Hello,
>
> I have a following problem:
> I created two simple tables and a query that uses both of
> them. This works perfectly. See the example below.
> The question is: is the same query possible when the two
> tables are located in diffrent databases.
> What I mean: I
Yes, his "MySQL" is the very good book I've been using.
It's copyright 2000, first printed December 1999. Is there an updated
one? You know MySQL is changing everyday :>) so the one I have is 1.5
years behind.
Dibo
Scott Baker wrote:
>
> I always recommend Paul DuBois' book. It's the best MyS
try:
select s3.name from staff s1, staff s2, staff s3
where s1.id = 1 and s1.reportsto = s2.id and s2.reportsto = s3.id
"Graeme B. Davis" wrote:
>
> I have a staff database which contains a column that has a "reports to"
> field.
>
> If I have a table like this:
>
> IDNameReports To
>
try SELECT * WHERE x like '3411'.
Steve Sobol wrote:
>
> I have a varchar field that contains the street number (part of a
> mailing address). It's a varchar because the field may occasionally
> contain non-numeric characters, but normally it doesn't.
>
> Let's call the field "x".
>
> I have a
32 matches
Mail list logo