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
: 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: [EMAIL PROTECTED]
Sent: Tuesday, April 01
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
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
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't
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 TABLE
will be 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
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
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
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 PROTECTED]
Subject: Re
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
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: [EMAIL
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
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?
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,
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)
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)
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
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
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)
23 matches
Mail list logo