Dear Peter,Thanks for your guiding.I have implemented it.Thank from every
member of this list too.
Mohsen,
The data structure you seem to be looking for is MYSQL_RES, the C API
resultset, which is an array which is described in the manual page you
were pointed to. It's pretty straightforward
Of course I was not hoping that SPs would be actually compiled but it
seems to me they are not even interpreted.
I have a preprocessing table of 170k rows in a ~72 MB table. A stored
procedure with a lot of string operations processes the data into
another table of approx 15 million rows( few
I have a project that involves several developers working on their own
machines. Each has a local copy of the database on their own machine. Since
we have some developers who develop while not connected to the network, we
cannot use a common database.
How can I version control the database so
The method employed by the company I work for is to maintain a version
controlled set of scripts, which can be used to create/update a database
(many of these scripts are objects such as UDFs, Stored Procedures and so
forth, which represent the 'software' layer within the database).
A bespoke
Hi,
I have to implement a bestseller list feature into a shop software
and, unfortunately, I don't see a possibility to make it as fast as
it has to be.
The relevant stuff is distributed among four tables [1]. `orders`
contains all the ordered products. I use the following query to
create a
Try using MYdbPAL from www.it-map.com .
The product has complete schema version control, alowing you to track
changes and compare sche,as for diffrences. Its FREE to MySQL users.
Tim
-Original Message-
From: Will Merrell [mailto:[EMAIL PROTECTED]
Sent: 20 February 2005 14:00
To: Mysql
I am building a
temporary memory table to store links in. Instead of having php truncating all
links older than 10 minutes is there just a way to have the table do itself
automatically?
ThanksDonny LairsonPresident29
GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228
We are building two
copies of our commonly used tables. When we have to write something we
write it Both tables:
TABLE
A
TABLE B MEMORY table
When we read to run
our script we only read from he MEMORY TABLE.
My question is how do
I tell TABLE B toclone TABLE Aafter a reboot
Hi to all,
I'm working with mysql 4.1, the InnoDb files are ~1.5Gb.
The question is: How to compress a inndodb data file?
My InnoDB free space is ~800Mb.
Thanks in advance.
--
Ivan Cachicatari
http://www.latindevelopers.com
--
MySQL General Mailing List
For list archives:
I am new to SQL and to MySQL, but am working with it on a project for a
graduate Database system course. I'm running MySQL 4.1.10 under Windows
2000. I am trying to load a table from a text file. The table in
question has a foreign key. The table that it references contains data.
The problem
Ivan,
- Original Message -
From: Latindeveloper [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 20, 2005 10:51 PM
Subject: InnoDB Files
Hi to all,
I'm working with mysql 4.1, the InnoDb files are ~1.5Gb.
The question is: How to compress a inndodb data file?
Nick,
http://dev.mysql.com/doc/mysql/en/innodb-monitor.html
you can use innodb_lock_monitor to find out who is locking the row.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
Hi,
I was assuming USE INDEX was only telling MySQL which INDEX it needed to
use, but it seems to be not always the case.
With MySQL 4.1.10, USE INDEX(topic) for the following query seems to change
the way the index is used.
mysql EXPLAIN SELECT numreponse FROM searchjoinhardwarefr13 WHERE
I am looking for instructions on how to configure mysql on a Linux server
with an already running version. I would need it run on a different
port and all the files to be installed in one location. I don't what
it to interfere with the standard install of mysql. Also I would like
it to install
See Running Multiple MySQL Servers on the Same Machine In the manual.
http://dev.mysql.com/doc/mysql/en/multiple-servers.html
-Eric
On Sun, 20 Feb 2005 20:40:11 -0800, Richard Kurth [EMAIL PROTECTED] wrote:
I am looking for instructions on how to configure mysql on a Linux server
with an
dear sir
good wishes.
i am using enterprise redhat linux 3. mine rpm version of mysql is
-3.23.58-1 and it was installed by the time of linux installation.
when i use if the rpm is installed or not by using the comman rpm -qa
| grep mysql
it shows
mysql-3.23.58-1
libdbi-dbd-mysql-0.6.5-6
using ySQL 4.1.9 and mysql-connector-net-1.0.4.
the following occurred.
CREATE TABLE customer (
code INT NOT NULL DEFAULT 0 PRIMARY KEY,
name VARCHAR(64) NOT NULL DEFAULT ''
);
INSERT INTO customer VALUES
(1, ''), (2, ''), (3, '');
MySqlConnection con = new MySqlConnection(
Hi
I'm making a webdrive that uses the Mysql DB.
I would like you to set up in mysql clustering mode.
Of
the clustering options, I would need, in the near
term, a warm standby that could be automatically be
made the primary RDBMS, if something goes wrong with
the current primary DB or its
I'm making a webdrive that uses the Mysql DB.
I would like you to use mysql clustering options.Of
the clustering options, I would need, in the near
term, a warm standby that could be automatically be
made the primary RDBMS, if something goes wrong with
the current primary DB or its hardware.
19 matches
Mail list logo