Is there a simple way to encrypted data as it's being stored in a
table? And then easily decrypted when it's queried?
Sample syntaxs if available - thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
If I have 4 Fields (FIELD1, FIELD2, FIELD3 FIELD4)
I can do this easily;
UPDATE TABLE_NAME SET FIELD4 = FIELD1;
But -- how do I do it so that FIELD4 = FIELD1 FIELD2 ??? I can't seem
to find any examples online. Maybe it's just too early in the morning -
I'm drawing a blank! ;)
Is there a way to export the results to a text file (comma-delimited
preferred)...
ie, SELECT * FROM TABLE test.txt ; (obviously this doesn't work) :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
If I have about 2Gb of raw text data to import everyday -- can I expect
that to take up about 2Gb in a mySQL database ... slightly more.. double?
Pretend there's no indexes for now.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I've been given some Oracle table dumps that are NOT plain text
delimited. I've been asked to look at using sqlloader to get the file
into my mysql database.
Does this exist for mysql?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I have some data that has been dumped from Oracle into what appears to
be a proprietary text file... It is not delimited into a format that I
can just import into mysql (easily). The IT guy has provided me an
outline of the dump..
ie;
SQL describe isup051024;
Name
It's possible that Gabe's mail spool is full, and he is not receiving
mail - including our responses.
Gabriel - if you are receiving any messages directly sent to you -
please respond to the list to rule that out.
If no responses are made to any of either directly or through the list,
If I have a table with fields
ID, NAME, VALUE
and they may be populated like
1, SHAWN, APPLE
2, TOM, BANANA
3, SHAWN, BANANA
4, JACK, GRAPES
5, TOM, APPLE
6, SHAWN, GRAPES
and I want to query all records showing only the most recent records for
each person
Any thoughts?
--
MySQL General
I'd like to kill 2 birds with one stone...
I'd like to SELECT a set of records (for viewing) and in the same motion
DELETE any that show up.
Can it be done?
Shawn Cummings
Engineering Project Manager
Global NAPs
10 Merrymount Rd
Quincy, MA 02169
Desk 617-507-5150
VoIP 617-507-3550
[EMAIL
select max(comments.commentid) as tagger, comments.commentref,
article.articlesubject, article.articlename, comments.commentfrom from
comments LEFT JOIN article ON comments.commentref=article.articleid GROUP
BY commentref ORDER by tagger DESC;
I have this query above.
I lists comments in
when I do a query is there a way to IGNORE the first X number of returned
records???
For instance I want to see 15 records after the first 50.
Shawn Cummings
Engineering Project Manager
Global NAPs
10 Merrymount Rd
Quincy, MA 02169
Desk 617-507-5150
VoIP 617-507-3550
[EMAIL PROTECTED]
I have a very simple table.
commentid, commentref (each field is an INT)
Each record is a comment... commentid is the ID (each new record is a
higher #).. and the commentref field if the story the comment refers to.
I want to be able to list the stories in order from most recent comment
This doesn't seem to be making sure that the newest commentid is the
result... Seems to be random.
At 09:11 AM 10/6/2003 -0400, you wrote:
try
select commentid, commentref
from comments
ORDER by
commentref ,commentid DESC;
-Original Message-
From: Cummings, Shawn (GNAPs) [mailto
ORDER by
commentref ,commentid DESC;
-Original Message-
From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 2:37 PM
To: [EMAIL PROTECTED]
Subject: sorting/grouping
I have a very simple table.
commentid, commentref (each field is an INT)
Each
If I have 4,000,000 records, and I just want to make sure that the last 100
records do not contain a certain value, ... how can I efficiently 'count'
the number of times in the LAST 100 records that a specific condition exists?
As an example,
mysql select COUNT(*) from Log WHERE
The RAND() syntax does not appear to be working for me.
What version mySQL is required?
At 04:43 PM 1/29/2002 +0200, Michael Widenius wrote:
Hi!
Ulf == Ulf Harnhammar [EMAIL PROTECTED] writes:
Ulf On Sun, 27 Jan 2002, Michael Widenius wrote:
One way to do this is to do as follows:
16 matches
Mail list logo