Hours after I left this mailing list, I found a bug
in 3.23.47. Since it's so easy to reproduce the bug here,
I'll let this example speak for itself:
CREATE TABLE t1 (txt varchar(10) default NULL);
INSERT INTO t1 VALUES ('aaa');
INSERT INTO t1 VALUES (NULL);
SELECT BINARY txt AS t FROM t1 GROUP B
[EMAIL PROTECTED] writes:
> OTC News Alerts' Last 3 Picks have gained 358%!
> Here is our next Hot Pick!
That's it. I'm out of here too.
//C - wonders what the list owner gets for letting the spam in. 10%?
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EM
@localhost entry,
but you want user@% to be matched when you connect from localhost.
Could that be it? If so, section 4.2.8 is your (rather dull) friend.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since
ted for a password, try
alias mysql="mysql -p"
//C - thinks that'll do it.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
-
formation on what you
did, it might be possible for someone here to see if it
is indeed a bug.
//C - mostly blaming himself if something crashes.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user
slashes() to exist,
it probably wouldn't.
//C - paranoid, but for good reasons
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
--
QL? Was it MyISAM, InnoDB, or some other
table type? You're not using the 2.2.14 Linux kernel,
right? And ermm.. well, that's all I can thin of now,
except.. you didn't run myisamchk on the table while
mysqld was running. No... nobody does that. Except me,
once, and it didn
or how often, so
I'm not really in a position to suggest anything. I just wanted to
raise your awareness of the possibility of such a solution.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Am
Ilic writes:
> SELECT count(distinct ip) FROM pole_voti
>
> It does'nt work. Why ?
What's your MySQL version? Check the docs to see what version is
required for count(distinct). I think it was added in 3.23.early,
so it might be time to upgrade.
//C
--
Carl Troei
t's best. If the
status column only has a few different values, an index
will not be used because the overhead of using the index will
be greater than the benefit. If this is the case, you'll
be better off without the index, and you could consider one
of the two options I rambled abou
's only done in a few places it should be doable.
If that won't work, but it's not important with perfect
accuracy, you could run that evil SELECT once a day or
however often you like, and cache the result.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTEC
ist owner can figure out how to restrict posting to
subscribers only, how hard can it be? As far as I have seen,
it's quite rare with serious posts from non-subscribers,
whereas the spam and empty bug reports arrive at a rate that's
on the order of mails per day.
//C - annoyed
--
Carl T
VAL 2 HOUR)
Except that you'd have to extract the correct offset from your
current local timezone. And of course you must know what TZ the
server has. The number of hours might not be an integer, btw,
but I'm pretty sure the number of seconds will.
//C - earlier than usual
--
Carl Troein -
LONGTEXT and you want
to put in in the database? That doesn't make much sense.
Why would you want to store more than 4 gigabytes per table row?
And what sort of data is that anyway? Since you'll probably not
have very many objects of that size, why not use the file system?
//C - giving
f you can't figure out". The page which
discusses how things work is
http://www.mysql.com/doc/C/o/Connection_access.html
It's probably a good idea to remove the entry for ''@'localhost'.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PRO
Host: %
>User: rknop
localhost is a special value (meaning connection over unix socket
rather than TCP/IP), and it's not matched by % in this case. You
need to grant access to user@localhost as well.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PRO
mail = CONCAT(SUBSTRING_INDEX(email, '@', 1),
'@comcat.net') WHERE email LIKE '[EMAIL PROTECTED]'
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org
ut it, but the
most common problems seem to be that mysqld is not running or
just plain old messed up file permissions.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '
it, but I think it'll be Q2 2002.
//C - forgets things
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
--
les of MySQL running
on high-end machines.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---
ction STDDEV_POP() which returns the population standard
deviation, so I thought that maybe it'd be a good idea to
implement this in MySQL as well. What do you think?
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
u should've been aware that the disk was about to
get full before it actually did, and so you should've had time to
make more room for the database.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
urself will have to make sure that the data in that column is what
it's supposed to be (with respect to what's in the longer column).
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89,
Shannon Kendrick writes:
> Does anyone know of a way to lock at the row level
> instead of table level using MySQL 3.23.46
Yep, use InnoDB instead of MyISAM tables.
//C - person of few words. But surprisingly seldom.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
throwing authentication failed.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
-
Before posting, pl
r to everyone: If you have a problem, you
should always consider buying a support contract from MySQL AB.
Hell, even if you don't have a problem, consider buying one just
to support them. After all, without the money they wouldn't be
able to do as much developing as they do.
//C
--
Carl Tr
he same piece of information in
two places. You could possibly use a INSERT...SELECT to a temp
table, and then REPLACE from that, although you'll probably need
to do table locking to avoid losing simultaneous updates to the
table.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 1
ase that you only use for temporary tables,
and give the user CREATE on that. It's a pretty clean solution,
except that it'd give you two rows in mysql.db instead of just one,
and you'd have to use database.table[.column] when accessing it.
//C
--
Carl Troein - Círdan / Istari-PixelMagic
l gives me error 1045 again.
> Can't get in with mysqladmin either.
What exactly are you doing and at what point does it fail? Could
you post the contents of your terminal window after failing?
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http:
th (absolute
or relative or whatever)
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
-
Befor
e to 'ignore' screws up the rules for all IPs?
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
MYS
ysql.sock.
Well, since the server fails to start that error is to be expected.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---
y don't want to match 3
out of 4 values for the first set and every other for the second.
That is, you're doing a bitwise AND (&), when what you want is probably
just a plain equality (=).
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UI
st so that the people at MySQL can get rich by
sending us spam? :-o
//C - In insane conspiracy theory generation mode
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '8
to be that greedy/cynical, but anyway.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
-
Befo
daemon is a potential security hole. This is
certainly true for mysqld, where the default privileges are very
permissive.
//C - pissed off at procter & gamble for screwing up his shampoo.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/
lected a database yet. Maybe you're intending
to do a SHOW TABLES?
> Unknown database
Just a hunch: Have you actually CREATEd the database? That is,
have you done a "CREATE DATABASE phpbook"? Note that it's
legal to grant permissions on databases that haven't been
created
Pragneshkumar Gandhi writes:
> > It doesn't, and IMHO the manual is clear on this:
> > "The planned update language will be able to handle
> > stored
> > procedures. Our aim is to have stored procedures
> > implemented
> > in MySQL 4.1. We ar
orking i do
> appreciate any help.
That's premission denied. Check the permissions on the data dir.
Maybe you did a chown -R ... * instead of chown -R ... . when you
gave it to the user?
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyn
tored
procedures. Our aim is to have stored procedures implemented
in MySQL 4.1. We are also looking at triggers."
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user sinc
ver is an ISP)?
What unix user you are is irrelevant. However, what MySQL user
you are is not. You should read the chapters on privileges and
security, and ask your ISP to do so too. You shouldn't be able
to connect as the anonymous user.
BTW, your clock is off by ~65 minutes.
//C
--
the manual section on table/column names if I'm not
completely mistake (could very well be, tho).
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirda
sults, so i
> killed the query).
What're the table structures (most importantly: what indices exist)?
What does the data look like? What did EXPLAIN return? Anything else
we should know? (that's a catch-all question from a sleepy and
intoxicated person, in case you're wonderin
since 3.22.
//C - points to the section on line length in the netiquette FAQ.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---
imilar if you don't want to have to set the
date and time manually.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
doing it after each and every
DELETE might be considered overkill, at least if you're not deleting
a majority of the rows.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '8
eful information about MySQL's host
cache. The only thing that seems to be missing is some way to
have entries live a fixed about of time, but since you can
FLUSH HOSTS every now and then, or turn off the caching completely
I don't think it's a real problem.
//C - learning
--
C
d restart the server at regular
intervals (once an hour or whatever) if one relies on host
names (maybe not a good idea unless you can control the DNS
server and/or hosts file) for additional security. This, of
course, assuming that the name<->address mapping isn't
absolutely constan
ends up hundreds or even thousands of positions
wrong in the list.
//C - about to change to pine. Seriously.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '8
and for about $2000 we got a dual AthlonMP @ 1.2GHz, 1GB RAM,
100GB IDE HD, and a nice-looking fulltower with lots of fans.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since &#
h MIN(column)>constant is equivalent to WHERE column>constant.
//C - not wearing his glasses
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
o
//C - doesn't trust users.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
-
Before posting, pleas
in. Could it be that you've done
some unwanted pre- or postprocessing of your data, such as escaping
some HTML entities?
//C - vague
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since
assword then later on i found
> out that the user table's password field had encryted . So what can i do if
> i want to make a login page to user which the password will be able to match
> the password in Mysql.User table.
See 1.
//C - hungry
--
Carl Troein - Círdan / Istari-PixelM
Jerry writes:
> How did you know I have an Amiga???
I know everything about everybody. I'm god. :-)
Or actually, I just looked at the mail headers. But hey,
you can still call me god if you want to. ;-D
//C - more diabolic than divine
--
Carl Troein - Círdan / Istari-PixelMag
a side note to Jerry, I checked my uptime this morning, and
my Amiga1200 has now been running for 59 days without a single
reboot. I have yet to see windows do that. :-D
And... oh my, it's freaking snowing outside. Aarrghhh!
//C - doesn't like cold weather
--
Carl Troein - Círdan / Istari-
VBScript, but I need to to this in mySQL).
Yes, string_expression+0 will be an integer. It's not pretty, but it
works.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '
at were matched and updated and the
number of warnings that occurred during the UPDATE. "
I believe this answers your question.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
and
sensible way, you just need to consider the file system permissions.
Make sure whatever file you try to dump to is really writable by
whatever user mysqld runs as.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga
Enter password:
> ERROR 1045: Access denied for user: 'web@localhost' (Using password: YES)
localhost is a special value not matched by wildcards. You need a
separate row in the user table for web@localhost. It might also
be wise not to allow access from every computer in the world, unless
ile or directory
Make sure the socket really there. Shouldn't it be /var/... and
not var/... ?
Oh, and unless your mail system had some sort of a problem, your
date is off by almost exactly one day.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pi
ignificant) difference. Also, the order of the columns might
have some archeological curiosity value. ;-)
//C - listening to Iron Maiden while drinking tea.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Am
is true if
the auto_increment is on the first part of an index, and you don't
delete all rows in the table with a DELETE without a WHERE.
//C
sql
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECT
make sure that you don't repeat whatever you did to
get the table corrupted. killall -9 mysqld is a BAD idea, as is
messing with the table files when mysqld is running.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirda
M value '' and the empty set
respectively. Also, columns that can be NULL can have a default
of NULL.
On an altogether unrelated matter: Your time zone is set to
pacific time, but your time reveals that you're somewhere on
the American east coast. You might want to correct your TZ.
/
rs might prefer other GUIs.
//C - ponders pizza
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
-
B
ues as one set,
which always has the same number of members (20).
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
-
ld take lots and lots of work.
How does your application handle such big numbers anyway?
The highest floating point precision I'm aware of (under
normal circumstances, that is) has onle 80 bits, and quite
a few of those are used for the exponent.
//C
--
Carl Troein - Círdan / Istari-Pixe
of all, let's take this back to the list so that
someone else can figure out the answer and/or benefit from
it.
I have no idea what's wrong. Surely the loopback device (lo0)
is up, right? Does your config say something about what post to
use? When you try to connect, does netstat -a give
the GRANT command?
For some reason you always get a 0 back from GRANT. There's probably
some internal reason for this.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it t
the string constant 'NOW(YY-MM-DD HH:MM:SS)'
which will be converted into the number 0. Lose the quotes, and
the stuff between the parentheses. (NOW() doesn't take any arguments.)
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | htt
complicated expression for points within it. You'd need
to index at least one of latitude and longitude.
BTW, I don't want to spend time loooking at it, but... does your
expression really work near the poles?
//C - three-dimensional
--
Carl Troein - Círdan / Istari-P
- shame on me for not working. :-P
Paranoid filter-bait: sql, database, nostril-hair
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---
length for CHAR is the
most important difference and the reason I use them for names
of things (I use TINYTEXT/TEXT for longer descriptions etc.)
//C - with a runny nose, a cup of tea, and a glass of Laphroaig
mysql, database, bloody, filter, die, die, die. :-P
--
Carl Troein -
Carl Troein writes:
> http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
Oops. That only convers the difference between 'localhost'
and anything else. If whoever posted the question is
interested in actually getting things to work, read the
manual chapter on how the pri
ual, your question covered by manual.
> >> Check your users and db table at mysql database
> >> probably the problem comes from there
> >>> My MySQL is not configured properly...
> >>>
> >>> I can connect using localhost with -h flag , but w
ERE (date,score) IN (SELECT
date,MAX(score) FROM quiz GROUP BY date) GROUP BY date,score
which would return an arbitrary person for each date's top score.
I hope this makes sense and clears things up.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http:
SELECT ... where you put that user-input value in
the field list of the SELECT, e.g.:
INSERT INTO foo (a,b) SELECT 10,b FROM tmptable
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmag
it might be useful to have a few different
mysql users that one application switches between based
on what application-level user is using the application,
but that's about it.
//C - expressing his $0.02 worth of thoughts.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 163
converting back and forth, and to
accomodate for a wide range of currencies, you might want to
store more decimals for some currencies than for others.
On the other hand, sums should always add up correctly, so
this might be a stupid suggestion.
//C
--
Carl Troein - Círdan / Istari-PixelMa
ell it. It's only one little number after
all, at least as long as you use some form of INT for your primary
keys.
//C - hopes everything is clearer than his sinuses
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga
e that directory. Have a look at the man page for
ldconfig or search the web for LD_LIBRARY_PATH if you want
to know more about them.
//C - learning
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damn
only
disadvantage of using suexec with php, is that you'll have to run
php as cgi, which means that you'll need shebangs ('#!') in your
files and make them executable and stuff, but it's not that big a
deal usually. There are cases where you're better off with the
module
Jose Luis Maieron writes:
> I'need know what version of MySQL running in Windows, is free licence ?
http://www.mysql.com/doc/M/y/MySQL_server_licenses.html
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga us
mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
-
equest, or should I just ask the admin
of my mail server to add a filter?
//C
database,sql,query,table
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned
isn't running. There's a chapter on
this in the FAQ.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---
so easy to convince. Specifically, their concern
is what potential buyers will think of aquiring something that might
be available to their customers for free. My counter-argument would
be that if someone wants to pay us to incorporate it into a
proprietary product, some sort of value has to be a
es anyone on this list know how?
> Side Question: How can I allow a SSH connection from a remote machine?
You need to install some SSH daemon. I bet there is one or two to
choose from on the Redhat CDs. Have a look at what RPMs are named
something that starts with ssh or SSH or something l
ur newfound knowledge into
swift and merciless action.
//C - always merciless, never swift. Or possibly the other way around.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user s
uot;By contrast, pipes, sockets and command-line arguments are
communication mechanisms normally used between two separate
programs. So when they are used for communication, the
modules normally are separate programs."
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED
a bad idea. This is why it's pointless to index
boolean columns, unless you have a very uneven distribution and
run ANALYZE TABLE while you have such a distribution.
Question to the list: Is the last part of what I said correct?
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 1
pler solution
available. The query in step 3 is extremely fast, so it doesn't
really matter, except that it's a bit more work to make an extra
query.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~
.bitbybit.dk/mysqlfaq/faq.html#ch6_0_0
What you're looking for is probably LAST_INSERT_ID(),
but I'll let you find it yourself. Oops, now I told you. :-P
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga us
endent means of IPC,
such as unix sockets. It's special to the clients, but also
to the privilege system.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user sinc
or 3.x versus 4.x, since upgrading to the
latest stable version is something you're supposed to do anyway).
//C - has 60 mails to read now for some reason.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagi
read the documentation but does not make any sense.
The manual is crystal clear on how to do it. Have you read
the entire chapter 4 and appendix A.4?
And please correct your date. It's off by a couple of days.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16
AQ
before posting.
//C - amazed that the some questions pop up almost every week.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---
a
syntax error due to a typo or something like that.
//C
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
oad it from the
web site.
//C - thinks 20+ line .sigs should be illegal
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---
1 - 100 of 204 matches
Mail list logo
