I've been scowering (sp?) the docs but I can't get past:
mysql use mysql;
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
mysql
This happens under any condition where access is needed.
It is after I have done mysql_install_db and chown and there is a user
mysql.
It doesn't
I have 100 records in mySQL database and I need to display them in my web
page using php and html. How to display them in multiple pages? Each page
must contain 25 records. Does anyone know how to do it other than create 4
pages and manually list the records there? or maybe point me some
On Wed, Jun 26, 2002 at 08:15:11PM +0530, Arul wrote:
Hi
Any idea when MySQL 4.0 stable release will be made..
As of now only Alpha is released..
Rumor has it that 4.0.2 might be beta.
Also any sites which run on 4.0 Alpha
Yes. Half my servers have been moved to what will be 4.0.2.
--
have you run the grant command? this adds users SEPERATE from your unix
user list.
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 2:39 PM
Subject: Access denied @locahost
I've been scowering (sp?) the docs but I can't get
Jeremy,
Would you mind sharing how many machines 'half your servers' might be, what
type of work are they doing and how long have they been up for / how stable
would you consider them to be?
Thanks,
Greg
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent:
try killall mysqld and then try to start it
Anil Garg writes:
Hi,
the sql process(on doing ps) shows the following process:
/usr/local/bin/safe_mysqld --user=mysql
when i kill this process and try to restart it with command:
safe_mysqld --user=mysql
it says a mysql process already
Sorry I should have made this a bit clear.
I have to tables with users names in them.
All I need is a list on the Usernames that are in one column but not the
other.
The problem is like Mr DuBois said, is that I get every possible match like
a matrix (I think?).
So how do I get the values that
You can use LIMIT clause:
SELECT fields FROM table LIMIT X,25
where X is number of row to start with.
You can substitute this number for example
in HREF:
A HREF=?X=25Page2/a
A HREF=?X=50Page3/a
A HREF=?X=75Page4/a
then your script should take X value and
use it to compose the query.
Aqua
Hi All
I tried to port this Oracle Query to MySQL.But Couldnt do it..
I am porting this to MySQL 3.23.51 ..The problem is mainly coz there's
another query within Decode function
The Query is
SELECT DECODE(U.CompanyID, NULL, U.UserID, (SELECT A1.UserID FROM Users A1,
User_Type_Details A2 WHERE
On Thu, Jun 27, 2002 at 05:27:29PM +0930, G r e g L a w r i e wrote:
Jeremy,
Would you mind sharing how many machines 'half your servers' might
be, what type of work are they doing and how long have they been up
for / how stable would you consider them to be?
Half of my server is, uhm, 3
* Peter Engström
I have an table called 'list' where I store all items for the pulldown
menues on my site.
Table list has three columns
- id (int autoincrement)
- pulldown_name (tinytext - name of pulldown)
- item (tinytext - the item for the pulldown menu)
A table called client_index
All I need is a list on the Usernames that are in one column but not the
other.
SELECT table1.Username
FROM table1 left join table2 on (table1.Username = table2.Username)
WHERE table2.Username is NULL;
Mikhail.
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: Mysql
* Simon Green
Sorry I should have made this a bit clear.
I have to tables with users names in them.
All I need is a list on the Usernames that are in one column but not the
other.
SELECT table1.Username
FROM table1 LEFT JOIN table2 ON table1.Username = table2.Username
WHERE
On Thu, 27 Jun 2002 09:01:58 +0100
Simon Green [EMAIL PROTECTED] wrote:
Sorry I should have made this a bit clear.
I have to tables with users names in them.
All I need is a list on the Usernames that are in one column but not the
other.
The problem is like Mr DuBois said, is that I get
Oops, forgot to send it to the list:
Use an index and offset in your queries.
You need 25 queries per page(=the offset), each page starting display from a
different record (=the index)
This would give something like this for page 1:
$result = mysql_query(SELECT * FROM your_table WHERE
Arul,
as you are intending to use open source software for free why not give it
a try and help with debugging?
4.0.1 is remarkably stable except for some glitches in replication and
boolean fulltext search. Alpha status applies mainly to the newly
developed features.
Go ahead and have fun!
Hi Thomas
I am always ready to give a try ..
But u see Managers will not be ready to take such a risk...and Morever our
client will not give a try ..:((
-Arul
- Original Message -
From: Thomas Spahni [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent:
Simon,
Thursday, June 27, 2002, 11:01:58 AM, you wrote:
SG Sorry I should have made this a bit clear.
SG I have to tables with users names in them.
SG All I need is a list on the Usernames that are in one column but not the
SG other.
SG The problem is like Mr DuBois said, is that I get every
tlr7425,
Thursday, June 27, 2002, 9:39:33 AM, you wrote:
t I've been scowering (sp?) the docs but I can't get past:
t mysql use mysql;
t ERROR 1044: Access denied for user: '@localhost' to database 'mysql'
t This happens under any condition where access is needed.
t It is after I have done
Andrei,
Thursday, June 27, 2002, 5:19:21 AM, you wrote:
AC If you execute UPDATE LOW PRIORITY table_name .. does mySQL automatically
AC return or does it wait for the update to execute? (that is, is it async or
AC sync)?
MySQL waits for the UPDATE complete.
--
For technical support
Anil,
Wednesday, June 26, 2002, 11:31:00 PM, you wrote:
AG the sql process(on doing ps) shows the following process:
AG /usr/local/bin/safe_mysqld --user=mysql
AG when i kill this process and try to restart it with command:
AG safe_mysqld --user=mysql
AG it says a mysql process already exists.
RBRoa,
Thursday, June 27, 2002, 5:07:39 AM, you wrote:
R Is it possible to use LOAD data infile syntax in MySQL ver 3.23.51 win98
R version?
Sure.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__
va,
Wednesday, June 26, 2002, 10:26:01 PM, you wrote:
vk I have installed MySQL 4.0 on Linux box using RPM. Everything is working fine, but
the database directory is set to
vk /var/lib/mysql. So everytime I create a database it is getting created on
vk /var/lib/mysql. What I would like to
Description:
I have an instance of MySQL v.4.0.1 Max with 11 children spawned running on
a Linux (RedHat 7.0 guiness, 2.2.16-22) personal laptop (Dell Inspiron 5000e)
and when I do a simple update on a table that is Full Text enabled, MySQL
and all its children crash.
I have absolutly no clue why
[localhost:~] ll% ps ax | grep mysqld
349 ?? S 0:00.04 sh ./bin/safe_mysqld
385 ?? S 0:00.08 /usr/local/mysql-3.23.51/bin/mysqld
10102 std R+ 0:00.00 grep mysqld
[localhost:~] ll%
Are these ?? supposed to be there, what do they mean?
Maybe this is indicative of my problem.
And don't forget to do a flush privileges right after.
Bhavin Vyas wrote:
Are u doing a user@hostname or user@%? The hostname part is needed, % means
from anywhere. A better way to write this to prevent any errors is enclosing
user host in single quotes as such: 'user'@'host'.
Regards,
apples,
Wednesday, June 26, 2002, 2:39:25 PM, you wrote:
a I got problem on my machine running with mysql 3.23.51, some field use
a varchar
a (40) if query from this field mysql got hanging
a Trying to get some variables.
a Some pointers may be invalid and cause the dump to abort...
a
Henry,
Thursday, June 27, 2002, 4:13:07 AM, you wrote:
HH I have mysql 3.23.41 running on a Dell Poweredge 2550 on standard install of
HH Red Hat 7.2 (2.4.9-21smp). This version of mysql came with Red Hat. It's been
HH running my website very smoothly for the last few months, and averages 130
Paul,
Wednesday, June 26, 2002, 7:43:44 PM, you wrote:
PT I've got the following 2 tables:
PT create table cinema_order (
PT id int not null primary key auto_increment,
PT revision_number int not null default 1,
PT active_revision int not null default 1
PT );
PT create table
Hello tlr7425,
Thursday, June 27, 2002, 12:29:10 PM, you wrote:
Please, don't write me. Send your question in the mail-list.
tgafe mysql will start and it is running and i can get the prompt:
mysql
tgafe but i can't do anything from there except to quit;
tgafe ?
You didn't answered my
tlr7425,
Thursday, June 27, 2002, 12:40:38 PM, you wrote:
t [localhost:~] ll% ps ax | grep mysqld
t 349 ?? S 0:00.04 sh ./bin/safe_mysqld
t 385 ?? S 0:00.08 /usr/local/mysql-3.23.51/bin/mysqld
t 10102 std R+ 0:00.00 grep mysqld
t [localhost:~] ll%
t Are these ?? supposed
ps ax | head -1
PID TT STAT TIME COMMAND
from 'man ps'
TT is the controlling terminal.
a ?? in the TT column means that it is not controlled by a terminal.
Daemons and some background processes detach from terminals.
This is normal and to be expected for mysqld and other daemons started
Hi
But Still Noone have throwed some light on the Date when MySql 4.0 Release
will be made formally which could enable me to use the Unions
Can anyone in this group please let me know...
-Arul
- Original Message -
From: Arul [EMAIL PROTECTED]
To: Thomas Spahni [EMAIL PROTECTED]
Cc:
Arul wrote:
Hi
Any idea when MySQL 4.0 stable release will be made..
As of now only Alpha is released..
Also any sites which run on 4.0 Alpha
4.0.1 has been very stable for us:
[root@db1 root]# mysqladmin version
mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686
Hi folks,
I am facing problems in running mysql with apache and perl on my system.
The version of mysql i am using is 3.23.39
Below is the program i wrote
to check the mysql connectivity with perl.
#!/usr/bin/perl
use lib qw(/home/www/pm);
$ENV{'DBI_DSN' } = dbi:mysql:z;
Just jumping in here so take this info accordingly.
Do you have root access to this machine?
If so, try restarting with --skip-grant-tables and set up your perm
scheme.
Look into mysqlaccess what does it say for root localhost ?
You can also replace user, host, db with '%' to see all
Hi,
I am in the process of running ecperf using mysql, and ran into a
small problem regarding SELECT COUNT - usd in some of the ecperf
source.
Apparently, SELECT COUNT (*) FROM is not valid syntax according
to mysql ? where as SELECT COUNT(*) FROM is ?
What's with this blank
Dear all.
(Debian 2.4.19, mysql.2.23)
I'm sorry if case was discussed btu :
can someone show me the documentation or articles about
cpu comsumption being done by mysql server or/and clients.
Or should I look for load balancing guide.
Problem is that after ONLY 20 users are connected to the
[snip]
Is there any way in SQL (and especially MySQL) that I can determine
the count of rows that would be returned by a SELECT with a GROUP BY
and a HAVING, without retrieving the rows?
For example, I want the number of orders whose total value is greater
that 1. The orders would be
You can select default table type at mysqld startup:
mysqld --default-table-type=tabletype
Pierre Baridon wrote:
how can i change the default table type ?
(innodb instead of myisam)
thanks,
Pierre
--
sql,query
Pierre Baridon [EMAIL PROTECTED] writes:
how can i change the default table type ?
(innodb instead of myisam)
In the startup-script for mysql, add --default-table-type=innodb as an
option to safe_mysqld.
--
- håkon
-
I have one client with three IPs one 0.0.0.0 other to connect internet and
the last from LAN. The problem is that when i try to connect a server MySQL
through MyODBC, i get the follow error message:
[MySQL][ODBC 3.51 driver] Lost connection to MySQL server during query
What's happening?
Thank
Add this to your my.cnf file :
# The MySQL server
[mysqld]
# Default table type for new tables
default-table-type=InnoDB
CB.
-Original Message-
From: Pierre Baridon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 12:09
To: [EMAIL PROTECTED]
Subject: default table type
how
Does anyone know if stored procedures have been implemented in MySQL?
Getting into the MySQL web site from the UK is almost impossible these
days so I thought I'd ask here.
Thanks in advance for any information,
Andy
-
On Thursday, 27. June 2002 13:36, Per Jessen wrote:
Hi,
I am in the process of running ecperf using mysql, and ran into a
small problem regarding SELECT COUNT - usd in some of the ecperf
source.
Apparently, SELECT COUNT (*) FROM is not valid syntax according
to mysql ? where as
Hi!
Since InnoDB implements foreign keys at a low level, it cannot presently
instruct MySQL to change the table definition in the .frm file and create a
new index.
We can modify the MySQL parser though so that it will treat
FOREIGN KEY (...) REFERENCES ...
like it does an ordinary KEY
Hi,
Can I lock a field somehow against modification?
So I have a table and it has 4 fields.
I want to lock the same two fields in two records,
to not enable to modify those fields.
Can I do it somehow?
Thanks in advance!
Regards;
Istvan
sql, mysql
MySQL doesn't support stored procedures yet.
Roma
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 8:01 AM
To: [EMAIL PROTECTED]
Subject: Stored procedures
Does anyone know if stored procedures have been implemented in MySQL?
Getting into
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 2:11 PM
[snip]
Apparently, SELECT COUNT (*) FROM is not valid syntax according
to mysql ? where as SELECT COUNT(*) FROM is ?
[/snip]
call and the opening parentheses. I
Yes ... we all know that stored procedures have not been implemented in
MySQL.
Sorry to be so terse, but this is about the umpteenth posting of this same
question this week ... doesn't anybody read the list or search the archive
before they post stuff?
- Original Message -
From: andy
Peter,
Thanks for the reply... Infact my.cnf wasn't there when I installed. So I created
it... Could you pass me the line to include in my.cnf for changing directory...
Unfortunately I couldn't find anything in the web site regarding this...
Once again thanks for the reply...
--
On Thu,
Peter,
Thanks for the reply... Infact my.cnf wasn't there when I installed. So I created
it... Could you pass me the line to include in my.cnf for changing directory...
Unfortunately I couldn't find anything in the web site regarding this...
Once again thanks for the reply...
--
On Thu,
Sad ... we gave MySQL a try almost three years ago, wound up replacing M$'s
SQL Server with MySQL, and now have 80+ very happy customers with a stable,
powerful, and very cost-effective database solution.
- Original Message -
From: Arul [EMAIL PROTECTED]
To: Thomas Spahni [EMAIL
Victoria Reznichenko writes:
Hi!
Description:
I have an instance of MySQL v.4.0.1 Max with 11 children spawned running on
a Linux (RedHat 7.0 guiness, 2.2.16-22) personal laptop (Dell Inspiron 5000e)
and when I do a simple update on a table that is Full Text enabled, MySQL
and all its
Hi
I'm running MySQL 4.0.2 compiled from the source tree on this site:
www.gnist.no (The largest online bookstore in Norway)
Used 4.0.1 earlier but that version had some small problems with fulltext
search.
Server version: 4.0.2-alpha-log
Uptime: 2 days 12 hours 40 min
Is there any way to tell mySQL to return immediatly?
Andrei Cojocaru
[EMAIL PROTECTED]
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 02:44
Subject: Re: How does update low priority work?
Andrei,
Thursday, June 27,
We are setting up three MySQL server (on separate machines) with one
master and two slave servers. All the machines has two network
interface. We want to create Private network between three machines only
to route replication traffic.
Can MySQL use multiple network interface on machine?.
Hi.
On Thu 2002-06-27 at 16:33:43 +0530, [EMAIL PROTECTED] wrote:
But Still Noone have throwed some light on the Date when MySql 4.0 Release
will be made formally which could enable me to use the Unions
Can anyone in this group please let me know...
Nobody throws in a date, because
[mysqld]
datadir=/var/lib/mysql
tmpdir=/home/mysql_temp
HTH
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
Does anyone else feel that lack of support for subqueries is the number 1
deficiency in MySQL? I'm not sure why support for subqueries is being
Actually, I am much more eagerly waiting for views and Unicode
support that sub-selects, although of course these would be very nice
too.
Vaclav
I think you didn't notice. He cannot access Mysql website from UK :)
-Original Message-
From: Gerald Jensen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 9:16 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Stored procedures
Yes ... we all know that stored
-Original Message-
From: Daniel Koch [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 13:11
To: Arul
Cc: MySQL
Subject: Re: MYSQL 4.0
Arul wrote:
Hi
Any idea when MySQL 4.0 stable release will be made..
As of now only Alpha is released..
Also any sites
got it thank everybody for the help... it is appreciated...
--
On Thu, 27 Jun 2002 15:13:31
Peter Lovatt wrote:
[mysqld]
datadir=/var/lib/mysql
tmpdir=/home/mysql_temp
HTH
Peter
---
Excellence in internet and open source software
When I run this comman I insert 253 records into ur_rights. If I runn the
comman without the insert statement it returns 33,483 records.
As result of insert command you have to receive stat info like this:
---
Records: 100 Duplicates: 0 Warnings: 0
---
Which values do you
Description:
mysql-server cannot start on netbsd 1.6BETA1
How-To-Repeat:
upgrade to netbsd 1.6; cd /usr/pkgsrc/databases/mysql-server; make install
Fix:
no fix
Submitter-Id: submitter ID
Originator:Charlie
Organization:
MySQL support: [none | licence | email
Hi,
It's seems to be bug try to rare the frequency of the command
(show) which is send to the mysqld.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
At 09:28 AM 6/26/2002, you wrote:
I recently installed MySQL on a computer running Windows 2000 and
have been working through the tutorial session in the manual. All
went well until I created the second (event) table. While I believe
that all the data in the table is correct, any query which
Hi,
Of courseanyway MySQL don't use directly network interfaces.This is a
Kernel job.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
-
Hi guys,
Does anyone know any sources on good DBA procedures for MySQL specifically?
Or a source for MySQL DBA scripts that might do some of the following tasks?
- check if mysqld is up and running and email a user if it is
- a script to give process/connection information (I'd like more info
Nilesh Shah wrote:
We are setting up three MySQL server (on separate machines) with one
master and two slave servers. All the machines has two network
interface. We want to create Private network between three machines only
to route replication traffic.
Can MySQL use multiple network
Hi,
Here is a strange problem!!
I created a table by the following qurey:
CREATE TABLE 1_polls (
id int(11) unsigned NOT NULL auto_increment,
question varchar(128) NOT NULL default '',
active tinyint(1) unsigned NOT NULL default '1',
sortorder int(11) NOT NULL default '0',
module_id
Hi all,
I'm trying to update a table from another table. There are three tables
involved t1, t2 and t3. Table t1 and table t3 have the data table t2 holds
the relationships, ie t2 looks like this:
t2id tinyinit
t1id tinyinit
t3id tinyinit
This is the update statment i'm trying:
UPDATE t3
At 7:12 -0700 6/27/02, Dave Morse wrote:
NO - mine is a honest question. An open source server in C and a
client in Java makes sense, I guess to some.
I guess I'm not sure why it wouldn't make sense. If you're running a
Web browser that's written in Java, do you require a Web server to be
In the last episode (Jun 27), Marek Wysmulek said:
Dear all.
(Debian 2.4.19, mysql.2.23)
I'm sorry if case was discussed btu : can someone show me the
documentation or articles about cpu comsumption being done by mysql
server or/and clients. Or should I look for load balancing guide.
Thanks all
-Original Message-
From: Joseph Bueno [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 10:56 AM
To: Nilesh Shah
Cc: [EMAIL PROTECTED]
Subject: Re: Multiple Network Interface
Nilesh Shah wrote:
We are setting up three MySQL server (on separate machines) with one
Yes, I agree sub-queries should be the highest priority with the next
release judging from the e-mails going around at the moment.
This was the first problem I found in my first day using MySQL. I don't
understand with all the versions that have been released of MySQL since 1996
why they
You can bind mysqld to a specific address using
mysqld --bind-address=IP-ADDRESS
Nilesh Shah wrote:
We are setting up three MySQL server (on separate machines) with one
master and two slave servers. All the machines has two network
interface. We want to create Private network between three
[EMAIL PROTECTED] wrote:
Does anyone else feel that lack of support for subqueries is the number 1
deficiency in MySQL? I'm not sure why support for subqueries is being
Actually, I am much more eagerly waiting for views and Unicode
support that sub-selects, although of course these would
Description:
what do I have to do to get configure to use correct gcc options like:
-I/usr/local/include -R/usr/local/lib ???
I use following options:
./configure --prefix=/home/mysql --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes
On Thu, 27 Jun 2002, Benjamin Pflugmann wrote:
On Thu 2002-06-27 at 16:33:43 +0530, [EMAIL PROTECTED] wrote:
But Still Noone have throwed some light on the Date when MySql 4.0
Release will be made formally which could enable me to use the Unions
Can anyone in this group please let me
Hi,
I'm doing research on DBMS recently and have found
some bugs in mysql's source codes.I think it will be
more convenient to point out them directly than using
mysqlbug.The following are my finds.
mysqladmin -version output:
mysqladmin Ver 8.22 Distrib 3.23.44, for pc-linux-gnu
on i686
It makes sense to many, or most, I'd say. Oracle produces clients in a
variety of languages. So does every major database vendor. There is
zero import in the difference between the languages a server and client
are written in.. it's all a network protocol, for God's sake, so who
gives a
I am fairly new to this, so please bare with me on this.
I am designing a database that stores information about the computers I
manage, and am developing a PHP front end to add, view, and edit information
about the computers. One issue I ran into is designing the hard drive
information. Some
On Thu, 27 Jun 2002, Gerald Jensen wrote:
Yes ... we all know that stored procedures have not been implemented in
MySQL.
I thought as much but just wanted rapid confirmation.
Sorry to be so terse, but this is about the umpteenth posting of this same
question this week ... doesn't anybody
[snip]
UPDATE t3 set t3.mynewfield = t1.mynewfield IN SELECT t1.mynewfield FROM t1,
t2, t3 WHERE t1.mynewfield = 1 and t2.t1id=t1.t1id and t2.t3id=t3.t3id;
and I getting:
ERROR 1064: You have an error in your SQL syntax near 'SELECT t1.mynewfield
from t1, t2, t3 WHERE t1.mynewfield = 1 at line 1
I just tried to do this on my MySQL server (version 3.23.51-max-log). It
works fine.
Mikhail.
- Original Message -
From: Anil Garg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 4:59 PM
Subject: Lost Connection to mysql server during query
Hi,
Here is a
Dave,
The language that the server is written in is irrelevant. Oracle, SQL
Server, Sybase and most other databases are written in C and Java developers
do business in them just fine. That's why JDBC is for. Many legacy systems
are written in C, C++, or other language. That is another area
I noticed ... but he was somehow able to get on the list to post his
message!
-Original Message-
From: Roma Gupta [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 9:13 AM
To: 'Gerald Jensen'; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Stored procedures
I think you didn't
Heikki,
Thanks for the patch. As I'm going on vacation tomorrow, I'll give it a
try next week and let you know if I find anything.
--shak
Heikki Tuuri wrote:
Hi!
It turned out that the bug indeed was connected with a 32-bit signed integer
wrap-over if the buffer pool on a 32-bit computer
Hi,
I've currently my website and two forum which runs with MySQL 4.0.2
flawlessly (and which a huge number of visitors for one of my forum).
mysql \s
--
mysql Ver 12.10 Distrib 4.0.2-alpha, for pc-linux-gnu (i686)
Connection id: 125151
Current database:
Current user:
I'm in the process of re-writing 100+ perl CGIs written for oracle to mysql.
Does anyone know how to get the dbh-quote(some_value) function in perl to
return the string NULL if some_value is empty. Currently its returning
'' (2 ticks) and when you update a numeric column, it sets the value to 0
Hi,
I try to use mysqlgui menu : Commands - Tables - Edit Table or Create Tables and
nothing happens.
Do you have any clue ?
Thank you for your kind support
Best Regards
Jerome AVEZOU
-
Before posting, please check:
Hi,
It seems you have to install zlib-1.1.4 on your system.
Regards,
Jocelyn
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 5:40 PM
Subject: configure won't configure
Description:
what do I have to do to get configure to use
I am currently using mysql 4.01 with caching for web page serving. I
pull several records out with a like statement on a text field. The db
consists of about 200,000 records right now and it is using 100% of the cpu
when the search is ran.
Since this is a critical function, it is ran on
With linux you would:
Add /usr/local/lib to your /etc/ld.so.conf file and run ldconfig.
Sun should have something similar.
[EMAIL PROTECTED] wrote:
Description:
what do I have to do to get configure to use correct gcc options like:
-I/usr/local/include -R/usr/local/lib ???
I use
Hi all. I have multiple tables in which I need to delete rows from the
beginning. I have them stored with an auto_increment id but I don't want
the records to start from 5 but from 1... is there a way to use
something like ALTER TABLE tablename AUTO_INCREMENT = 1; but also that
will make the
Never mind. He says with his head hung low I'm an idiot!
I was populating a the table for someone else and didn't notice that one of
the fields was an auto-inc. Skipped that field and surprise...everything
worked fine.
Thanks for the help. Next time I will remember to pull one body part out of
Looks like you want to bring up something that doesn't have anything to
do with the original question which is your perogative. But please
don't compare MySQL with Oracle and mainstream SQL RDBMSs. Give us a
break.
-Original Message-
From: Andrew Houghton [mailto:[EMAIL PROTECTED]]
Hi,
I have MySQL3.23.47 running on a Cobalt RaQ4 System. The mysql
installed datadir turned out to be /var/lib/mysql. /var directory has
its own partition (/dev/hda3) and total space available is 194MB. As My
databases are growing and Im out of space now on the /var directory.
I am thinking
Description:
The following query results in a different # of rows if the sql_big_tables is
set to 1:
select count(incidents.ref_no) from incidents, labels where incidents.ref_no like
'020531%' group by labels.label, incidents.ref_no;
The query seems unusual because it was a lot
1 - 100 of 156 matches
Mail list logo
