> I didn't key the placename because they're not guaranteed to be
>unique, but that means that a search for "Artesia" takes many (~30)
>seconds to complete, which is really not very useful.
You should not use the placename as a PRIMARY KEY, but it can still have
an index. You really should add a
Since HEAP tables don't support fulltext indexes, is moving MYISAM
tables to ramdisk an acceptable workaround?
On Sat, 2004-02-21 at 18:35, Mark Maunder wrote:
> I've noticed a 4 times insert speed improvement by moving the MYI index
> file of a myisam table to a ramdisk. The MYD file is still on
Hi, all,
I'm still very much a newbie at MySQL, and thought a good starter project
would be a simple places database of every populated place-name in the world
along with its latitude and longitude. I already have the data, and
originally planned to have only 4 tables with 2-4 fields each:
Pla
Hi,
That's what i thought... but it makes no sense to me... it should be a way
to store data safely using MySQL encryption functions...
In the meantime... what are you using for encryption?
FBR
"Matt W" <[EMAIL PROTECTED]>
22/02/2004 08:24 p.m.
To
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
How do they get hooked up? I think the first two technologies to learn are cgi and
PHP: they are somewhat different approaches, and one should know both if one wants
work.
PHP is probably your easiest first step, as it's really been set-up nicely to handle
this task.
But since you are in skil
Hi,
- Original Message -
From: <[EMAIL PROTECTED]>
Sent: Sunday, February 22, 2004 3:18 PM
Subject: Re: Encryption Issue
> According to documentation there is a "query log" wich logs
established
> connections and executed queries, also there is the "binary log" wich
> stores all stateme
Hello
I am CS student. I want to understand the architecture
and code of MySQL (guess the subjects says it
all)...What do you think will be the best place to
start off?
Any docs on the architecture of MySQL?
Karam
__
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read on
Read a few tutorials on whichever programming language you decide to learn.
PHP works well with MySQL, so does perl and a few other languages.
Personally I would say look in your paper or online for your area and see
what people are looking to hire and then just focus on that language. That
way yo
Those were my exact thoughts being a former cne and msce. I know how to write the
code whatever form I want, web based or standalone, I can also create the necessary
db in mySql but how do they get hooked up?
Walt
- Original Message -
From: "Donny Simonton" <[EMAIL PROTECTED]>
To: "'W
I am setting up a new database with MySQL for the following purposes:
1. Enter information for potential employees like name address email
address employment status, resume, and some more.
2. I am looking to develop build or use something allready developed as
a gui interface to allow users to en
According to documentation there is a "query log" wich logs established
connections and executed queries, also there is the "binary log" wich
stores all statements that changes something (Used for replication)
So... if i do something like
update myTable set field1=AES_ENCRYPT('information'
As a manager of over 20 programmers, I would say from a web point of via PHP
would be your best bet. Everybody who graduates today can program in Java,
and if they don't have any other skills I don't even interview them. I
consider Java programmers to be the MCSE of a few years ago.
Donny
> -
If it weren't for the nasty issue of getting a Java applet to talk to a
form, which is a real pain due to the issue of getting a certificate for
your applet, I'd recommend that because it the whole shebang is pretty
straightforward: write a simple GUI to act as your form, write the code to
access
I recently graduated from college, BS in computer science, I am familiar with a
variety of languages including C++, Java, VB, jscript, perl, cgi and sql. I used VB in
the past for a front end on MS access. I have not yet landed a job so I thought
learning mySql and creating a some sort of form t
Hi,
I have an application working in Windows, developed in VB5 using RDO method
to access data.
I use a parametrised query that is correctly working on e PC with Office97
installed.
When is installed Office2000 I receive the error:
07002:[MYSQL][ODBC 3.51 Driver]
[mysqld-3.23.53 max] SQLBindParame
[EMAIL PROTECTED] wrote:
I would like to encrypt informaton in MySQL DB using the "AES_ENCRYPT"
function, but what if someone looks into the log files?
What ever may be logged by the mysql daemon - I can't believe it loggs
passwords or the stored data itself. So why do you think so?
bye
Fred
16 matches
Mail list logo
