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
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
ri, 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. You can see below, that my machine shut down normally, yet when
>>
urrent database, 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 resto
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 mdyk...@gmail.com wrote:
Please gentlemen,
It is a valid question if a somewhat hackneyed one.
MySQL continues to live
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
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 shawn.l.gr...@oracle.comwrote:
Hi,
On 10/29/2013 9:52 PM, h...@tbbs.net wrote:
2013/10/29 11:35
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
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 shawn.l.gr...@oracle.comwrote:
Hello Neil,
On 10/28/2013 2:06 PM, Neil Tompkins wrote:
Hi
If I have
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
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
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
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 ?
Any advice anyone ?
-- Forwarded message --
From: Neil Tompkins neil.tompk...@googlemail.com
Date: Thu, May 30, 2013 at 8:27 AM
Subject: Audit Table storage for Primary Key(s)
To: [MySQL] mysql@lists.mysql.com
Hi,
I've created a Audit table which tracks any changed fields
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 cars...@bitbybit.dkwrote:
On 30-05-2013 09:27, Neil Tompkins wrote:
Hi,
I've created a Audit table which
) 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 Tompkins wrote:
Thanks for your response. We expect to use the Audit log when looking
into
exceptions
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
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,
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
:
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 wrote:
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
* FROM tempHotelRateAvailability;
On Wed, May 29, 2013 at 2:57 PM, Ananda Kumar anan...@gmail.com wrote:
did u check if data is getting inserted into tempHotelRateAvailability
On Wed, May 29, 2013 at 7:21 PM, Neil Tompkins
neil.tompk...@googlemail.com wrote:
This is my Trigger which doesn't
goes not 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 Query Editor
CREATE TEMPORARY TABLE
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
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 i...@it.myjobgroup.co.ukwrote:
BOOLEAN is a synonym for TINYINT(1) in MySQL:
http://dev.mysql.com/doc/refman/5.6/en/numeric-type-overview.html
On 22 May 2013 17:55, 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 shawn.l.gr...@oracle.com wrote:
Hello Neil,
On 5/22/2013 1:05 PM, Neil Tompkins wrote:
Hi, Like the link states
For clarity
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
that FOREIGN KEYs are
implemented?
-Original Message-
From: Neil Tompkins [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, May 01, 2013 5:53 AM
To: [MySQL]
Subject: Adding language support to tables
Hi,
I've the following database structure of 4 tables
-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 deploying MySQL in the Cloud with two MySQL servers with master to
master replication i have a good failover solution
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
?
Same with regions/states and cities and districts ?
On Sun, Apr 21, 2013 at 9:28 AM, Denis Jedig d...@syneticon.net 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 foreign key
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
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
Basically I only what to return the IDs that have both types.
On Thu, Nov 22, 2012 at 2:39 PM, marek gutowski marek.gutow...@gmail.comwrote:
SELECT DISTINCT id FROM table WHERE type IN ('2','5')
should work
On 22 November 2012 14:30, Neil Tompkins neil.tompk...@googlemail.comwrote:
Hi
...@gmail.com wrote:
U can remove the type field it will work
On Nov 22, 2012 8:21 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
Basically I only what to return the IDs that have both types.
On Thu, Nov 22, 2012 at 2:39 PM, marek gutowski marek.gutow...@gmail.com
wrote:
SELECT DISTINCT
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
neil.tompk...@googlemail.com 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
think of.
On 2012-11-22 10:01 AM, Neil Tompkins neil.tompk...@googlemail.com
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 mdyk...@gmail.com wrote:
response did not go
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 mdyk...@gmail.com wrote:
Assuming that (id,type) is unique in the source data, that is a pretty
elegant
When trying this query I get
FUNCTION id does not exist
On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman mdyk...@gmail.com wrote:
select id from
(select distinct id, count(*)
from my_table
where type in (2,5)
group by id
having count(*) = 2)a;
Ignore that it does work fine. Sorry
On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman mdyk...@gmail.com 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
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 mdyk...@gmail.com wrote:
Assuming that (id,type) is
imagine counting the parameters in the code
being so hard.
Cheers
Claudio
On 22 November 2012 15:01, Neil Tompkins neil.tompk...@googlemail.com
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
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
stronga href=http://www.domain.com/; class=linkthis is a
test/a/strong
stronga href=http://www.domain.com/; title=this is a test
class=linklink/a/strong
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 rja...@yahoo-inc.com 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
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 j...@bytesmiths.com wrote:
Where are your domain experts? You *are*
of the 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
chris.tatedav...@inflightproductions.com wrote:
What are you using to view
MySQL workbench
On 21 Nov 2011, at 13:36, Chris Tate-Davies
chris.tatedav...@inflightproductions.com 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
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
Try the MySQL workbench software
On 14 Oct 2011, at 19:12, AndrewMcHorney andrewmchor...@cox.net 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
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 vegiv...@tuxera.be wrote:
- Original Message -
From: Alex Schaft al...@quicksoftware.co.za
If you have a table with columns A B, and might do a where on A or
B, or
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 r...@grib.nl wrote:
Next question. If you have the two separate indexes and then do two
queries, one for a and one for
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
Em 07-10-2011 00:22, Michael Dykman escreveu:
Only one index at a time can be used per query, so neither strategy is
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
. 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 neil.tompk...@googlemail.com
wrote:
Maybe that was a bad example. If the query was name = 'Red' what index
should I create
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 mdyk...@gmail.com wrote:
For the first query, the obvious index
Can anyone help me ?
Begin forwarded message:
From: Tompkins Neil neil.tompk...@googlemail.com
Date: 30 September 2011 20:23:47 GMT+01:00
To: mark carson mcar...@pixie.co.za
Cc: [MySQL] mysql@lists.mysql.com
Subject: Re: Slow query - please help
I downloaded version
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 h.rei...@thelounge.net wrote:
so mysql is currently the wrong database for your project
sad but true, you can not
I'm not sure it would work in my environment of IIS and MySQL ?
On 29 Sep 2011, at 20:10, mos mo...@fastmail.fm 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.
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 eroomy...@gmail.com wrote:
Hey Neil, I read your question too quickly and jumped to the conclusion
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)
shawn.l.gr...@oracle.com wrote:
?
Regards
Neil
On Mon, Oct 4, 2010 at 3:38 PM, Joerg Bruehe
joerg.bru...@oracle.comwrote:
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
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 joerg.bru...@oracle.com wrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes for example field_1, field_2 and
field_3
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 joerg.bru...@oracle.com wrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes
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 fuller.art...@gmail.com wrote:
100% agreed.
Arthur
The other exception is also where financial data is being stored. If
you
have,
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 c...@etrak-plus.com 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
Thanks for the useful information. This is the answer I was. Looking
for.
Neil
On 22 Jul 2010, at 22:25, Jerry Schwartz je...@gii.co.jp wrote:
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, July 22, 2010 4:50 PM
To: Jerry Schwartz
Cc: Shawn Green (MySQL);
How many indexes are recommended per table ??
On 7 Jul 2010, at 06:06, Octavian Rasnita octavian.rasn...@ssifbroker.ro
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
, but every
index also needs to be updated when your data changes.
On Thu, Jul 8, 2010 at 11:25 PM, Neil Tompkins neil.tompk...@googlemail.com
wrote:
How many indexes are recommended per table ??
On 7 Jul 2010, at 06:06, Octavian Rasnita octavian.rasn...@ssifbroker.ro
wrote:
Hi,
MySQL
We are looking to install on windows.
Sent from my iPod
On 11 Oct 2009, at 18:02, muhammad subair msub...@gmail.com 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]
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
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'm now
trying to extract the information from a different system, however the saved
chr(10) are showing as binary values
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
. ))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. How do I
obtain
are in your Makefile, 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 glib.h in my libraries.Neil
--libs
Ben Neil Tompkins wrote: Thanks Ben, but I don't appear to have the
header file glib.h in my libraries.Neil
Date: Wed, 14 May 2008 12:39:09 +0100 From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED
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
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'm now
trying to extract the information from a different system, however the saved
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:
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
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 =
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
Thanks Sebastian, but I now get the error message
[MySQL][ODBC 3.51 Driver][mysqld-3.23.58]Invalid use of group function
Date: Thu, 20 Mar 2008 12:59:22 +0100 From: [EMAIL PROTECTED] To:
mysql@lists.mysql.com Subject: Re: ORDER BY calculated field Sebastian
Mendel schrieb: Neil
=
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 error message
[MySQL][ODBC 3.51
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'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
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
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, Neil Tompkins said:
Do you think these functions
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 the DES_ENCRYPT
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
version 4 however
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
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: ENCODE() and DECODE()
Date: Mon, 12 Mar 2007
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/
--
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 credit card numbers. How do I
unencrypt
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 Tompkins wrote:
What do you
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 want to take a look at DES_ENCRYPT
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 require.
Thanks
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
: 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 query ?
(SELECT * FROM db1
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 * FROM db2.table)
If db2
1 - 100 of 150 matches
Mail list logo
