Hi Jim,
Please forgive the elementary question but I am new to MySQL and DBs in
general.
I have inherited a MySQL DB to which the root password is not available, I
have read the documentation on the subject but my best efforts have failed
to elicit the desired result from MySQL.
I did some playing around with various indices on the tables and found that
the fastest configuration was without any indices! With two tables (t1 and
t2) with fields start and end, using an index (start, end) or indices on
the on the two fields separately, the speed of joining the two tables
Hi Tom,
... you forgot to put the locking purpose: write or read:
Ex:
lock mytables write;
Gelu
G.NET SOFTWARE COMPANY
- Original Message -
From: Tom Caruso [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday,
Hi,
My opinion is :
- open the mysql client;select the system mysql database with use
mysql and update the
users table with next SQL statement :
update user set Password=PASSWORD('your_new_password') where
user='root' and Host='%';
and to make active this change you can do:
Tom,
Monday, February 25, 2002, 3:41:27 AM, you wrote:
TC Hello,
TC I am using MySQL 3.23.47 under Windows 98 (mysql-opt) and I am
TC having a strange problem. I issued the LOCK TABLES
TC table_name; command at the command prompt and I got the
TC following error: ERROR 1064: You have an
jim,
Monday, February 25, 2002, 5:26:35 AM, you wrote:
j Hi all,
j Please forgive the elementary question but I am new to MySQL and DBs in
j general.
j I have inherited a MySQL DB to which the root password is not available, I
j have read the documentation on the subject but my best efforts
Hi,
I've a table with a longblob type field.
I've a pdf file in a field and I would like to open it in a browser with PHP.
How ca I do with which query can I take the PDF file?
Thanks
Sorry for my english.
Sam
-
Before
Hi,
I've a table with a longblob type field.
I've a pdf file in a field and I would like to open it in a browser with PHP.
How ca I do with which query can I take the PDF file?
Thanks
Sorry for my english.
Sam
-
Before
Hello everyone,
We are about to migrate to a Linux system on an MPC82xx - either 8240 or
8260. With only 32meg of memory, we need mySQL to have a very small
footprint.
Most of our tables are quite small in volume - maybe 1000 or 2000 rows in
total for all of the dynamic tables, and a much
Dear all.
I have Debian (kernel 2.4.19) and mysql 3.23.49 updated from 3.22.
Before update everything was working fine. After it seems to also
BUT:
I can not connect from other host then localhost (literally - even 127.0.0.1
takes no effect)
Iptables rules are wide accepting.
In host name
On Mon, Feb 25, 2002 at 01:08:49PM +0100, Marek Wysmulek wrote:
Dear all.
I have Debian (kernel 2.4.19) and mysql 3.23.49 updated from 3.22.
Before update everything was working fine. After it seems to also
BUT:
I can not connect from other host then localhost (literally - even
On Fri, Feb 22, 2002 at 08:29:03AM -0500, Anthony W. Marino wrote:
On Friday 22 February 2002 02:15 am, Jeremy Zawodny wrote:
On Thu, Feb 21, 2002 at 08:07:39PM -0500, Anthony W. Marino wrote:
Is there a timeline/status for 4.x functionality available?
No. It'll be ready when it's
On Fri, Feb 22, 2002 at 08:59:41AM +, [EMAIL PROTECTED] wrote:
I would like to second this request. I *really* want the replication
failover functionality targeted for 4.x. In fact, if it isn't
going to arrive by, say, midsummer, I will have to develop my own
failover solutions.
Well,
On Mon, Feb 18, 2002 at 03:05:09PM -0500, Andrew Crum wrote:
As for a filesystem. I wouldn't recommend ext2 or ext3 at all. I
would _highly_ recommend a journaling filesystem such as Reiserfs
(http://www.namesys.com) or XFS (http://oss.sgi.com).
You do know that ext3 is journaling, right?
I can not connect from other host then localhost (literally - even
127.0.0.1
takes no effect)
Iptables rules are wide accepting.
In host name there is name of the host, and in hosts IP is associated.
Are you using the Debian mysql-server package? If so, then check out
your
Hi, All
gweMysql JDBC Driver Update!!
$B!&(BSupport Borland Enterprise Server5.0 (EJB2.0)
$B!&(BSupport JBuilder6
$B!&(BConnectionPoolDataSource support maxPoolSize property
( 0 means no-limit )
[WebSite]
Impex,
Sunday, February 24, 2002, 6:05:51 PM, you wrote:
IHMH Hello everyone,
IHMH I am trying to do backups using the crond daemon on my Linux server.
IHMH Can I write a similar line as below on my crontab file.
IHMH Any examples would be appreciated.
IHMH mysqldump impex
BLANCHET,
Monday, February 25, 2002, 12:06:09 PM, you wrote:
B Hi,
B I've a table with a longblob type field.
B I've a pdf file in a field and I would like to open it in a browser with PHP.
B How can I do with which query can I take the PDF file?
Use SELECT statement, but don't forget to
Rex,
Monday, February 25, 2002, 6:18:41 AM, you wrote:
RY Hello,
RY When I tried to run mysqlgui, this is the error message that I received:
RY can't connect to local MySQL server trough socket (111)
RY I've checked and created all the client files. What does it mean? How can
RY I correct
On Mon, Feb 25, 2002 at 01:29:27PM +0100, Marek Wysmulek wrote:
I can not connect from other host then localhost (literally - even
127.0.0.1
takes no effect)
Iptables rules are wide accepting.
In host name there is name of the host, and in hosts IP is associated.
Are you
Are you using the Debian mysql-server package? If so, then check out
your /etc/mysql/my.cnf file to see that networking is enabled.
It seems to be disabled BUT how to enabled it ?
Remove the skip-networking entry.
Jeremi youre the best ;-)). Thanks a lot.
--
Pierre,
Sunday, February 24, 2002, 10:54:38 PM, you wrote:
PdP Don't know if this is the right forum, but you can always flame me if
PdP I'm wrong :-)
PdP I tried using the mySQL OLEdb (ADO) driver with Delphi. ALthough I can
PdP get a data connection and see the table names, the field
On Sunday 24 February 2002 06:26 pm, Arjen Lentz wrote:
Hi Anthony,
On Fri, 2002-02-22 at 23:43, Anthony W. Marino wrote:
On Fri, 2002-02-22 at 18:59, [EMAIL PROTECTED] wrote:
Is there a timeline/status for 4.x functionality available?
I would like to use MySQL 4.x, however, I'm
Jeremy Zawodny writes:
Why is porting MySQL to BeOS still on the TODO list? The OS is
esentially dead, right?
Just wondering...
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL
On Mon, Feb 25, 2002 at 01:48:13PM +0100, Marek Wysmulek wrote:
(Hmmm. Zawodny Are you related with a polish family ? - I'm polish
too ;-
My grandparents came to the United States from Poland sometime around
1910, I believe. I'm 100% Polish, but cannot speak the language.
Glad
Rex Yuan writes:
Hello,
When I tried to run mysqlgui, this is the error message that I received:
can't connect to local MySQL server trough socket (111)
I've checked and created all the client files. What does it mean? How can
I correct it? MySQL server is up and running.
Thank
Hello all forgive me for posting off topic (again - that's only two!)
I need to install the QT 2.2.2 client libraries on a Linux Mandrake 7.1
machine. I have created this app using Borland's delphi/kylix combo and
it runs fine on my LM 8.1 machine (it must have qt installed by default
maybe).
Dear all.
Have anyone practice in www-mysql package ?
I've installed apache, www-mysql. And so ? What next.
Marek Wysmulek.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I am upgrading from MySQL ver. 3.22.32 to 3.23.41. I have installed
ver. 3.23.41 on a new server which I will eventually use to replace my
old server that's running 3.22.32. I have tar'ed and ftp'ed the
datbases files over to the new server. When I copy them over to the
table directory (
On Saturday 23 February 2002 05:34 pm, you wrote:
(gdb) thread 1
[Switching to thread 1 (process 31905, thread 1)]
#0 ?0x82011ce in memcpy ()
(gdb) bt
#0 ?0x82011ce in memcpy ()
#1 ?0x82a33c0 in mysql_bin_log ()
#2 ?0x80b7cd8 in ha_commit_trans ()
#3 ?0x8076e24 in mysql_execute_command ()
Hi guys.
I made system. it is based on php+apache+mysql.
This system i would like to sell a Company.
Must i or this Company buy any licence from mySQL AB to legally use mysql
with apache+PHP in this system ?
I need quickly an answer.
Regards.
I. Piasecki
--
Okresl Swoje potrzeby - my
Hi,
Does anyoone know how to connect to mysql from a Java application in windows 2k?
Any help would be greatly apppreciated. I may be writing to the wrong list, anyone got
any suggestions of where i could get help with this online.
Cheers,
Bill
Hi ,
I'm trying to perform a SQL query containing several calls to mySQL replace
functions.
On the same basis that this :
SELECT replace(message, @TITLE@, title) FROM **
in this case, message and title are 2 fiels of the the same table
I want to do something like this :
SELECT
Hello,
You'd probably want JDBC.
http://www.mysql.com/downloads/api-jdbc.html
Steve
On Tue, Feb 19, 2002 at 03:17:49PM +, Bill Fogarty wrote:
Hi,
Does anyoone know how to connect to mysql from a Java application in windows 2k?
Any help would be greatly apppreciated. I may be writing
[EMAIL PROTECTED] writes:
The latest rpms for mysql 3.23.49 produce a signal 4 error when
attempting to run the installed mysql server.
on all our servers running redhat 7 thru 7.2.
Obviously this can't be a kernel 2.2.x issue, since 7.2 is on 2.4.x.
I've tried multiple installs now
Richard,
Monday, February 25, 2002, 6:08:53 PM, you wrote:
RR I am upgrading from MySQL ver. 3.22.32 to 3.23.41. I have installed
RR ver. 3.23.41 on a new server which I will eventually use to replace my
RR old server that's running 3.22.32. I have tar'ed and ftp'ed the
RR datbases files
Ireneusz,
Monday, February 25, 2002, 5:08:56 PM, you wrote:
IP Hi guys.
IP I made system. it is based on php+apache+mysql.
IP This system i would like to sell a Company.
IP Must i or this Company buy any licence from mySQL AB to legally use mysql
IP with apache+PHP in this system ?
IP I need
I have a problem, when I try to connect to the Data Base
[root@hvserver_tja bin]# mysql
bash: mysql:command not found
[root@hvserver_tja bin]# ./mysql
ERROR 2002: Can't connect to local MySQL server through '/tmp/mysql.sock'
(2)
[root@hvserver_tja bin]# ./mysql -h hvserver_tja -u -p
Enter
Hi,
Are you sure that the MySQL server is running?
If so, maybe look for the mysql.sock file (find / -name mysql.sock)
./mysql -u username -p --socket=/location/of/socket.sock
Steve
On Mon, Feb 25, 2002 at 04:38:59PM +, Ricardo Javier Aranibar Le?n wrote:
I have a problem, when I
How do I restore a Mysqldump of a database? I've found documentation on how
to backup a db and have done but I can't figure out how to create a new db
from my dump file? Please help.
thanks
Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY
Ricardo,
Monday, February 25, 2002, 6:38:59 PM, you wrote:
RJAL I have a problem, when I try to connect to the Data Base
RJAL [root@hvserver_tja bin]# mysql
RJAL bash: mysql:command not found
RJAL [root@hvserver_tja bin]# ./mysql
RJAL ERROR 2002: Can't connect to local MySQL server through
On Monday, 25. February 2002 17:47, Miretsky, Anya wrote:
How do I restore a Mysqldump of a database? I've found documentation on how
to backup a db and have done but I can't figure out how to create a new db
from my dump file? Please help.
1) Create an empty db yourdb
2) mysql -uuser
Also, check permissions on the mysql directories to make sure that MySql can
actually write into it and that other people can read the mysql.sock file.
-Original Message-
From: Steve Suehring [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 8:42 AM
To: Ricardo Javier Aranibar
FYI-
My Environment:
- Windows NT 4.00.1381
- MySQL Ver 11.15 Distrib 3.23.43, for Win95/Win98 (i32)
Program will not allow me to create or edit tables. Also, bombs when I
try to create a database.
sT
-
Before
Steve Traver writes:
FYI-
My Environment:
- Windows NT 4.00.1381
- MySQL Ver 11.15 Distrib 3.23.43, for Win95/Win98 (i32)
Program will not allow me to create or edit tables. Also, bombs when I
try to create a database.
sT
Table creation and editing is not done ...
If you
Why is the max_data_length portion of Show table status ... for innodb
tables null? Is there a way to get this value? I want to use this and
data_length to display a % of space used statistic.
Eric Mayers
Software Engineer I
Captus Networks
sql,query
Let me try again. I recently installed mysql. I need to change the root
password. However, whatever method I try mysql tell me that the user table
is read only.
mysqladmin -u root password 'mynewpassword'
mysqladmin: unable to change password; error: 'Table 'user' is read only'
Or
mysql
for the EXCELLENT index in your MySQL book. I developed several questions
this morning and was able to find answers to all easily using the index in
your book.
Much appreciated.
Craig
[EMAIL PROTECTED]
-
Before posting,
From: Ari Kahn [EMAIL PROTECTED]
However, whatever method I try mysql tell me that the user table
is read only.
It sounds to me like root doesn't have sufficient permissions granted to write to
that table, but I could be wrong. There's something in the docs about accessing after
you've
sql,query
At 11:56 -0600 2/25/02, Craig Westerman wrote:
for the EXCELLENT index in your book. I developed several questions this
morning and was able to find answers to all easily using the index in your
book.
Much appreciated.
Craig
[EMAIL PROTECTED]
Thanks, I'm glad it was useful.
hi,
I creating a table where I am using one field as Auto Increment. I want
to know two things or rather I want to do to thinks for the same column
1. When I am inserting the values and the Query fails, the increment
should not took place and
2. When I delete a particular row from the table
- Create a dir in /Library/StartupItems called mysql
- make a shell file called mysql containing (and make it executable)(this
assumes that user-id stuff is in /etc/my.cnf):
#!/bin/sh
. /etc/rc.common
if [ ${mysql:=-NO-} = -YES- ]; then
ConsoleMessage Starting MySQL Server
cd
Compiled MySQL 3.23.49 from source and I still can't kill the server
without -9 in OS X 10.1.3
sigh...
--
John McCauley
CTGi, Oakton, VA USA
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On 25 Feb 2002, at 10:03, Eric Mayers wrote:
Why is the max_data_length portion of Show table status ... for innodb
tables null? Is there a way to get this value? I want to use this and
data_length to display a % of space used statistic.
I think you're misunderstanding what the
Hi.
On Mon, Feb 25, 2002 at 11:22:22AM -0700, [EMAIL PROTECTED] wrote:
From: Ari Kahn [EMAIL PROTECTED]
However, whatever method I try mysql tell me that the user table
is read only.
It sounds to me like root doesn't have sufficient permissions
granted to write to that table, but I
Is there any electronic version of this book (e-book)?
Because it will be very helpfull if it has an index-content like PDF docs.
And why pay for paper? We live on 2000 no?
Makis
-Original Message-
From: Craig Westerman [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002
1. The auto_increment will not occur on failure. Try it yourself to
verify; I did.
2. When you delete a row, you DO NOT WANT the auto-increment to re-number.
You SHOULD have gaps. Why?
Because if the auto_incremented field is a primary key, and there are other
tables who fields refer to that
At 0:44 +0530 2/26/02, Chetan Lavti wrote:
hi,
I creating a table where I am using one field as Auto Increment. I want
to know two things or rather I want to do to thinks for the same column
1. When I am inserting the values and the Query fails, the increment
should not took place and
2. When I
From: Chetan Lavti [EMAIL PROTECTED]
1. When I am inserting the values and the Query fails, the increment
should not took place and
It doesn't.
2. When I delete a particular row from the table there should not be any
gap in the auto increment sequence.
This doesn't work. Although you
Okay, this is clearly not what I want. I'm looking for a method to see
how much space a table is using compared to the total amount of space
available. Is there a way to do this (with innodb tables)?
Eric Mayers
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
Hi All,
Does anyone have an idea why I am getting an error Fatal error: Call to
undefined function: mysql_connect() in /var/www
in this PHP function
mysql_connect(localhost,root,password);
Thanx All
-
Before posting,
Hi.
On Mon, Feb 25, 2002 at 04:08:56PM +0100, [EMAIL PROTECTED] wrote:
Hi guys.
I made system. it is based on php+apache+mysql.
This system i would like to sell a Company.
Must i or this Company buy any licence from mySQL AB to legally use mysql
with apache+PHP in this system ?
This is
I don't take work out of office, NEVER! :)
Is not possible to copy e-book either, I think!
(PS: You're so sick to read work books at home ? :)
Makis
-Original Message-
From: Georg Richter [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 9:52 PM
To: savaidis; 'MySQL
On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote:
Does anyone have an idea why I am getting an error Fatal error: Call to
undefined function: mysql_connect() in /var/www
That's the error you get if you try to call mysql_connect() but don't have
the MySQL support compiled in to the PHP module.
sql,query
Is it possible to setup a system DSN with myodbc? We have several databases
that need to be linked together for Crystal Reports to use. So far I have
not figured out how to do this.
TIA!
Carl McNamee
Systems Administrator
Billing Concepts
(210) 949-7282
sql,query
Does anyone know how / if it's possible to recover a lost .MYI file if I
still have the .MYD and .frm files? It seems like it should be possible
but I haven't found any documentation on it yet.
Thanks,
- bdf
-
Thanx all,
I am new to this and still learning, when I installed Linux, I did not have
to do anything to PHP however I did just get the mysql rpm and install
without any special configuration, Does anyone have an idea of any article
that will help me recompile my php with my apache.
Thanx
If you do that don't you run a greater risk of corruption of the datafiles
if the host unexpectedly goes down?
Dave
On Mon, Feb 25, 2002 at 01:07:06PM -0800, Steven Roussey wrote:
I was reading an article on speeding up Oracle on Linux(1) and thought
their two optimizations for Linux would
At 21:35 +0200 2/25/02, savaidis wrote:
Is there any electronic version of this book (e-book)?
One of the chapters (the C API chapter) is online at the publisher's
site, and there are some other pages available at Amazon. All of these
are PDF format. There are pointers to this material at the
Hello everyone,
I have this database, I'm using InnoDB type tables. I wanted to know the
following:
How can I manipulate the tables, so that db supports multiple users trying
to access the same table for writing or reading purposes at the same time.
Thanks,
Oganes Demirchyan
Motorola Life
Oganes,
It sounds like what you want is row-level-locking. This is a feature of
InnoDB tables. It allows users to write to a table while other users
are reading from the same table. Of course, they cannot read and write
the same rows simultaniously. Have you tried to do this and had some
At 16:09 -0600 2/25/02, Paul DuBois wrote:
At 21:35 +0200 2/25/02, savaidis wrote:
Is there any electronic version of this book (e-book)?
One of the chapters (the C API chapter) is online at the publisher's
site, and there are some other pages available at Amazon. All of these
are PDF format.
Hello,
I'm running MySQL on a Windows 2000 box. I was running 3.23.47 until
3.23.49 was released. After upgrading to 3.23.49, queries like this don't
work:
UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' AND
password='blah';
Normally, that would increment the value in
Hi,
I'm new to MySQL and this list. ^_^
My question is: What's the best and fastest way to convert an Informix
database to MySQL?
Thanks,
Jessica
-
Before posting, please check:
http://www.mysql.com/manual.php (the
$query =
mysql_query(SELECT * FROM table WHERE date LIKE '%. $query .%');
// returns all items in database
$query = 2001-01-01
mysql_query(SELECT * FROM table WHERE date LIKE '%. $query .%');
// returns all rows that have 2001-01-01 as the date
What is proper way to define a variable to
Hi,
First of all, I'm not an expert at all, I'm just a newby who started a week
ago,,,
But I guess that the answer is very simple: Why don't you link your MySQL
database to Access thru MyODBC?
This way your customers could use Access as the front-end, while MySQL is
the back-end where the data
On Mon, Feb 25, 2002 at 02:44:45PM -0800, Eric Mayers wrote:
Oganes,
It sounds like what you want is row-level-locking. This is a
feature of InnoDB tables. It allows users to write to a table while
other users are reading from the same table. Of course, they cannot
read and write the
I am hosting websites that use the mysql database. One of my customers has
a query that they run occasionally that really bogs down the entire server.
The load sometimes jumps up into the double digits (on a Red Hat 6.2
server).
Here is their query:
select count(*) from aptreviews,
I'm getting a syntax error when I try to insert more two
sets of values into a table.
I have looked at the manual on the insert statement, and
don't see what is wrong.
Can someone tell me.
Here's the info.
mysql describe book;
SQL statement are:
What is proper way to define a variable to include all dates newer than
1995-01-01?
$query = ???
select * from table where date '1995-01-01'
What is proper way to define a variable to include all dates older than
1995-01-01?
$query = ???
select * from table where
On Tuesday, 26. February 2002 00:18, Craig Westerman wrote:
What is proper way to define a variable to include all dates newer than
1995-01-01?
What is proper way to define a variable to include all dates older than
1995-01-01?
What is proper way to define a variable to include all
At 15:33 -0800 2/25/02, Bob Rea wrote:
I'm getting a syntax error when I try to insert more two
sets of values into a table.
I have looked at the manual on the insert statement, and
don't see what is wrong.
The error message indicates that the problem is at the word values.
The problem with
i'm trying to keep my code nice and clean
and one of the ways i'm doing this is keeping all the sql request code in
one module
the problem is: it's not working.
basically, all i really want is a subroutine call in my cgi that looks like
this:
my $dbh = DBI-connect('DBI:mysql:xx',
On Tuesday, 26. February 2002 00:33, Bob Rea wrote:
I'm getting a syntax error when I try to insert more two
sets of values into a table.
I have looked at the manual on the insert statement, and
don't see what is wrong.
ERROR 1064: You have an error in your SQL syntax near
'values(
Get rid of the second values.
mysql INSERT into book(
- isbn,
- title,
- authlname,
- authfname,
- publisher,
- pubdate,
- dewey,
- lcnum
- )
- values (
- '1-56592-434-7',
- 'MySQL mSQL',
- 'Yarger',
- 'Randy Jay',
- O'Reilly,
-
Change it to
INSERT into book(
isbn,
title,
authlname,
authfname,
publisher,
pubdate,
dewey,
lcnum
)
values (
'1-56592-434-7',
'MySQL mSQL',
'Yarger',
'Randy Jay',
O'Reilly,
null,
null,
null
),
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:nick hoffman
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Seems hard to answer without asking more questions, but some
basic questions first:
Is complex_id indexed in both tables? (SHOW INDEX FROM aptreviews)
Have you tried EXPLAIN'ing the query to see if maybe the index
isn't being used?
Questions:
That the queries are stuck on
Bob,
This is just a guess, but looking at
http://www.mysql.com/doc/I/n/Insert_speed.html it appears that the way
to do multiple inserts looks like:
INSERT INTO a VALUES (1,23),(2,34),(4,33);
a(col1, col2).. Perhaps multiple inserts requires that you specify all
columns in the order that the
The problem is that the DB resides on a Unix box and he access it
through a cgi program
-Original Message-
From: Luis Gonzalez [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 5:18 PM
To: [EMAIL PROTECTED]
Subject: Dumping a MySQL DB Out to Access
Hi,
First of all, I'm not
I assume you are talking about bdflush only at 100% (I'm actually trying
90%). Thing is, all our tables are constantly changing. Unless the
server crashes just after a flush tables command, the tables are likely
to get corrupt anyhow. The data altering flow of queries is over 1000/s
at the
I thought there was a problem with the datafile corruption if the cache was
lost when you chattr a file. That the file would become corrupt.
Dave
On Mon, Feb 25, 2002 at 03:55:23PM -0800, Steven Roussey wrote:
I assume you are talking about bdflush only at 100% (I'm actually trying
90%). Thing
Hello,
I'm running the same code in 2 different environments, but both access
the same MySQL database (3.23.47 Max, running on Solaris) and both use
mm.mysql-2.0.7.
Environment 1: IBM VisualAge for Java, which has JDK 1.2.2, running on a
Windows machine
Environment 2: JDK 1.3.1 running on Red
Paul,
At 23:09 2002-02-25, you wrote:
One of the chapters (the C API chapter) is online at the publisher's
site, and there are some other pages available at Amazon. All of these
are PDF format. There are pointers to this material at the book's
companion site:
http://www.mysql.com/mysql-book/
Is there any electronic version of this book (e-book)?
One of the chapters (the C API chapter) is online at the publisher's
site, and there are some other pages available at Amazon. All of these
are PDF format. There are pointers to this material at the book's
companion site:
Thanks for the assistance!
Seems hard to answer without asking more questions, but some
basic questions first:
Is complex_id indexed in both tables? (SHOW INDEX FROM aptreviews)
Yes, they are:
mysql SHOW INDEX FROM aptreviews;
I'm trying to port some stuff to OpenOffice.org from MS-Office.
Currently we store a lot of stuff in MS-Access 2000.
I figured out how to connect OO to a MySQL DB via MyODBC 3.51. But there
are a few problems.
1) I need filtering by date-fileds. Many of our tables have the fields
Hi All,
I'm trying to connect ms access to a mysql server that I installed on my
Linux machine. I already downloaded the MyODBC 2.50 which is required to
connect to mysql using ms access. My problem is when I try to connect the
database in ms access to the mysql server I get the error Host not
Hi there,
I have a postgreSQL query like
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...)
and I'd like to have an equivalent MySQL query. Your
help would be greatly appreciated.
The reason is that we were running Java
SQL statement are:
What is proper way to define a variable to include all dates newer than
1995-01-01?
$query = ???
select * from table where date '1995-01-01'
What is proper way to define a variable to include all dates older than
1995-01-01?
$query = ???
select * from table where
1 - 100 of 125 matches
Mail list logo