Robert MannI wrote:
Hello!
I have three tables, mapping out a n:n relationship of authors and the
books they worked on:
table 1: authors (id, name)
table 2: authorships (author_id, book_id)
table 3: books (id, name, bestseller tinyint)
Here's two different queries I want to run:
1. Select eac
Hello!
I have three tables, mapping out a n:n relationship of authors and the
books they worked on:
table 1: authors (id, name)
table 2: authorships (author_id, book_id)
table 3: books (id, name, bestseller tinyint)
Here's two different queries I want to run:
1. Select each author, and how man
This worked --
To fix the mySQL socket error, start mysql in terminal by doing this...
sudo /usr/local/mysql/bin/safe_mysqld
close Terminal, then open it again and put in these two...
sudo mkdir /var/mysql/
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
Restart Apache
Should work until they
Hi There,
Has anyone been successful installing and running MySQL (current
version) on the new Mac OS (Leopard)?
__
Craig Hoffman
iChat/AIM: m0untaind0g
__
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
If you are going to rely on obfuscation to protect valuable data, you might
want to consider not posting the particular method you will use on a public
mailing list.
I think any method you implement will lower the overall security of the system.
But, if you must search for encrypted text, you
I also need to protect a couple dozen Float fields and thought I could
obscure them a bit by adding an offset to them based on an encrypted id
stored with each row. It is not going to be as good as encryption but
will help to obfuscate the data.
How much will obfuscation save you? Are you sav
At 01:47 PM 10/26/2007, you wrote:
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> [EMAIL PROTECTED] wrote:
> > mos wrote:
> >>
> >> The data is quite valuable because there is a lot of competition in
> >> this particular marketplace and my competitors would like to get their
> >> hand
At 12:31 PM 10/26/2007, you wrote:
[EMAIL PROTECTED] wrote:
mos wrote:
The data is quite valuable because there is a lot of competition in this
particular marketplace and my competitors would like to get their hands
on it. I've spent 5 years writing the software and generating the data.
Le
On 10/24/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Gerard wrote:
> > Currently I am running a concat statement to combine a field with a user
> > name and domain to create and email address. In testing it looks like
> > running the concat is a very slow command to run. The select stateme
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> [EMAIL PROTECTED] wrote:
> > mos wrote:
> >>
> >> The data is quite valuable because there is a lot of competition in
> >> this particular marketplace and my competitors would like to get their
> >> hands on it. I've spent 5 years writing
[EMAIL PROTECTED] wrote:
mos wrote:
The data is quite valuable because there is a lot of competition in
this particular marketplace and my competitors would like to get their
hands on it. I've spent 5 years writing the software and generating
the data. Let's say for the sake of argument the
mos wrote:
The data is quite valuable because there is a lot of competition in this
particular marketplace and my competitors would like to get their hands
on it. I've spent 5 years writing the software and generating the data.
Let's say for the sake of argument the data is worth $1 million.
Ian,
At 09:36 AM 10/26/2007, you wrote:
On 26 Oct 2007 at 9:17, mos wrote:
> I posted this message twice in the past 3 days, and it never gets on the
> mailing list. Why?
> Here it is again:
>
> I have a Text field that contains paragraph text and for security
reasons I
> need to have it encr
Rob Wultsch wrote:
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Aaron Fischer wrote:
Thanks Peter and Baron, these both worked well.
The "left join on" took .1919 seconds and the "left outer join as" took
.1780 seconds.
They are synonymous in MySQL. The only difference is 6 extra c
Aaron
>The "left join on" took .1919 seconds and the "left outer join as"
took .1780 seconds.
Caching :)
PB
-
Aaron Fischer wrote:
Thanks Peter and Baron, these both worked well.
The "left join on" took .1919 seconds and the "left outer join as"
took .1780 seconds.
=)
On Oct 26,
Caleb Racey wrote:
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Caleb Racey wrote:
It is indeed buggy and badly documented. It depends on the current
database's character set instead. Try this:
SET NAMES utf8;
SET character_set_database=utf8;
LOAD DATA INFILE...
Baron
Thanks for
On 10/26/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
>
> Aaron Fischer wrote:
> > Thanks Peter and Baron, these both worked well.
> >
> > The "left join on" took .1919 seconds and the "left outer join as" took
> > .1780 seconds.
>
> They are synonymous in MySQL. The only difference is 6 extra ch
Aaron Fischer wrote:
Thanks Peter and Baron, these both worked well.
The "left join on" took .1919 seconds and the "left outer join as" took
.1780 seconds.
They are synonymous in MySQL. The only difference is 6 extra characters
in the query text. The difference was probably due to caches.
Aaron Fischer wrote:
Greetings!
I have a problem that it seems would best be solved using subqueries.
However, I am working on a server that is running MySQL 3.23.58, so
subqueries are not available to me.
What I am trying to do:
I have two tables, each containing approximately 37,000 rec
Thanks Peter and Baron, these both worked well.
The "left join on" took .1919 seconds and the "left outer join as"
took .1780 seconds.
=)
On Oct 26, 2007, at 11:37 AM, Peter Brawley wrote:
Aaron
An exclusion join:
SELECT a.col
FROM a
LEFT JOIN b ON a.col=b.col
WHERE b.col IS NULL;
PB
Aaron
An exclusion join:
SELECT a.col
FROM a
LEFT JOIN b ON a.col=b.col
WHERE b.col IS NULL;
PB
Aaron Fischer wrote:
Greetings!
I have a problem that it seems would best be solved using subqueries.
However, I am working on a server that is running MySQL 3.23.58, so
subqueries are not avai
Aaron Fischer wrote:
Greetings!
I have a problem that it seems would best be solved using subqueries.
However, I am working on a server that is running MySQL 3.23.58, so
subqueries are not available to me.
What I am trying to do:
I have two tables, each containing approximately 37,000 recor
Greetings!
I have a problem that it seems would best be solved using
subqueries. However, I am working on a server that is running MySQL
3.23.58, so subqueries are not available to me.
What I am trying to do:
I have two tables, each containing approximately 37,000 records. I
want to com
I don't think it will be any better to count distinct values. I think
the query is just slow because the index lookups are slow. Is the
'word' column really 150 bytes? That's probably the culprit. How slow
is this, by the way? 370k rows in one table, verifying the
non-existence of index re
Caleb Racey wrote:
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql b
Caleb Racey wrote:
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql b
On 26 Oct 2007 at 9:17, mos wrote:
> I posted this message twice in the past 3 days, and it never gets on the
> mailing list. Why?
> Here it is again:
>
> I have a Text field that contains paragraph text and for security reasons I
> need to have it encrypted. If I do this, how can I still imple
I posted this message twice in the past 3 days, and it never gets on the
mailing list. Why?
Here it is again:
I have a Text field that contains paragraph text and for security reasons I
need to have it encrypted. If I do this, how can I still implement full
text search on it?
Also, I have a lo
Does anyone know how to get the load data infile command to load utf8 data?
I have setup a database as utf8 with a collation of utf8_general_ci, the
mysqld server is started with --character-set-server=utf8. Server variables
say character_set_database = utf8. I use the sql below
LOAD DATA INFIL
29 matches
Mail list logo
