I need help creating a select that returns 4 records that have
contiguous addresses that start on a bit boundary.
If 4 do not exist, I need a return of zero records.
I would like to do this in one statement and I do not have ownership of
this mysql server, so fancy views, temporary tables,
I should have said consecutive addresses, rather than contiguous.
I care about a set of consecutive addresses, and there is no guarantee
of record order.
On 12/17/2015 07:35 AM, John Stile wrote:
> I need help creating a select that returns 4 records that have
> contiguous addresses that
LIMIT 0,1
) AND (@b+3) limit 0,4;
On 12/17/2015 08:14 AM, John Stile wrote:
> I should have said consecutive addresses, rather than contiguous.
> I care about a set of consecutive addresses, and there is no guarantee
> of record order.
>
> On 12/17/2015 07:35 AM, John Stile wro
/tables_priv.frm’
So I went to google, and realised that I’d probably upgraded without running
mysql_upgrade. So I try..
[~] john@server% (872) mysql_upgrade -u root -p mysql
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection
__mysql_exceptions,OperationalError (2003 Can't connect to MySQL server on
'localhost' (10061))
My question: How do I change from localhost to 124.0.0.1?
TIA
John
On Sun, 1/9/13, Terry J Fundak te...@tjsoftworks.com wrote:
Subject: Re: Can't
crystal balls we don't know
what about tell us what software you are speaking about?
Well, I'm using MySQL ;) In my first post, I stated version 5.5 and on Win8/64.
I looked in mysql.config.pl and no localhost :(
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
it from the folder
where that script lives since it's not in the path. Otherwise, it complains it
can't find the script.
TIA,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi;
How do I change my connection from localhost to 127.0.0.1 on a Win8 machine?
TIA,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Well, if you want to get unstuck in time, maybe you need to call Billy
Pilgrim ;-)
Andy Wallace wrote:
We've been having some issues with one of our MySQL servers lately,
and currently
the dang thing is stuck. For at least the last hour, NOW() is
returning the same
value:
mysql select now();
for submitting your preliminary proposal is
this Friday, March 29!
http://mosscon.org/
Spread the word and submit your proposal!
Thanks,
John Hicks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
:) )
Any help would be greatly appreciated.
--
John C. Nichel IV
System Administrator
KegWorks
http://www.kegworks.com
716.362.9212 x160
j...@kegworks.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
-Original Message-
From: Rik Wasmus [mailto:r...@grib.nl]
Sent: Monday, October 01, 2012 10:44 AM
To: mysql@lists.mysql.com
Subject: Re: NOT_REGEXP Query Help
I'm having an issue using regular expressions, and I was hoping
someone can see the syntax error that I'm missing
--
John C. Nichel IV
System Administrator
KegWorks
http://www.kegworks.com
716.362.9212 x160
j...@kegworks.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I'm trying to create a function that formats a time in a standard way
('%H:%i'). But all I can seem to get back is null.
DROP TABLE IF EXISTS bogus_table;
CREATE TABLE IF NOT EXISTS bogus_table (
btime TIME
);
INSERT INTO bogus_table VALUES ('12:34:56');
DROP FUNCTION IF EXISTS bogus ;
I am working on an app to allow a committee to schedule classes. The members
of the committee can all update the database by changing the time or the
instructor for a class. I have to write an app to warn them when they've
scheduled an instructor for 2 classes at the same time or if they've
Partitioning is available in the community edition and has been for a
while now. Support is the only real difference and since Oracle took
over the support available in the community is usually faster and better
than you get from Oracle.
John
On Wed, 2011-09-21 at 16:23 +0200, Claudio Nanni
: Descripción: cid:image002.jpg@01CB8CB6.ADEBA830]
Polígono Campollano C/F, nº21T
02007 Albacete (España)
Tlf:967-504-513 Fax: 967-504-513
www.ingenia-soluciones.com
--
John Daisley
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44 (0
www.ingenia-soluciones.com
*De:* John Daisley [mailto:daisleyj...@googlemail.com]
*Enviado el:* viernes, 03 de junio de 2011 11:18
*Para:* Rocio Gomez Escribano
*CC:* mysql@lists.mysql.com
*Asunto:* Re: timezone
Have you populated the timezone tables? Run this query if you are not sure
Difference Engine
http://mark.goodge.co.uk
http://www.ratemyairport.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk
--
John Daisley
Butterfly Information Systems
on the system,
you might need to download and parse the rules yourself in your code.
Unless, of course, you're talking about the timezone difference between
Spain and the Canaries, but you mentioned summer/winter time explicitly, so
I don't think so.
--
*From: *John
the access they need and security is a little tighter :)
You should also find Stored Procedures execute a little faster :)
On 3 June 2011 11:47, Mark Goodge m...@good-stuff.co.uk wrote:
On 03/06/2011 11:24, John Daisley wrote:
The reason
*GRANT SELECT, INSERT, UPDATE, DELETE ON mydyb
I think the default location on Centos is /etc/my.cnf
Regards
John
On 1 June 2011 10:24, Adarsh Sharma adarsh.sha...@orkash.com wrote:
Dear all,
I install mysql in CentOS -5.4 through 2 commands :
yum install mysql-server
yum install mysql-client
And I can see directories created
A simple stored procedure run by the event scheduler at predetermined times
will do this quite easily. Can you post the output of SHOW CREATE TABLE for
your two tables?
John
On 23 May 2011 13:15, Machiel Richards machi...@rdc.co.za wrote:
Hi Everyone
I have posted this question quite
Does it make any difference if I allocate a particular number of bytes for a
varchar? I mean, just as an example, maybe its more efficient to use a power
of 2 as the field length. Or maybe power of 2 minus 1. I'm guessing not and
that anything less than 255 is the same.
I'm converting some
From: Claudio Nanni claudio.na...@gmail.com
To: Shawn Green (MySQL) shawn.l.gr...@oracle.com
Cc: John G. Heim jh...@math.wisc.edu; my...@lists.mysql.com
Sent: Wednesday, March 30, 2011 2:01 AM
Subject: Re: getting procedure code via mysqldump
In case you use a linux or unix system
I would like to use mysqldump to get a copy of the code for a stored
procedure in a format that is similar to the code I used to create it. The
problem is that I'm blind and I have to listen to the code to debug it. I
think I have a file containing the code that I used to create the stored
are obviously working, but for some reason the ISSUER
check is not working. How can I debug that futher?
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
as much experience on this yet so I would
really appreciate assistance.
Regards
Machiel
--
John Daisley
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44 (0)7918 621621
Email: john.dais...@butterflysystems.co.uk
Seen this a lot with poorly written web apps which open connections but dont
close them when finished. Try setting wait_timeout and/or
interactive_timeout to close unused connections.
John
On 24 November 2010 11:27, Johan De Meersman vegiv...@tuxera.be wrote:
Hey,
Late last night, I got
Johan,
Are you sure mmm couldn't handle this?
Machiel,
Maybe you could `simulate` the whole thing using some federated tables on
one of the slave instances? Then although you are replicating to 3 instances
you could access all the data from a single instance?
Regards
John
On 24 November 2010
or changing the innodb_log_file_size to match the size of the
files on disk.
If the Innodb engine is not available then MySQL will use the default
(usually MyISAM) storage engine even if Innodb was specified. You can stop
this behaviour by setting sql-mode=NO_ENGINE_SUBSTITUTION
Regards
John
On 22
You are correct, in a master slave setup the slave does not accept writes.
John
On 22 November 2010 11:06, Machiel Richards machi...@rdc.co.za wrote:
Hi All
sorry to bother everyone again. but now I have a question from a
client which I am sure about my answer, however need
specifically set readonly on the slave you
have to be very careful in order to maintain data integrity on the slave and
also not to break repliacton. Tools like Maatkit are designed to check data
integrity on the slave due to exactly this issue,
thanks Andy.
Quoting John Daisley daisleyj
:http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--
John Daisley
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44
928 distinct Call_No strings,
so I'm not afraid of wasting space or anything.
Thanks,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
';
+--+
| Call_No |
+--+
| News |
| NewsD CT |
+--+
2 rows in set (0.02 sec)
Thanks a ton for your help, I would have never figured this out, esp
since I was looking down all the wrong rat holes.
Thanks,
John
--
MySQL General Mailing List
For list archives: http
What is the hardware spec? Anything else running on the box?
Why are you replicating but not making use of the slave?
Can you post the output of SHOW CREATE TABLE?
Regards
John
On 2 September 2010 12:50, Alexandre Vieira nul...@gmail.com wrote:
Hi list,
I'm having some performance problems
= products.products_id
WHERE products.enabled = 1
AND products_sales.language = 'EN'
This works fine, however I also want to SUM the ES language within the same
query. Is this possible to do, or should I just query the table twice,
replacing the language parameter ?
Thanks.
Neil
--
John Daisley
, they are rarely suitable for any
system without modification. If you don't know what you are doing read the
manual, ask questions, test, test and test again. (or hire a
MySQL professional)!
Regards
John
On 16 August 2010 13:32, Johan De Meersman vegiv...@tuxera.be wrote:
1. Make sure it works
2
CURRENT_TIMESTAMP as the default for a TIMESTAMP
column.
The way around this is to have a trigger set the column value to UUID()
Regards
John Daisley
--
John Daisley
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI
On 07/25/2010 09:29 PM, Mark Phillips wrote:
I have been away from sql for awhile, and can't seem to figure out how to
write a simple query for two tables.
Table 1 has many columns, two of which are hID and vID. Table 2 has two
columns, ID and name. The hID and vID in table 1 correspond to the
Most likely a foreign key constraint would be violated if the table were
dropped. Check those index definitions on `Store` and `User` columns.
Regards
John Daisley
Microsoft SQL Server 2005/2008 Database Administrator
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos
`) REFERENCES
`second_table` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
So, first you remove the key:
ALTER TABLE table_name DROP KEY `idx`;
then the foreign key:
ALTER TABLE table_name DROP FOREIGN KEY `table_name_ibfk_1`;
Then that should do it!
Regards
John Daisley
Any idea when the 5.5 GA release will be?
- John
--
---
John May : President http://www.pointinspace.com/
Point In Space Internet Solutions j...@pointinspace.com
Twitter: http
wordwide? So I make practice with the most
used one.
Thanks in advance!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk
--
John Daisley
Certified MySQL 5 Database
administering MS SQL Server and IBM
Cognos BI tools!
Regards
John
On 13 July 2010 14:55, Rob Wultsch wult...@gmail.com wrote:
On Tue, Jul 13, 2010 at 6:24 AM, alba.albetti alba.albe...@libero.it
wrote:
Hi,
I'd like to know which are the main tasks for a DBA, so in addition of
the on-line
To unsubscribe:
http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk
--
John Daisley
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44 (0)7918 621621
Email: john.dais...@butterflysystems.co.uk
but the best way to control these is ensure your app closes its
connections when it is finished with them and do not use persistent
connections unless absolutely necessary
Regards
John
John Daisley
SQL Server 2005/2008 Database Administrator
Certified MySQL 5
products a
The query is erroring out on 'd.date' in expression two of the if
statement, #1109 - Unknown table 'd' in field list. Is there a way I
can do a IF((SELECT.), expr2, expr3) and have expr2 populate with
whatever is returned from the select statement? Thank you.
--
John C. Nichel IV
you for the reply. Unfortunately, not all of the rows I'm
selecting in the main clause will have an entry in the other table, so
if I do it that way, it won't return any data for the rows that don't
have a match in the order_details table.
On 7/8/2010 9:59 AM, John Nichel wrote to:
Hi
.
http://www.eset.com
--
John Daisley
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Microsoft SQL Server 2005/2008 Database Administrator
Cognos BI Developer
Telephone: +44 (0)7918 621621
Email: john.dais...@butterflysystems.co.uk
On my db server, mysql has 2 gigabytes for temporary tables and yet its
creating 99% of temporary tables on disk.
According to mysqltuner, 99% of temporary tables are created on disk. I've
confirmed this via the show global status like 'created%' command. This
is in spite of having the
also consider that it is much more likely that remote slaves will start
falling behind particularly if you throw encryption into the equation.
Regards
John
On 24 May 2010 13:24, Carl c...@etrak-plus.com wrote:
Walter,
Don't know how I missed that but it exactly what I needed.
Thanks
the
information of children, credit cards and bank accounts.)
Thanks,
Carl
- Original Message -
*From:* John Daisley daisleyj...@googlemail.com
*To:* Carl c...@etrak-plus.com
*Cc:* Walter Heck wal...@openquery.com ; mysql@lists.mysql.com
*Sent:* Monday, May 24, 2010 6:47 AM
and tokenization. MySQL replication with ssl is not going to meet
the requirements. Probably be easier to write the data to both servers
directly rather than writing to one and then trying to secure replication to
a level demanded by the pci regs.
regards
John
On 24 May 2010 13:23, Prabhat Kumar
Right now I have the spamassassin bayesian rules database in mysql myisam
tables on our mail server. I want to move it to our database server.
Mysqltuner tells me that the read/write ratio is 10/90. 90% writes.
Given a database that is doing 90% writes, what database engine should I
use?
between 16:45:57 and 16:47:01 on 26th
February 2010 and this is what I would need the query to return only working
with a lot more data. Any ideas?
Thank you in advance for any help, suggestions. This is currently on a MySQL
5.1 system.
Regards
--
John Daisley
Certified MySQL 5 Database
If you only want root to be able to log in locally then you only need
'root'@'localhost' unless you are using tcp connections.
regards
John
On Tue, Mar 30, 2010 at 11:25 PM, Carlos Mennens carlosw...@gmail.comwrote:
Today I installed MySQL 5.1.45-1 on my production server and it
recommended
as much care of your
hardware by ensuring that it is kept secure and not left in the hands of an
untrustworthy isp, disposed of in an insecure manner or kept in an insecure
office.
John Daisley
Certified MySQL 5 DBA / Developer
Cognos BI Developer
Tel: +44 (0)1283 537111
Mobile: +44 (0)7918
On Sun, Mar 21, 2010 at 9:49 PM, mos mo...@fastmail.fm wrote:
At 03:21 PM 3/21/2010, John Daisley wrote:
Mike,
Encrypted filesystems can seriously impact performance of MySQL.
Its an entirely different issue to MySQL encryption but one would hope
that, if you are going to go to all
-
From: Jim j...@lowcarbfriends.com
Sent: Friday, March 19, 2010 4:22 PM
To: John Daisley daisleyj...@googlemail.com; mysql@lists.mysql.com
Subject: Re: MySQL Encryption
Thanks for the reply, John.
What you are describing seems to be the approach I've seen on the few
places I've seen
in a database stored procedure and use database
security to prevent unauthorised access. At no point do I have this logic
outside the database in any external application or script! That would be
silly :)
Regards
John Daisley
On Thu, Mar 18, 2010 at 7:26 PM, Jim j...@lowcarbfriends.com wrote:
In terms
BY TAP.LastName, TAP.FirstName, Sum(Pts.Points)
Regards
John
On Tue, Mar 16, 2010 at 6:17 PM, Jesse j...@msdlg.com wrote:
I have the following query:
SELECT TAP.ID http://tap.id/, M.UID, TAP.FirstName, TAP.MI,
TAP.LastName, TAP.State,
TAP.SchoolName, TAP.StateApproved, TAP.DiplomatApproved
to MySQL!
Regards
John
On Tue, Mar 16, 2010 at 6:46 AM, Machiel Richards machi...@rdc.co.zawrote:
Hi all
Maybe someone can assist me with this one.
A while back I requested some information relating to the
MySQL innodb buffer pool size that seems to fill up
What are your plans for OS as this can have an impact on hardware choice
especially if you are considering Solaris or Open Solaris.
Regards
John
On Tue, Mar 16, 2010 at 3:22 PM, Евгений Килимчук ekilimc...@gmail.comwrote:
http://assets.en.oreilly.com/1/event/27/Linux%20Filesystem
... this
operation needs to be scripted, or to be presented as one command line
that can be copy-and-pasted.
How can I do something like :
mysqladmin -h db_server -u user -pPASSWORD DATABASE truncate table
table1 ?
--
***
* John Oliver
On Tue, Mar 16, 2010 at 02:12:42PM -0700, John Oliver wrote:
Is there a way to use mysqladmin (or mysql) to truncate a table as a
one-off command from the command line?
I have an issue with importing data from one database into another, but
the second database might have columns
Has MySQL Proxy been improved since that article was released?
I ask because although I have no personal experience with it I do know of a
big UK based online payment processing company who use MySQL Proxy with
MySQL 5.1 in production very successfully.
On Thu, Mar 11, 2010 at 3:34 PM, Johan De
Hi,
I am working on configuring a new hardware database server. I'm a little
confused as to what to do about disk. We have several mysql databases but by
far the 2 most active are spamassassin bayesian rules and horde3/imp web
mail. Both do a lot of updates. The bayesian rules are added to
...
--
***
* John Oliver http://www.john-oliver.net/ *
* *
***
--
MySQL
From: machi...@rdc.co.za
To: mysql@lists.mysql.com
Subject: slow queries not being logged
Date: Tue, 23 Feb 2010 09:59:13 +0200
Good day all
I hope you can assist me with this one...
We have a client where the slow query log was disabled.
overcome this issue so please do
let me know what you decide.
Regards
John Daisley
==
John Daisley
Certified MySQL DBA / Developer
IBM Cognos BI Developer
Tel: +44(0)1283 537111
Mobile: +44 (0)7819 621621
Email: j...@butterflysystems.co.uk
==
Sent via HP IPAQ mobile
I am trying to help a friend with her website, which is on Yahoo. I went into
her phpMyAdmin, and got the message:
Your PHP MySQL library version 3.23.49 differs from your MySQL server version
4.1.14. This may cause unpredictable behavior.
Another message told me to run the script:
About 5 years ago, I was asked to write a php app for my department. The app
keeps track of graduate school applicants to my department at the
university. The main data elements are the scores each professor gives to
each applicant. There are only about 400 applicants each year so even with
On 2/5/2010 5:15 AM, Suresh Kuna wrote:
In the mysql prompt, execute the below
use mysql ; select user from user ;
will show all the accounts in a MySQL database.
Alternatively, you can use myphpadmin. I guess it all depends upon what
you need the information for and to what purpose.
What error are you getting?
===
John Daisley
MySQL 5.0 Certified Database Administrator (CMDBA)
MySQL 5.0 Certified Developer
Cognos BI Developer
Telephone: +44(0)1283 537111
Mobile: +44(0)7812 451238
Email: john.dais...@butterflysystems.co.uk
===
Sent via HP
configurations.)
--John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
: 50 things to know before migrating from Oracle to MySQL
-Original Message-
From: John Meyer [mailto:johnme...@pueblocomputing.com]
Sent: Thursday, January 28, 2010 2:16 PM
To: mysql@lists.mysql.com
On 1/28/2010 3:21 AM, changuno wrote:
Read a blog which states 50 things to know before
On 1/28/2010 3:21 AM, changuno wrote:
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
would it have been too much to just link to it?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On 1/28/2010 4:52 PM, Brian Dunning wrote:
Hey all -
I need a few million sample contact records - name, company, address, email,
web, phone, fax. ZIP codes and area codes and street addresses should be
correct and properly formatted, but preferably not real people or companies or
email
If I may recommend:
http://www.generatedata.com/#download
On 1/28/2010 8:11 PM, Carlos Proal wrote:
Google for data generator, there are free and commercial solutions
available.
Carlos
On 1/28/2010 5:52 PM, Brian Dunning wrote:
Hey all -
I need a few million sample contact records - name,
From: Jaime Crespo Rincón jcre...@warp.es
Sent: Monday, January 25, 2010 5:30 PM
2010/1/25 John G. Heim jh...@math.wisc.edu:
I have a server with 16Gb of RAM and a dual-core 2Ghz processor. It is
running the latest mysql-server from debian lenny (5.0.1). I have
databases
for drupal, moodle
to use near 'WHERE
`productid` = 173846 `variantid` = 73130 `type` = 's'' at line 1
--
John C. Nichel IV
System Administrator
KegWorks
http://www.kegworks.com
716.362.9212 x16
j...@kegworks.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Please forgive my ignorance. Going from update to replace and left the
'where' part of the statement. Definitely a DOH! moment.
--
John C. Nichel IV
System Administrator
KegWorks
http://www.kegworks.com
716.362.9212 x16
j...@kegworks.com
-Original Message-
From: John Nichel
: O'Reilly Media; 2 edition (June 18, 2008) Language: English
ISBN-10: 0596101716 ISBN-13: 978-0596101718
Here is a brief preview of the first edition:
http://books.google.ca/books?id=iaCCQ13_zMICprintsec=frontcoverdq=high+performance+mysqlcd=1#v=onepageq=f=false
Mike
At 10:19 AM 1/26/2010, John G. Heim
General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk
===
John Daisley
MySQL 5.0 Certified Database Administrator (CMDBA)
MySQL 5.0 Certified Developer
Cognos BI Developer
I have a server with 16Gb of RAM and a dual-core 2Ghz processor. It is
running the latest mysql-server from debian lenny (5.0.1). I have databases
for drupal, moodle, spamassassin, horde3, and a small database for
departmental stuff.
The problem is that inserts/updates are sometimes very slow,
On 1/19/2010 7:49 AM, Mark Goodge wrote:
On 19/01/2010 14:44, Tompkins Neil wrote:
Hi All,
Following on from my earlier email - I've the following question now :
I can enforce that the user can't use the same password as the
previous four
- when they change their password. However, the user
this matches queue, but
the Regex behavior is bizarre with unicode.)
Does anyone know why the final regex acts weird? It there a good solution?
Thanks in advance,
John Campbell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 1/18/2010 5:52 PM, Colin Streicher wrote:
On January 18, 2010 01:34:15 pm Tompkins Neil wrote:
Hi
I'm in the process of designing a login system to a secure web page using
MySQL. One of the features is we need to record and ensure that the user
password is different from any of the last
order only has one line item a
piece. However, if the first order has one line item and the second
order has two line items, MySQL returns $30 as the total. Is there a
way to make MySQL add the ordertotal column only once per unique order
in the orders table? TIA
--
John C. Nichel IV
System
what I can do about a stray pointer.
--
***
* John Oliver http://www.john-oliver.net
-pointer? Aborting backtrace!
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html
contains
information that should help you find out what is causing the crash.
100104 16:43:51 mysqld ended
--
***
* John Oliver
A where y = 25
Good luck,
John
to be an effective 'pricing lever' it has to be a viable alternative.
MySQL is a very effective pricing lever on Oracle as it is a mature and proven
product with excellent support.
Regards
John
-Original Message-
From: Martijn Tonies m.ton...@upscene.com
Sent: 16 December 2009 13:16
Cc: mysql
the price is going to be then perhaps I should offer 2€ or maybe
MySQL users should get together submit a realistic offer.
Regards
John Daisley
Business Intelligence Developer / Certified MySQL 5.0 Database Administrator
Inspired Gaming Group Plc
Direct Dial +44 (0)1283 519244
Telephone +44 (0
the performance benefits
(especially with ndbcluster) or the availability of suitably trained and
certified people to support their products.
Regards
John
-Original Message-
From: Martijn Tonies m.ton...@upscene.com
Sent: 17 December 2009 09:44
To: mysql@lists.mysql.com
Subject: Re: Help
it (unlikely).
John
===
John Daisley
MySQL 5.0 Certified Database Administrator (CMDBA)
MySQL 5.0 Certified Developer
Cognos BI Developer
Telephone: +44(0)1283 537111
Mobile: +44(0)7812 451238
Email: john.dais...@butterflysystems.co.uk
===
Sent via HP IPAQ mobile
in your box) try
increasing the values for tmp_table_size and max_heap_size, these control how
large an in-memory temp table can grow before it is converted to an on disk
temp table.
Regards
John
===
John Daisley
MySQL 5.0 Certified Database Administrator (CMDBA)
MySQL 5.0
of EXPLAIN
EXTENDED for the query you posted? Can you also post the output of 'SHOW CREATE
TABLE' for the tables fdata,ftype,fgroup?
John Daisley
Business Intelligence Developer - MySQL Database Administrator
Inspired Gaming Group Plc
Direct Dial +44 (0)1283 519244
Telephone +44 (0)1283
1 - 100 of 1816 matches
Mail list logo