http://developers.slashdot.org/article.pl?sid=07/04/01/1448207&from=rss
"One of the unique qualities of the MySQL server is its ability to have
multiple storage engine operate concurrently. Companies like Oracle and
Solid have contributed their own storage engines to the open source project.
With
On 04/01/2007 03:28 PM, Anoop kumar V wrote:
Sql create statements need to be run using a compatible client.
sqlplus for
oracle, mysqlclient for mysql etc.. Here you just have a target as
part of
your routine build that also takes care of building / renewing your
database
with (or w/o) data.
Sql create statements need to be run using a compatible client. sqlplus for
oracle, mysqlclient for mysql etc.. Here you just have a target as part of
your routine build that also takes care of building / renewing your database
with (or w/o) data.
Plus a layer of abstraction such as a ant for eve
Sounds like perhaps an unnecessary complication, why would this be
better than the root SQL CREATE statements?
-Micah
On 04/01/2007 12:41 PM, Anoop kumar V wrote:
DDLUTILS is what you need:
check this out:
http://db.apache.org/ddlutils/
and better still (if you are using Ant as a build tool)
DDLUTILS is what you need:
check this out:
http://db.apache.org/ddlutils/
and better still (if you are using Ant as a build tool):
http://db.apache.org/ddlutils/ant/
Then you can store these ant scripts in your VCS (version control system).
To create or destroy the schema with data just run an
[snip]
How do i insert a file in a blob field from the command line ?
[/snip]
>From http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
mysql> UPDATE t
SET blob_col=LOAD_FILE('/tmp/picture')
WHERE id=1;
--
MySQL General Mailing List
For list archives: http://list
Hi,
How do i insert a file in a blob field from the command line ?
Any help would be appreciated.
Warm Regards
--
:wq! Mário Gamito
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 04/01/2007 09:06 AM, Jonathan Horne wrote:
i have a production system running FreeBSD 6.2-p3/MySQL 5.0.33, with 2
databases. i also have a development box, which is pretty much a mirror of my
production system, that i would like to import my databases into. daily, the
production system du
Using ALTER statements would make it tough to get a complete view. I
would stick with your original idea. This would enable diffs to work
nicely, and the latest revision would contain everything you need to
know to create the database.
-Micah
On 04/01/2007 07:11 AM, Miles Thompson wrote:
Mic
i have a production system running FreeBSD 6.2-p3/MySQL 5.0.33, with 2
databases. i also have a development box, which is pretty much a mirror of my
production system, that i would like to import my databases into. daily, the
production system dumps the databases to .sql files, as well as is a
Michael,
We're about to head down the same road, using Subversion, and my thought was to
initially capture a series of CREATE TABLE statements and store them all in
one file.
Then as schema was modified on the development server, update those
statements using SVN.
Your idea looks a lot bett
I have a puzzling situation where a query works, but only outside of a
function. If I try to abstract away some of the complexity by placing the
subquery inside a function, the db seems to get stuck in an infinite query
and the entire system becomes unresponsive (from the MySQL console I can
ctrl-c
12 matches
Mail list logo
