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 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 wrote:
> I need help creating a select that returns 4 records that have
> contiguous addresses that st
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, indexi
mysql/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 'mysq
ust opens up a mysql session, and that only if I do 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
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
__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 wrote:
Subject: Re: Ca
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(
But get to it! The deadline 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
> -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 miss
er version 4.1.22 (yeah, I know it's old :) )
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
rd, this is a MySQL
4.1.22 db. TIA
--
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 ;
DELIMIT
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
sch
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
t 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 wrote:
> On 03/06/2011 11:24, John Daisley wrote:
>
>> The reason
>>
>> *GRANT SELECT, INSER
tracked somewhere 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
r each site
> which can be accessed by the server admins without needing to have access to
> each site's own database.
>
> Clues, anyone?
>
> Mark
> --
> Sent from my Babbage Difference Engine
> http://mark.goodge.co.uk
> http://www.ratemyairport.com
>
> --
&g
; *Rocío Gómez Escribano*
>
> r.go...@ingenia-soluciones.com
>
>
>
> [image: 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
&
nes.com
>
>
>
> [image: 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
I think the default location on Centos is /etc/my.cnf
Regards
John
On 1 June 2011 10:24, Adarsh Sharma 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 c
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 wrote:
> Hi Everyone
>
>I have posted this question quite a w
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 dat
From: "Claudio Nanni"
To: "Shawn Green (MySQL)"
Cc: "John G. Heim" ;
Sent: Wednesday, March 30, 2011 2:01 AM
Subject: Re: getting procedure code via mysqldump
In case you use a linux or unix system, to strip off the comments in linux
bash is very easy, you ca
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
proc
''@'ipaddress' (using
password: YES)
The basics of ssl 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
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
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 wrote:
> Hey,
>
> Late last night, I got a call
system failure
> it is rather quick and easy enough to get the slave running as the
> master.
>
>I do not have as much experience on this yet so I would
> really appreciate assistance.
>
> Regards
> Machiel
>
--
John Daisley
Certified MySQL
ou dont 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.
>
You are correct, in a master slave setup the slave does not accept writes.
John
On 22 November 2010 11:06, Machiel Richards 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 to confirm.
created 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
Jo
very large DBs, Ive not personally used it tho).
> >
> > Thats about it I think, unless anyone wants to correct me on that...
> >
> > thanks Andy.
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.
ysql> WHERE BIB_ID = '464';
+--+
| 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
Char(36)
which would hopefully index better? I only have 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
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 wrote:
> Hi list,
>
> I'm having some performance problem
les.products_id = 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
cnf/my.ini files, 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 wrote:
> 1. Make sure
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 I
KEY (`idx`) 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
Jo
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
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
used 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
> >> worked only as developer and not as DBA.
> > >> Thanks!
> > >>
> > >>
> > >> --
> > >> MySQL General Mailing List
> > >> For list archives: http://lists.mysql.com/mysql
> > >> To unsubscribe:
> > >> http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
> > >>
> > >>
> > >
> > >
> > >--
> > >Claudio
> >
> >
> >
> >
>
> Keith J. Clark
>
>
> Business ManagerOwner
> The BookwormWaterloo Hosting
> Quality Used Books Complete Web Hosting Provider
> www.k-wbookworm.com www.waterloohosting.com
> sa...@k-wbookworm.com sa...@waterloohosting.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
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44 (0)7918 621621
Email: john.dais...@butterflysystems.co.uk
spend 90% of my time administering MS SQL Server and IBM
Cognos BI tools!
Regards
John
On 13 July 2010 14:55, Rob Wultsch wrote:
> On Tue, Jul 13, 2010 at 6:24 AM, alba.albetti
> wrote:
> > Hi,
> > I'd like to know which are the main tasks for a DBA, so in addition of
>
file 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 My
ve that join logic to the query's main clause?
>
> PB
>
> -
>
Thank 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
limit 1
) > 0, d.date, 0
) as last_sold
FROM
products a
The query is erroring out on 'd.date' in expression two of the if
statement, "#1109 - Unknown table 'd' in field list"
Linux I have MySQL 5.0 and under Windows MySQL 5.1 and I definitely
> need to upgrade?
>
> There are some differences between the global variables that start with
> innodb_ under Windows and Linux, but I don't know if those differences make
> InnoDB to choose another index.
>
> Tha
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 foll
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
formation of children, credit cards and bank accounts.)
>
> Thanks,
>
> Carl
>
> - Original Message -
> *From:* John Daisley
> *To:* Carl
> *Cc:* Walter Heck ; mysql@lists.mysql.com
> *Sent:* Monday, May 24, 2010 6:47 AM
> *Subject:* Re: Master - master rep
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 wrote:
> Walter,
>
> Don't know how I missed that but it exactly what I needed.
>
&
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?
--
system was free 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 M
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 wrote:
> Today I installed MySQL 5.1.45-1 on my production server and it
>
On Sun, Mar 21, 2010 at 9:49 PM, mos 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
>&g
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
-Original Message-
From: Jim
Sent: Friday, March 19, 2010 4:22 PM
To: John Daisley ; 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 this topic discusse
`
AS CHAR))
I then store the logic 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, Ji
, TAP.StateApproved, TAP.DiplomatApproved, C.ChapterType,
S.Region, S.District
ORDER BY TAP.LastName, TAP.FirstName, Sum(Pts.Points)
Regards
John
On Tue, Mar 16, 2010 at 6:17 PM, Jesse wrote:
> I have the following query:
>
> SELECT TAP.ID <http://tap.id/>, M.UID, TAP.
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 ha
ll, which won't work... 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 truncate table
table1 ?
--
****
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, Евгений Килимчук wrote:
>
> http://assets.en.oreilly.com/1/event/27/Linux%20Filesystem%20Performance
MySQL!
Regards
John
On Tue, Mar 16, 2010 at 6:46 AM, Machiel Richards wrote:
> Hi all
>
>
>
>Maybe someone can assist me with this one.
>
>
>
>A while back I requested some information relating to the
> MySQL innodb buffer pool siz
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 eac
y the deltas?
Thanks...
--
***
* John Oliver http://www.john-oliver.net/ *
* *
*
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
> 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 wa
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: mysql_fix_pri
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
all
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
here are multiple mysql directories in most
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
gs-to-know-before-migrating-oracle-to-mysql/
Man, I love Google.
Thanks,
Carl
- Original Message -
From: "Daevid Vincent"
To:
Cc: "'changuno '"
Sent: Thursday, January 28, 2010 5:49 PM
Subject: RE: 50 things to know before migrating from Oracle to MySQL
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
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 addre
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 unsubscribe
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
ne 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_zMIC&printsec=frontcover&dq=high+performance+mysql&cd=1#v=onepage&q=&f=false
Mike
At 10:19 AM 1/26/2010, John G. Heim wr
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--
` = 73130
&& `type` = 's'
And the error for both is the same:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'WHERE
`productid` = 173846 && `variantid` = 73130 && `type` = &#
From: "Jaime Crespo Rincón"
Sent: Monday, January 25, 2010 5:30 PM
2010/1/25 John G. Heim :
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, hor
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,
x27;[[:<:]]q[uùúûüũūŭůűųǔǖǘǚǜ][eèéêëēĕėęě][[:>:]]'
Matches que, queue, qué. (I have no idea why 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 Gen
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 ca
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 fou
when each 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
ace!
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
I don't know what I can do about a "stray pointer".
--
***
* John Oliver
ts?
select count(*) from A where y = 25
Good luck,
John
rice
unless a regulator demands 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
=
m can boast 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
Sent: 17 December 2009 09:44
To: mysql@lists.mysql.com
Subject: Re: Help saving
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
g 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
Sent: 16 December 2009 13:16
Cc: m
Yes, you can symlink it. How much performance benefit you get will depend on
hardware and traffic.
===
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
complete and tables are locked whilst it runs. If
you have slaves running you may want to add LOCAL to the OPTIMIZE TABLE
statement so the operation does not run on your slaves.
I'm stuck doing some other stuff at the mo but I will try and have a
proper look at this later and will get bac
1 - 100 of 1932 matches
Mail list logo
