rator and comma as decimal separator).
HTH & HAND
:-D
- --
David T-G
[EMAIL PROTECTED]
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (FreeBSD)
iD8DBQFBPPGHGb7uCXufRwARAllpAKCzmDQpbLcVa5q9MvXlo8ZxkHj
a
that hadn't occurred to me. So for the moment I'm still looking at a
single table structure. Good enough...
%
% With regards,
%
% Martijn Tonies
Thanks & HAND & Still listening...
:-D
- --
David T-G
[EMAIL PROTECTED]
http://justpickone.org/davidtg/ Sh
7;ll summarize what I learn
and/or decide when the conversation or direct emails wind down.
TIA & HAND
:-D
- --
David T-G
[EMAIL PROTECTED]
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (FreeBSD)
iD8DBQFBNFR
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Egor, et al --
...and then Egor Egorov said...
%
% David T-G <[EMAIL PROTECTED]> wrote:
% >
% > I have just moved my web site from one server to another (whew!) and I am
% > having a problem with a mysql user definition for a c
thout a password
properly asks me for one (so I'm not showing it on the command line to
anyone with ps tools :-)
%
%
Thanks & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi again, all --
...and then David T-G said...
%
% I have just moved my web site from one server to another (whew!) and I am
% having a problem with a mysql user definition for a calendar program.
...
Sorry for the duplicate post; I only realized
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
and, similarly, the web script cannot get in. Yet when I select the user
record from mysql.user and mysql.db they appear complete.
What glaringly obvious omission have I failed
head, and without any real security checking
since you're the only who will use the script and you know better). This
will ask for db name, db user, db pass and then connect as your root user
to attempt to create the database and then give the user permissions on
it (thereby creating the
ly obvious omission have I failed to see?
TIA & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone
HTH & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/ Shpx gur Pbzzhav
table.
Oh, there is, indeed. CF "normalization" :-)
HTH & HAND & good luck Paul
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Edd
p; HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrpr
. Is there any way to do
What about, on machine two,
mysqldump -hmachine1 -uuser -ppassword --opt --all-databases > backup
or so?
% this besides using ftp.
Definitely. There's scp, for instance ;-)
%
% Any help would be appreicated.
%
% Richard
HTH & HAND
:-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mike --
...and then Michael Stassen said...
%
% Mikael Fridh wrote:
[And thank you to Mikael, too.]
%
% >On Wednesday 12 November 2003 17.15, David T-G wrote:
% >
% >>What if one user connects to the database as different users
t see it. (If they
% can see it, you've got bigger problems than just the mysql password).
Yeah :-) Even if we're *not* talking about root, too.
%
% Michael
Thanks & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED]
satisfactory answer).
Those of you who store your passwords in the script file for all to see,
how do you keep all from seeing them? And those of you who don't, what
are you doing to stay secure? And those of you who have a different
approach, what is it?
TIA & HAND
:-D
- --
David
rmation in the MySQL documentation. Read this once at
% least.
Agreed. It has everything you need.
HTH & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mar
plaintext password?
Why not instead save the encrypted password and then when checking always
encrypt what you're given and compare it? Not only is it more secure,
it's easier :-)
%
% thanks,
Sure thing.
%
% Luis R. Lebron
% Sigmatech, Inc
HTH & H
% corrupt the database files?
Very probably.
%
% Thanks,
Sure thing!
%
%
% Keith
HTH & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker
27;t matter, so to speak :-) Could you afford a little bit of
extra load time at startup to have your un-split, all-RAM, fast table?
HTH & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral cou
happen in one of twenty small files as in one large file.
%
% A couple of years ago I looked into big tables for myself and everyone said
% you need the raid option in MySQL. Now I'm not sure!
That's probably because ext3 and reiser and xfs weren't around :-)
%
% Thanks
to do with disk RAID; they are completely
separate.
%
% Thanks,
%
% Steve
HTH & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Scien
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Doug, et al --
...and then David T-G said...
%
% ...and then Comcast said...
% %
% % I would like to ORDER BY RANDOM - is there an easy way to do that.
%
...
% I don't know if you can select random() like you can select count() but
% perhap
ike you can select count() but
perhaps you don't even need that temp table...
%
% Thanks.
Good luck! & let us know how you end up doing it.
%
% -Doug
HTH & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and
the docs with a docid, one table
for all of the words with a wordid, and one table to tie them together
containing the docid and the wordid. Duplicate words only require one
row in the word table and would have required separate docid entries
anyway, so you save.
HTH & HAND
:-D
- --
Da
e table if questions are used
% more than once. As they are not you can put the question order field in
% the question table.
Excellent; great to know. Thanks!
%
% Best regard,
% Andy.
Thanks & HAND
:-D
- --
David T-G * There is too much animal courage in
(play)
to update a bunch of
fields after a not-at-the-end insertion, which is what put me onto the
idea of storing the order in a single spot in the first place. But it
seems so much cleaner :-) The only problem is [efficiently] getting the
data back out when I want to display it...
%
% I h
t order based
on the contents of another field (but not simply sorting on that field)?
TIA & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, &
ry,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl N
everyone knew
how to be McQ, and one could either be a dependent leaf or just pull down
your own mail and news to have it locally (web sites aren't typically
meant to be mirrored by the anonymous visitor).
mysql query,
:-D
- --
David T-G * There is too much ani
uite thorough response to my question
in the thread "problems with GRANT, user, databases".
%
% Thanx
% -- Mitko
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not
were some changes to the filtering concept mentioned a while
ago. Have they been implemented yet?
2) Why not just have all posts from non-subscribed users either moderated
or handshaken via tmda or the like?
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too
base or a new user?
TIA & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/da
(0.02 sec)
mysql> quit
Bye
bash-2.05a$ mysql -ujunk -pjunk
Welcome to the MySQL monitor. Commands end with ; or \g.
mysql> use junk_test ;
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'junk_test'
mysql>
Not only am I a little confu
the license and update the DB
and so on -- and then it should probably send the email to the user, too!
%
% Any ideas would be greatly appreciated.
HTH & HAND
%
% - Sheryl
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL P
r and Stefan's messages mentioning
it.
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http:/
;s *exactly* what I needed. Works perfectly.
I *promise* I looked in the reference manual; CONCAT does not appear in
the TOC at all, and there is no "how do I glue these fields together"
example listed in the 3.5 examples.
%
% Duncan
Thanks again & HAND
mysql query,
:-D
- --
Da
.. :-)
Indeed :-)
Thanks a bunch for the clarification!
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health&quo
query or rewrite the shell script,
neither of which can make it onto my list today).
Does mysql have a formatting option (other than -H, since HTML is the
last thing I want) to allow me to define the output, perhaps in a manner
similar to a printf string?
TIA & HAND
mysql query,
:-D
- --
D
where I have a
question... Does the ODBC back end read the Access DB file, and if so
what sorts of back ends are out there for Linux and FreeBSD?
% Hth,
% Arthur
Thanks a *bunch* & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED
iles -- but without
having to have MS Access. That would be my desire if I ever had to touch
an MS Access file, since I don't have Access almost don't run Windows at
all.
Did I misunderstand anyone?
HTH & TIA & HAND
mysql query,
:-D
- --
David T-G * Th
; HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpn
ten a
file converter -- also quite possibly because MS hasn't released the file
spec and nobody has reverse-engineered it :-)
I did a quick CPAN search and found DBIx::Record::Format::ODBC::MSAccess
which looks somewhat hopeful; you might dig into that a bit.
HTH & HAND
mysql query,
OS cluster. What platform are you using?
%
%
% Thank you
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Scien
-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
ow to send a note to the robot to turn off autoreplies to
one's address...
%
% Sherzod
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker
ption.
% statistical analysis. Also, which table type is good for this purpose? I
% will be thankful for any suggestion on this.
Since you're just holding data and not, as far as I can tell, doing lots
of transactions, an ordinary myisam table is probably quite sufficient.
%
% anu
leave it like it is
because it doesn't really matter (and geeks such as I can make anything
funny) or change from 'sex' to 'gender' to make the subject unambiguously
a noun.
HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage i
he UK.
%
% I have previously used a company in India and I am not averse to trying this
% again.
%
% Suggestions anybody...
HTH & HAND
%
% Thanks to all.
%
% Richard
%
% SQL
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL
ticular pointers, but if you still
have problems after these steps, start with the apache docs and try to
get something simple like a static html page or an image to come up.
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EM
grammar; this is all right off the top of my head) and if it
doesn't try any of system, `` or popen.
%
% I'll almost bet that they won't let me run a task from the server.
% What about running a script from an exe ?
What script, what exe, and what machine?
%
% thanks
Sure thing!
from any
other machine that has cron or task scheduler or whatnot.
Meanwhile, start shopping around for other hosts that let you use cron :-)
%
% Any help is appreciated.
%
% thanks
HTH & HAND
%
% MS
mysql query,
:-D
- --
David T-G * There is too much animal c
egant :-) to me.
%
% > % HTH,
% >
% > Ditto :-)
%
% ... :-)
*grin*
%
%
% Benjamin.
%
% --
% [EMAIL PROTECTED]
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral
ld row data as well.
% value not-used in the column automatically (1,2,3,1026,4,5,1000,6,7,...)?
Nope.
%
% Thank you,
% Vicente
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not suffi
-)
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvb
es it :-)
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/dav
used any Linux, give SuSE a try.
%
% Your comments are really appreciated.
%
% Thank you,
%
% JFernando
% * sql *
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas, et al --
...and then Thomas Spahni said...
%
% Hi, David
Hi!
%
% On Tue, 21 Jan 2003, David T-G wrote:
%
% > % Are you sure that smallint is enough for your index? Do you really need to
% >
% > I've thought about that a
s your expected recovery time for a complete disaster on my
machine?
and go from there; if any of the answers don't sound right, then ask more
questions about that topic.
% Any opinions on either?
I have the best quality/price ratio, of course. [Oops; I did it again.]
% Thanks.
HTH
in the database -- and vice versa.
%
% thxs.
HTH & HAND
%
% Alex.
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "
o name a few of the *many* possibilities and
permutations thereof.
% Any comments are welcome. Thanks a lot.
%
% --
%
% Clemente Zamora
% GlobalReservas
% (http://www.clementezamora.com)
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courag
you purchas an
UnSubscribe Support Services Contract.
%
% Sam
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health&quo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas, et al --
...and then Thomas Spahni said...
%
% On Mon, 20 Jan 2003, David T-G wrote:
%
...
% > create table pieces
% > (
% > # ID number
% > id smallint unsigned not null default 0 auto_increment primary key ,
% >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Victoria, et al --
...and then Victoria Reznichenko said...
%
% On Monday 20 January 2003 16:16, David T-G wrote:
% > create table pieces
% > (
...
% > words text (4095) ,
% > fulltext index (words(4095))
% > ) ;
%
% Dav
D
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf
no
expected bugs and you can start using it now, though we'll probably do
more development and add some features here and there" in the MySQL world
as well as for much other software.
I think that Microsoft starts selling their products at about the 'beta'
stage,
our table structure, which I'll
do in more detail now that I have an example against it, and then I have
to figure out how to read that to learn a bit about how it works -- but
I'm very grateful!
%
% =C=
%
% *
% * Cal Evans
% * Stay plugged into your audience.
% * http://www.christianper
ading on joins and haven't figured it out yet. Pointers
to favorite tutorials are appreciated, but I'm trying not to flat-out ask
the list to explain it to me (though that's fine with me at this point,
too).
%
% =C=
Thanks again & HAND
mysql query,
:-D
- --
David T-G
lightened.
% Design" or something like that. I'm sure there's not a lot of posts that
% mention grapes and wines on the list.
Yeah :-)
Thanks! to all & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTEC
hat is just a bunch of FKs to other tables.
Oh, I agree :-)
%
% YMMV, HTH,
% =C=
Thanks & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mar
ne decide what to do in a grey area of this sort -- in this
situation, for example? ;-)
TIA & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] --
he foreign 'composer' field?
TIA & HAND
Good grief; even Dan's qsecretary is better than this mysql query thing!
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Zak & George --
...and then Zak Greant said...
%
% On Fri, Jan 10, 2003 at 11:50:28PM -0500, David T-G wrote:
% >
% > ...and then Gman said...
% > %
% > % How can I delete a database in MySQL so I recreate it?
% >
% > echo
e password for that user. More in the manual :-)
%
% George Flatman
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy
else is computer related'. I just don't have the
time for all of that other stuff, even if I do run off at the mouth
mysqlf (hey, that typo is good enough to leave in here :-) sometimes.
%
% Larry S. Brown
% Dimension Networks, Inc.
% (727) 723-8388
mysql query,
:-D
- --
David T
ty, perl) at 0.25 until recently and have just made the
jump; yay :-) Meanwhile, if you're tracking your pro-bono and/or learning
time, it may be better for you to credit back the hours because you can
then count up what you've given away.
%
% Many thanks,
HTH & HAND
%
%
Well, there again you're crossing functionality... The developers care
about the database engine and how to get data in and out quickly; backup
is an entirely separate issue. Yes, it's important, but it's very much a
different animal -- and so it shouldn't be part of the same
uggest that this be part of the now-nascent FAQ, so I've
copied the mysql-faq list on this reply.
Thanks & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECT
ain mysql list. But even lurkers are welcome on the FAQ list :-)
%
% Regards,
% --
% Stefan Hinz <[EMAIL PROTECTED]>
Thanks & HAND & HNY
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral cour
you're also walking around with a loaded and
cocked gun with the safety off and your finger on the trigger. Don't
stumble :-)
%
% TKS
% Rick
HTH & HAND & Happy New Year
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [E
t;[EMAIL PROTECTED]>
Thanks for the pointer!
%
% Bruce
Thanks & HAND & HNY
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker
!
%
% I'd be happy to build the software, if that helps.
We'd love to have you :-)
%
% Let me know
%
% Peter
Thanks & HAND & HNY
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not suffic
row and fill in the left-most empty one? Do I stick the IDs
in a text field and then parse my way across that field, or can the DB do
it?
%
% Any way
% You may have to re-think parts of your database structure. A good book on
% ERD diagrams might help.
Indeed.
%
% Bes
e came together in a group class).
Even so, that still doesn't answer the question of how to have data of
different magnitude in the same table. If I have one class with one
person and another with two people, how would I have a single record for
each which lists the client(s)?
Thanks again
have more than
% one class.
% You no longer need to worry about double booking.
Because I can come back to an unique index, you mean, perhaps?
%
% Hope this helps
It's a start; thanks a bunch!
HAND & HNY
:-D
- --
David T-G * There is too much ani
nt and i.fname =
'penelope' order by timeslot;
which gives me a lovely
++-+
| substring(s.timeslot,1,13) | concat(c.fname,' ',c.lname) |
+--------+-+
| 2002-12-27 0
0948-0 Fax: +49 30 7970948-3
HTH & HAND & HNY
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://justpick
jump on it at the start.
HAND & Happy New Year
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health"
http://j
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
...and then David T-G said...
%
% I'm so far about knee-deep in my project where I'll be using php to talk
% to the mysql database and spit out my web pages. I wonder if I should be
% making individual calls to the database or
SQL question, so this once I've
posted it to both lists. I'll also summarize to both.
TIA & HAND & Happy New Year
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
> Thanks & HAND & HH
%
%
% Hehe. I wondered about the non-abbriviation in your first mail
% already. ;-)
*grin* I figure the first one in the thread will define it for later
since it's not too standard... :-)
%
% HTH,
%
% Benjamin.
%
%
% --
% [EMA
rary tables) only stumble upon a specific bottleneck. It
Ahhh...
% sounds to me as if you are worrying about non-issues currently. But,
% of course, a basic understanding of what is going on never hurts.
Heh. Yeah :-) Where can I buy one of those? ;-)
%
% HTH, and yes, HAND, too,
%
% Benjamin
Regards,
% --
% Stefan Hinz <[EMAIL PROTECTED]>
% Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
% Heesestr. 6, 12169 Berlin (Germany)
% Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
HTH & HAND & Happy Holidays
mysql query,
:-D
- --
David T-G
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
...and then David T-G said...
%
...
% hashsum tinyblob not null , # hash of the card: have we seen this one?
% index (hashsum) # for quick lookups
...
% ERROR 1170 at line 49: BLOB column 'hash' u
nyblob(255) not null
but that puked at the create stage :-)
TIA & HAND & Happy Holidays
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Ed
ep all my "drop" statements in one script, all my
% "create" scripts in another, and all my "populate" scripts in yet another.
Yeah, I think I'll do something like that.
%
% Arthur
Thanks & HAND & Happy Holidays
mysql query,
:-D
--
David T-G
ve :-) I thought that a
temporary table helps to speed up specific queries because the grouping
is already done and then you just select from that, but I dunno :-)
%
% HTH,
%
% Benjamin.
%
% --
% [EMAIL PROTECTED]
Thanks & HAND & Happy Holidays
:-D
- --
David T-G
gh I like mysql...
%
% HTH,
%
% Benjamin.
%
%
% --
% [EMAIL PROTECTED]
Thanks & HAND & HH
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Scie
content as well :-)
%
% 'Preciate any aid on this.
HTH & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED] -- Mary Baker Eddy, &
lly slow as the table grows... Is this the sort of thing
where a temporary table is advised, or should I define a reverse table
that shows each instructor and his/her bookings, or what?
TIA & HAND & Happy Holidays
:-D
- --
David T-G * There is too much animal courage in
(
1 - 100 of 141 matches
Mail list logo
