erver version for the right
> syntax to use near 'update COMPANY_NUMBERS_tmp_Mikhail c join
> tmp_HEMSCOTT_MKTVALUES t on c.ticker =' at line 1
>
Explain only works with tables and SELECT queries:
http://dev.mysql.com/doc/refman/4.1/en/explain.html
--
Pat Adams
Digital Darkness
.html describes
the pitfalls of running multiple servers on the same machine about
halfway down the page in the bold 'Warning' paragraph.
--
Pat Adams
Digital Darkness Promotions
Dallas Music Wiki http://digitaldarkness.com
--
MySQL General Mailing List
For list archives: http://lists.m
> more of a problem with subselects because how does one alias it?
> Servlet sql:
>
> sql = "SELECT " +
> "u.id as user_id, " +
> "u.first_name as fname, " +
You're aliasing it as fname
ame index defined
twice. Since the leftmost column in your primary key is referer, you do
not need it as its own index.
--
Pat Adams
Digital Darkness Promotions
Check out the Dallas Music Wiki http://digitaldarkness.com
signature.asc
Description: This is a digitally signed message part
On Mon, 2006-06-12 at 13:32 -0400, Jesse wrote:
> > Um, did anyone actually answer Jesse's question?
>
> The consensus seems to be that the correct way to pronounce it is My S-Q-L,
> Not My Sequel. So, that's the way I'm going to pronounce it. Actually,
> most of the people I say the name to h
inst NPTL.
>
> This appears on my config.log session:
>
> --enable-threads=posix
> Thread model: posix
>
> Is that NPTL? I know NPTL is POSIX, but maybe this should say Thread
> model:
> NPTL.
NPTL stands for Native POSIX Thread Library, so yeah, it's using NPTL.
the correspoinding action
> id,
> they should be 456 and 431 instead...
If you don't include id in either an aggregate function or the GROUP BY
clause, MySQL 'helps' you by choosing a seemingly-random value to stick
in the id field.
--
Pat Adams
Digital Darkness Promoti
her precedence, so the expression is
interpreted as (t1, (t2 JOIN t3)). This change affects statements that
use an ON clause, because that clause can refer only to columns in the
operands of the join, and the change in precedence changes
interpretation of what those operands are."
--
Pat Ada
On Thu, 2006-04-20 at 19:15 -0400, fbsd wrote:
>
>
> can someone please just send me or post a example of editing feilds
> of a
> mysql database within an html form and then updating the values
> thanks alot
These should tell you everything you need to know.
http://www.php.net/manual/en/ref.mys
ition not taken?
Try print($result[0]) or print($result['logon_id']); $result is a handle
to the result set, not something you can print. It's the same thing as
if you tried to print out the return value of mysql_connect, which
should return a resource id. There wasn't an error
n the
> answer here. Does it mean that the price for both
> MySQL Developer Exam I & II are US $200? ie US $200
> cover the two exams
$200 for the core certification, and $200 for the Professional
Certification.
--
Pat Adams
Digital Darkness Promotions
Check out the Dallas M
rl-DBI RPM without src in the
filename.
--
Pat Adams
Digital Darkness Promotions
Check out the Dallas Music Wiki http://digitaldarkness.com/tiki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e tables from being destroyed."
If you take away the FILE privilege they won't be able to write out the
filesystem.
--
Pat Adams
Applications Programmer
SYSCO Food Services of Dallas
signature.asc
Description: This is a digitally signed message part
st
have similar internal data types inside InnoDB so that they can be
compared without a type conversion. The size and the signedness of
integer types has to be the same."
You've got an INT in comments table and an int(10) unsigned in the
journal table. They need to match in signedness.
--
Pat Adams
Applications Programmer
SYSCO Food Services of Dallas
signature.asc
Description: This is a digitally signed message part
On Fri, 2005-08-12 at 09:30 -0600, Duke, Brian wrote:
> Like crashing, auto-rebooting, memory leaking, program cost, etc...
>
> -Original Message-
> From: Pat Adams [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 12, 2005 9:21 AM
> To: mysql@lists.mysql.com
>
On Fri, 2005-08-12 at 09:55 -0500, Jay Blanchard wrote:
> [snip]
> Same machine, any performance difference?
> [/snip]
>
> Yes. Linux will consistently outperform Windows in many areas.
Except for those areas that it doesn't.
--
Pat Adams
Applications Programmer
SYSCO Foo
rom the
least significant part of a UNIX timestamp would be sufficient to seed a
RNG randomly enough for average web applications, but it's not truely
random, since a web log will show what time the user hit the
application, and you can figure out what the RNG was seeded with at that
point.
--
cryptographically secure random
number generators can be predicted under absolutely identical
circumstances.
--
Pat Adams
Applications Programmer
SYSCO Food Services of Dallas
signature.asc
Description: This is a digitally signed message part
| sort -u
run in a database directory on a *NIX box (or Windows with Cygwin) will
print out the tables that contain search_string. It takes a while, but
it gives you the information you're looking for. I probably wouldn't run
that on my tables if they're being written to, but I
19 matches
Mail list logo
