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 que
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 i
The easiest route is to use mysqldump with the --no-data option. it
will dump the full schema info including feign keys, etc.
-- michael dykman
On Wed, 2005-02-02 at 13:31, Dan Stromberg wrote:
> I have a system with set of web pages that use PHP and a MySQL database.
>
> Apparently the old w
> I have a system with set of web pages that use PHP and a MySQL database.
>
> Apparently the old webmaster has disappeared, and a new webmaster has been
hired. She needs to know the schema of the database.
>
> So my question is: Is there a way of querying MySQL not for values of
fields, but rat
PROTECTED]
Subject: Pulling a database schema out of a unknown MySQL database?
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old webmaster has disappeared, and a new webmaster has
been hired. She needs to know the schema of the database.
So my question is
I'd do something like 'mysqldump -d foo'; the -d option only dumps the
table defs.
> -Original Message-
> From: Dan Stromberg [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 02, 2005 12:31 PM
> To: mysql@lists.mysql.com
> Cc: [EMAIL PROTECTED]
> S
Dan Stromberg <[EMAIL PROTECTED]> wrote on 02/02/2005 01:31:17 PM:
>
> I have a system with set of web pages that use PHP and a MySQL database.
>
> Apparently the old webmaster has disappeared, and a new webmaster has
> been hired. She needs to know the schema of the database.
>
> So my questi
You mean "show databases", "show tables" and "describe $table_name" for
every table in the database ?
Balazs
On Wed, Feb 02, 2005 at 10:31:17AM -0800, Dan Stromberg wrote:
>
> I have a system with set of web pages that use PHP and a MySQL database.
>
> Apparently the old webmaster has disappe
I have a system with set of web pages that use PHP and a MySQL database.
Apparently the old webmaster has disappeared, and a new webmaster has
been hired. She needs to know the schema of the database.
So my question is: Is there a way of querying MySQL not for values of
fields, but rather for t
At 15:53 +1000 on 06/07/2004, Ligaya Turmelle wrote about Re: Advice
on Database Schema Design:
I think I get what you are trying to do and it sounds good (though I am
still a beginner). The only thing I can think that might cause a problem is
since you have more then a couple of tables you MAY
I think I get what you are trying to do and it sounds good (though I am
still a beginner). The only thing I can think that might cause a problem is
since you have more then a couple of tables you MAY have to write joins for
all of them . Only you would know if you can do that and/or be comfortabl
I am converting a form that was originally designed to be Email
Submitted into a Submit-to-PHP-Page Form (which will then insert the
data into a MySQL Database).
I expect no problems in actually scanning the submission to extract
the data but I have some questions on the design of the Tables t
Massimo,
Monday, August 19, 2002, 10:40:50 AM, you wrote:
MP> As in your instruction on 4 jul 2002 23:51:13 I added the
MP> SET NO_FOREIGN_KEY_CHECKS=1;
^^^
Should be:
SET FOREIGN_KEY_CHECKS = 0
MP> after having installed 3.23.52 for WIN on my win2k syst
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Massimo Petrini" <[EMAIL PROTECTED]>
Sent: Monday, August 19, 2002 12:52 PM
Subject: Re: new command in 3.23.52 - innodb database schema dump
> Massimo,
>
> it was c
> As in your instruction on 4 jul 2002 23:51:13 I added the
>
> SET NO_FOREIGN_KEY_CHECKS=1;
>
> after having installed 3.23.52 for WIN on my win2k system in the first
line
> of my shema dump (obtained with MYSQLDUMP -opt);
>
> But wheh I lanch the command
> mysql database
> I received the fol
As in your instruction on 4 jul 2002 23:51:13 I added the
SET NO_FOREIGN_KEY_CHECKS=1;
after having installed 3.23.52 for WIN on my win2k system in the first line
of my shema dump (obtained with MYSQLDUMP -opt);
But wheh I lanch the command
mysql database http://www.mysql.com/manual.php (th
10:06 PM
Subject: innodb database schema dump
> I had the same problem, and while I don't think there's a way around it,
you
> can load the schema with the force option so that it will eventually make
it
> to the table the must be created first, (even if a previous table creation
>
I had the same problem, and while I don't think there's a way around it, you
can load the schema with the force option so that it will eventually make it
to the table the must be created first, (even if a previous table creation
gives an error). Running the script many times over and over will
ev
how can i dump innodb tables schema with foreign key references
so that the tables are created in the right order ?
thanks,
Pierre
--
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
TED]
Subject: Re: print database schema
Hello
more of a visual tool. The program I did see had views of all the tables
as if you had done a "describe table_name" for each table, then had lines
linking the relationships between tables (similar to what you can view in
Access , even th
Fax: (632) 634-5139
- Original Message -
From: "Steven Wren" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 29, 2002 12:42 PM
Subject: print database schema
> Hello
>
> I was wondering if anyone knew of a program that would allow you to print
Hello
more of a visual tool. The program I did see had views of all the tables
as if you had done a "describe table_name" for each table, then had lines
linking the relationships between tables (similar to what you can view in
Access , even though i hate to admit I have used it :)
would just be
At 14:42 +1000 1/29/02, Steven Wren wrote:
>Hello
>
>I was wondering if anyone knew of a program that would allow you to print
>out a complete database. I have seen it on a PostGre DB, so I am sure
>MySQL should have something...
You mean mysqldump --no-data db_name ?
>
>cheers!
>
>Regards,
>
>
Hello
I was wondering if anyone knew of a program that would allow you to print
out a complete database. I have seen it on a PostGre DB, so I am sure
MySQL should have something...
cheers!
Regards,
___
Steven Wren
[EMAIL PROTECTED]
http://www.server101.com
Webhosting and E-commerce S
Try "mysqldump -d database_name"...
On Fri, 22 Jun 2001, Juan wrote:
> Can I generate my Database Schema from mySQL? How?
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
Hi,
Can I generate my Database Schema from mySQL? How?
TIA,
Juan.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
26 matches
Mail list logo