Hi all,
I have a table shares that consists of
company id, shareholder id, shareholder name.
Company id and shareholder id are decimal digits; shareholder name is text.
Due to some missings of my initial data, I'd like to create a unique id for
the shareholder ids
which are blank/null in the
Hi, Dmitriy, Vladimir!
On 19 Sep 2007, at 07:40, Vladimir Shebordaev wrote:
Hi, Dmitriy,
would you please specify when you get those reconnects?
The Linux connect() system call on non-blocking AF_UNIX sockets
should return immediately with EAGAIN when the peer's backlog queue
is full.
Hi everyone,
Just getting into database stuff a little bit, and wanted to double
check something with you guys.
I have a database, which has 2 tables, I have created a user using
this syntax: grant select, update, delete on dbname.table to
'me'@'localhost' identified by 'mypass';
then
Kevin,
To link articles keywords wouldn't you want a table like this?
CREATE table articles_keywords(
AK_id int auto_increment PRIMARY KEY,
AK_article_id int NOT NULL,
AK_keyword_id int NOT NULL
);
I don't understand why you want the sort of 'dynamic table' you describe.
PB
-
Kevin
It's been a few years since I did any regex queries, but I swear I used
to be able to do something like:
SELECT fieldname FROM tablename WHERE field RLIKE '(^|\|)2(\||$)';
And that would find '2', with an optional '|' at the beginning, or at
the beginning of the line, and an optional '|' or
Howdy,
I'm trying to add a second slave, slave2, running MySQL 5.0.22 on CentOS 5
to our system that currently has one master and one slave, slave1, running
4.0.24, and somehow slave2 somehow ends up with too many records in many
of the 30 tables in the database.
Steps taken:
1. Stopped
Hi,
[EMAIL PROTECTED] wrote:
Howdy,
I'm trying to add a second slave, slave2, running MySQL 5.0.22 on CentOS 5
to our system that currently has one master and one slave, slave1, running
4.0.24, and somehow slave2 somehow ends up with too many records in many
of the 30 tables in the
Robert DiFalco wrote:
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
Hi,
[EMAIL PROTECTED] wrote:
Howdy,
I'm trying to add a second slave, slave2, running MySQL 5.0.22 on CentOS
5
to our system that currently has one master and one slave, slave1,
running
4.0.24, and somehow slave2 somehow ends up with too many records in
many
of the 30 tables in the
Hi.
I've got this table in mySQL:
item 1:
-- firstname: John (Johnie)
-- phone: 555-600-200
item 2:
-- firstname: Peter
-- phone: 555-300-400
I created this SQL query to find 'johnie':
SELECT friends.id FROM friends WHERE ((friends.firstname LIKE '%
johnie %' OR
At 19:34 +0200 19/9/07, thomas Armstrong wrote:
I've got this table in mySQL:
item 1:
-- firstname: John (Johnie)
-- phone: 555-600-200
item 2:
-- firstname: Peter
-- phone: 555-300-400
I created this SQL query to find 'johnie':
SELECT friends.id FROM friends WHERE
You are putting a space between johnie and the % wildcards. That space is
not ignored, it is part of the pattern. LIKE %johnie% will find every
occurrence of johnie no matter what surrounds it.
If you need something more complicated, such as only ignoring (, then you
need to get more complicated.
Maybe I missed this in the text below, but are you trying to daisy
chain the slaves (master - slave 1 - slave 2) or have multiple slaves
connecting to one master?
Is slave 1 configured with log-slave-updates?
Regards,
Scott
On Wed, 2007-09-19 at 12:31 -0500, [EMAIL
Looking for the OS X 4.1 binary package installer, I can not seem to locate
this on the site, I just find a source style, and a tar style. I am pretty
sure in the past, I was able to have a double clickable installer, and it
had a preference pane for starting and stopping the service.
--
14 matches
Mail list logo