timestamp.
--
Michael T. Babcock
http://mikebabcock.ca/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to
yourself are duplicated, not entire threads.
I often remove the person's E-mail address if its not some form of
urgent posting (like this one) or where they may not care about the
response, especially if I'm just adding to a thread and not actually
responding to them.
--
Michael T. Babcock
--
MySQL
and then
'window' your way through it using the LIMIT clause.
CREATE [ TEMPORARY ] TABLE search_result_abc123 SELECT (no limit);
Then for each 'page' of data, do:
SELECT * FROM search_result_abc123 LIMIT x, x+10;
--
Michael T. Babcock
--
MySQL General Mailing List
For list archives: http
it still was when you looked at it (since you posted
your message on the 12th).
Given more time, I'd presume ib_logfile0 to eventually show Mar 20 or so
and ib_logfile1 to show the same as it has moved on to the next file ...
--
Michael T. Babcock
--
MySQL General Mailing List
For list archives
isn't that difficult in most
situations you may encounter. A little wrapping to be sure, but
validating parsers are easy to get your hands on and designing an
expat-based parser that knows your schema (XML DB) for translation
isn't a big chore for most data types I've come across.
--
Michael T
. In Python, you
build a mutli-layer dictionary of the XML file and then do something like:
def deconstruct(xmldata, parentdata):
for item in xmldata:
if item.has_subitems():
deconstruct(item, xmldata)
query = INSERT INTO %s VALUES (...) % (xmldata.name, ...)
--
Michael T
service, just
like anywhere else.
This list is a convenient place to discuss or ask questions about
probably 98% of situations. That last 2% probably requires support.
Please note, as always that 72.83% of all statistics are made up on the
spot.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http
?
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
experience with cleaning up
something like this?
It seems you're dealing with area code logic. If you can re-schema your
tables, consider:
SELECT ...
LEFT JOIN phoneno on cdr.dialednoid = phoneno.id
WHERE ...
AND phoneno.areacode in (866,877,888)
AND ...
Get the idea?
--
Michael T
else has the problems others have mentionned.
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/
pgp0.pgp
Description: PGP signature
?
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/
pgp0.pgp
Description: PGP signature
your tunnel with ssh -ddd for extra debugging output on tunnel creation
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
the interface.
This code can be made quite small and efficient with Python in my
experience. If you have no Python experience; feel free to follow other
suggestions, but consider trying it.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
--
MySQL General
more
efficient than using MySQL, but YMMV. I've found qmail with
Courier-IMAP to be so fast that I can't really say I'd want to try using
a different back-end at all. If you end up with any benchmarks, feel
free to post them.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http
.xx's functionality is required on our own servers. I'm
sure the query caching will improve performance when I upgrade, but at
this point it isn't a necessity.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
--
MySQL General Mailing List
For list archives: http
notification tacked on.
Mind if I throw my hand up as one of those people? :-)
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Basic, by way of reference had this neat bug:
a = 0
for i = 1 to 100
a = a + 0.01
next i
print a
... printed 0.99 or 1.01 depending on your platform.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
a full backup and then
rebuild my data files for a full restore. Should I keep my original files for
your reference/debugging?
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock
. Reverse RIGHT,
LEFT above for RIGHT JOIN. The others will make more sense when you get
that.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http
CXX CFLAGS CXXFLAGS LDFLAGS
./configure \
--sysconfdir=/etc \
--prefix=/usr \
--localstatedir=/var/mysql \
--enable-assembler \
--with-berkeley-db \
--with-innodb \
--with-comment \
--enable-thread-safe-client
--
Michael T. Babcock
CTO
Michael T. Babcock wrote:
I've got a nice MySQL crash that happened during the night last night and I
can't seem to get it to come back online for me without --skip-innodb.
Follow-up with mysql's bug report:
MySQL support: none
Synopsis:InnoDB Crashing on Startup
Severity:critical
) by web.mysql.com (8.11.6/8.11.6) id
h1LJVhi24085; Fri, 21 Feb 2003 20:31:43 +0100
Date: Fri, 21 Feb 2003 20:31:43 +0100
Message-Id: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
To: Michael T. Babcock [EMAIL PROTECTED]
Subject: Re: Re: Examples needed of MYSQl/PHP update, delete scripts and
relevant
Your message
Bernhard Döbler wrote:
there's a Password()-Function in MySQL. Can somebody tell my on what standard is based (MD5 etc.) and if there's something similar in a DBMS that also supports triggers? InterBase does not support many functions...
Its deprecated; use MD5() or SHA1() ...
--
Michael T
MySQL, that's their choice. If they decide they want to use it with
Oracle, that's their choice too.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http
use
(some people here may not, of course).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
to the diff.
between the position offsets in each (which are sorted in position order).
Just thinking out-loud, and no, I've never benchmarked it but I played
with the idea in Python a few times as a proof-of-concept.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. SQL
http://www.fibrespeed.net/~mbabcock
).
I don't write much commercial, non-GPL code. I write a lot of
commercial and GPL'd code though, and so do many other people (like
MySQL AB). You might want to consider it too.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
of business models are different, but not unprofitable.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
eventually - it's in the todo.
Wow, I love this list (and the MySQL team). Go to bed with a question,
wake up with an answer.
Well, in EST5EDT at least. Thanks.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
It would be nice to extend the user permissions table to have per-user
limits like max_user_connections and the various timeouts applying
directly to specific user/host combinations.
Just a thought / suggestion.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. SQL
http://www.fibrespeed.net
mysql.user table:
- max_question:number of commands user can send to server,
- max_updates: number of changes user can submit,
- max_connections: well, I let you guess ;-)
Maybe I'll have to take the plunge and upgrade after all.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http
the database as a reference value. The 'ol' values are just
as easily put in the PHP itself, of course, since they have nothing to
do with the data (no association to that data).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
response from a query, not the data
in the query. Don't forget to do a mysql_fetch_array or mysql_fetch_row
on the resource before using it.
As a test:
$res = mysql_query(...);
print $res;
while ($row = mysql_fetch_array($res)) {
print $row;
print $row['id'];
}
--
Michael T. Babcock
C.T.O
= mysql_fetch_array($res);
if ($row['password'] != $pass_md5) die(Bad password);
This way, the data going over the MySQL link is already secure before it
goes over your network or leaves your program.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
to do it) and measure your actual bandwidth usage; you may
be surprised. Cross-reference with a ping log (also done with RRDTool
on my machines) to see if its a latency or bandwidth cap issue.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
any more efficient except in
file descriptor usage (although I've expressed the same doubts about
InnoDB's avoidance of the filesystem too).
SQL and all that ...
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
the lines
with OL...results.../OL or perhaps just use PHP/Perl/? to do an $i++ for
display?
Why put this in the query at all, if it has nothing to do with the data?
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock
to the Microsoft SQL Server product often mis-
named as 'SQL' itself (by people who don't know what SQL is).
If I were you, I would explain relational databases
and normalization (at list to normal form III).
Very well described by many other books; especially Oracle
certification books.
--
Michael T
question (win98_se)'.
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
network masking
math and then store your IP addresses as 16 bit long integer
values (until you're storing ipv6 addresses, of course). Store
your network mask as either the 16 bit value of the mask or if
you care about space, a tinyint of how many bits are in the mask.
--
Michael T. Babcock
CTO
On Tue, Feb 11, 2003 at 03:34:52PM -0500, Peter Grigor wrote:
Dood, he's not gonna be very happy storing an IP as 16 bits :)
Excuse my long day; 32 bits would be much more useful.
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, SQL)
http
term 'gender'.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. SQL
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
) and there is no meaning lost by
doing so (and therefore no reason _not_ to do it, except sheer laziness,
of which most of us are probably guilty).
My appologies for spamming the list with this drivel.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. SQL
http://www.fibrespeed.net/~mbabcock
of E-mails in IMAP
format, some of my clients, using the same servers have gigabytes of
E-mails stored this way and find it to be faster than local storage).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
Zak Greant wrote:
Heh. There are still some gems like this in the manual.:)
I have let our documentation team know about the awkward wording.
Just use the term gender instead of sex and everyone will be happy :-)
(Esp. the people searching for 'animal sex' on Google ...)
--
Michael T
Martin Hudec wrote:
I would like to know what are limitations for mysql in number of records, size
of records, size of tables etc.
Check the free online user-commented manual first, ask any questions you
still have afterward.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http
{servername}
Correct?
If setting up a semi-automated version of this pipe is all it requires
to do replication (a few greps and pipes), then writing such a program
would allow for multi-to-multi replication (for example).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net
= cursor.fetchall()
return (count, results)
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
it autoextend instead of the current
one. How do I properly set the size on the current file so that it has
no problems if I remove the autoextend keyword, or is this not.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
... so you might as well have essentially `alias mysqlstat
$x='mytop --vmstat=$x'` (yes, I know that's not valid bash symantics).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before
is always
better responses that don't help you decide. In the best (and what I
think will happen), someone will tell you the differences in CPU usage
or fast file access speeds or some such value that will mean something,
or even that it is not actually going to make a difference.
--
Michael T
Steve Quezadas wrote:
PS Here is some information about my tables and indexes:
Maybe I missed it, but where's the EXPLAIN on the JOIN query?
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
within the server's
directory namespace.
Please read http://www.mysql.com/doc/en/LOAD_DATA.html
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http
as directories
under their database directories with row values as files under row
directories, with directories named by their primary index values
(randomly otherwise?). It would make an interesting project at any rate.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
to do a proper restore. Don't be in that situation. (We'd do one
if they paid us, of course ...)
and go from there; if any of the answers don't sound right, then ask more questions about that topic.
If they tell you its a stupid question, that's another good hint :-)
--
Michael T. Babcock
in Unicode. UCS-16 is useful for storing the data on disk in
only specific circumstances; like a database).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check
Steven Roussey wrote:
Might also look at:
vmstat 1
`vmstat 1` is my favorite instant-info server debugging tool. I
wouldn't mind the same program for MySQL (where's that mytop author
anyhow? j/k)
Blocked processes (second column) is a very useful piece of info too.
--
Michael T
reverse the query.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
:localhost:3306 foreignhost
...then set up the info for master (on the slave) to be localhost:3307.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http
locks before doing a backup to get
it over with, but backing up from a replication client is much smarter,
imho.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check
table and
do a search on that. I get the same results, and the query time is
halved.
Do an explain on all those queries, post the output here and the time it
took to run the queries.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
here. Ask if they're on the list :).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
, and I'm sure you've considered this, at least table
creation is a semi-rare enough event in the life and activity of the
average database that adding more overhead to the process wouldn't
affect much.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
...
then you end up with a left join like above.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
I don't
have yet) than have to extract data properly after the fact for
normalization.
Reading any old website about normalization will say basically the same
thing (and if they don't, they shouldn't be writing about normalization).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http
($Params))) return -1;
list ($rows, $error) = sql_do_query(SELECT ... FROM Vehicles LEFT JOIN
... WHERE $Params);
...
return $rows;
I worry about connecting, doing the actual query once connected and
error checking in sql_do_query, so my main code looks clean(er).
--
Michael T. Babcock
C.T.O
'supervise' so as to make sure its always there and
restarts if it gets killed / dies / is stupid / upgraded.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check
the same as:
INSERT INTO table (foo, bar) VALUES (NULL, text);
which would throw an error (correctly).
No comment ;-)
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please
of logging in, since MySQL won't be able to authenticate them.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
functions whereas PERL actually
does some additional work in there. In PERL's case, its probably a
similar code distance to just do a single executed query and return an
array of results as it is in PHP though. I'd benchmark it to be sure
though.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd
it keeps working that way safely, I'd say we
already have a solution though.
Oh yeah, without the words SQL or QUERY, this message would be spam.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
, '/a') FROM stuff;
But please remember, as was said earlier, to use the appropriate
escaping functions for your language to make sure link contains no
special HTML characters in the second instance and no URL characters in
the first.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http
/sh
cat $message | sendmail [EMAIL PROTECTED]
Look up how E-mail messages are formatted (its text; do a view source on
this message, for an example) and you're probably home-free.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
, there are an even larger list of books to consider. The ones I
found most helpful initially were the Oracle certification course books.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting
is there to stop respawns from being too fast and to
keep from confusing mysqladmin; when you do mysqladmin shutdown, it gets
confused if mysqld starts back up too soon (thinking it didn't shut down
yet I suppose).
Just FYI ... :-)
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. (sql)
http
] section to your ~root/.my.cnf file.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
specifying this in the query.
Search for REFERENCES in the MySQL manual; it only applies to InnoDB
type tables though.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please
);
return a href=\$HREF\$Text/a;
}
print td align=center.LinkURI($field)./td;
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php
= Wine.ID
LEFT JOIN Grapes
ON Grapes.ID = GrapesID
WHERE Grapes.Name = Grape1;
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http
mean that you moved columns to a new
table, then it makes sense; but rows? Where you getting bad query
response time?
Just curious.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before
checkpoints) and the ability to work and live a
'free' life. You have to choose your goals properly (much like SQL
design) before taking the first steps. If self-governance is a goal,
get good leaders.
--
Michael T. Babcock (no, I'm not a sympathizer to either side)
C.T.O., FibreSpeed Ltd.
http
on these?
alter table2 add index table1_id_idx(table1_ID);
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
. That is, adding the username to the comments in the binary update
log (and other logs).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com
(see
downloads / links page) as you learn SQL.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
= ThreadMutex4) and do your work. MySQL will block
the UPDATE until the previous thread (if any) rolls back or commits its
transaction.
Any thoughts / technical comments? (I just started doing this in a large
internal log tracking project that does, in fact, use MySQL) :-)
--
Michael T. Babcock
C.T.O
) id
h02JEGm29551; Thu, 2 Jan 2003 20:14:16 +0100
Date: Thu, 2 Jan 2003 20:14:16 +0100
Message-Id: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
To: Michael T. Babcock [EMAIL PROTECTED]
Subject: Re: Re: Using files stored as blob [OT]
Your message cannot be posted because it appears to be either
your SQL database,
install the MyODBC drivers, and link to the tables from Access. From
there, it's easy to program Access to make update screens, etc.
Chuck
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
on freshmeat.net. Searching MySQL admin windows on Google
should get you quite a few responses as well.
FWIW, this comes up a lot and phpMyAdmin gets mentionned almost as often.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
gives me generic SQL responses regarding
many products (often MS SQL Server, since they decided to use the lone
word 'sql' in its name).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before
. That's probably a good place to look
as well (just skip to the MySQL bits).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php
)
List-ID: mysql.mysql.com
If Eudora can't filter on arbitrary headers, complain to them frequently.
To be more specific: filter for the List-ID to contain mysql.
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
http://www.fibrespeed.net/~mbabcock
, what kind
of theoretical work is required to allow nested transactions?
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php
at the
same site. I'm surprised SQL hasn't been updated to support new time
formats yet, but oh well.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http
select * from temp;
+-+
| date|
+-+
| 2002-02-31 00:00:00 |
+-+
1 row in set
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
this if you
searched sourceforge or freshmeat.net. FWIW, I'd be tempted to
normalize your table down to:
Survey
SurveyQuestion
Question
UserQuestionResponse
User
You can try to figure out the rest from there ...
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
all
queries. So, having the parent linger a bit should have no affect on the
child. Yet it does.
I'm not a PERL god, but from C experience, try looking up wait and
wait on your child instead of just exiting.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. SQL
http://www.fibrespeed.net/~mbabcock
yet, but oh well.
Well, there is BIGINT, isn't there? :-))
TAI64N sub-second precision is 64 bits for the integer and 64 bits for
the floating-point value ... :)
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
software in the world, but don't have
faith in any software product just because you've heard its name a lot.
OpenBSD and Linux were helping run the majority of the Internet long
before most people had heard either name.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net
Jeremy Zawodny wrote:
It's a sad day when confidence is built by a company's PR budget
rather than the product's track record.
You mean like Microsoft?
Oh, sorry to bring that up ... :-)
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. ... sql ... for this one :)
http://www.fibrespeed.net
available on this list? I don't often analyze 13 SQL table queries for
free.
PS, you've got several tables not using indexes. Fix it :)
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
1 - 100 of 334 matches
Mail list logo
