r something similar, it's not a common
occurance to run more than one query in the same query() function;
therefore, no semi-colon is required by the coder, which voids the
possibility of accidentally adding a second semi-colon.
--
Mike Johnson . : . : . AIM: denonymous
ht
d only return those
dates equal to or later than the current datetime.
--
Mike Johnson . : . : . AIM: denonymous
http://www.coldcircuit.net ' : ' : ' http://65.96.177.11
"According to one of our readers, the new MacOS X contains another
Satanic holdover
re on your
filesystem than MySQL. If you can support file sizes greater than 2G or 4G,
then there probably is no limit.
And for the record, you should *not* direct questions like this to
[EMAIL PROTECTED], [EMAIL PROTECTED], or [EMAIL PROTECTED]
--
Mike Johnson
have access to the MySQL default client?
If so, log in and use the following:
SET PASSWORD FOR user@host = PASSWORD('newpassword');
--
Mike Johnson . : . : . AIM: denonymous
http://www.coldcircuit.net ' : ' : ' http://65.96.177.11
"According
rge
Does that help, maybe with a system() or backticks call?
--
Mike Johnson . : . : . AIM: denonymous
http://www.coldcircuit.net ' : ' : ' http://65.96.177.11
"According to one of our readers, the new MacOS X contains another
Satanic holdover from th
ECT MAX(iSession), iUser FROM O_Sessions GROUP BY iUser;
+---+---+
| MAX(iSession) | iUser |
+---+---+
| 2 |41 |
| 4 |42 |
| 6 |43 |
+---+---+
3 rows in set (0.00 sec)
Does that last query help?
they could all be executing
various
> snippets of
> sql over 5 connections.
>
> -Original Message-
> From: denonymous [mailto:[EMAIL PROTECTED]]
> Sent: 02 May 2002 08:27
> To: Sean O'Donnell; [EMAIL PROTECTED]
> Subject: Re: ensuring that I'm getting the
t ID"
> what happens if you are using connection pooling though?
>
>
> -Original Message-
> From: denonymous [mailto:[EMAIL PROTECTED]]
> Sent: 02 May 2002 08:09
> To: [EMAIL PROTECTED]
> Subject: Re: ensuring that I'm getting the correct "last insert I
would be the wrong userID being
returned. LAST_INSERT_ID() is handle-based, though, so there should be no
worries with that -- the sessions will be kept separate.
Hope this helps!
--
denonymous . : . : . AIM: denonymous
http://www.coldcircuit.net ' : ' : '
. One of the
> books in the table is 'Professional PHP Programming', but, while 'php'
> will pick it up, and 'php perl' as well, 'php -perl' won't!
>
> Surly it should work! :-S
Your NOT terminology is wrong -- if you can get it to say &qu
e end of your SQL query, simply add an ORDER BY [ASC|DESC] clause.
In your case, it looks like it'd be:
SELECT * FROM news ORDER BY datetime DESC;
--
denonymous
www.coldcircuit.net
http://24.91.199.33
-
Before postin
From: "Andrew Rich" <[EMAIL PROTECTED]>
> Howdy, how can I add an extra field to an already created table in sql ?
ALTER TABLE tablename ADD columnname attributes
See http://www.mysql.com/doc/A/L/ALTER_TABLE.html for more details.
--
denonymous
-+-+
> | 1 | 20020404164500 | 20020405111308 | 0 |
> ++++-+
> 1 row in set (0.01 sec)
This is a MySQL feature -- the first TIMESTAMP type column in a row will be
updated automatically wh
imes insert fine, when using single- or double-quotes, but
when quotes aren't used, I think MySQL assumes it's an integer and trims
leading zeros.
Hope this helps!
--
denonymous
www.coldcircuit.net
-
Before
name;
Not sure about all rows from all tables, though.
--
denonymous
www.coldcircuit.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
ion...
One example that comes to mind is accessing ftp://, gopher://, news://, etc
from a web browser.
Seems like a fairly valid newbie question to me, especially if one is not
versed in protocols.
--
denonymous
www.coldcircuit.net
-
he 5th Friday of the month, if there is one."
How would you do it? Any ideas?
--
denonymous
www.coldcircuit.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
+
As far as as I can tell, the following query should deliver what you want:
SELECT SUM(invoice_amount), state, statement_date
FROM invoice
ORDER BY statement_date, state
Let me know if this does the job!
--
denonymous
www.coldcircuit.net
0)
SELECT * FROM tablename ORDER BY field1 LIMIT 9,20;
(selects rows 10-30)
--
denonymous
www.coldcircuit.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
one provide some help?
Try this:
delete from user where user='wus';
--
denonymous
www.coldcircuit.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
e before it goes into the
database to trim it down to a reasonable size in the event some joker
decides to paste a few thousand lines of text into the comments.
--
denonymous
www.coldcircuit.net
-
Before posting, please check
DATE foo SET clicks=clicks+1;
SELECT * FROM foo;
UPDATE foo SET clicks=clicks+1;
SELECT * FROM foo;
DROP TABLE foo;
You can increment 'columnname' with 'columnname+1'; that way, you don't need
to get the current value first.
--
denonymous
www.coldcircuit.net
--
his won't give you UNIX_TIMESTAMP(), but it gives you the MMDDhhmmss
timestamp. Does that help?
--
denonymous
www.coldcircuit.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
The documentation for Apache is pretty good, too, even on
Windows platforms.
(never thought I'd be one of those guys that sits on lists and plugs open
source, but hey -- the times are a-changin'!)
--
denonymous
www.coldcircuit.net
--
this forum but, if you'd
really like, you can mail me for some info relating to the issue.
--
denonymous
www.coldcircuit.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
From: "phplist" <[EMAIL PROTECTED]>
> I've tried further, and still came up short. This time, if I use the % -
> it returns nothing.
Here's another way to do it, using PHP:
Organization: http://$url\";>$organizationGeographic Region:
$geographicDescription: $descriptionURL: http://$url\";>$urlS
t want to use this for your application, especially as you'd
now have a web-based user with rights to the reserved mysql database. That's
a huge security risk.
I'd highly recommend creating a new table, outside of the reserved mysql
database, and leave that database fo
ast_backup;
I've done this in the past, and this method of creating a table doesn't copy
key info. Took me a couple tries, but I finally figured it out.
I don't know if this is your problem, persay, but it's the only time I&#x
ething that
> has to be enabled?
I was referring to the slave's replication binlogs, but it appears you don't
have them (they'd be on the slave in the MySQL data directory, afaik). I
don't know much about replication setup, I'm only going by our setup here.
field3=3D'three';
> >
> >it works with as many AND and
> >it works with OR but not together
> >
> >is there something like brackets or other logical opertators
Yes, parentheses work fine. This should help you out:
SELECT * FROM table WHERE (field1=3D&#x
n
me. There are a couple other reports here that calculate this number in
other ways, and I'd like to be able to positively state that this is the
be-all end-all for the needed data.
Much thanks!
--
denonymous
www.coldcircuit.net
denony
s and the replication logs? The
replication logs should be in the MySQL data directory. When a slave stops
replication, that's where the last known error is logged, and usually sheds
insight into *that* problem.
I don't know if it'll show anything, but if you haven't
es are not padded; instead, trailing spaces are removed when values are
stored. (This space removal differs from the ANSI SQL specification.)"
--
denonymous
www.coldcircuit.net
denonymous.ne.mediaone.net
-
Before posting, please
by the machine(s) you're running the
INSERT on.
--
denonymous
www.coldcircuit.net
denonymous.ne.mediaone.net
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
;
SELECT DECODE(pass,'encodepassword') FROM foo WHERE username='testuser';
DROP TABLE foo;
Hope this suits your purposes...
--
denonymous
www.coldcircuit.net
denonymous.ne.mediaone.net
-
Before posting,
35 matches
Mail list logo
