I"m a little confused by the query you posted.. it looks like it would
work, although with many redundant subqueries to get there. From your
requirement, I don't understand why you needs to wrap it in a self-
referencing subquery..
Why does this not give you the same logical value?
selec
are correct... there are always a million things
that could go wrong at runtime. Each of those php mysql_XXX calls will
return a null or false on failure .. if you check every time you will
save yourself a lot of hassle in the long run,
- michael dykman
- [EMAIL PROTECTED]
On Thu, 2006-01
subsequent run of the insert statement. I thought
this odd as I only ran the same statement repeatedly leaving me with
one row ever, but the value updated just fine.
- michael dykman
On Wed, Jan 21, 2009 at 10:54 PM, Ashley M. Kirchner wrote:
>
> Anyone?
>
>
> I'm trying
/en/date-and-time-types.html
You may also save considerable space..
from http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
DATE3 bytes
TIME3 bytes
DATETIME8 bytes
TIMESTAMP 4 bytes
YEAR1 byte
- michael dykman
On Wed, Jan 28, 2009 at 12:31 AM, mos wrote
e going to squeeze out any performance benefit by converting to
int.. you might even lose some ground to the special handling your
date-as-int your app might have to do.
- michael dykman
On Wed, Jan 28, 2009 at 1:30 AM, mos wrote:
> At 11:43 PM 1/27/2009, Michael Dykman wrote:
>>
>&g
o any arbitrary string, so it si inevitable that you will
get unsafe input sooner or later.
- michael dykman
On Sun, Feb 8, 2009 at 12:31 AM, wrote:
> Hello mysql,
>
> On one of my sites, I have a query that logs attempts to access the
> site by potential bad guys. It has been working for
gt; can I expect it? TIA
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
>
>
--
- michael dykman
- mdyk...@gmail.com
- All models are wrong. Some
y different
than the operational business data which is the backbone of our
day-to-day business.
- michael dykman
On Sun, Feb 8, 2009 at 5:51 PM, mos wrote:
> At 11:14 AM 2/8/2009, Michael Dykman wrote:
>>
>> We recently began using infobright in my shop.. reporting queries
>&g
Can anyone help me suggest the right optimization for our company's server.
>
> I suggest High Performance MySQL, Second Edition :-) There's no way
> to really give any good advice without knowing what you use the server
> for.
>
I enthusiastically second that recommenda
ur ordinal field (I use 'ordinal' by convention as
'order' is a SQL keyword)
AUTHORS
- authorid
- name
-- other fields
BOOKS
- bookid
- title
-- other fields
A2B
- bookid
- authorid
- ordinal
--
- michael dykman
- mdyk...@gmail.com
- All models are wrong. Som
On Mon, Feb 16, 2009 at 8:37 PM, PJ wrote:
> Michael Dykman wrote:
>> On Mon, Feb 16, 2009 at 5:20 PM, PJ wrote:
>>
>>> In my db there are a number of books with several authors; so, I am
>>> wondering how to set up a table on books and authors to be able to
>
I work for a high-volume web site and we use nothing but RAID 10 on
all databases which requires a minimum of 4 disks. The write penalty
for raid 5 is just too high for our application. Much of that space
goes unused, but we need the stripe to keep up with the I/O.
- michael dykman
On Sun
7;2')";
>$result2 = mysql_query($sql2, $db);
>
$sql2 = "INSERT INTO authors
(first_name, last_name, ordinal) VALUES
('$first_nameIN', '$last_nameIN', '1'),
('$first_name2IN', '$last_name2IN', '2
tion logs onto separate spindles.. Separate
partitions on the same physical device will be of little-to-no-value.
For systems like Oracle or DB2, this is part of the standard
installation drill. ON MySQL, I do not do this routinely, but I do
when I am expecting high, sustained loads,
--
- mi
changes along the way using a similar slave-driven,
process-as-much-as-you-can-in-advance plan. It was excruciating, but
we pulled it off.
- michael dykman
On Tue, Mar 24, 2009 at 9:38 AM, Craig Dunn wrote:
> Baron Schwartz wrote:
>>
>> If you can't take downtime, I&
ing your report.
--
- michael dykman
- mdyk...@gmail.com
- All models are wrong. Some models are useful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
No include is possible, but this is done pretty routinely:
cat *.sql | mysql ...
- michael dykman
On Wed, Apr 1, 2009 at 10:19 AM, Jørn Dahl-Stamnes
wrote:
> Hello,
>
> After googling for an hour I gave up to find a solution.
>
> Problem: A framework is creating a lot of SQL
No, I'm afraid not.
- michael dykman
On Sat, Apr 18, 2009 at 7:11 AM, Uwe Kiewel wrote:
> Hi,
>
> is it possible to have separated binlogs for each mysql-db?
>
> Thanks,
>Uwe
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.
for binlog-do-db
- michael dykman
On Sat, Apr 18, 2009 at 12:10 PM, Uwe Kiewel wrote:
> Michael Dykman schrieb:
>>
>> No, I'm afraid not.
>
> So, how it's possible to replicate one specific db? I have 4 db's writing
> into binlog. I need only one of th
ommand:
SHOW TABLE STATUS;
I hope this helps.
--
- michael dykman
- mdyk...@gmail.com
- All models are wrong. Some models are useful.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ed ie.
SELECT uuid();
and produces a guaranteed unique 36 character sitrng, but this might
not be very efficient in joins as your dataset grows.
- michael dykman
On Tue, Apr 28, 2009 at 12:59 AM, yuan edit wrote:
> I have a shopping cart table like this:
>
> CREATE TABLE shopping_cart
want
to display it format it for display using LPAD. ie.:
mysql> SELECT lpad(5,8,'0');
+---+
| lpad(5,8,'0') |
+-------+
| 0005 |
+---+
--
- michael dykman
- mdyk...@gmail.com
- All models are wrong. Some models are useful.
me restart after the shutdown event
or did it stay stopped?
If it did restart, was your perl program able to recognize that and
start using it again or did your application stop on first detecting
that error?
- michael dykman
On Sun, May 3, 2009 at 11:21 PM, Randomcoder wrote:
> Hi,
>
> I run
Your directive looks fine assuming dublin expects to always connect
from localhost.
One thing though: your user does not need the 'WITH GRANT OPTION' bit
as that gives them permission to gratn permissions to other users,
which I don't think is what you want.
- michael dykman
7;, 'Mr', 345 987 5500)
> in the MySql console in order to avoid typing it each time you want to fill
> a new record.
> I tried to right click my mouse,it doesn't select what I need to highlight.
>
> Please,any advice is welcome.
What you have at the console is his
d the size of the data per connection. Anyone know what setting I
> need to tweak to ensure that it can accept large inserts of this size?
>
> Thanks,
>
> Gary
As I recall, max_allowed_packet is what controls that limit.
--
- michael dykman
- mdyk...@gmail.com
- All models a
need a little more information. The table looks sound but is
clearly designed to link 2 other tables. If you are failing to
insert or update, it seems likely that it is because the data is
absent in the foreign tables. Can you confirm? Because without that
forgeign data, these rows are pretty meaningl
On Fri, May 22, 2009 at 12:26 AM, PJ wrote:
> Michael Dykman wrote:
>> On Thu, May 21, 2009 at 11:06 PM, PJ wrote:
>>
>>> I have a seemingly impossible situation. I cannot insert values into the
>>> tables and I cannot alter or delete the primary key (which sh
+0700).
I don't think you do. You would have to get your application to parse
out the date into something that MySQL can negotiate. The only reason
this works at all in your case is because you happen to have +
which we can safely ignore.
--
- michael dykman
- mdyk...@gmail.com
- A
, 2009 at 3:17 PM, PJ wrote:
> Michael Dykman wrote:
>> On Fri, May 22, 2009 at 12:26 AM, PJ wrote:
>>
>>> Michael Dykman wrote:
>>>
>>>> On Thu, May 21, 2009 at 11:06 PM, PJ wrote:
>>>>
>>>>
>>>>> I have a seemingly i
I
> don't see a need to run mysql_fix_privilege as I manually copied the
> necessary privilege data.
>
>
> /Per Jessen, Zürich
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
PM, Per Jessen wrote:
> Per Jessen wrote:
>
>> Michael Dykman wrote:
>>
>>> Have you tried running the offending SQL manually against you new
>>> installation? Does it come back clean in the isolated case?
>>
>> No, not manually, but the job/the SQL is
that would have reacted.
- michael
On Mon, May 25, 2009 at 12:19 PM, Per Jessen wrote:
> Michael Dykman wrote:
>
>> Given the new hardware, I'm now suspecting the RAID controller. I have
>> seen misconfigured RAIDs or bad RAID drivers take out a server in just
>>
.sql
...
and then wrote a shell script to fire them off in sort-order. I
deliberately used the numbering convention from line-numbered basic to
allow me to inject intervening files without having to renumber the
set.
--
- michael dykman
- mdyk...@gmail.com
- All models are wrong. Some mode
[Note] Event Scheduler: Loaded 0 events
> 090612 11:07:25 [Note] /usr/sbin/mysqld: ready for connections.
> Version: '5.1.34-community-log' socket: '/var/lib/mysql/mysql.sock' port:
> 3306 MySQL Community Server (GPL)
> 2 3 4 5 6 7 8 9 10 11 12 13 14 1
but it will work
- michael dykman
On Sat, Jul 4, 2009 at 2:48 AM, Nathan
Huang wrote:
> Hi guys
> I am going to fetch out the data from remote mysql database according to
> timestamps colmmen, however my local date is different from the one on
> remote mysql database,
> how can I g
be guaranteed of consistent behaviour,
explicitly ask for what you want.
- michael dykman
On Mon, Jul 13, 2009 at 8:20 PM, Artie Ziff wrote:
> Hello,
>
> I am returning to mysql after long break, so not experienced with
> details. I inherited a text file with the mysql DDL stat
0 | 742892 | NULL |
> ++---+-+---+-++---+-++-+-------+-+--+--+++---+--+--+--+---+
you that if you create a unique
key for when ever your 'search' criteria is, you can get this
behaviour like so:
INSERT INTO mytable SET col1 = val1, ... ON DUPLIATE KEY UPDATE
- michael dykman
On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervi wrote:
> Hi;
> I would like to te
we'll see a lot of ordered bulk inserts.
>
> It ran counter to the results that we were seeing so I had to verify
> that InnoDB always clusters by primary key regardless of the position
> of the auto increment column in the primary key.
> Kyong
>
> On Thu, Jul 30, 2009 at 7
>>
>>
>
> --
> -
> Johnny Withers
> 601.209.4985
> joh...@pixelated.net
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.
If you look at the options for mysqldump more closely, you will see
that you can specify the version of the server which will be importing
the result file. These cause MySQL to taylor the SQL syntax according
to the target platform.
- michael dykman
On Wed, Sep 2, 2009 at 11:03 AM, Matt
If I may,
If you have foreign keys on your InnoDB, you can still import your
data to MyISAM but foreign keys will be lost. Otherwise, the data
will load just fine.
- michael dykman
On Mon, Sep 14, 2009 at 11:14 AM, Todd Lyons wrote:
> On Mon, Sep 14, 2009 at 7:44 AM, Néstor wrote:
>&
A mysqldump will work just fine. By default, that dump is going to
explicitly specify the table type .. you will have to edit it if you
want to import to MyISAM.
- michael dykman
On Mon, Sep 14, 2009 at 10:44 AM, Néstor wrote:
> Maybe one of you experts know the answer.
>
> I have
Perhaps this could help you out..
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_soundex
- michael dykman
On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer wrote:
> Suppose I have a table of a few thousand people, with a FirstName field
> and a LastName field.
>
> Thx again
>
> -Original Message-
> From: Michael Dykman [mailto:mdyk...@gmail.com]
> Sent: Friday, September 25, 2009 3:42 PM
> To: Jones, Keven
> Subject: Re: Correct way to start new .MYD & .MYI files
>
> If you are prepared to accept that any data ass
me." Winnie the Pooh
> http://blog.imabug.net/
> PGP KeyID = 0x1F9779FD, 0x319393F4
> PGP keys available on request ICQ 3113529 O-
> ---------
>
> On 09/25/2009 04:04 PM, Michael Dykm
action Engines
>
> http://dev.mysql.com/doc/refman/5.1/en/storage-engine-compare-transactions.html
>
>
--
- michael dykman
- mdyk...@gmail.com
Don’t worry about people stealing your ideas. If they’re any good,
you’ll have to ram them down their throats!
Howard Aiken
--
MySQL Genera
This looks like much more of a python question than a MySQL question..
I'll reply offline.
- michael dykman
On Sun, Oct 4, 2009 at 2:04 PM, Victor Subervi wrote:
> Hi;
> I have the following python code:
> sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %
kp5.png
>
> Thanks!
>
> --
> Marcelo de Assis
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
>
>
--
- michael dykman
- mdyk...@gmail.com
Don’t
mysqldump is by no means the fastest way to move data between systems.
For a bulk job of this magnitude, try this:
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
- michael dykman
On Wed, Oct 14, 2009 at 3:59 AM, Claudio Nanni wrote:
> We dumped a mysql 4.1.22 database using
Brian,
You could spend a lot of time crawling through version release notes
looking for something which might refer to your issue, or you might
just upgrade to 5.0.86-0 which is the latest 5.0. There have been
close to 2 years worth of bug-fixes since 5.0.51a
- michael dykman
On Wed
I can think of no reason why this shouldn't work, My administrator
colleagues would probably beat me with 2x4's for handing them such a
delicate construct to maintain in production but it seems perfectly
feasible to me :-)
- michael dykman
On Wed, Oct 14, 2009 at 11:03 AM, Christian
If you could show us the table structure (SHOW CREATE TABLE
membership), we could easily correctly the query.. you seems to have
some data among your field names...
If the question is about the CSV converter, you will have to ask them.
- michael dykman
On Thu, Oct 15, 2009 at 11:26 AM
Victor,
again, your question has more to do with python usage than MySQL
per-se.. you would be better off pursuing these questions in a python
forum.
- michael dykman
On Thu, Oct 15, 2009 at 3:28 PM, Gavin Towey wrote:
> "Image in string form" Â sounds like you're not ins
LL default '0',
> `rep_id` int(11) NOT NULL default '0',
> `description` text collate utf8_bin NOT NULL,
> PRIMARY KEY (`line_number`)
> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
- michael dykman
On Sat, Oct 17, 2009 at 2:20
your network setup?
Not the safest of practices, but for dev accounts, I usually create
one for user@'%' and sometimes one one for u...@localhost if needed
and that works very well for me..
- michael dykman
On Mon, Oct 19, 2009 at 7:30 PM, John Oliver wrote:
> I have a probl
That is correct. Many db interfaces off programmatic abstractions of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil wrote
that
>>
>> on success: COMMIT
>>
>> on error: ROLLBACK
>>
>> - michael dykman
>>
>>
>>
>> On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil
>> wrote:
>>
>> Hello Everyone,
>> I am a newbie using i
| smccoy | Computer Software | 15 |
> | smccoy | Networking | 4 |
> | smccoy | New User | 1 |
> | smccoy | Printer | 2 |
> | smccoy | Server | 4 |
> | sokolsky | Computer Software | 1 |
> | sokolsky | Telep
structure via LOAD INFILE
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
- michael dykman
On Thu, Oct 29, 2009 at 1:09 PM, Brian Dunning wrote:
> Sorry if this is a n00b question, I did read the docs for mysqldump before
> posting, but couldn't figure it o
generally used. python appears to use
prepared statements under the covers.. it provides an similar
facility, at any rate.
What are you working in?
- michael dykman
On Fri, Oct 30, 2009 at 12:06 PM, Sydney Puente wrote:
> Hello,
>
> I am populating mysql with data, from an extern
as
values in SQL statement.. I don't know the name of that function off
the top of my head, but I"m pretty sure 'escape' is the keyword.
- michael dykman
On Sat, Oct 31, 2009 at 7:29 PM, Sydney Puente wrote:
> Thanks michael,
>
> Good question/observation - I
needs, often leaving a lot of unused raw storage space.
The system was usually deployed on a single disk, being more-or-less
static and easily reproducible.. Once you are booted and primed, the
system disk barely gets touched.. all the important stuff is in RAM.
- michael dykman
On Sun, Nov 1, 20
Let me guess,
you are doing a source build on a linux box? Have you installed the
kernel headers?
- michael dykman
2009/11/4 Martin Gainty :
>
> In file included from readline.c:54:
> readline/readline.h:70:29: sys/ttydefaults.h: No such file or directory
>
> any clue whe
> Konkurs: Wygrywaj nagrody z Pudzianem!
> Sprawd¼ >> http://link.interia.pl/f240e
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
>
>
> You're right on one hand. But on the another in some languages you have a
> more characters after the Z letter.
> Apart from that try this:
>
> select 'F' as test
> union
> select 'FAA'
> order by test;
>
> and you'll see:
>
> test
&
connection and then have a closer look at
whatever component is managing that.. apparently, its' doing it
wrong.
- michael dykman
On Wed, Nov 4, 2009 at 10:36 AM, Tompkins Neil
wrote:
> Hi
>
> Thanks for your quick response. In our test environment running MySQL
> 5.1.31
Well you might need to parenthesize the expression, but note that
simple integer math done on a DATE or DATETIME, the units are days.
you probably want
... where first_seen < (NOW() - 5);
michael dykman
On Wed, Nov 4, 2009 at 2:28 PM, Stefan Onken wrote:
> Hello,
>
> I am
y behviours of the connection manger that are giving
you trouble, then you will have to look at however that is
configured.. in your case, that is an ASP/.net matter and you should
consult the gurus there.
- michael dykman
On Thu, Nov 5, 2009 at 5:42 AM, Tompkins Neil
wrote:
> Thanks for
the function max(), among others, makes no sense in the absence of a
GROUP BY clause.
try adding "GROUP BY user_id"
- michael dykman
On Sun, Nov 8, 2009 at 9:40 AM, John Meyer
wrote:
> I want to get a list of all users who haven't posted in a week. But when I
> use t
Under InnoDb, you could use file-per-table which would have
significantly reduced the inter-dependencies.. given the large data
size and heavy I/O you report, it might be a wise way to go.
- michael dykman
On Mon, Nov 9, 2009 at 3:41 AM, Johan De Meersman wrote:
> Presumably because you
nce it goes above 255 because of the length, but is there a storage
> difference between VARCHAR(100) and VARCHAR(255)? Obviously there's a
> functional difference in what gets cut off when I try to store into that
> table, but is that the only difference?
>
> Thanks for
ng up database access
pretty good.
OR
have the external updating process record a log of changes to
a particular table, then you monitor thread can scan that table for
new entries.
- michael dykman
On Tue, Nov 17, 2009 at 7:06 AM, Gaurav Nigam (TMP-Japan)
wrote:
> Can somebody ple
*
> *Please block this account's access to the *
> *internet until its cleaned up. We are basing *
> *this on an analysis of the header NOT the FROM*
> *address. *
>
&
whole list in here, the whole statement will be applied to the
system atomically meaning all changes logically take place at the same
time.
I have done this under 4.1 at an industrial level.. works like a charm
for any table type I tried.
- michael dykman
On Sun, Nov 22, 2009 at 3:01 AM, Rob
queries (not to mention expected performance targets)
but 4x64 CPUs churning that kind of data could really take advantage
of a lot more RAM.
- michael dykman
On Tue, Nov 24, 2009 at 12:25 PM, Johan De Meersman wrote:
> First off, for 4.000.000.000 records at 1867 byte per record, you'
;
> Any ideas?
>
> Thanks,
> Neil
>
> --
> Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
> Host Joomla!, Wordpress, phpBB, or vBulletin for $25/mo
> Unmetered bandwidth = no overage charges, 7 day free trial
>
>
> --
> MySQL General Mailing List
>
ct_id = l.client_id
>
> Any ideas how to do this?
>
> Thanks
> Neil
>
> --
> Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net
> Host Joomla!, Wordpress, phpBB, or vBulletin for $25/mo
> Unmetered bandwidth = no overage charges, 7 day free trial
>
&
on of this table always
exists:
RENAME TABLE
active.geo to archive.geo,
standby.geo to active geo;
- michael dykman
On Fri, Dec 11, 2009 at 8:58 AM, Johan De Meersman wrote:
> On Fri, Dec 11, 2009 at 1:56 PM, Ken D'Ambrosio wrote:
>
>> > rename table olds
am here asking :)
>
> Thanks in advance!
>
> Steve Staples.
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com
>
>
--
- michael dykman
- mdy
command would have the same limitations.
- michael dykman
On Fri, Dec 11, 2009 at 11:35 AM, Jim Lyons wrote:
> Can you use that syntax if the databases are on different file systems? If
> you can, and the original table is big, the command would take a while as it
> moved data from one fi
Yeah, that's exactly right
You can also do some partials like
'user'@'192.168.2.%'
- michael dykman
On Fri, Dec 11, 2009 at 11:33 AM, Steven Staples wrote:
> They are actual IP's, not domain names.
>
> So it would be like `us...@`192.168.0.100` and `
.
Depending on how your data is stored, it might now be 'quite' as
simple as a unix 'mv' command.. if this is a production system, I
would recommend you do a dry run with a replicant/slave. No amount of
theorizing will tell as much as the experiment.
- michael dykman
On Fri,
more important than it is today!
- michael dykman
On Sat, Dec 12, 2009 at 5:29 PM, Michael Widenius
wrote:
>
> Subject: Help saving MySQL from Oracle!
>
> I, Michael "Monty" Widenius, the creator of MySQL, is asking you
> urgently to help save MySQL from Oracle&
ve this in the hands of the highest bidder?
- michael dykman
On Sun, Dec 13, 2009 at 11:23 AM, Neil Aggarwal wrote:
> Doug:
>
>> I do not
>> see anyone willing to put up anything to support mysql... you
>> don't like
>> it... put up a billion dollars an take contr
Thank you John, You have hit on my point exactly. There are
thousands on companies and 100's of thousands of jobs which are owed
to this product. That is what we are defending.
- michael dykman
On Mon, Dec 14, 2009 at 4:27 AM, John Daisley wrote:
>
> Claudio Nanni wrote:
&
n but significantly similar.
Lock the tables and rsync again; the second time is MUCH faster and
the result is correct.
Against a 'quieted' MyISAM table, your technique sounds fool-proof.
Of course, test your resulting tables before you commit to anything.
- michael dykman
On Thu, De
last_insert_id() returns the last id auto-incremented in *the current
session*. If you disconnect and reconnect, it can not be retrieved.
- michael dykman
On Sun, Dec 27, 2009 at 11:42 AM, Victor Subervi
wrote:
> On Sun, Dec 27, 2009 at 11:27 AM, Mattia Merzi wrote:
>
>> 2009/
Gavin,
very nice,
- michael dykman
On Mon, Dec 28, 2009 at 2:16 PM, Gavin Towey wrote:
> No, that won't work, remember that the WHERE clause is applied to each row
> individually -- y is 25, then it also cannot possibly be 24 at the same time,
> so AND condition has no meanin
No, nothing will ever equal null. In strict relational theory, which I
don't know well enough to begin expounding on here, null does not even
equal another null. That's why SQL provides IS NULL and IS NOT NULL
as explicit cases.
- michael dykman
On Mon, Dec 28, 2009 at 2:32 PM
ght
>> FROM matches
>>
>> )
>>
>> UNION
>> (
>>
>> SELECT team2_partner_id, teammatch_id, match_type, team1_score,
>> team2_score,
>> team1_points, team2_points, no_fight
>> FROM matches
>>
>> )
>>
>> ) m ON
but for all
kinds of trouble shooting in general.
- michael dykman
On Tue, Jan 5, 2010 at 8:42 AM, ishaq gbola wrote:
> Am running windows on my local host and Redhat linux on the remote server, I
> have no mysql client on local host. TAC for the NMS using the database
> ad
rs look longish, maybe?
- md
On Wed, Jan 6, 2010 at 10:53 AM, Victor Subervi wrote:
> On Wed, Jan 6, 2010 at 10:56 AM, Michael Dykman wrote:
>
>> I don't really use sets when I can avoid them (too much special
>> wierdness) but from the manual I see this:
>>
>>
point of a set identifier to be an easy mnemonic for a particular
bit value. Nothing is gained by trying to represent data with the
identifier itself.
- michael dykman
On Wed, Jan 6, 2010 at 1:25 PM, Victor Subervi wrote:
> On Wed, Jan 6, 2010 at 2:18 PM, Hassan Schroeder > wrote:
>
ith a snapshot of the current state of the master
(excepting the binary logs) and only the binary logs produced by the
master from that point forward matter.
- michael dykman
On Wed, Jan 6, 2010 at 2:43 PM, Steve Staples wrote:
> Silly me sees that there is an 'expire_log_days' in
thing like
echo "select * from mytable" > mysql -u someone mydb > mytable.tsv
which will output tab-delimited records, one per line, suitable for
feeding to SQL*Loader.
I would put the command into a shell script and have cron call that
shell script.
- michael dykman
On We
bles like server_id is showing "0"
> what i had to do is set global parameter in mysqld cli w/c is not a good
> thing..
>
>
> additional info:
>
> Default options are read from the following files in the given order:
> /etc/my.cnf ~/.my.cnf /etc/my.cnf
>
>
>
tween trys. In spite of 1M+ user/day we rarely
made it to the third attempt.
- michael dykman
On Mon, Feb 1, 2010 at 9:33 AM, Dante Lorenso wrote:
> All,
>
> I am trying to create an atomic operation in MySQL that will manage a
> "queue". I want to lock an item from a table
> Oracle will sell it if they can convince the customer.
Any one who has had the pleasure of using Oracle Application Server
can attest to that.
--
- michael dykman
- mdyk...@gmail.com
May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.
1 - 100 of 447 matches
Mail list logo