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 bombarde
: mysqladmin -u root password "newpassword" and that failed
with Access denied. I tried doing that as (computer) root and again I
received that error.
I just do not understand what it is that I am supposed to do.
Can someone provide some light?
Wade
Answered my own question. For posterity:
"alter table abc add unique(foo, bar);"
And the index will be created using the name of the first column you
specify. Works like a charm!
--Noel
- Original Message -
From: "Noel Wade" <[EMAIL PROTECTED]>
To: <[EM
Hi All,
Say I have a table with an auto_increment field that is being used at the primary key.
When I insert a new record, is there any way to easily grab the primary key value for
that new record? I had another unique field that I was originally going to use to do
a select statement; but n
I know its possible to use multiple fields for the primary key in a table
i.e. "primary key(foo,bar)"
Is it possible to do this with "unique" identifiers as well? Like "unique
key(foo,bar)" ??
I already have a primary key on a table, but I'd also like to force two fields to form
a unique comb
Of course, I'd figure it out right after sending this. For the interested:
"alter table XYZ drop key foo;"
Take care,
--Noel
- Original Message -
Given an existing table with a field defined as:
"foo" char(60) not null unique
What would be the proper syntax for an ALTER TA
Hi all,
Hopefully a simple question for anyone who cares to take a swing at it:
Given an existing table with a field defined as:
"foo" char(60) not null unique
What would be the proper syntax for an ALTER TABLE statement, to remove the unique
constraint / key on this field? A "modify" doesn'
voted upon by the users of the site and the top 10-15
questions will be sent off to Monty on the 22nd of this month.
Matt Wade
http://codewalkers.com/
-
Before posting, please check:
http://www.mysql.com/manual.php (the
>Description:
I'm running MySQL-3.23.51 stable RPMS on the master for a replicated database here.
It is processing a large quantity (9,000,000 rows/table/day) of usage records in a
pretty much constant flow of inserts.
The raw usage tables consume roughly 400MB/table/day in .MYD and about the sa
at's going on? I've tried this on two different systems with
the exact same error.
Thanks,
Wade
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Title: Blank
Has anyone built or implemented field level
auditing in a mysql database? Any body have a quick down and dirty way of doing
this?
Thanks for the suggestions
Wyly Wade
Forefront Inc
1413 S. Howard Ave
Suite 104
Tampa Fl, 33606
813-253-2267
be put into the next serious
development instead. ) I understand it does not always work this way.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 3:01 AM
To: Wyly Wade
Cc: Joseph Bueno; Roger Ramirez; [EMAIL PROTECTED];
[EMAIL PROTECT
kes a few seconds to drop an index if you realize you do not need
it afterward.
Wyly Wade
Forefront Inc
1413 S. Howard Ave
Suite 104
Tampa Fl, 33606
813-253-2267
-Original Message-
From: Joseph Bueno [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 3:47 AM
To: Roger Ramirez
Cc: [
Title: Blank
Any body got any good through nightly
maintenance and back-up scripts?
Wyly Wade
Forefront Inc
1413 S. Howard Ave
Suite 104
Tampa Fl, 33606
813-253-2267
why not... it improves speed and removes the overhead and limitations of
the FS.
-Original Message-
From: David Patton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 9:20 AM
To: Wyly Wade
Subject: RE: thoughts on raw file systems
I certainly hope not :)
-Original Message
Title: Blank
Can you use a raw partition with MySQL much
like you can with Oracle or Sybase?
Wyly Wade
Forefront Inc
1413 S. Howard Ave
Suit 104
Tampa Fl, 33606
813-253-2267
Can Cold Fusion querys work with MySQL? What would I have to do if
anything to make it work?
WD
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
Is the common way to index a site, then place that into a database? If so
whats the best(easiest) way to index a site? Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
problem is I have to use mysqladmin variables -u root -p
PASSWORD:x
I tried piping the less command at the end of -p but it didnt work
> Of course it does.
>
> mysqladmin variables | less
-
Before posting, p
when I run the command, (in linux) it serves up the variables. But the
variables seem to be much more than what is listed in Paul Dubois' book. So
I am unable to view all of it in terminal. The less command doesnt work with
it either so how can I view mysqladmin variable info?
--
yes it was an old install, strange, it seems to want to connect now.
bizarre
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request t
I cant get access into mysql. I get access denied for user when
trying to log into mysql as root with password. Anyone help?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
Is it the only way to get mysql to work on d: is to install on c: then move
to d: ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
I have the apache, mysql, php bundle for win. I want to use mysql on IIS
though, will this ver of mysql work or do I need to remove this bundle?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
24 matches
Mail list logo
