On Fri, 19 Jan 2018 11:25:42 -0500, shawn l.green wrote:
> Hello Chris,
>
> On 1/19/2018 12:50 AM, Chris Roy-Smith wrote:
>> Hi I am running mysql 5.7.20 in ubuntu linux 17.10
>>
>> I have 2 tables, member and status with contents like
>>
>> member:
>&
selected year.
select details.ident, given, surname from details left join status on
details.ident = status.ident where NOT EXISTS (select year from status
where (status.year = 2018) and (details.ident = status.ident) )
Thank you for looking at this.
regards, Chris Roy-Smith
--
MySQL General
om tl_clients AS c) AS dt
WHERE twoyear >= 2 AND halfyear == 0;
I have not run it through MySQL, so you may have to fix the syntax a bit...
Thanks,
Roy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi Shawn,
On 19.10.15 22.33, shawn l.green wrote:
On 10/19/2015 3:48 PM, Roy Lyseng wrote:
Hi Ben,
On 19.10.15 16.07, Ben Clewett wrote:
Hi Roy,
Thanks for the clear explanation.
I guess (hypothetically) the optimizer could see if it has a key, and
then use
two starts: one on 'a >
Hi Ben,
On 19.10.15 16.07, Ben Clewett wrote:
Hi Roy,
Thanks for the clear explanation.
I guess (hypothetically) the optimizer could see if it has a key, and then use
two starts: one on 'a > 0' and one on 'a < 0', taking a union of the result?
Which might ma
ually interpreted as
SELECT * FROM t WHERE a <> 0;
The optimizer is not able to see that "a <> 0" means "a = 1", and hence no index
will be used.
Thanks,
Roy
Thanks,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql
mizer detected that is constant, so it will be evaluated
once and cached for subsequent uses.
Thanks,
Roy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi Jennifer,
great that it worked.
Try replacing the line
`ip` IN (temp_ip)
with
`ip` IN (SELECT ip FROM temp_ip)
Each subquery needs to be a complete SELECT query.
Thanks,
Roy
On 17.02.14 21:11, Jennifer wrote:
On Feb 17, 2014, at 10:17 AM, Roy Lyseng wrote:
please try filtering
(*) > 1
)
I think this will be more performant on version 5.6, though. If this is too
slow, you may try materializing the subquery in a temporary table and use that
table instead of the subquery.
Thanks,
Roy
On 17.02.14 17:42, Jennifer wrote:
On Feb 12, 2014, at 6:30 PM, Larry Mart
-30, subtracting 6
months gives 2011-03-30.
My best recommendation is "don't do it".
Hope this helps,
Roy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
COUNT function).
Thanks,
Roy
On 17.03.11 18.00, LAMP wrote:
Yes, that was my question. Though, since English is not my first language, let
me try to post it again:
There is a list of all orgs and items org bough, from table called orders
item_id org_id
34 2607
34 2607
34 1520
36 2607
36 1520
36
Hi zhongtao,
thank you for reporting this bug. It has been filed as
http://bugs.mysql.com/bug.php?id=60279
Regards,
Roy
On 24.02.11 08.08, tanzhongt wrote:
create table t1(a int);
create table t2(b int);
PREPAREstmt FROM "select sum(b) from t2 group by b having b in (select b
t a fraction follows."
I think we should consider these alternatives now:
1. Deprecate use of '.' as a substitute for standard
punctuation characters. The other "relaxed form" stuff
can remain. The manual should say "don't use '.' etc.".
Peter>
Hello.
i am using Redhat EL3 linux. and mysql version is 3.23.49a-Max
but sometime will shutdown suddenly. when i read the mysql log file
have found as below.
please help me.. tks
Roy
InnoDB: Assertion failure in thread 143396 in file mem0pool.c line 345
InnoDB: We intentionally generate a
i am getting the error somthing like that
GET ERROR(127) TABLE HANDLER PROBLEM
i am sorry that i coulde not take mysqlbug script
thanks
ajay,hyderabad,india
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http
Hey folks,
Anyone know a Unix monitoring (text-based) software to check in realtime
the usage of a MySQL server? Like nmon, topas, top or something like
that but for MySQL except mytop?
Thanks
--
Sébastien Roy
Administrateur de Systèmes Senior / Senior System Administrator
PointPub
= 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
--
**
*Sébastien Roy*
Administrateur de Systèmes Senior / Senior System Administrator
**
*PointPub Communi
;s
running under AIX 5.3 under a 64bit Kernel/Machine with 4 Gig of RAM and
12 CPU. All the database are in use by web applications using PHP or Java
Thanks in advance.
--
Sébastien Roy
Administrateur de Systèmes Senior / Senior System Administrator
PointPub Communications. - Laval, Canada
(514
Can someone please tell me what the command would look like to grant access
for the root user to a database and table on a remote host.
Thanks in advance
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 27 October 2005 23:12
To: mysql@lists.mysql.com
Subject: Re: S
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: 25 October 2005 18:06
To: Alastair Roy
Cc: mysql@lists.mysql.com
Subject: Re: PHP and mysql
Yes.
Whenever you have a problem, go back to basics. Can you login as root
on the commandline? What password do you use there? Once you're
there, ch
Greetings everyone, I am having a problem with PHP and mysql I have copied a
script exactly off a website to open the database and insert a new user I
try to access the mysql database using the root user, and enter information
into the user table, this is the PHP I am using
When I try this
Should have specified - all parts will have the same
tolerance numbers. Thanks for the quick, informative,
responses. I'll give them a whirl.
Roy
On Tue, 2005-10-04 at 15:59, Becla, Jacek wrote:
> Yes, agreed. The case you mentioned about missing tolerance is
> not in his example
10
How do I set up a query whose output would
look like this:
Tolerance PartA PartB PartC
1 10 12 6
2 11 14 7
3 13 16 7
4 15 16 8
5 18 17 10
Thanks,
Roy
ng Fedora Linux 2.6.6-1.435 and
mysql server 4.0.20-standard.
Thanks,
Roy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can a child table have multiple foreign key references linking
its records to two or more parent tables?
Can a parent table also be a child table? That is, can a parent
table have a foreign key that links it to another table?
I setting up my tables as INNODB types.
Thanks,
Roy Harrell
r any advice.
Sincerely,
Roy Harrell
Adaptive Equipment
2512 NE 1st Blvd #400
Gainesville, FL 32609
352.372.7821
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
All I want is to just use mysql as the backend for my application. I don't
want to implement any features from mysql. So basically, I just want the
list of files necessary to use it as a data store.
~roy~
-Original Message-
From: Reggie Burnett [mailto:[EMAIL PROTECTED]
Sent: Wedn
will be using
the package & deployment feature in VB.NET to create the installer.
In the meantime, I will check out the command line help to see if I can find
to command to install mysql as a service, and probably grant user access as
well.
Thanks,
~roy.
-Original Message-
From: Reggi
Also, I will need to know how to start mysql as a service, setup users &
password, all through the installation package. I would appreciate any help
that anyone can provide.
Sincerely,
Roy.
reasons.
Thanks!
Roy
enchmarks, you'll probably
want to perform reboots (at a minimum) between tests to bypass caching
effects - unless that's what you're trying to test. :) I'd be
interested in hearing what you discover.
Roy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ts in main
memory: not the sort of thing you want after a crash... If you have the
time/interest, why not try some benchmarks of your own?
Roy
--
Date: Wed, 12 May 2004 00:22:21 +0200
To: [EMAIL PROTECTED]
From: JFL <[EMAIL PROTECTED]>
Subject: fastest file
for errors (netstat -e on W2K) and approach it from that
angle; verifying proper speed/duplex configuration between your hosts
and networking equipment.
As a last resort, you can look through your OS (eventvwr on W2K) and/or
MySQL's log files for indications of the problem.
Good luck,
Roy
-
I've got a bunch of files which contain packed fixed-field-width
records. The records are pretty long; depending on the file, as long
as 1000 characters and 10's of fields. Fields are a mix of numeric and
alphanumeric types.
What's the best way to load these into mysql? Mysqlimport looks lik
On Friday, September 12, 2003, at 10:24 PM, Paul DuBois wrote:
FILE is a global privilege (it's recorded only in the user table)
and must be granted at that level:
GRANT FILE ON *.* TO 'roy'@'localhost';
Ah. That makes sense. Thanks.
I'm not sure why you&#
denied for user: '[EMAIL PROTECTED]' (Using password: NO)
mysql>
I tried to do a "grant file", but get a "wrong usage" error:
[EMAIL PROTECTED] schema]$ mysql -u root -p -s
Enter password:
mysql> grant file on netscore.* to roy;
ERROR 1221: Wrong usage of DB GRANT
Can't use 'ORDER BY desc limit 1' since that will only give me 1 entry.
Anything else I can try? There has to be a way to get all the counts
from table2 which have the newest timestamp for each id in the table!
Please help!
Roy
-Original Message-
From: Michael Iatauro [ma
ow to do it 4.1! Please! :)
Roy
-Original Message-
From: Rudy Metzger [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 3:49 AM
To: Roy Walker; [EMAIL PROTECTED]
Subject: RE: Complex select statement
I never heard before that you can use a select statement in an arithmetic expression.
Onl
FROM table2
WHERE id.table_tmp=id.table2 AND WHERE MAX(timestamp.table2));
INSERT INTO table2 (id,count,period_count,date,timestamp) SELECT
id,count,period_count,date,timestamp FROM table_tmp;
DROP TABLE table_tmp;
I get an error on the UPDATE command.
Any ideas?
Thanx,
Roy
-Original Messa
for the 'SELECT count FROM table2 WHERE id=id1' section.
Is this illegal syntax? Would this be considered a subselect?
Thanx,
Roy
-Original Message-
From: "Paracková Eva, Ing" [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 12:30 AM
To: Roy Walker
Subject
period_count, date='TO_DAYS(NOW() -1)';
Sorry if this is easy, but I could not find an example of any mathematic functions
while doing an INSERT ... SELECT.
Thanx,
Roy
Is there a simple MySQL command that will give a Row Count (# of records)
WITHOUT running a select (huge database)
Thanks!
Roy
I had a problem using mysql-max stable versin running
on redhat linux 7.1. The data has been lost every
other day it will come back again. What should I do?
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
---
Hello,
Is there, in MySQL 4.0 database tables, a pseudo column ROWID (containing a
unique id for each row of the tables), like in Oracle or Informix databases ?
If not, will this feature be in MySQL 4.1 ?
Regards
A. ROY
Hello !
Is there, in MySQL 4.0 database tables, a pseudo column ROWID (containing a
unique id for each row of the tables), like in Oracle or Informix databases ?
If not, will this feature be in MySQL 4.1 ?
Regards
A. ROY
php command script to do an
http insert into the database (the security on this method could be of
concern).
Any feedback would be GREATLY appreciated. If anyone has any experience
importing command-line output into a remote MySQL database please elaborate.
Thanx
Roy
Did you find the solution ?
-Message d'origine-
De : Bruce Stewart [mailto:[EMAIL PROTECTED]]
Envoyé : 20 août, 2001 11:41
À : 'Roy, Steeve'; [EMAIL PROTECTED]
Objet : RE: MySQL OLEDB
Steeve,
I have had the same problem for months, with no solutions.
If you find a solut
Hello, I us emysql oledb driver to connect on my database. When I use that localy on
the computer where mysql run, I can connect correctly on any of my database. When I
try from another computer (where I have installed the MySQL oledb driver) I get this
message. Why ?
Test connection
tions?
Thanks
Roy
ld mention setting that in mysql.server as well as setting the
basedir.
Thanks,
-Jonathan
---
Jonathan Roy - [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
from beheerder wherer naam like '%naam%'
Can this be done with SQL language?
thank you,
Roy
t; without responses?
It is basically, how many unique GroupIdentifiers with LogType 1 exist,
which do not have any equivalent LogType 2 entries...
the table is:
Name: UniqueLog
Fields: LogType
GroupIdentifier
(Theere are others but these are the ones concerned)..
Thanks for any/all help!
Che
e
optimization flags recommended in the manual for gcc 2.95 on an Intel
machine.
-Jonathan
---
Jonathan Roy - [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
Hello MySQL fanatics,
My problem is the following:
I want to store a filelink in a table, but when I insert values into a column of type
varchar MySQL kills the slashes in the path.
EG
when i've created the following table:
create table pictures (
picturelinkvarchar(80) not null
);
insert
I think I got it working...
thanks!
I had a few pretty complex queries, so it took a little while to understand,
and then convert all of them! :)
> -Original Message-
> From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 28, 2001 8:56 PM
> To: Roy Na
-Original Message-
> From: nigel wood [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 28, 2001 8:16 PM
> To: Roy Nasser
> Subject: Re: Is it possible to use an "optional field"?
>
>
> On Wed, 28 Mar 2001, you wrote:
> > Hi,
> >
> > I ha
... (Reply All)... Thanks! :)
Roy Nasser
CTO
Vem Cá Servicos de Internet S/C Ltda.
Av. Paulista 2421 14* Andar
São Paulo SP Brasil
55 11 3347 3456 / 9953 8853 - cel
www.jarbas.com.br
[EMAIL PROTECTED]
-
Before posting, please
ight.
Thanks in advance for helping me.
(please respond directly to [EMAIL PROTECTED] if possible)
--
Jeff Roy
Webmaster
The Sailing Company/
Cruising World & Sailing World
http://www.cruisingworld.com
http://www.sailingworld.com
mailto:[EMAIL PROTECTED]
(401)
Hello, I'm testing MYSQL client with MSWIN2K adv. server and I wonder how the edit
table function works.
Hello, I wondered if MySQL is capable of being accesed by an ASP script?
tnx!
='in000501');
the error message is 1064 syntax error in the nested
sql query
hope you would help,
Regards,
Anirban Roy
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions
thout any further problem. Considering
mit-pthreads will never want to use an OS ALIGN() instead of it's own,
perhaps add this #undef to the distribution, or add it conditional on
detecting OpenBSD.
Thanks,
-Jonathan
---
J
62 matches
Mail list logo
