At 23:58 -0400 10/9/04, leegold wrote:
On Sat, 9 Oct 2004 22:31:07 -0500, "Paul DuBois" <[EMAIL PROTECTED]> said:
At 23:18 -0400 10/9/04, leegold wrote:
>Seems like mysql_real_escape_string function is not working?
>mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32)
>
>$originalstr
leegold wrote:
On Sat, 9 Oct 2004 22:31:07 -0500, "Paul DuBois" <[EMAIL PROTECTED]> said:
At 23:18 -0400 10/9/04, leegold wrote:
Seems like mysql_real_escape_string function is not working?
mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32)
";
echo addslashes( $originalstring ), "";
echo
I had an encrypted password. I changed the encrypted
password as follows:
mysql>update user password=newpassword;
I immediately relised that I should have used the
following:
mysql>update user password=PASSWORD(newpassword);
I am can not now use MySQL which is locally installed
in my home c
On Sat, 9 Oct 2004 22:31:07 -0500, "Paul DuBois" <[EMAIL PROTECTED]> said:
> At 23:18 -0400 10/9/04, leegold wrote:
> >Seems like mysql_real_escape_string function is not working?
> >mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32)
> >
> > >$originalstring = "Apostrophe's rock";
> >e
At 23:18 -0400 10/9/04, leegold wrote:
Seems like mysql_real_escape_string function is not working?
mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32)
";
echo addslashes( $originalstring ), "";
echo mysql_escape_string( $originalstring ), "";
echo mysql_real_escape_string( $originalstrin
Seems like mysql_real_escape_string function is not working?
mysql Ver 14.5 Distrib 4.1.3a-beta, for Win95/Win98 (i32)
";
echo addslashes( $originalstring ), "";
echo mysql_escape_string( $originalstring ), "";
echo mysql_real_escape_string( $originalstring ), "";
?>
Shows up in my browser as
It's pretty much just how you said it. MyISAM tables (the default mysql table type)
do not support foreign key constraints. InnoDB tables do support them.
Here is a breakdown of the pros and cons of each as I see it (others please feel free
to tell me I've got it all wrong :)).
MyISAM pros:
(SORRY FOR THE BLANK MESSAGE WRONG BUTTON PUSHED)
Greetings:
I am trying to create referential intergrity... I was reading that
mySql does not support that on the Database Level and that you have to
do it manually.
However i am now seeing some posts that talk about it... i.e.
Foreign Key
Greetings:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Did you insert into the permission tables or did you use a GRANT
statement? You may need to flush your permissions (FLUSH PRIVILEGES).
On Sat, 9 Oct 2004 20:57:29 +0200, roland <[EMAIL PROTECTED]> wrote:
> Hello again,
>
> refering to my previous question I forgot to mention that xxx.xxx.xxx.xxx
> I am in need of mysql alpha 4.0.0, i have searched mysql.com but i
> couldn't find it.
> Can anyone help me out, by reffering out a good site.
There is a 4.0.0a version here:
http://downloads.mysql.com/archives.php?p=mysql-4.0
Assuming the "a" means alpha, that should be it.
--
MySQ
Hi Team,
I am in need of mysql alpha 4.0.0, i have searched mysql.com but i
couldn't find it.
Can anyone help me out, by reffering out a good site.
Thanks
Suresh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
Hello all
Sitting stuck in an upgrade to mysql 4.1, I thought this mailing list would be
a good idea to get help.
I've a php4/mysql application developed on a windows xp machine. Right now I
want to migrate this app to my linux machine. Since the app uses subqueries,
I need to upgrade MySQL on
Does the user have permission to access the server remotely, from the IP
address of the client? You may have to add an entry in the user table
in the mysql database specifying the IP address from which you're trying
to log in.
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Hello again,
refering to my previous question I forgot to mention that xxx.xxx.xxx.xxx is
an IP number.
using mysql -h xxx.xxx.xxx.xxx -u user -puserpassword
I would exect to be able to achieve a connection.
The user and userpassword I must add are isnerted with grant with TO
'user'@'%' as we
Hello,
I have my server running can connect via localhost but I cannot connect from
another PC via TCP.
From the client I do this
mysql -h xxx.xxx.xxx.xxx -u mysql
(no password set yet and I the same client call without -h works on localhost)
but I recive the message:
ERROR 2003: Can't connec
If I have a MyIsam table that is not subject to modification,
is a series of select calls like this:
select * from table limit 0,100;
select * from table limit 100,100;
select * from table limit 200,100;
...
Guaranteed to return each row in the table exactly once (as long
as I keep going until the
Just goofing around--not making any claims about efficiency other
than this is the shortest way I've found to do this over my years
of working with different flavors of SQL. This one is running
with MySQL 4.1.
Has anyone done better?
--jim
How it works:
1. a MySQL variable (@num) is used to tra
I did find a reference to EXIST/NOT EXISTS clause in the SQL manual, but I get an ODBC
Failed call when I run the following simplified query
SELECT *
FROM main_db
WHERE NOT EXISTS (SELECT * FROM featureenable WHERE featureenable.FeatureKey =
main_db.FeatureKey);
Bob
-Original Message-
I have a query, call qry_AssociatedFeatures, that finds all features associated with a
given plan
SELECT functionalsubgroup.Functional, functionalsubgroup.SubGroup, main_db.Feature,
main_db.FeatureKey, functionalsubgroup.FSKey, featureenable.PlanName
FROM featureenable INNER JOIN (main_db INNER
I need to move one database with 5 tables to another box. What files I
should copy?
I use MYSQL 3.23.58.
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I think you can use a fulltext index and a regex:
select * from table where match( ftfield) against ('+interests
+reading' in boolean mode) and ftfield rlike your regexp
or
select * from table where match( ftfield) against ('+interests
+reading' in boolean mode) having ftfield rlike yo
Hi List,
This is my first post so I apologize if I use the wrong terminologies.
I am currently using 3.x but I am thinking of going to 4.x or possibly be an
early adopter of 5.x
How many concurrent database users can there be for each version?
Also I run v 3.x on FreeBSD 4.7-stable and for some
Hi all,
I have a customer for which, on one of his server running Red Hat 7, when
it starts mysql, mysqld take all the CPU ressources. He can connect on the
command line and do basic things like "show tables", but he has a PHP
application can no longer connect to the data base.
I will be visiting
24 matches
Mail list logo
