Hi,
On Sat, Apr 28, 2001 at 05:12:42PM +0200, Antonino Chirco wrote:
Mysql : 3.23.33
server : NT 4.0 S.P.3
Client : Win98
This is the table structure:
CREATE TABLE `ordinit` (
`ID_Ordine` int(11) NOT NULL auto_increment,
`Cod_Cliente` int(11) default NULL,
.. OMISSIS ..
On Fri, Apr 27, 2001 at 07:21:38PM -0700, Soren Ragsdale wrote:
I purchase web space on www.phpwebhosting.com, which offers PHP and
mySQL services in a shared server environment. Each user gets their
own database, in which they can create their own tables. Today,
someone is using a LOT of
Hi,
I am trying to compile Apache with PHP4/MySQL support.
PHP4 compiles/installs fine, but when I compile Apache with PHP4/MySQL
support, I get an error when linking the MySQL shared library
libmysqlclient.a.
Here is the compile log, after that are the various compilation options.
*Snippet of
i'm makin a search engine the table looks like this -
---
| number | name | keywords | description | url | rank |
---
query's are made to against keywords, and description which are a
Your question IS for this list, as far as it concerns
MySQL. I do understand it like this, and I think many
people think this way here. Many of us strated here
with 'stupid' questions. These lists are a great thing,
I think, it's like a bread for newbies, and a way to join
also advanced users..
As far as I know, 'update' is a reserved word
and you should quote it with reversed quotes
(you know they are on my keyboard near '1').
I hope it helps.
Daniel BI
Hi,
I'm useing mysql php and SSL on a colbalt raq, the problem I'm having
is
that when ever I use the update query it
just put the -p flag first :)
Daniel BI
=
Original message
Attempting to define an admin user that can connect from any host.
Host='%', user='admin', password=PASSWORD(xxx), all _priv values are 'Y'
when launching "./mysql -u admin -p mysql" and entering password, I get:
Sander Pilon writes:
Howdy,
./ChangeLog
Indeed, those don't appear to be in the tar archive.
Any ideas?
Do you need them?
tar xfz mysql++.tar.gz
cd mysql++-
./configure; make; make install
Voila.
And yes, the mysql online manual has been broken for over 6
Braxton Robbason writes:
isn't this the expected behavior?
(1008306000-988344000)/86400 = 231.04
select mod(231.04,7);
0
231.04 mod 7 is .04, rounded down to 0. 7*33=231
the mod function rounds the result - that's expected, right? Other than that
I don't see what the problem is.
The 5_Class.html file online is only a few lines and only describes the
manipulators, as opposed to the old 5_Class.html file distributed with
1.7.5 and the downloadable one, which is 300Kb and contains descriptions
of much, much more.
Manipulators is (the only) section 5.1 in the on-line
On Sun, Apr 29, 2001 at 02:45:06PM +0200, Sander Pilon wrote:
The 5_Class.html file online is only a few lines and only describes
the manipulators, as opposed to the old 5_Class.html file
distributed with 1.7.5 and the downloadable one, which is 300Kb and
contains descriptions of much, much
Sander Pilon writes:
The 5_Class.html file online is only a few lines and only describes the
manipulators, as opposed to the old 5_Class.html file distributed with
1.7.5 and the downloadable one, which is 300Kb and contains descriptions
of much, much more.
Manipulators is (the only)
Hi,
I would like to know how to measure how many MB of one particular
databases is taken in PHP command. I know I can always use the command of
du ... . But this command is not work under apache because the user and
group are nobody, while the user and group for mysql is mysql, also the
Hello,
I am a Java developper, I use Mysql and TOmcat,
I want to know what SSL is?
Thanx
___
Do You Yahoo!? -- Pour faire vos courses sur le Net,
Yahoo! Shopping : http://fr.shopping.yahoo.com
I saw your mail on our WWW bug for MySQL++ manual.
Do you use MySQL++ at Yahoo! ??
Just curious ;o)
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*|
My insert query look like your
'INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);';
after the query I look into the table 'ordinit' and always looks fine: the value of
ID_ordine is really incremented.
But the following 'select LAST_INSERT_ID()' return zero :-((
It looks like a bug ?
Hi,
Hello,
I am a Java developper, I use Mysql and TOmcat,
I want to know what SSL is?
Thanx
SSL is Secure Socket Layer.
Is a technology to encrypt and decrypt message (HTML pages or other)
over Internet.
Best regards.
On Sun, Apr 29, 2001 at 04:44:10PM +0300, Sinisa Milivojevic wrote:
I saw your mail on our WWW bug for MySQL++ manual.
Do you use MySQL++ at Yahoo! ??
I believe so. The work I do is mostly in Perl. The person who
maintains all our charting code uses the C interface to MySQL. But
there's
I am a Java developper, I use Mysql and TOmcat,
I want to know what SSL is?
Nothing_to_do_with_mysql.
ssl=secure socket layer
More info? type ssl into the seach field of you favorite searchengine.
Bye,
B.
-
Before
On Sun, Apr 29, 2001 at 03:38:07PM +0200, [EMAIL PROTECTED] wrote:
My insert query look like your
'INSERT INTO ordinit(ID_ordine, Cod_Cliente) VALUES (NULL, 10);';
after the query I look into the table 'ordinit' and always looks fine: the value of
ID_ordine is really incremented.
But the
Hello, everybody!
Can MYSQL understand this (GROUPing BY FUNCTION(column))?
--
Best regards,
Igor mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi,
Does the function Unix_TimeStamp() work in MySQL under Windows NT? It
doesn't seem to work here in simple queries, such as this query:
Select Unix_TimeStamp();
Thanks
Noor
-
Before posting, please check:
MY PROBLEMS SO FAR
All versions of MySQL I have tried so far have come in RPM format which I
have rpm2targz to set up. Then I have
gunzip/tar or tar xzf to unpack the archive. The archive unpacks in
different folders to those that the scripts expect and
this is a problem for a start. Also some
Hi,
How do you keep MySQL password out of view of visitors when needed in PHP to access
the db. The password is in plain english in all the php files, and can be easily
downloaded by anyone.
Philippe
ex:
? mysql_connect(host, user, password);
mysql_select_db(database);
?
Hello,
Is there a windows mysql client to manage a distant
unix mysql server?
Thanx
Sofiane
___
Do You Yahoo!? -- Pour faire vos courses sur le Net,
Yahoo! Shopping : http://fr.shopping.yahoo.com
I have found the solution for my 'select LAST_INSERT_ID();' problem.
I must check the 'Change BIGINT columns to INT' option in the
ODBC entry options in my NT server and everything work fine.
Why this ?
This means that I never use BIGINT columns in my Database ?
Thanks.
Regards.
Thank you to those of you who have responded to my inquiry about
indexing.
Here is more complete information about the tables involved.
++
describe Tiger_main
Field TypeNullKey Default Extra
tlidvarchar(10) PRI
rdid
How do you keep MySQL password out of view of visitors when needed in
PHP to access the db. The password is in plain english in all the php
files, and can be easily downloaded by anyone.
PHP is parsed so should show the password etc to the world. It's better to
use an include and put that
Yes, try urSQL -- http://www.urbanresearch.com/ursql
There is also mysqlgui from
http://www.mysql.com/downloads/gui-clients.html and several more listed at
http://www.mysql.com/downloads/contrib.html#SEC569
On Sun, 29 Apr 2001, [iso-8859-1] Sofiane Sakhri wrote:
Hello,
Is there a windows
Check out MySQLFront ... http://www.mysqlfront.de
- Original Message -
From: Sofiane Sakhri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, April 29, 2001 10:11 AM
Subject: Is there mysql client under Windows?
Hello,
Is there a windows mysql client to manage a distant
unix
Running mysql 3.23.22-beta on Redhat 7.0 w/apache and php4, and getting
the following error message:
/usr/libexec/mysqld: Can't create/write to file /var/run/mysql.pid
(Errcode: 13)
Tried to upgrade mysql to no avail, anyway, can connect locally on the
server terminal, but when try to connect
Is there a simple way to prevent password trading on an apache system
using mod_auth_mysql? I've already got the module installed and
working. It would be nice if a directory of flat files could be
protected, without having any kind of SSI's, CGI's, etc.
anyone ... anyone?
--
On Wed, 25 Apr 2001, newsgroups wrote:
Date: Wed, 25 Apr 2001 20:15:07 -0400
From: newsgroups [EMAIL PROTECTED]
To: MySQL-Group [EMAIL PROTECTED]
Subject: File Not Found Error
Sorry to be such an everything newbie. Perhaps this a unix error and not
MySQL but a simple Describe statement
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:
MySQL support: none
Synopsis: configure fails: checking size of char... 0
Severity: non-critical
Priority: low
Category: mysql
Class: sw-bug
Release:
On Sun, Apr 29, 2001 at 05:30:58PM +0200, Noor Dawod wrote:
Does the function Unix_TimeStamp() work in MySQL under Windows NT?
It doesn't seem to work here in simple queries, such as this query:
Select Unix_TimeStamp();
What about
SELECT UNIX_TIMESTAMP(NOW())
?
--
Jeremy D. Zawodny,
Bom dia, Gustavo,
I am not in a position to comment nor to verify your warning. However, I am
pretty annoyed by the way you make it public to the world. Unless I missed
something here, but when someone discovers a security hole in any program,
it's common standard to contact the manufacturer
On Sun, Apr 29, 2001 at 03:12:51PM +, [EMAIL PROTECTED] wrote:
Description:
When a ordinary users tries to analyze bin log using a remote host (-h
ip_address) mysql server daemons crahes.
How-To-Repeat:
Just use mysqlbinlog to analyze a remote host binlog.
mysql -h
I disagree with you markus, and here is why..
1gustavo probably isn't the only person who has noticed this, so it's
fair to say it's already made the round amongst those who arent so nice.
2this _is_ the mysql list.
3this way, people can plan for such a problem and button things up
Hi,
Is there someone who incremented the max_connection
value to something above 100 (200) (300) on Freebsd 4.2?
I had problems with mysql on freebsd 4.0, hooked up
after some days without any good reason :).
Some people told me thread libraries on
Hi Chris,
You should not forget those users who depend greatly on the tech support
(patches) of the manufacturer. Given your expertise and knowledge you might
be able to protect yourself, but not everybody is (as a matter of fact even
Gustavo said he isn't). In addition, to make things worse,
Marc Bragg wrote:
Running mysql 3.23.22-beta on Redhat 7.0 w/apache and php4, and getting
the following error message:
/usr/libexec/mysqld: Can't create/write to file /var/run/mysql.pid
(Errcode: 13)
Tried to upgrade mysql to no avail, anyway, can connect locally on the
server
These points are all well considered, but the point is that I operate
under the assumption that the bad guys out there already have this
information, and that only legit people don't have it becuse they do not
operate in those circles. And yes, if you are operating a service on the
internet, you
how do you uninstall mySQL (v3.23.37) from a linux system?
thanks,
Justin Stern
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Ok so here's the deal, I'm trying to check if mysql is working on my machine
so I open up the dos command prompt, type cd c:\mysql\bin and everything's
fine
then it try to create a test database by typing mysqladmin create testDB,
it try's to connect but it gives me an error message
Can't
On Sun, Apr 29, 2001 at 09:47:49PM -0400, [EMAIL PROTECTED] wrote:
how do you uninstall mySQL (v3.23.37) from a linux system?
If using an RPM, do it the way you normally would with any RPM.
If using the source install, follow the instructions that is comes
with. See the INSTALL-SOURCE file.
Hi everyone,
I was wondering if anyone could help me/or has come across the following
problem:
It's to do with replication - Scenario:
We have a publisher/subscriber as the same server. Using MERGE replication
with 2 subscribers. The publisher database is our co-operate database with
many
On Mon, Apr 30, 2001 at 02:24:53PM +1200, Desmond Armstrong wrote:
Hi everyone,
I was wondering if anyone could help me/or has come across the following
problem:
It appears to have nothing to do with MySQL, so you might try asking
in a more on-topic forum.
Jeremy
--
Jeremy D. Zawodny,
hello there,
I am currently using MS Access to develop reports and I am looking for a new avenue
to develop these reports. I have been looking into MySql and so far I am very
interested. my question is what are the limitation of MySql in comparison to MS
Access and how does one develop
MySQL does not have a built in report generator. I use the commercial
product Crystal Reports as my report generator. It is quite powerful,
buggy in early versions, but they seem to be getting better. Try here
http://www.crystaldecisions.com/products/crystalreports/
Regards,
Gary SuperID
Did you install mysql as a service? If you did, the MySQL Monitor should
come up when you open a Command prompt and type: mysql {enter}
- Original Message -
From: Rhasaun Campbell [EMAIL PROTECTED]
To: mysql list [EMAIL PROTECTED]
Sent: Sunday, April 29, 2001 8:47 PM
Subject: Newbie win
Hi,
I am trying to install MySQL 3.23.37 from the RPM distribution.. At the point where
the rpm installs the default tables it hangs:
[root@teaparty src]# rpm -i MySQL-3.23.37-1.i386.rpm
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv
Dear Sir,
I tried MySQL installation in RedHat 7.0 and get finally version
mysql-3.23.37.When I was installing
with 1st step run ./configure --prefix=/usr/local/mysql --with-charset=big5
and got flowing message and can not continue .
error message
checking for termcap functions
I am running RedHat linux 7.1 and MySQL 3.23.37. I am trying to use
mysqlimport and am getting an error message mysqlimport: Error: Can't get
STAT of /path/to/file/file (Errorcode: 13) , when using table: table_name.
I looked the error up in the on-line documentation and changed the UMASK and
On Mon, Apr 30, 2001 at 12:53:39PM +0800, §õZµØ wrote:
Dear Sir,
I tried MySQL installation in RedHat 7.0 and get finally version
mysql-3.23.37.When I was installing with 1st step run ./configure
--prefix=/usr/local/mysql --with-charset=big5 and got flowing
message and can not continue
Hello,
I just ran into some problems with the mysql setup on win2000. I
start mysql as a service. If you go into your control
panel-administrative tools-services, you can start mysql.
One more thing (if you didn't see it a couple days ago when I posted it):
If you have problems
which RPM should installed ?
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: §õZµØ [EMAIL PROTECTED]
Cc: MySQL°ÝÃD [EMAIL PROTECTED]
Sent: Monday, April 30, 2001 1:12 PM
Subject: Re: problem of MySQL Installation
On Mon, Apr 30, 2001 at 12:53:39PM +0800, §õZµØ
On Mon, Apr 30, 2001 at 02:02:53PM +0800, ??? wrote:
which RPM should installed ?
Not sure. I don't really use them. But I'm sure if you got into
whatever directory they are stored in and run something like:
ls *curses*
ls *termcap*
You'll find them pretty quickly, no?
Jeremy
--
Jeremy
I know Sasha has been involved with the email police for awhile. I gotta
tell ya, my opinion is negative. Sure, I understand the dynamics.
Unwanted emails are intrusive. They waste bandwidth. They squander
resources. Those type arguments, however, do not justify the intrusion
the security squad
Hi,
I have already posted this message but I got no reply I am really stuck
on this topic - if anybody knows anything help would be greatly
appreciated.
I have only just joined this list today any help would be greatly
appreciated.
I have implemented the new MERGE table feature as part of my
59 matches
Mail list logo