Hello friends,
I need to reset auto increment to a lesser value, is there a metod to do so
in any version of mysql.
Pl. help me.
Thanks
abhi
On Sat, Aug 2, 2008 at 10:49 PM, Nacho Garcia [EMAIL PROTECTED] wrote:
http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
mysql *ALTER TABLE tbl AUTO_INCREMENT = 100;*
On Sat, Aug 2, 2008 at 5:28 PM, abhishek jain [EMAIL PROTECTED] wrote:
Hello friends,
I need to reset
abhishek jain wrote:
On Sat, Aug 2, 2008 at 10:49
But as per a thread on this link, if the resetted value is less than the
highest value already in table then the effective increment value will start
from highest number and not from 100.
I have deleted some rows and i want the increment to
Mark Goodge wrote:
On a more general note, if the actual value of the primary key matters
for anything other than simply existing as a primary key, then you
shouldn't be using auto-increment at all. You should generate the
value through some other means and insert it with the value that you
Chris W wrote:
Mark Goodge wrote:
On a more general note, if the actual value of the primary key matters
for anything other than simply existing as a primary key, then you
shouldn't be using auto-increment at all. You should generate the
value through some other means and insert it with the
Hey all,
What is the most effective way to block HTML code
in insert statements?
I have a client with a comments form that is being
bombarded with people inserting references to
their own sites, etc, and I need an effective way
to filter basically any HTML tags at all.
Thanks,
Skip
--
On Sat, 2008-08-02 at 16:16 -0500, Skip Evans wrote:
Hey all,
What is the most effective way to block HTML code
in insert statements?
I have a client with a comments form that is being
bombarded with people inserting references to
their own sites, etc, and I need an effective way
to
Skip Evans wrote:
Hey all,
What is the most effective way to block HTML code in insert statements?
I have a client with a comments form that is being bombarded with people
inserting references to their own sites, etc, and I need an effective
way to filter basically any HTML tags at all.
Doubt this can be done easily if at all.
Accept only text and no html. But even that should be the job of the form
validator
--Original Message--
From: Skip Evans
To: mysql@lists.mysql.com
Sent: Aug 2, 2008 14:16
Subject: Blocking HTML code in inserts?
Hey all,
What is the most
assuming php from your sig strip_tags
http://www.php.net/manual/en/function.strip-tags.php
shannon
On Aug 2, 2008, at 5:16 PM, Skip Evans wrote:
Hey all,
What is the most effective way to block HTML code in insert
statements?
I have a client with a comments form that is being
I'm seeing this more and more
I'm hearing the justification that its easier to put an pre-formatted anchor
tag or href but you're right
if html is stored in the DB then javascript can easily follow
of course the overseas contractors sticking in href to their own sites sure
does'nt help
Glad to
11 matches
Mail list logo