for using XML with Mysql.
Specifically I have a complex XML file, I would like to create a schema in
MYSQL based on it (I have XSD as well) and be able to upload new xml data
into the database as it's released to me.
I cannot find a good way to achieve this, currently I am trying to use
Hi
Hoping someone can help me work some information or direction to a good
resource for using XML with Mysql.
Specifically I have a complex XML file, I would like to create a schema in
MYSQL based on it (I have XSD as well) and be able to upload new xml data
into the database as it's released
Does someone have some schemas from multi-master to one slave excluding the
circular replication.
Please tell me.
Thanks.
Zhigang
new features in this release:
* Support for database schema evolution, including automatic schema
migration, immediate and gradual data migration, as well as soft
object model changes (ability to work with multiple schema versions
using the same C++ classes).
For a quick showcase
- Original Message -
From: Stan Iverson iversons...@gmail.com
Yes, it's a binary file; however, MySQL Connector for ODBC only works
in Windows and I'm using a Mac. If no other solutions, will try
tomorrow on a friend's PC.
If it's binary, you're gonna have no other choice but to
Hello Stan,
On 2/3/2012 20:06, Stan Iverson wrote:
On Fri, Feb 3, 2012 at 11:11 AM, Johan De Meersmanvegiv...@tuxera.bewrote:
- Original Message -
From: Stan Iversoniversons...@gmail.com
I have a Mac and a Linux server and I need to read the table schema
for a database dump from
difference between doing things right and doing the right
things.
On 3 Feb 2012, at 13:52, Stan Iverson wrote:
Hi;
I have a Mac and a Linux server and I need to read the table schema for a
database dump from MSSQL. Possible? How?
TIA,
Stan
--
MySQL
don't have MSSQL installed on either my Mac or my Linux server. I want to
read the table schema. This doesn't appear to be a viable option.
or one of the Navicat products...
http://www.navicat.com/en/download/download.html
Site is currently not serving.
Please advise.
TIA,
Stan
If you only need to view the schema, and not load the data, you could open the
dump file using a text editor like BBedit or TextWrangler (you would have to
Google the websites as I am away from my desk right now).
Wendell Turner
+44(0) 777 164 6532
wendel...@gmail.com
- Original Message -
From: Stan Iverson iversons...@gmail.com
I have a Mac and a Linux server and I need to read the table schema
for a database dump from MSSQL. Possible? How?
Heeh. If you're talking about an SQL dump into a textfile, that should be
doable - you might have to mess
On Fri, Feb 3, 2012 at 11:11 AM, Johan De Meersman vegiv...@tuxera.bewrote:
- Original Message -
From: Stan Iverson iversons...@gmail.com
I have a Mac and a Linux server and I need to read the table schema
for a database dump from MSSQL. Possible? How?
Heeh. If you're talking
There is one database name 'XYZ' on linux system, some one has mistakenly
created new
database name with 'xYZ', database is created when I use 'xYZ' database, there
are no
tables with SHOW TABLES, but when i run SHOW PROCEDURE STATUS it show
procedures from
'XYZ' database.
My concern is that
Is this a production setup.
If not, take complete dump of the all databases.
Drop the xYZ database, see if you can see all the objects under XYZ.
Since the xYZ database is created, its obvious, that names are case
sensitive, and it show not show object from XYZ, when u under xYZ.
Can you please
http://www.ferdychristant.com/blog//archive/DOMM-7QJPM7
On Sun, Jul 10, 2011 at 10:14 PM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
Dear all,
Today I need to create a schema for my application website that allows user
comments too.
I think we have to maintain hierarchical data
On Jul 12, 2011, at 7:54 PM, Prabhat Kumar wrote:
Today I need to create a schema for my application website that allows user
comments too.
I think we have to maintain hierarchical data and it is very common as all
sites are supporting this feature.
Can somebody suggest me some guidelines
Dear all,
Today I need to create a schema for my application website that allows
user comments too.
I think we have to maintain hierarchical data and it is very common as
all sites are supporting this feature.
Can somebody suggest me some guidelines to follow and some links too.
Thanks
I:
While designing the schema of the database, I have two choices:
Scenarios:
1. Create multiple tables, one for each department. The relationship for
most of the tables is one-to-one.
2. Create one master table so that each department updates its respective
columns in the same table.
Please
, then why
write an application in the first place?
Part I:
While designing the schema of the database, I have two choices:
Scenarios:
1. Create multiple tables, one for each department. The relationship for most
of the tables is one-to-one.
2. Create one master table so that each department updates
:
Part I:
While designing the schema of the database, I have two choices:
Scenarios:
1. Create multiple tables, one for each department. The relationship for most
of the tables is one-to-one.
2. Create one master table so that each department updates its respective
columns in the same table
Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
26-Feb-10
Schema and Data Comparison and Synchronization Tools for MySQL Offer Command
Line Mode and Comparison Reports
MySQL database
Performance Schema: Instrumenting Code
http://forge.mysql.com/wiki/Performance_Schema:_Instrumenting_Code
This Thursday (February 18th, 17:00 UTC - note the different starting
time!), Marc Alff will present the brand new Performance Schema:
Instrumenting Code. Marc is the implementor
5:58
To: Scott Haneda
Cc: mysql@lists.mysql.com
Subject: Re: Information Schema
Scott
Information_schema is a virtual database only. I think it was added in
MySQL 5.0.2 to comply with SQL:2003 specifications.
information_schema provides the same info as you can get from 'SHOW'
commands. Every
Ok, so how do I disable that?
- Mark
-Original Message-
From: John Daisley [mailto:john.dais...@mypostoffice.co.uk]
Sent: woensdag 29 april 2009 5:58
To: Scott Haneda
Cc: mysql@lists.mysql.com
Subject: Re: Information Schema
Scott
Information_schema is a virtual database only
I have been meaning to find out about this since I moved to mysql 5.
In version 4, I never saw the table information schema. With it
being in version 5, I assume it was something only the root users, or
a higher level user could see.
I now know that it shows up under any account. I
John
I have been meaning to find out about this since I moved to mysql 5.
In version 4, I never saw the table information schema. With it
being in version 5, I assume it was something only the root users, or
a higher level user could see.
I now know that it shows up under any account. I
email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
From: bobsh...@ntlworld.com
To: mysql@lists.mysql.com
CC: win32-h...@lists.mysql.com
Subject: Newbie ... Schema details listing
Date: Sun, 12 Apr 2009 14:54:50
I have written a .cfm to output a listing of columns with Name, Format, Size,
NULL, KEY, etc.
One thing I need to include is whether the Primary Key is AUTO_INCREMENT
That element does not appear to be in the same SCHEMA table.
Where is it ? and How can I use it with this Query
for various web/scripts that
need varying levels of security.
This will cycle through each server and do a schema and data dump and
create a tarball for you. Useful for a weekly or monthly or even a
one-off.
Use as you like
We have a pretty large database (several terabytes and hundreds of tables).
When I do a simple query from the information schema, e.g. select table_name
from tables, it can minutes to come back with the answer. Yet, if I do a
show tables, describe or show create table the response is instant
PROTECTED]
Sent: Monday, October 06, 2008 7:51 PM
To: Andy Shellam; mysql@lists.mysql.com
Subject: Re: Any easier way to compare mysql schema of 50 databases?!
Thank you all, guys!!
i shall try these and respond on which worked best for me.
Regards,
Uma
On 10/6/08, Andy Shellam [EMAIL
I just used mysqldiff for a project, and was successful.
-Original Message-
From: Uma Bhat [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2008 7:51 PM
To: Andy Shellam; mysql@lists.mysql.com
Subject: Re: Any easier way to compare mysql schema of 50 databases?!
Thank you all, guys
Uma Bhat wrote:
Hey guys!
*MySQL version 5.0*
Hence before doing this, *we want to ensure that
there is ABSOLUTE *no* difference in schema between each of them. (all
datatypes, and other such database objects, engines, MUST be IDENTICAL).*
*QUESTION* - what's the *EASIET way to compare
are in progress of *optimizing* and designing the existing mysql database
enviromnent on *linux*. And need help in comaparing schema of 50
databases from the same mysql instance.
*MySQL version 5.0*
*SCENARIO* - There are 50 mysql databases (which we have been informed that
is of same schema
Uma Bhat wrote:
We are in progress of *optimizing* and designing the existing mysql database
enviromnent on *linux*. And need help in comaparing schema of 50
databases from the same mysql instance.
If you can afford to spend a few dollars to get the right tool, you want
to get DB Comparer
in comaparing schema of 50
databases from the same mysql instance.
If you can afford to spend a few dollars to get the right tool, you
want to get DB Comparer for MySQL from the folks at EMS:
http://www.sqlmanager.net/en/products/mysql/dbcomparer
This tool will compare the schemas of 2 MySQL
Lorenso wrote:
Uma Bhat wrote:
We are in progress of *optimizing* and designing the existing mysql
database
enviromnent on *linux*. And need help in comaparing schema of 50
databases from the same mysql instance.
If you can afford to spend a few dollars to get the right tool, you want
Hey guys!
We are in progress of *optimizing* and designing the existing mysql database
enviromnent on *linux*. And need help in comaparing schema of 50
databases from the same mysql instance.
*MySQL version 5.0*
*SCENARIO* - There are 50 mysql databases (which we have been informed
description or make it a boolean in
stead of a text setting'). It will also use less space because of the
previous.
Ofcourse, I don't see any settings description or setting types
limitations in your schema as it is now.
If that isn't an objection, you could create the foreign key constraint
.
Ofcourse, I don't see any settings description or setting types
limitations in your schema as it is now.
If that isn't an objection, you could create the foreign key constraint on
the existing table as such:
ALTER TABLE Settings ADD UNIQUE KEY (applicationID)
ALTER TABLE Settings ADD FOREIGN KEY
Problem is that there are combinations that I'll never care about
What do u mean by the above statement.
I would definitly go for the first solution, though ur taking more time on
the index, but u dont need to keep adding columns and doing joins as u think
would happen in the second approch.
On Mon, Jul 7, 2008 at 2:49 AM, Ananda Kumar [EMAIL PROTECTED] wrote:
Problem is that there are combinations that I'll never care about
What do u mean by the above statement.
What I meant is that I will never do a query for (e.g.) (30, anything).
So I have an index on values that I'll
how many rows would be there in this table and what is the growth rate of
this table.
regards
anandkl
On 7/7/08, Waynn Lue [EMAIL PROTECTED] wrote:
On Mon, Jul 7, 2008 at 2:49 AM, Ananda Kumar [EMAIL PROTECTED] wrote:
Problem is that there are combinations that I'll never care about
What
Waynn Lue wrote:
I have two tables, Applications and Settings. Here are the two schemas:
mysql desc Applications;
+-+-+--+-+-++
| Field | Type| Null | Key | Default |
Extra |
I feel creating the third table would just be duplicating the data and
occupying space. Creating index on existing table and quering would be
better. But you got a good point of FOREIGN KEY CONSTRAINT. Can we use this
constraint on current SETTINGS table, rather than creating the third
table.
On
space
because of the previous.
Ofcourse, I don't see any settings description or setting types
limitations in your schema as it is now.
If that isn't an objection, you could create the foreign key constraint
on the existing table as such:
ALTER TABLE Settings ADD UNIQUE KEY (applicationID)
ALTER
in your schema as it is now.
If that isn't an objection, you could create the foreign key constraint on
the existing table as such:
ALTER TABLE Settings ADD UNIQUE KEY (applicationID)
ALTER TABLE Settings ADD FOREIGN KEY (applicationID) REFERENCES
Applications(applicationID) ON UDPATE CASCADE
I have two tables, Applications and Settings. Here are the two schemas:
mysql desc Applications;
+-+-+--+-+-++
| Field | Type| Null | Key | Default |
Extra |
Schema is a collection of databases.
On Fri, Mar 28, 2008 at 6:00 PM, Nanni Claudio
[EMAIL PROTECTED] wrote:
I know I am a little late.
From my experience with Oracle Database:
ORACLE MYSQL(equivalent)
---
DATABASE
: Re: FW: Re: what is a schema? what is a database?
Schema is a collection of databases.
On Fri, Mar 28, 2008 at 6:00 PM, Nanni Claudio [EMAIL PROTECTED] wrote:
I know I am a little late.
From my experience with Oracle Database:
ORACLE MYSQL(equivalent
On Mon, Apr 7, 2008 at 1:24 AM, Moon's Father [EMAIL PROTECTED] wrote:
Schema is a collection of databases.
A schema is a definition of tables fields and their relationship.
Kevin.
--
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I know I am a little late.
From my experience with Oracle Database:
ORACLE MYSQL(equivalent)
---
DATABASEMYSQL INSTALLATION
SCHEMA DATABASE
So in Oracle a Database is an instance running
Carlos Savoretti schrieb:
Hi all!
Well, question is how could I to retrieve information about
types supported.
IMHO, no
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
?
I do not think you can use the information schema to get this
information. However you can use help:
For server side help, type 'help contents'
mysql help DATA TYPES
You asked for help about help category: Data Types
For more information, type 'help item', where item is one of the following
topics
Hi all!
Well, question is how could I to retrieve information about
types supported . In PostgreSQL the query would be:
--
SELECT pg_type.oid, typname, usename, obj_description(pg_type.oid)
FROM pg_type, pg_user
WHERE
On Tue, 04 Mar 2008 09:48:03 -0600, Paul DuBois wrote:
Apparently MySQL lacks this feature, but what feature is it lacking?
There's no equivalent to:
SELECT * FROM database.schema.table;
In MySQL, the two are equivalent. The keyword DATABASE or DATABASES can
be replaced with SCHEMA
schemas, schema simply being a grouping for
objects in a database. In a SQL Server 2005 database, there can be two
tables named Product if one is in the schema Sales and the other is in
the schema Manufacture. The two tables are Sales.Product and
Manufacture.Product.
A fully qualified SQL Server
Hi Thufir, all !
Thufir wrote:
On Tue, 04 Mar 2008 09:48:03 -0600, Paul DuBois wrote:
[[...]]
In MySQL, the two are equivalent. The keyword DATABASE or DATABASES can
be replaced with SCHEMA or SCHEMAS wherever it appears.
Right, but that wasn't exactly what I was asking. I'm fairly
Sorry. An example of a fully qualified SQL Server object name is:
SELECT * FROM Server123.Database456.Sales.Product
The object Server123.Database456.Manufacture.Product is a different
table from Server123.Database456.Sales.Product.
Joerg Bruehe in his post called a schema a namespace, I
my understanding is that Namespace is a defined grouping of classes
http://m5.eecs.umich.edu/docs/namespaceMySQL.html
where MySQL triggers a namespace must be unique within the schema
(database).
http://markmail.org/message/m5icpi2luv6baijt?q=Joerg+Bruehe+AND+namespace
+AND+definitionpage=1refer
.)
And similar, a schema in that ANSI SQL standard opened a name space
for tables and views, and AFAIR that was its only purpose.
(No, I will not try to dig up that standard - its schema concept had
no practical relevance in products back then.)
Jörg
--
Joerg Bruehe, Senior Production
On Wed, 05 Mar 2008 15:01:12 +0100, Joerg Bruehe wrote:
I have not heard of a three level naming scheme yet.
Aha, thanks for the history, helps to put what I was reading into context.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Mon, 03 Mar 2008 14:20:58 -0500, Martin Gainty wrote:
http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html According to
MYSQL doc:
A schema is a database
That contradicts the following claim (to my reading):
A true fully (database, schema, and table) qualified query
My experience (Oracle, PostgreSQL, MySQL, SQL Server) is that every
DBMS is different in this regard. Microsoft's SQL Server works like
this:
A SQL Server instance (server) can have many databases.
A database can have many schemas, schema simply being a grouping for
objects in a database
At 8:58 AM + 3/4/08, Thufir wrote:
On Mon, 03 Mar 2008 14:20:58 -0500, Martin Gainty wrote:
http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html According to
MYSQL doc:
A schema is a database
That contradicts the following claim (to my reading):
A true fully (database, schema
http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html
According to MYSQL doc:
A schema is a database
Wikopedia says a Schema is defined as:
Pronounced as skee-ma, the structure of a database system, described in a
formal language supported by the database management system (DBMS
I've been referencing a variety of sources, including wikipedia. What I
know about a schema is that in SQLite the .schema command will show the
the SQL structure of that databases tables, which would be analogous to
DESCRIBE foo in MySQL (with the difference that SQLite shows all tables
Yes, you are exactly right. The schema is the structure of the database.
Keith
I've been referencing a variety of sources, including wikipedia. What I
know about a schema is that in SQLite the .schema command will show the
the SQL structure of that databases tables, which would be analogous
Eric Frazier wrote:
Daevid Vincent wrote:
This has been asked for many many times on this list, not sure why
mySQL AB
doesn't just release a command line tool like a 'mysql diff' and also a
'mysql lint'. The lint one should be totally trivial for them to do,
as they
already have a SQL parser!
Daevid Vincent wrote:
This has been asked for many many times on this list, not sure why mySQL AB
doesn't just release a command line tool like a 'mysql diff' and also a
'mysql lint'. The lint one should be totally trivial for them to do, as they
already have a SQL parser! I can't tell you how
PM
To: mysql@lists.mysql.com
Subject: DB Schema Comparison Utility ?
Hi Folks,
I am new to MySQL. We have a development environment where we have
three systems
1) Developement Database on Machine A
2) Test Databasae on Machine B
3) Live Database on Machine C
So we
Subject: DB Schema Comparison Utility ?
Hi Folks,
I am new to MySQL. We have a development environment where we have
three systems
1) Developement Database on Machine A
2) Test Databasae on Machine B
3) Live Database on Machine C
So we make changes to the Developement Database
question is, is there a way of automatically migrating
the changes from Dev to Test, Test to Live ?
I have worked with a DB which had an admin function wherein you could
connect two databases and it would run a comparison between the two
databases and produce a file of schema differences which you
is, is there a way of automatically migrating
the changes from Dev to Test, Test to Live ?
I have worked with a DB which had an admin function wherein you could
connect two databases and it would run a comparison between the two
databases and produce a file of schema differences which you could
Folks,
A help needed. My manager's pushed me to optimize the tables that I
created in distributed in several DBs. I have tried best to explain to him
that I have followed the strict formula design to do the Join, Search and
so on. However, the system performance is not good enough yet when our
You should read up on the show status and show variables output.
That will give you a start as to perhaps some obvious issues. For
instances, your opened_tables and threads_created should not be
large. Using the right table types is also a very big issue, although
you may have gone down
Hailiang Ji wrote:
Folks,
A help needed. My manager's pushed me to optimize the tables that I
created in distributed in several DBs. I have tried best to explain to him
that I have followed the strict formula design to do the Join, Search and
so on. However, the system performance is not good
Hi all,
Can someone suggest a good method or normalized schema for storing product
information (id, description, price) which changes over time so that as a
product is gradually discounted, an order will reflect the cost of that
particular product at that particular time?
--
-jp
At birth
Hi,
On Thu, June 14, 2007 18:16, Jake Peavy wrote:
Hi all,
Can someone suggest a good method or normalized schema for storing product
information (id, description, price) which changes over time so that as a
product is gradually discounted, an order will reflect the cost of that
particular
hey all,
I have two tables like that:
artists(id,name)
albums(id,artist_id,album_name)
and I need to transfer the data of this database to three tables that
look like this:
artists(id,name)
albums(id,name)
artists_albums(album_id,artist_id)
any idea what's the fastest query to do this?
thanx
Patrick Aljord wrote:
hey all,
I have two tables like that:
artists(id,name)
albums(id,artist_id,album_name)
and I need to transfer the data of this database to three tables that
look like this:
artists(id,name)
albums(id,name)
artists_albums(album_id,artist_id)
any idea what's the fastest
Hi,
Is it possible to rename a DB schema? if so how? Using mysql 5.0, innodb
engine.
-nikita
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it possible to rename a DB schema? if so how? Using mysql
5.0, innodb engine.
See 'Rename Database' at http://www.artfulsoftware.com/queries.php for
a start on the solution.
PB
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database
Matthew Wilson writes:
I've spent the last month building a fairly elaborate database with
lots of foreign keys.
I want to draw a diagram that maps the relationships between all the
tables, but I haven't found any software that can do that.
Does anyone have any suggestions? I want to draw a
I've spent the last month building a fairly elaborate database with lots
of foreign keys.
I want to draw a diagram that maps the relationships between all the
tables, but I haven't found any software that can do that.
Does anyone have any suggestions? I want to draw a picture with a box
for
Try to use DBDesigner, you´d get it from www.fabforce.net
Matthew Wilson [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
I've spent the last month building a fairly elaborate database with lots
of foreign keys.
I want to draw a diagram that maps the relationships between all
PROTECTED] Behalf Of Matthew Wilson
Sent: Wednesday, August 30, 2006 2:58 PM
To: mysql@lists.mysql.com
Subject: How to draw data model diagrams from existing schema?
I've spent the last month building a fairly elaborate database with lots
of foreign keys.
I want to draw a diagram that maps
diagrams from existing schema?
I've spent the last month building a fairly elaborate database with lots
of foreign keys.
I want to draw a diagram that maps the relationships between all the
tables, but I haven't found any software that can do that.
Does anyone have any suggestions? I want
Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Matthew Wilson
Sent: Wednesday, August 30, 2006 2:58 PM
To: mysql@lists.mysql.com
Subject: How to draw data model diagrams from existing schema
Wilson
Sent: Wednesday, August 30, 2006 1:58 PM
To: mysql@lists.mysql.com
Subject: How to draw data model diagrams from existing schema?
I've spent the last month building a fairly elaborate
database with lots of foreign keys.
I want to draw a diagram that maps the relationships between
On Mon, 10 Apr 2006, Brian Menke wrote:
Does anyone happen to know where a basic schema for tracking questions and
answers from tests that a student has completed. I don't know why I am
having difficulty with this, but I can't seem to figure out how to set up
the tables correctly to store
) a student has or
is taking.
Best,
Mikhail Berman
-Original Message-
From: JC [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2006 11:22 AM
To: Brian Menke
Cc: mysql@lists.mysql.com
Subject: Re: Student question answer schema
On Mon, 10 Apr 2006, Brian Menke wrote:
Does anyone happen
@lists.mysql.com
Subject: RE: Student question answer schema
Brian,
Sound like you need to normalize your data. Quick review of what you
sent to the list shows that you need 5 tables:
* student table - each student description
* module table - each module description
* question table - each question
Does anyone happen to know where a basic schema for tracking questions and
answers from tests that a student has completed. I don't know why I am
having difficulty with this, but I can't seem to figure out how to set up
the tables correctly to store this information.
The basics
N number
, 2006 10:38 PM
To: mysql@lists.mysql.com
Subject: Student question answer schema
Does anyone happen to know where a basic schema for tracking questions and
answers from tests that a student has completed. I don't know why I am
having difficulty with this, but I can't seem to figure out how to set up
All,
I've searched the help and even found this very useful link
http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html regarding all the
Information schemas.
What I can find is information regarding some way to retrieve the number of
pages used to store an index. Perhaps this is because
I've used msyqldump to retrieve the structure and data of my db, but
can I use it to only spit out the structure, ie, the Create Table
statements, but none of the inserts.
Thanks.
Scott.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
ONLY Schema
I've used msyqldump to retrieve the structure and data of my db, but
can I use it to only spit out the structure, ie, the Create Table
statements, but none of the inserts.
Thanks.
Scott.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
We use SVN to commit our code, but sometimes a dev will commit broken SQL
schema.
We use php -l to validate all php prior to allowing the checkin, wondering
if there is some simmilar tool for mySQL (we're migrating to v5.0 if that
helps) to prevent broken schema syntax from sneaking into our
What is a schema? How is different from a database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
as far as I know a schema is a description of a database.
[EMAIL PROTECTED] wrote:
What is a schema? How is different from a database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 221 matches
Mail list logo