Hi all,
Yet another 3am night and I still can't get my MySql to work. I
installed MySql on a cobalt Raq 4 server running Linux. I can telnet into
the mysql directory, but can not seem to change the root pass. I've
searched every place except the one that as the answer to my question. What
am
On Saturday, 29. June 2002 15:10, andy wrote:
Hi Andy,
What shows mysql_errno after mysql_query?!
Why you don't use mysql_real_escape_string (or mysql_escape_string for PHP
Version < 4.1.1) instead of addslashes?!
Regards
Georg
-
> Another option is to run the 3.23.51 server for a while and when you
> get a load problem do 'mysqladmin proc ext'. This command should show
> us if MySQL is using more table scans than usual.
The load problem shows up immediately.
+--++
| Variable_name
Hello MySQL developers
I forward this in behalf of a Debian user who filed a bug report against
the Debian package.
bye,
-christian-
On Fri, Jun 28, 2002 at 07:21:26PM +, [EMAIL PROTECTED] wrote:
> Package: mysql-server
> Version: 3.23.50-1
> Severity: wishlist
>
>
> Currently I have abo
Hi!
> "Steven" == Steven Roussey <[EMAIL PROTECTED]> writes:
Steven> I tried the skip-name-resolve and it had no effect. So there goes my
Steven> hypothesis.
Steven> Here are the results from test:
Steven> Benchmark DBD suite: 2.14
Steven> Date of test:2002-06-24 11:19:19
Steven>
At 15:01 -0400 6/29/02, Lou Picciano / Essex Systems wrote:
>RE: MySQL 4.01-max, InnoDB, Solaris, Raw device support
>
>Has anyone had any specific experience implementing an InnoDB tablespace
>under Sparc Solaris?
>
>A specific few lines in my.cnf would be very helpful...
>
>As we are using a Spa
RE: MySQL 4.01-max, InnoDB, Solaris, Raw device support
Has anyone had any specific experience implementing an InnoDB tablespace
under Sparc Solaris?
A specific few lines in my.cnf would be very helpful...
As we are using a SparcStorage Array, our device pathnames look something
like:
Innodb_d
> From: Michael Bacarella [mailto:[EMAIL PROTECTED]]
> Not the case for me. I tried the prebuilt binary and then my own
> built binary within 30 minutes of each other (the time of day when
> we had the lowest loads) and there was a clear difference.
> Unusable (>40 loadav) vs. humming along smoot
Julian:
In my experience, MySQL doesn't project release dates. The surest way to
avoid pulling a Microsoft (miss release dates) is not to project release
dates in the first place.
As I understand it, they are working through the to-do list
(http://www.mysql.com/doc/T/O/TODO_MySQL_4.0.html) in 4.
> Hi,
>
> Perhaps the table is corrupted ? (the second query uses index
> if they is one whereas the first doesn't). REPAIR TABLE
> reports nothing wrong ?
>
> Regards,
> Jocelyn
Just use that, and now it seems to work...
Thanks everyone...
//
Jonas
yes. Using myODBC you can connect with any ODBC client and issue any valid
sql statement. (Personally, I use VFP but it's dumber brother Access will
work also.)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Dennis [mailto:
The commands you are typing are shell commands. You are in the mysql
client. Try:
use mysql;
select * from user;
You need to be at a shell prompy to issue bin/mysqladmin -password
testpassword
HTH,
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Orig
Its not clear from the docs if external mySQL databases (say running on a
linux system) can be linked to Windows database with myODBC. Does this work
bi-directionally (ie can I retrieve info from the linux databases and
update records on the linux box with queries from windows?
Thanks,
DB
-
Hi all,
I'm a newbie at this, so here's a newbie question. I have installed
MySql on a Cobalt Raq 4 running Linux via a .pkg file. All seemed to go
well, I am able to get into the MySql directory via telnet but no commands
seem to work. See session below. Can anyone help me with putting a r
At 6:11 + 6/29/02, toby - wrote:
>thnx a million paul
>
>got that :)
>
>>So ... why do you want to do this?
>
>well i get really irretated of seein row# 66 right after 5
So basically, it's just a psychological thing on your part, right?
>but seriously i dont know the + or - points of th
wrong mailing list. (This is abuse, you want arguments...down the hall, to
your left.)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: toby - [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 6:05 AM
To: [EMAIL PROTECT
last I heard it was 'sometime before the end of the year.'
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Julian Htun [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 9:34 AM
To: [EMAIL PROTECTED]
Subject: MySQL 4.1
Joonas,
> checking for MySQL library directory... configure: error: Didn't find
> the mysql library dir in ''
I had the same problem couple days ago, and I fixed it manually (just edit
configure.in file).
In this file path to MySQl library directory is
"/usr/local/mysql/lib/mysql", I changed it
Hi,
Perhaps the table is corrupted ? (the second query uses index if they is one
whereas the first doesn't).
REPAIR TABLE reports nothing wrong ?
Regards,
Jocelyn
- Original Message -
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
To: "Jonas Olofsson" <[EMAIL PROTECTED]>; <[EMAIL PROTEC
Jonas,
I think that the problem is not in MySQL server, but may be it is in MySQL
client.
Do you use standard (command line) MySQl client?
Mikhail.
- Original Message -
From: "Jonas Olofsson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 16:39
Subject: RE: Hi
> Jonas,
>
> try to execute this command:
>
> SELECT count(1) FROM table_name;
>
> Result should be 28. Do you have 28?
>
> Mikhail.
Yes, it says:
--
SELECT count(1) FROM table_name;
+--+
| count(1) |
+--+
| 28 |
+--+
1 row in set (0.00 sec)
--
//
Jonas Olofs
Does anybody knows estimated release date of MySQL ver 4.1 with Stored
Procedure?
Thanks,
-Julian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hello,
I've tried to install mysql 4.0.1 Alpha.
The configuration did not give me any error's
The "make" also worked just fine.
But when I run "make test" I get the following error:
ERROR: /down/new/mysql-4.0.1-alpha/mysql-test/var/run/master.pid was not
created in 30 seconds; Aborting
make: **
Hi there,
I would like to save a jpg into a blob field of mysql. The function
underneath works fine if I read the image from the temporary destination
where php did put it after uploading.
My problem is, that I would like to do some funky stuff to the image like
changing colors or adding waterma
Hi!
Packet for 'C++ API library for MySQL' is 'mysql++-1.7.9.tar.gz'.
At first I type 'automake' and it complain 'not found next files:
AUTHORS, NEWS, INSTALL, COPYING and ChangeLog'.
I can write next 'autoconf' as README said and it will go great. But
then if I type './configure', everything
hi guyz
how do i call a phpfile into another phpfile
like i wanna call cat_disply.php from within article.php
so dat it displays all the categories WHERE im giving it a call
now i did this in c/c++
i CALLED files as i call functions
but is this possible in php ?
thnx a million
tob
Jonas,
try to execute this command:
SELECT count(1) FROM table_name;
Result should be 28. Do you have 28?
Mikhail.
- Original Message -
From: "Jonas Olofsson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 11:20
Subject: Hidden rows in table.
> Hi.
>
> I h
On Saturday, 29. June 2002 11:15, Hugo Veiga wrote:
Hello Hugo,
> will this do?
> if(!mysql_query(myData, query)
> {
>results = mysql_store_results(myData);
>
-if(mysql_num_rows() == 0)
+if (!mysql_num_rows(results))
>{
>//action;
>}
> }
with the above correction it
> 1 - if i wanna make an action based on the fact that a query i just
made
> won't return results (empty set), how can i test that?
>
> will this do?
> if(!mysql_query(myData, query)
> {
>results = mysql_store_results(myData);
>
>if(mysql_num_rows() == 0)
>{
>//action;
Hi.
I have just started to use MySQL and I have come up with a strange
problem.
I have a table with 28 rows. When I do 'SELECT * FROM table_name;' in
the MySQL client it only shows 12 of these rows. But if i specify one of
the rows that are not shown with the first command, like 'SELECT * FROM
t
hi there
the present serves for some clearing some doubts i have:
1 - if i wanna make an action based on the fact that a query i just made
won't return results (empty set), how can i test that?
will this do?
if(!mysql_query(myData, query)
{
results = mysql_store_results(myData);
Hi Arul,
> What i meant to say is that My First Query returns 3 rows satisfying two
> conditions Like CI.IndustryID IN (2,3) and Count(C.CompanyID) = 2
>
> So when i add another OR say (CI.IndustryID IN (2,3) OR C.b2b = 'N') and
> Count(C.CompanyID) = 2
>
> I guess it should aways have the possib
32 matches
Mail list logo
