se, do you mean the database
> files only? Are you doing a complete restore?
>
> On Fri, Jan 22, 2016 at 1:23 PM, Neil Tompkins <
> neil.tompk...@googlemail.com> wrote:
>
>> Hi,
>>
>> Hoping someone can help me identify why I keep having to restore my
>>
database works fine, but seems to crash when I shut the PC down.
On Fri, Jan 22, 2016 at 8:47 PM, Lisa Smith wrote:
> Hi Neil,
>
> When you say you delete the current database, do you mean the database
> files only? Are you doing a complete restore?
>
> On Fri, Jan 22, 2016 at 1:23
My disk drive has about 3 gb free space. The sequence of events is
1. Create database
2. Restore the data
3. Use the database, SELECT data etc
4. Shut down PC
5. When I restart PC I get this error
Hi,
Hoping someone can help me identify why I keep having to restore my
database. You can see below, that my machine shut down normally, yet when
I restarted the machine back up, I'm getting the error
'mysql\innodb_table_stats.ibd. Cannot open tablespace' and am having to
delete the current datab
Personally I think people, myself included are using other resources like
stackoverflow to get answers to my MySQL questions.
> On 24 Nov 2014, at 17:27, Michael Dykman wrote:
>
> Please gentlemen,
>
> It is a valid question if a somewhat hackneyed one.
>
> MySQL continues to live on in many
Hi,
I'm using MySQL 5.6.17 on Amazon Web Services RDS and when calling SELECT
UUID_SHORT() I'm getting a number bigger than 9223372036854775807. For
example the number I get is
12057145185130250250
The problem is in my table I have a column as BIGINT(20) unsigned, but when
storing a number 12057
Shawn
What I need is that if I pass say 10 parameters/variables to a query, I
only want to update the column/field if the value passed is NOT NULL.
On Wed, Oct 30, 2013 at 3:41 AM, Shawn Green wrote:
> Hi,
>
> On 10/29/2013 9:52 PM, h...@tbbs.net wrote:
>
>> 2013/10/29 11:35 -0400, Shawn Green
passed for each field is NOT
NULL.
Therefore, I felt this needs to be done at database level in the stored
procedure. How can I accomplish this.
Thanks
Neil
On Mon, Oct 28, 2013 at 6:17 PM, Shawn Green wrote:
> Hello Neil,
>
> On 10/28/2013 2:06 PM, Neil Tompkins wrote:
>
>> Hi
&
Hi
If I have a update statement like
UPDATE MY_TABLE
SET FieldName1 = Now(), FieldName2 = :MyVariable
WHERE FieldName3 = 'Y'
How can I only update the FieldName2 field if the value of MyVariable is
NOT NULL ?
Thanks
Neil
I have installed MySQL 5.6.13 on our Windows 2003 server and need to
configure the service so that no external access is possible from a remote
IP addresses.
On the server it's self, the MySQL service will need to be accessed by IIS
hosting a ASP.NET application and web services.
I know that this
I have the following four MySQL tables
Region
RegionId
City
CityId
RegionId
Hotel
HotelId
CityId
HotelRegion
HotelId
RegionId
I'm struggling to write a UPDATE statement to update the City table's
RegionId field from data in the HotelRegion table.
Basically how can I update the City table with
Hi,
I've created a Trigger and want to edit it. Using MySQL Workbench, I can
Alter the table, and click Triggers and select the trigger action I want to
edit (on my local database, MySQL running on same PC)
However, if I try the exact same procedure on a Trigger on a remote
database, I don't see
Hi,
I have a number of INSERT and UPDATE statements in a MySQL Stored
Procedure, that works in the form of START TRANSACTION followed by COMMIT.
Also I am handling any EXCEPTION.
However, after calling COMMIT, how can I get the number of Rows that were
affected either INSERTED or UPDATTED ?
Tha
ss for the amount of space you'll be using for
> your data and index; (2) Please do the math of just how many inserts you
> can do per second over the next 1.000 years if you use a longint
> auto-increment field for your PK.
>
> / Carsten
>
> On 31-05-2013 11:14, Neil T
have currently 54 tables, of which probably 30 will
be audited. So a INT PK wouldn't work because of the number of updates we
are applying.
On Fri, May 31, 2013 at 9:58 AM, Carsten Pedersen wrote:
> On 30-05-2013 09:27, Neil Tompkins wrote:
>
>> Hi,
>>
>> I've
Any advice anyone ?
-- Forwarded message --
From: Neil Tompkins
Date: Thu, May 30, 2013 at 8:27 AM
Subject: Audit Table storage for Primary Key(s)
To: "[MySQL]"
Hi,
I've created a Audit table which tracks any changed fields for multiple
tables. In my Audit ta
Hi,
I've created a Audit table which tracks any changed fields for multiple
tables. In my Audit table I'm using a UUID for the primary key. However I
need to have a reference back to the primary key(s) of the table audited.
At the moment I've a VARCHAR field which stores primary keys like
1
1|
ot get inserted from temp table
> to innodb table
>
>
> On Wed, May 29, 2013 at 7:29 PM, Neil Tompkins <
> neil.tompk...@googlemail.com> wrote:
>
>> I took the following lines of code slightly modified and it returned some
>> data using a normal
ability', 1,'RoomsToSell',4,4, NOW());
SELECT * FROM tempHotelRateAvailability;
On Wed, May 29, 2013 at 2:57 PM, Ananda Kumar wrote:
> did u check if data is getting inserted into tempHotelRateAvailability
>
>
> On Wed, May 29, 2013 at 7:21 PM, Neil Tompkins <
> n
#x27;, 1,'RoomsToSell',1,2,
NOW());
On Wed, May 29, 2013 at 2:49 PM, Ananda Kumar wrote:
> can you please share the code of the trigger. Any kind of error your
> getting
>
>
> On Wed, May 29, 2013 at 6:49 PM, Neil Tompkins <
> neil.tompk...@googlemail.com> w
Hi,
I've a trigger that writes some data to a temporary table; and at the end
of the trigger writes all the temporary table data in one insert to our
normal Innodb table.
However, for some reason the trigger isn't copying the table from the
temporary table to the Innodb table. If I write in the
Hi,
Using Workbench with MySQL 5.6 how do I edit a existing Trigger. Do I need
to DROP the Trigger and create a new one ? If that is the case how can you
run start command in a live environment ?
Thanks
Neil
Hi Shawn
I plan in installing the latest MySQL version tomorrow. Does MySQL not
support Bool eg true and false
Neil
On 22 May 2013, at 19:05, shawn green wrote:
> Hello Neil,
>
> On 5/22/2013 1:05 PM, Neil Tompkins wrote:
>> Hi, Like the link states
>>
>>
; synonym type which infact behaves unlike a boolean
should."
Has BOOL, BOOLEAN been taken out of MySQL 5.6 ?
On Wed, May 22, 2013 at 6:01 PM, Ian Simpson wrote:
> BOOLEAN is a synonym for TINYINT(1) in MySQL:
>
> http://dev.mysql.com/doc/refman/5.6/en/numeric-type-overview.html
Hi,
I've just created some tables that I designed using the MySQL Workbench
Model. However, the database type BOOLEAN which was in my models has been
converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5 on
Windows 2008 server.
Any ideas why this has been removed ?
Neil
s the PRIMARY KEY, and make it ASCII, not UTF8.
> That would turn the 4-byte id into a 2-byte string.
>
> I gather you are using an new-enough NDB so that FOREIGN KEYs are
> implemented?
>
> > -Original Message-
> > From: Neil Tompkins [mailto:neil.tompk...@googlemai
Hi,
I've the following database structure of 4 tables for geographical
information
CREATE TABLE IF NOT EXISTS `mydb`.`country` (
`country_id` INT NOT NULL ,
`country_code` CHAR(2) NOT NULL ,
`name` VARCHAR(255) NOT NULL ,
PRIMARY KEY (`country_id`) ,
UNIQUE INDEX `country_code_U
mor...@oracle.com
> @andrewmorgan
> www.clusterdb.com
>
> > -Original Message-
> > From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
> > Sent: 27 April 2013 23:28
> > To: [MySQL]
> > Subject: Fwd: MySQL Cluster or MySQL Cloud
> >
> > > If deplo
rance
?
Same with regions/states and cities and districts ?
On Sun, Apr 21, 2013 at 9:28 AM, Denis Jedig wrote:
> Neil,
>
> Am 21.04.2013 08:47, schrieb Neil Tompkins:
>
> Using joins I can obtain which country each city belongs too. However,
>> should I consider putting a
Hi
I'm creating the following basic tables
COUNTRIES
countries_id
name
REGIONS
region_id
countries_id
name
CITIES
cities_id
region_id
Using joins I can obtain which country each city belongs too. However,
should I consider putting a foreign key in the CITIES table referencing the
countries_i
Hi,
I've used in the past MySQL Community Server 5.x. Everything is fine,
however I'm now wanting to implement a new High Availability solution and
am considering MySQL Cluster. However, I heard that MySQL Cluster doesn't
support store procedures ? Are there any other restrictions I need to be
Hi,
I've the following data
total, supplier_id, product_name, supplier_code
125,2,iPod,xyz123
100,1,iPod,abc123
145,3,iPod,1213113
245,4,iPod,12345
What query do I need to get the lowest total in this case 100 for
supplier_id 1 ?
Thanks
Neil
from code I can't imagine counting the parameters in the code
> being so hard.
>
> Cheers
>
> Claudio
>
>
>>
>> On 22 November 2012 15:01, Neil Tompkins
>> wrote:
>>> Michael,
>>>
>>> Thanks this kind of works if I&#
Doing a EXPLAIN on the SELECT statement it is using "Using where; Using
temporary; Using filesort" with 14000 rows of data. How best to improve
this; when I already have indexed on id and type
On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman wrote:
> Assuming that (id,type) is unique in the so
Ignore that it does work fine. Sorry
On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman wrote:
> Assuming that (id,type) is unique in the source data, that is a pretty
> elegant method:
>
> > select id from
> > (select distinct id, count(*)
> > from my_table
> > where type in (2,5)
> > group by id
When trying this query I get
FUNCTION id does not exist
On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman wrote:
> select id from
> > (select distinct id, count(*)
> > from my_table
> > where type in (2,5)
> > group by id
> > having count(*) = 2)a;
>
By unique you mean that no id and type would be duplicated like
1,1
1,1
Yes it isn't possible for duplicate id and type in more than 1 row
On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman wrote:
> Assuming that (id,type) is unique in the source data, that is a pretty
> elegant method:
>
> > se
think of.
>
> On 2012-11-22 10:01 AM, "Neil Tompkins"
> wrote:
>
> Michael,
>
> Thanks this kind of works if I'm checking two types. But what about if I
> have 5 types ?
>
> On Thu, Nov 22, 2012 at 2:53 PM, Michael Dykman wrote:
>
>> >
>&
ave to go the JOIN route
>
> select distinct a.id from mytable a
> inner join mytable b on (a.id=b.id)
> where a.type= 2 and b.type = 5;
>
> - michael dykman
>
> On Thu, Nov 22, 2012 at 9:30 AM, Neil Tompkins
> wrote:
> > Hi,
> >
> > I'm strugglin
; U can remove the type field it will work
> On Nov 22, 2012 8:21 PM, "Neil Tompkins"
> wrote:
>
>> Basically I only what to return the IDs that have both types.
>>
>>
>> On Thu, Nov 22, 2012 at 2:39 PM, marek gutowski > >wrote:
>>
Basically I only what to return the IDs that have both types.
On Thu, Nov 22, 2012 at 2:39 PM, marek gutowski wrote:
> SELECT DISTINCT id FROM table WHERE type IN ('2','5')
>
> should work
>
>
> On 22 November 2012 14:30, Neil Tompkins wrote:
>
>>
Hi,
I'm struggling with what I think is a basic select but can't think how to
do it : My data is
id,type
1000,5
1001,5
1002,2
1001,2
1003,2
1005,2
1006,1
>From this I what to get a distinct list of id where the type equals 2 and 5
Any ideas ?
Neil
Hi,
Is there such a way in a MySQL query to extract the text "this is a test"
from the following strings as a example
http://www.domain.com/"; class="link">this is a
test
http://www.domain.com/"; title="this is a test"
class="link">link
Thanks
Neil
At the moment im concentrating on london postal codes but future would be us
zip codes too
On 24 Apr 2012, at 18:09, Rick James wrote:
> Please be more precise about the rules. In the US, "12345-6789" would become
> "12345". This would follow a different rule.
>
> Is your rule "stop after t
Hi
I am trying to get some background information with regards the design. I have
a fair idea but would like advice from anyone that has previously worked on
similar projects.
On 20 Feb 2012, at 17:22, Jan Steinman wrote:
> Where are your domain experts? You *are* consulting with them, no
two dbs should be the same have
> you
> checked that they actually are set to the same?
>
>
>
>
> On Monday, November 21, 2011 9:20:10 PM Neil Tompkins wrote:
>> MySQL workbench
>>
>> On 21 Nov 2011, at 13:36, Chris Tate-Davies
> wrote:
>>>
MySQL workbench
On 21 Nov 2011, at 13:36, Chris Tate-Davies
wrote:
> What are you using to view the data?
>
>
>
> On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote:
>> ;>>> 2011/11/20 20:27 +, Tompkins Neil
>> Does anyone know why Chinese characters are not displaying correctly
We are running MySQL 5.1.46 with master to master replication with 3 other
servers for 3 different websites in 3 different parts of the world.
My question is how often should we be looking to upgrade our MySQL version
considering we can't really afford any downtime.
Thanks
Neil
--
MySQL Genera
Try the MySQL workbench software
On 14 Oct 2011, at 19:12, AndrewMcHorney wrote:
> Hello
>
> I just downloaded the MySql server software. I am now looking for software
> that is gui based and will allow me to easily define a database, create
> tables and to do updates of records within the t
In this instance would you create four indexes key(a) key(b) key(a,b) key (b,a)
? Or is the decision based on the query response time ?
On 11 Oct 2011, at 13:40, Rik Wasmus wrote:
>> Next question. If you have the two separate indexes and then do two
>> queries, one for a and one for b. If you
Just to clarify having key indexes of (a,b) or (b,a) have no difference ?
On 11 Oct 2011, at 09:36, Johan De Meersman wrote:
> - Original Message -
>> From: "Alex Schaft"
>>
>> If you have a table with columns A & B, and might do a where on A or
>> B, or an order by A, B, would single
> As per the subject we've a large insert query that gives up the error MySQL
> server has gone away when we try to execute it. Any ideas why ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
> optimal. You need at look at the queries you intend to run against the
> system and construct indexes which support them.
>
> - md
>
> On Thu, Oct 6, 2011 at 2:35 PM, Neil Tompkins
> wrote:
> Maybe that was a bad example. If the query was name = 'Red'
;>> Just remember that idx_a(field_a,field_b) is not the same, and is not
>>>>> considered for use, the same way as idx_b(field_b,field_a).
>>>>>
>>>>> -NT
>>>>>
>>>>>
>>>>> Em 07-10-2011 00:22, Michae
Maybe that was a bad example. If the query was name = 'Red' what index should
I create ?
Should I create a index of all columns used in each query or have a index on
individual column ?
On 6 Oct 2011, at 17:28, Michael Dykman wrote:
> For the first query, the obvious index on score will give
Can anyone help me ?
Begin forwarded message:
> From: Tompkins Neil
> Date: 30 September 2011 20:23:47 GMT+01:00
> To: mark carson
> Cc: "[MySQL]"
> Subject: Re: Slow query - please help
>
> I downloaded version mysql-5.6.2-m5-win32.msi and he table definitions are
> below, let me know if
Am thinking now that it might be best to use MySQL 5.6 as this is a new project
still in development and we will have the new FullText Search with Innodb
On 29 Sep 2011, at 18:43, Andrew Moore wrote:
> Hey Neil, I read your question too quickly and jumped to the conclusion you
> weren't sure M
I'm not sure it would work in my environment of IIS and MySQL ?
On 29 Sep 2011, at 20:10, mos wrote:
> Derek is right. The Sphynx search engine is much faster than MyISAM's full
> text search engine. It will work on InnoDb tables so you don't have to export
> the data to MyISAM.
>
> Mike
>
>
But I could create an additional myisam table to overcome my problem providing
I can get the data to synchronise between the two tables
On 29 Sep 2011, at 18:16, Reindl Harald wrote:
> so mysql is currently the wrong database for your project
> sad but true, you can not have fulltext-search and
Hi Shawn
Thanks for your response. In your experience do you think I should
still retain the data used to generate the computed totals ? Or just
compute the totals and disregard the data used ?
Regards
Neil
On 8 Oct 2010, at 19:46, "Shawn Green (MySQL)"
wrote:
Hi Neil,
On 10/5/2010
Neil
On Mon, Oct 4, 2010 at 3:38 PM, Joerg Bruehe
wrote:
Hi!
Neil Tompkins wrote:
Thanks for your reply. So should we create individual indexes on
each
field or a multiple column index ??
This question cannot be answered without checking and measuring your
installation. The decision wh
Following on from my previous email I have columns containing numbers
which are then used in SUM and MIN/ MAX functions should these be
indexed too ?
On 3 Oct 2010, at 16:44, Joerg Bruehe wrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes for example field_1, fie
Thanks for your reply. So should we create individual indexes on each
field or a multiple column index ??
On 3 Oct 2010, at 16:44, Joerg Bruehe wrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes for example field_1, field_2 and
field_3
etc and then perform a s
Thanks for all the useful information. I'm going to ensure the
relevant fields are indexed and our db is optimised.
On 4 Sep 2010, at 16:10, Arthur Fuller wrote:
100% agreed.
Arthur
The other exception is also where financial data is being stored. If
you
have, say, a database containi
Hi
I've a soccer application consisting of managers, teams players and
fixtures/results. Basically each manager will get points for each game
which will depend on the result.
What would be the best table design bearing in mind that a manager can
move to a different club.
My thought was
Carl you don't wish go offer so sample code ?
On 19 Aug 2010, at 19:18, "Carl" wrote:
I have written this in both C and Java. It is very complex as, in
real
life, you want to balance home and away, sequence the games so that
the home
or away games are spread throughout the schedule, accom
Thanks for the useful information. This is the answer I was. Looking
for.
Neil
On 22 Jul 2010, at 22:25, "Jerry Schwartz" wrote:
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, July 22, 2010 4:50 PM
To: Jerry Schwartz
Cc: Shawn Green (MySQL); mysql@lists.mysql.com
also needs to be updated when your data changes.
On Thu, Jul 8, 2010 at 11:25 PM, Neil Tompkins > wrote:
How many indexes are recommended per table ??
On 7 Jul 2010, at 06:06, "Octavian Rasnita" > wrote:
Hi,
MySQL can use a single index in a query as you've seen in th
How many indexes are recommended per table ??
On 7 Jul 2010, at 06:06, "Octavian Rasnita" > wrote:
Hi,
MySQL can use a single index in a query as you've seen in the result
of explain.
Of course it is better to have an index made of 2 or more columns
because it will match better the quer
We are looking to install on windows.
Sent from my iPod
On 11 Oct 2009, at 18:02, muhammad subair wrote:
Hi,
Maybe, first you can check MySQL documentation [0], [1]
[0] http://dev.mysql.com/doc/refman/5.0/en/secure-using-ssl.html
[1] http://dev.mysql.com/doc/refman/5.0/en/secure-basics.htm
Hi, I've the following table design (attached txt file, for some reason the
content was being blocked) and I'd like any advice if this is the correct
method/design.
Thanks for any comments. Neil
_
Play and win great prizes with Li
4 -0500> From: [EMAIL PROTECTED]> To: [EMAIL
> PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: replace chr(10) in field>
> > Neil Tompkins wrote:> > Hi,> > > > I've got some data in our fields which
> contain a carriage return 'chr(10)',
o: [EMAIL
> PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: replace chr(10) in field>
> > Neil Tompkins wrote:> > Hi,> > > > I've got some data in our fields which
> contain a carriage return 'chr(10)', as saved using a ASP page. I
Hi,
I've got some data in our fields which contain a carriage return 'chr(10)', as
saved using a ASP page. I'm now trying to extract the information from a
different system, however the saved chr(10) are showing as binary values.
What would be the best way for my to replace chr(10) to a \n ?
le, which you can get (on
> Linux) using the commands:> > # glib-config --cflags> # glib-config --libs> >
> Ben> > Neil Tompkins wrote:> > Thanks Ben, but I don't appear to have the
> header file in my > > libraries.> > > > Neil> > > &
out there...> > Also ensure the correct
> include and link directives are in your > Makefile, which you can get (on
> Linux) using the commands:> > # glib-config --cflags> # glib-config --libs> >
> Ben> > Neil Tompkins wrote:&
to us as well. ))Let me know if you have any
questions.Standing by and I hope this helped you.Sincerely,Craig Huffstetlerxq
on FreeNode #mysql | #apache
On Wed, May 14, 2008 at 6:13 AM, Neil Tompkins <[EMAIL PROTECTED]> wrote:
Hi,When performing a SQL query like SELECT Name FROM Customers
Hi,
When performing a SQL query like SELECT Name FROM Customers. How do I obtain
the time in which the query took to execute like 1.5 seconds etc
Thanks,
Neil
_
All new Live Search at Live.com
http://clk.atdmt.com/UKM/go/msnnkm
Perfect. It worked just how I wanted.
Thanks for your help.
Neil
> Date: Wed, 7 May 2008 19:54:39 +0200> To: [EMAIL PROTECTED]> Subject: Re:
> Order Problem> From: [EMAIL PROTECTED]> > Hi,> > You should look at the
> `FIND_IN_SET` function here: >
> http://dev.mysql.com/doc/refman/5.0/en
Hi All,
I've the following query :SELECT ProductID FROM Products WHERE Enabled= ' Yes'
AND ProductID IN(varProductID)
This query works fine. However the query result is in a different order to
what I passed in varProductID.
How can I order the results based on my list like
varProductI
=
ProductsPurchases.ProductIDGROUP BY Products.ProductID ORDER BY varProductCount
DESC
> Date: Thu, 20 Mar 2008 13:08:51 +0100> From: [EMAIL PROTECTED]> CC:
> mysql@lists.mysql.com> Subject: Re: ORDER BY calculated field> > Neil
> Tompkins schrieb:> > Thanks Sebastian, but I now get the
ian
> Mendel schrieb:> > Neil Tompkins schrieb:> >> Hi> >> > >> I want to order by
> the totalled fields varProductCount and > >> Products.ProductReviewDESC> > >
> > just put them together, separated with comma, like it is writt
Hi
I want to order by the totalled fields varProductCount and
Products.ProductReviewDESC
Neil
> Date: Thu, 20 Mar 2008 11:36:30 +0100> From: [EMAIL PROTECTED]> To:
> mysql@lists.mysql.com> Subject: Re: ORDER BY calculated field> > Neil
> Tompkins schrieb:> >
Hi,
How do I achieve a SQL statement to order my results based on two calculated
fields for example :
SELECT COUNT(ProductsPurchases.ProductID) as varProductCount, Products.Name,
Products.ProductReview
FROM ProductsPurchasesINNER JOIN Products ON Products.ProductID =
ProductsPurchases.Produc
Hi,
I have a table of records all of which have a timestamp against them like
2007-10-25 10:10:19, and category like red, blue etc and a unique key.
Using a SELECT statement is it possible to retrieve the count and number of
records for each day e.g 2007-10-25 for all red, and all blue etc
Hi
I've the following process/queries which I want to speed up, for a product
inventory/warehouse which we have a number of items available to sell each day
For Each Company
For Each Product
For Next 7 Days
CheckQuantityUpdateQuantity
Next Day
Next Product
Nex
Hi
I'm looking to design a hotel reservation/availability system to be used
online. Has anyone had any experience with regards table / database design ?
Thanks
Neil
_
100’s of Music vouchers to be won with MSN Music
https://www.mus
I'm using ASP. Do you know any resources that I could use ?
From: "Wm Mussatto" <[EMAIL PROTECTED]>
To: "Neil Tompkins" <[EMAIL PROTECTED]>
Subject: Re: ENCODE() and DECODE()
Date: Mon, 12 Mar 2007 15:27:26 -0700 (PDT)
On Mon, March 12, 2007 15:05, Nei
Do you think these functions would be ideal for my requirements in terms of
encrypting credit card numbers when stored in a database ?
From: "Wm Mussatto" <[EMAIL PROTECTED]>
To: "Neil Tompkins" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: ENC
I've been researching the best method to store credit card numbers in a
database which are saved encrypted. My version of mysql is 3.23 therefore I
think the only function I could use is
ENCODE() and DECODE().
I've tried these functions and they appear to work as I want. I've a couple
of qu
I just tried and it appears the functions DO NOT work in version 3.23
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: FW: Re: MD5()
Date: Mon, 12 Mar 2007 09:28:27 +
I thought the DES_ENCRYPT/DES_DECRYPT functions were released in mysql
v
I thought the DES_ENCRYPT/DES_DECRYPT functions were released in mysql
version 4 however they work with my version of mySQL 3.23 ?
Neil
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: FW: Re: MD5()
Date: Sat, 10 Mar 2007 18:24:19 +
Strange
Strange the DES_ENCRYPT/DES_DECRYPT functions work with my version of mySQL
3.23
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 18:20:43 +
DES_ENCRYPT/DES_DECRYPT appears to be what we
DES_ENCRYPT/DES_DECRYPT appears to be what we require.
Thanks
Neil
From: "Mogens Melander" <[EMAIL PROTECTED]>
To: "Neil Tompkins" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 12:19:53 +0100 (CET)
Or you might wa
The problem I have is our mysql database version is 3.23 and we are not in a
position to upgrade.
From: "Ian P. Christian" <[EMAIL PROTECTED]>
To: Neil Tompkins <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 10:24:45 +
Neil
What do you recommend I use ?
From: "Ian P. Christian" <[EMAIL PROTECTED]>
To: Neil Tompkins <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: MD5()
Date: Sat, 10 Mar 2007 10:18:41 +
Neil Tompkins wrote:
I'm looking to use MD5() to encrypt cre
I'm looking to use MD5() to encrypt credit card numbers. How do I unencrypt
this when reading the value ?
Thanks,
Neil
_
Get Hotmail, News, Sport and Entertainment from MSN on your mobile.
http://www.msn.txt4content.com/
--
M
I've been using the MATCH() with FullText Scoring for quite a while now on
one table. I now need to combine the data from another database. I have :
Database1.Table1
with
Database2.Table1
If I use the the FullText scoring using just one database/table it is OK,
but when I query the databas
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Neil Tompkins schrieb:
> Not sure if this is possible or not. But I've two identical tables in
> two different databases. Is it possible to retrieve data from the
> different tables in one query ?
(SELECT * FROM db1.table) UNION (SELECT
abases
Date: Thu, 25 Jan 2007 12:01:48 +0100
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Neil Tompkins schrieb:
> Not sure if this is possible or not. But I've two identical tables in
> two different databases. Is it possible to retrieve data from the
> different tables in one qu
1 - 100 of 151 matches
Mail list logo
