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
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
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
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, &
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
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)
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
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
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
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
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
-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
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
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
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
% 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
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
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
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
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]
-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
. 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
:-
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
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
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
-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
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
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
ted column or a whatever when I
create this table?
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, "
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello again --
...and then David T-G said...
%
% I would like to create a couple of related tables (just for starters) but
% I can't figure out how to do it; there are lots of CREATE TABLE examples
% in the mysql manual but nothing that
:-)
%
% PB
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] -- Mary Baker Eddy, "Science and Health"
http://www.justpickone.org
:-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://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
I can design and implement it, though, at my
usual consulting rates; you might want to sit down with me (or anyone
else, but *someone*) and see what you really need and what it's going to
cost you.
%
% Rgds,
% Neil
HTH & HAND
mysql query,
:-D
- --
David T-G
le_size33554432
tmpdir/var/tmp/
version 3.23.52
How does it look, Doc? Will I ever play the violin?
%
% PB
Thanks & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and n
tions with a ccard and then bill the card if you fail to show,
not unlike hotels do. AFAIK they retain card numbers long-term for
customer convenience (heh -- and their own, as we all truly know) and
so I can't store them in a non-backed-up, one-time-pad table or some
such.
TIA & HAN
.2.3 "How Stable is MySQL?".
%
% Thanks,
% Joao.
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&
leted.]
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://www.justpickone.org/d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William --
...and then William R. Mussatto said...
%
% On Sun, 1 Dec 2002, David T-G wrote:
%
% > Date: Sun, 1 Dec 2002 18:42:03 -0500
% > From: David T-G <[EMAIL PROTECTED]>
% > To: mysql users <[EMAIL PROTECTED]>
% > S
;mysql"
% database?
You might try starting mysqld with --skip-grant-table to remove the
restrictions and then create a fully-capable account (or change the
database root account password) and then restart normally.
%
% Thank you,
% Jing
HTH & HAND
:-D
- --
David T-G
ns to the data. A third person cannot read it.
Sounds like a start. Thanks for the ideas!
% -- Bernd
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]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Peter, et al --
...and then Peter Brawley said...
%
% > I can't find a my.cnf file anywhere on this
% > FreeBSD 4.5 system!
% >
% > I know [also from your other reply :-] that I can set various options in
% > my personal .my.cnf file... Does that i
;m not any of the first three?
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://www
of course prefer to use Apache as my web server.
Of course!
%
% Other than that, I am open to suggestions or comments.
HTH & HAND
%
% bjc-
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral cou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello, all --
...and then David T-G said...
%
% I apologize in advance for asking kindergarten-level questions on the
% list, but my head is getting really bruised from this one. I'm trying to
I still don't understand it all ;-) bu
n email address
beginning with [-_\.] (though I don't have time to test it at the
moment).
Wouldn't something simple like
...
WHERE Email NOT REGEXP ".*@.*"
do the job nicely (if not the 'NOT REGEXP "@"' of another reply)? It
certainly would be easie
ndled for me :-)
Is sorting and speed a consideration when making a select request? Is
that the sort of thing where an index will speed things up?
TIA & HAND
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not suffi
n't casually log in on your machine as root, you
shouldn't casually use a root mysql user for your work. You might make a
root account for yourself, but also make a normal account and work within
that except when you need special access.
%
% Thanks,
%
% TR
HTH & HAND
mysql qu
# last, first names
lname varchar(40) ,
index (lname) ,
fname varchar(40) ,
index (fname) ,
mname varchar(40) ,
...
) ;
for a client table with indexed first and last name fields?
%
% PB
I'll ask about char vs varchar and text next time :-)
Thanks & HAND
ld have to be an "executive summary" overview so that it didn't my
eyes bleed, though :-)
TIA & HAND
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PRO
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ted --
...and then [EMAIL PROTECTED] said...
%
% On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote:
%
% >...and then [EMAIL PROTECTED] said...
% >%
...
% >% Most things I've read say to establish a "mysql" user -I
E like 'smith%'
or such?
%
% PB
%
Thanks a bunch & 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
rows
will not be updated" or the like.
%
% Regards,
% --
% Stefan Hinz <[EMAIL PROTECTED]>
% CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de>
% Heesestr. 6, 12169 Berlin (Germany)
% Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
Thanks a bunch! & HAN
definition
and then list from there (and then it gets messy if we add a new level)
or do I create a "jobscalelevels" table and define the levels in there
and then set the personnel.level field to match and forget about the idea
of a set?
TIA & HAND & Happy Ho
rupted (MC, MasterCard, mastercard, ...), but I guess that gets
enforced in the software interface, right?
Thanks again & HAND & Happy Holidays
mysql query,
:-D
- --
David T-G * There is too much animal courage in
(play) [EMAIL PROTECTED] * society and not sufficient mo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daevid --
...and then Daevid Vincent said...
%
% Thanks for the reply Bill, however this did not solve the problem. I
% still receive the same error with your method as well.
%
% 1064: You have an error in your SQL syntax near ';
% CREATE TABLE Depa
an. Just try to create a db and two
% tables and you'll see it choke.
Actually, while I do both php and mysql, I haven't yet done mysql from
php -- and so I'd be a lousy debugging source for that :-)
%
% d
HTH & HAND
mysql query,
:-D
- --
David T-G
d for redundancy, perhaps as a
slave server, since this is business and time is money).
HTH & 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
ing accessed. But I specifically wasn't talking about HW/OS
limitations because he wasn't :-)
% 80 million records and it takes minutes with a gig of RAM
% and 800 pentium III. each minute in front of a computer is
% like dog years... 1 = 7
*grin* Too true...
%
%
% Jim
HTH &
xit "some error" ;
create database dbname ;
...
and not try to create and populate a database on top of an existing one?
Or is there perhaps a "RENAME DATABASE" command (I saw RENAME TABLE) so
that I could rename the old one to get it out of the way but not toss it?
TIA & HAND
m
; 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 Eddy, "Science and Health"
http://www.justpickone.org/davidtg/Sh
p; 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 Eddy, "Science and Health"
http://www.justpickone.org/da
, you could react very flexible
% on the concerns you mentioned.
Yeah. There will be an installation script (probably shell, because of
its portability, but perhaps perl for power) so I can just take the extra
steps of detecting the database and getting rid of it as a subtask.
%
% HTH,
It does; th
n a real database but I'll be inserting the values
one at a time from my front end where I'll calculate the md5 sum myself,
but it works as an example.]
% can test with the SELECT and only add CREATE TABLE / INSERT part at
% the end. And LIMIT is your friend.
OK :-)
%
% HTH,
%
% B
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
(
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, &
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
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
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
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
-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
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
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
> 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
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.
-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
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
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
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
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
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
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
!
%
% 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
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
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
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
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
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
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
%
%
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
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
-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
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
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] --
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
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
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
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
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,
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
-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
1 - 100 of 141 matches
Mail list logo
