Re: table structure problem

Hi, Shawn, Thanks for replying. What i meant is that i would also like to create a table with "site types", where i would have a listing of possible sites, like arqueology, natural, etc. and maybe use it to redirect the queries instead of having to hardcode the table name when i need to list a spe

Re: table structure problem

On 7/8/2010 11:29 PM, Miguel Vaz wrote: Hi, I am having some uncertainty while designing the following structure: I have two sets of data: * arqueology sites (can be natural): id name description id_category id_period x y * natural sites (can be arqueological also - bear with me -, so there

table structure problem

Hi, I am having some uncertainty while designing the following structure: I have two sets of data: * arqueology sites (can be natural): id name description id_category id_period x y * natural sites (can be arqueological also - bear with me -, so there will be duplicate records in the above ta

[MySQL] Table structure help needed

I am creating surveys for our website and want store questions and answers in a database. I found a tutorial that was useful, however it only gave structure for a single question with one answer. My surveys need to be more comprehensive than a poll question, and so I need some help with the structu

Re: Help with Table structure

y, August 11, 2008 19:14 Subject: Re: Help with Table structure > Not sure how someone can intelligently comment on your table structure > when you haven't given any details of the data you are storing. In my > experience, the fact that you have 75 fields in your table is a strong &

Re: Help with Table structure

Not sure how someone can intelligently comment on your table structure when you haven't given any details of the data you are storing. In my experience, the fact that you have 75 fields in your table is a strong indicator that your data is not normalized. If that is the case you table

RE: Transplanting table structure changes

0.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com >-Original Message- >From: Markus Grossrieder [mailto:[EMAIL PROTECTED] >Sent: Sunday, August 10, 2008 8:46 AM >To: Jerry Schwartz; mysql@lists.mysql.com >Subject: Re: Transplanting table structure changes

Re: Transplanting table structure changes

Hello Jerry, > >You might want to try our Schema Compare tool inside Database Workbench. > >This tool also has a "script recorder" that can record any changes you > >make > >to (meta)data in order to help you keep your change scripts. > > > [JS] Ah! I just discovered that if I hit what looks like

Help with Table structure

table structure. Thanks. Velen

Re: Transplanting table structure changes

riginal Message - From: "Jerry Schwartz" <[EMAIL PROTECTED]> To: "'Martijn Tonies'" <[EMAIL PROTECTED]>; Sent: Friday, August 08, 2008 8:44 PM Subject: RE: Transplanting table structure changes >You might want to try our Schema Compare tool insid

RE: Transplanting table structure changes

>You might want to try our Schema Compare tool inside Database Workbench. >This tool also has a "script recorder" that can record any changes you >make >to (meta)data in order to help you keep your change scripts. > [JS] Ah! I just discovered that if I hit what looks like the "record" button, I get

RE: Transplanting table structure changes

>-Original Message- >From: Martijn Tonies [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 07, 2008 1:46 AM >To: mysql@lists.mysql.com >Subject: Re: Transplanting table structure changes > >Hello Jerry, > >> I've added about a dozen new colu

Re: Transplanting table structure changes

Hello Jerry, > I've added about a dozen new columns to two tables in my development > environment, and now I need to roll it out to our production environment. > Can anyone suggest an easy way to do this? I want to avoid typos, as much as > I can. > > > > I made the original changes with PHPMyAdmi

Re: Transplanting table structure changes

Sutput the table definitions and cut and paste the new columns into a ALTER TABLE table_name ADD column_name column-definition statement. --- On Wed, 6/8/08, Jerry Schwartz <[EMAIL PROTECTED]> wrote: > From: Jerry Schwartz <[EMAIL PROTECTED]> > Subject: Transplanting table

Transplanting table structure changes

I've added about a dozen new columns to two tables in my development environment, and now I need to roll it out to our production environment. Can anyone suggest an easy way to do this? I want to avoid typos, as much as I can. I made the original changes with PHPMyAdmin, so I don't have any ori

Re: Table Structure

At 5:32a -0400 on Fri, 16 May 2008, Ananda Kumar wrote: >>> 2 Index would do range scan, which would be comparitivly slower. >> >> Not exactly. This, again, depends on implementation and the >> data against which queries are run. An index is an index. >> Remember, a primary key is implemented by

Re: Table Structure

Hi Kevin, > 2 Index would do range scan, which would be comparitivly slower. Not exactly. This, again, depends on implementation and the data against which queries are run. An index is an index. Remember, a primary key is implemented by the MySQL engine as a unique not null b-tree index. In f

Re: Table Structure

At 2:49a -0400 on Fri, 16 May 2008, Ananda Kumar wrote: > it goes without saying Eh, not to those who don't know. Hence the list and question. :-D Krishna, the short answer is that it depends on your data, and the queries against it that you run. Test/benchmark on your own DB and data to see w

Re: Table Structure

;> On Thu, May 15, 2008 at 1:22 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote: >>> >>> > On Tue, May 13, 2008 at 1:30 AM, Krishna Chandra Prajapati >>> > <[EMAIL PROTECTED]> wrote: >>> > > Hi all, >>> > > >>> >

Re: Table Structure

gt; On Tue, May 13, 2008 at 1:30 AM, Krishna Chandra Prajapati >> > <[EMAIL PROTECTED]> wrote: >> > > Hi all, >> > > >> > > Below is the user_delivery table structure. >> > > >> > > CREATE TABLE `user_delivery

Re: Table Structure

Tue, May 13, 2008 at 1:30 AM, Krishna Chandra Prajapati > > <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > > > > Below is the user_delivery table structure. > > > > > > CREATE TABLE `user_delivery` ( > > > `user_id` decimal

Re: Table Structure

OTECTED]> wrote: > > Hi all, > > > > Below is the user_delivery table structure. > > > > CREATE TABLE `user_delivery` ( > > `user_id` decimal(22,0) NOT NULL default '0', > > `delivery_id` decimal(22,0) NOT NULL default '0', > &

Re: Table Structure

On Tue, May 13, 2008 at 1:30 AM, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > Hi all, > > Below is the user_delivery table structure. > > CREATE TABLE `user_delivery` ( > `user_id` decimal(22,0) NOT NULL default '0', > `delivery_

Table Structure

Hi all, Below is the user_delivery table structure. CREATE TABLE `user_delivery` ( `user_id` decimal(22,0) NOT NULL default '0', `delivery_id` decimal(22,0) NOT NULL default '0', `send_to_regulator` char(1) default NULL, PRIMARY KEY (`user_id`), KEY `user_deliv

RE: Backup table structure, not data

This works fine for me: http://www.mysql.com/products/tools/administrator/ -Original Message- From: Esbach, Brandon [mailto:[EMAIL PROTECTED] Sent: Monday, February 18, 2008 12:22 PM To: [EMAIL PROTECTED] Cc: MySQL User Group Subject: RE: Backup table structure, not data I ended up

RE: Backup table structure, not data

PROTECTED] Sent: 18 February 2008 11:24 To: Esbach, Brandon Cc: MySQL User Group Subject: Re: Backup table structure, not data > Is there any way to backup a complete database structure > (tables/fields/indexes/etc), without the data? Or even get a creation > script per table? > >

Re: Backup table structure, not data

Is there any way to backup a complete database structure (tables/fields/indexes/etc), without the data? Or even get a creation script per table? At present the only way I can think of is to restore a backup to another server and just delete records (a legacy database with data hitting over 12GB,

Re: Backup table structure, not data

# mysqldump --help look for the flag --no-data Ben Esbach, Brandon wrote: Is there any way to backup a complete database structure (tables/fields/indexes/etc), without the data? Or even get a creation script per table? At present the only way I can think of is to restore a backup to anothe

Backup table structure, not data

Is there any way to backup a complete database structure (tables/fields/indexes/etc), without the data? Or even get a creation script per table? At present the only way I can think of is to restore a backup to another server and just delete records (a legacy database with data hitting over 12GB,

Re: Seeing Table Structure

If you have MySQL5 you can show table structure via the 'information_schema' pseudo-database. This has the advantage of dumping column data for all tables in one output table. In addition, you can select/sort the metadata using standard SQL: [EMAIL PROTECTED]> show tables from infor

Re: Seeing Table Structure

That works. Thanks. Tony -Original Message- From: Mogens Melander <[EMAIL PROTECTED]> To: Olaf Stein <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED]; MySql Sent: Mon, 23 Jul 2007 12:29 pm Subject: Re: Seeing Table Structure Try this: # mysqldump -d DBNAME > tables.sql --n

Re: Seeing Table Structure

Yes, please, email it to me. Tony -Original Message- From: Olaf Stein <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; MySql Sent: Mon, 23 Jul 2007 12:22 pm Subject: Re: Seeing Table Structure I don't know of any way of doing this for all tables. wrote a python script tha

Re: Seeing Table Structure

his for all tables. > I wrote a python script that creates a html file with information about > tables (engine, fields,keys,indices) > > If you are interested in it I can email it > > Olaf > > On 7/23/07 11:34 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrot

Re: Seeing Table Structure

rote: > Hi; > I need to see the table structure of all the tables of a database I have. I > could also just dump all the data from all the tables in the database and copy > the database, thus grabbing the table structures. I can´t find in the > documentation how to do either of

Seeing Table Structure

Hi; I need to see the table structure of all the tables of a database I have. I could also just dump all the data from all the tables in the database and copy the database, thus grabbing the table structures. I can´t find in the documentation how to do either of those. Please advise. TIA, Tony

Re: better table structure: 30 records in 2 column table or one record in 30 columns table

[EMAIL PROTECTED], hi, i'm created a 'configuration' table: create cofiguration ( config_key VARCHAR(25) NOT NULL PRIMARY KEY, config_value VARCHAR(255) NOT NULL ) ENGINE=MyISAM; I have about 30 records (store_name, store_owner, template_name, website_width, owner_address, prodcuts_per_page,..

better table structure: 30 records in 2 column table or one record in 30 columns table

hi, i'm created a 'configuration' table: create cofiguration ( config_key VARCHAR(25) NOT NULL PRIMARY KEY, config_value VARCHAR(255) NOT NULL ) ENGINE=MyISAM; I have about 30 records (store_name, store_owner, template_name, website_width, owner_address, prodcuts_per_page,..). now i wonder is m

Re: selecting data from 2 local DBs with same table structure

Thanks Peter, this should give me a head start. I will try it and mail again if I get stuck. Craig On 6/25/06, Peter Brawley <[EMAIL PROTECTED]> wrote: >I need the query to select the data from table1 on db1 and then select the >data from table1 on db2 and return a result of where if a field

Re: selecting data from 2 local DBs with same table structure

>I need the query to select the data from table1 on db1 and then select the >data from table1 on db2 and return a result of where if a field data value >is found in both tables that matches on name for example, it would count the >occurrences. Not entirely clear. Do you mean ... SELECT  

selecting data from 2 local DBs with same table structure

Hello List! Does anybody know how to select and build a result set from two or more databases with the same table structures that are on the same server. I need the query to select the data from table1 on db1 and then select the data from table1 on db2 and return a result of where if a field dat

Re: RESOLVED : exporting table structure/data in mysql?

ahhh... thanks. good to know. - philip On May 28, 2005, at 8:57 PM, Paul DuBois wrote: At 20:50 -0500 5/28/05, Philip George wrote: ya, i just meant when you go to the main table of contents page for the docs: http://dev.mysql.com/doc/mysql/en/index.html ... there's no mention of it.

Re: RESOLVED : exporting table structure/data in mysql?

At 20:50 -0500 5/28/05, Philip George wrote: ya, i just meant when you go to the main table of contents page for the docs: http://dev.mysql.com/doc/mysql/en/index.html ... there's no mention of it. there's SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION and SHOW CREATE VIEW, but no SHOW CREATE

Re: RESOLVED : exporting table structure/data in mysql?

ya, i just meant when you go to the main table of contents page for the docs: http://dev.mysql.com/doc/mysql/en/index.html ... there's no mention of it. there's SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION and SHOW CREATE VIEW, but no SHOW CREATE TABLE. - philip On May 28, 2005, at 8

Re: RESOLVED : exporting table structure/data in mysql?

At 20:26 -0500 5/28/05, Philip George wrote: this is what i was looking for: SHOW CREATE TABLE tablename; for some reason it isn't on the main doc page. - philip http://dev.mysql.com/doc/mysql/en/show-create-table.html On May 28, 2005, at 8:19 PM, Philip George wrote: what's the sql synt

Re: exporting table structure/data in mysql?

thanks. - philip On May 28, 2005, at 8:25 PM, Paul DuBois wrote: At 20:19 -0500 5/28/05, Philip George wrote: what's the sql syntax (in mysql) for exporting a table's structure and and data (the one that reiterates the original CREATE TABLE statement)? ..so that i'll end up with somethin

Re: RESOLVED : exporting table structure/data in mysql?

this is what i was looking for: SHOW CREATE TABLE tablename; for some reason it isn't on the main doc page. - philip On May 28, 2005, at 8:19 PM, Philip George wrote: what's the sql syntax (in mysql) for exporting a table's structure and and data (the one that reiterates the original CREAT

Re: exporting table structure/data in mysql?

At 20:19 -0500 5/28/05, Philip George wrote: what's the sql syntax (in mysql) for exporting a table's structure and and data (the one that reiterates the original CREATE TABLE statement)? ..so that i'll end up with something that can be put in a .sql script for later imports if needed. SHOW

exporting table structure/data in mysql?

what's the sql syntax (in mysql) for exporting a table's structure and and data (the one that reiterates the original CREATE TABLE statement)? ..so that i'll end up with something that can be put in a .sql script for later imports if needed. thanks. - philip -- MySQL General Mailing List F

Table structure not replicating

Hi, we're running 4.1.11 on two Debian woody machines and replication on the 'laterooms' database is working marvellously with the exception of altering table structure. If I execute an ALTER TABLE ... ADD... no error is generated, but the slave does not add the column. Of cour

RE: Database/Table Structure

Adam, Thanks much. Best wishes. Cheers. -Original Message- From: Adam [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 8:47 PM To: Ferguson, Michael; MySQL General Subject: Re: Database/Table Structure Michael, There are a bunch. I'll assume you have a Win32 client t

Re: Database/Table Structure

ate a graphical output of > thedatabase/table structure? FlowChart type? > > Thanks > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database/Table Structure

G'Day All, Can anyone recommend an application that will read/probe a MySQL database on a Linux server and generate a graphical output of thedatabase/table structure? FlowChart type? Thanks

Re: help with table structure

Also International Numbers Have you seen any address books accomodating 3 digit Country Code?? Martin- - Original Message - From: <[EMAIL PROTECTED]> To: "Chris W. Parker" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 12, 2004 1:20 PM

RE: help with table structure

You were wondering about a separate phone number table? Most phone numbers (esp. cell phones and home phones) belong to only one person. If that were your only data, then creating a new table may not make sense. However, dozens of people can share a common number (like in a large office. Each p

Re: help with table structure

Chris W. Parker wrote: interesting you say that because i was going to do this same thing except not as completely as i probably should (which i think is what you are suggesting). what i mean is, my extra table of addresses was going to be merely shipping addresses for the customer and nothing else

RE: help with table structure

Justin Smith on Tuesday, October 12, 2004 8:48 AM said: > What you have so far looks good, but what I learned from doing my > ecomm project was that it is beneficial to make a separate table for > anything and everything that you might have more than one of... > Add

Re: help with table structure

What you have so far looks good, but what I learned from doing my ecomm project was that it is beneficial to make a separate table for anything and everything that you might have more than one of... Addresses, phone numbers, and email addresses are all great candidates for breaking out into an

help with table structure

hello, i'm just looking for some examples of a customer table that some of you are using for your ecomm sites (or any site that would need a "customer" table). here is mine so far: (horrible wrapping to follow...) mysql> describe customers; ++-+--+-+-

RE: Best table structure

re in the table. -JF > -Original Message- > From: Tom Chubb [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 30, 2004 5:27 AM > To: [EMAIL PROTECTED] > Subject: Best table structure > > Please can someone let me know their opinion on the following. > I am new to

Re: Best table structure

o.uk>cc: Fax to: 06/30/2004 08:26 Subject: Best table structure

R: Best table structure

> Would I be better keeping this format and inserting multiple rows on each > submit, or to have one row for all 81 variables ($name, 20 x > Position, 20 x > Artists, 20 x Titles, 20 x Labels.) > I know that the latter will be easier to query. Are you sure? Why? > Also, without maintenance, the

Re: Best table structure

Hello Tom, Wednesday, June 30, 2004, 1:26:52 PM, you wrote: TC> My question is this: TC> Would I be better keeping this format and inserting multiple rows on each TC> submit, or to have one row for all 81 variables ($name, 20 x Position, 20 x TC> Artists, 20 x Titles, 20 x Labels.) TC> I know tha

Best table structure

Please can someone let me know their opinion on the following. I am new to MySQL and can't seem to find the right info anywhere. I have written some code for submitting a top 20 music chart online. I use the following to insert into mysql: INSERT INTO chart (name, chartpos, artist, title, label)

Re: error with loading table structure and data from a script file

scriptfile.sql; > This way I managed to load my table structure and my data. Is the first command > obsolete in mySQL ver 4.1.18? mysql -u root -p databasename < some_file.sql is not the command of mysql client. You should run it from the command line. For example, if MySQL dir is C:

Re: error with loading table structure and data from a script file

b <[EMAIL PROTECTED]> wrote: > > Hi, > > I'm using mySQL 4.1.18 on Windows XP pro. I tried this syntax and I received error. > > mysql -u root -p databasename > What is the right syntax for this. > > I managed to unpack my table structure from t

error with loading table structure and data from a script file

Hi, I'm using mySQL 4.1.18 on Windows XP pro. I tried this syntax and I received error. mysql -u root -p databasename

RE: Batch table structure update tool

MAIL PROTECTED] Subject: Batch table structure update tool Hi I'm looking for a tool (program, library), which given a file describing the structure of the tables in a database, could update the structure of those tables, i.e. create new table, add fields and change field size. Such a tool

Batch table structure update tool

Hi I'm looking for a tool (program, library), which given a file describing the structure of the tables in a database, could update the structure of those tables, i.e. create new table, add fields and change field size. Such a tool (especially as a dll library) would be very useful because i

Can table structure cause table corruption?

Y (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # -------- # # Table structure for table `Audios` # CREATE TABLE `Audios` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(50) NOT NULL default '', `Desc` text NOT NULL, P

Re: selecting table structure

> Is there a way to select/query the table structure and get a recordset > with the results? > Something like: > "Id", int, not null, autoincrement > name, varchar(20), not null SHOW COLUMNS FROM or even DESCRIBE These commands return recordsets exatly line SEL

Re: selecting table structure

> Is there a way to select/query the table structure and get a recordset > with the results? > Something like: > "Id", int, not null, autoincrement > name, varchar(20), not null DESC table_name Chris -- MySQL General Mailing List For list archives: http://lists.mysql

SV: selecting table structure

gt meddelande- > Från: Gjoko Jovanovski [mailto:[EMAIL PROTECTED] > Skickat: den 22 oktober 2003 15:10 > Till: [EMAIL PROTECTED] > Ämne: selecting table structure > > > Is there a way to select/query the table structure and get a > recordset with the results? S

selecting table structure

Is there a way to select/query the table structure and get a recordset with the results? Something like: "Id", int, not null, autoincrement name, varchar(20), not null Thanks, Gjoko. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Seeking advice on best table structure

* Rajesh Kumar > Roger Baklund unknowingly asked us: > > >>What would be a good way to deal with the following... No, I did not. Scott Haneda asked the question. I replied. :) And I recommended considering the SET column. > But for a couple of reasons, SET is not recommend. > > 1. It introduces f

Re: Seeking advice on best table structure

Roger Baklund unknowingly asked us: What would be a good way to deal with the following... I have a form that has 5 checkboxes on it, lets say the checkboxes are for categories, and more than one can be selected. For example: please tell is what brochure you want [] car [] boat [] truck [] SUV []

Re: Seeking advice on best table structure

* Scott Haneda > What would be a good way to deal with the following... > > I have a form that has 5 checkboxes on it, lets say the > checkboxes are for categories, and more than one can be > selected. > > For example: > please tell is what brochure you want > [] car > [] boat > [] truck > [] SUV >

Re: Seeking advice on best table structure

At 03:30 PM 8/20/2003 -0700, Scott Haneda wrote: What would be a good way to deal with the following... I have a form that has 5 checkboxes on it, lets say the checkboxes are for categories, and more than one can be selected. For example: please tell is what brochure you want [] car [] boat [] tru

Seeking advice on best table structure

What would be a good way to deal with the following... I have a form that has 5 checkboxes on it, lets say the checkboxes are for categories, and more than one can be selected. For example: please tell is what brochure you want [] car [] boat [] truck [] SUV [] beetle I have been asked to provid

Re: Reading table structure and data from sql file.

Thanks Nils Binay - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Binay Agarwal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 12:24 PM Subject: Re: Reading table structure and data from sql file. &

Re: Reading table structure and data from sql file.

Hi everybody, > >I have backed(backup.sql) up one Mysql database which contains 10 > tables using mysqldump. > > Now I want to read just one table structure and it's data from backup.sql > to another database. How do i achieve it. > > I have tried "mysql d

Re: Reading table structure and data from sql file.

t; From: "Nils Valentin" <[EMAIL PROTECTED]> > To: "Binay Agarwal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, August 13, 2003 11:59 AM > Subject: Re: Reading table structure and data from sql file. > > > Hi Binary, > > >

Reading table structure and data from sql file.

Hi everybody, I have backed(backup.sql) up one Mysql database which contains 10 tables using mysqldump. Now I want to read just one table structure and it's data from backup.sql to another database. How do i achieve it. I have tried "mysql databasename < backup.sql

Re: Reading table structure and data from sql file.

t; <[EMAIL PROTECTED]> To: "Binay Agarwal" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 11:59 AM Subject: Re: Reading table structure and data from sql file. > Hi Binary, > > You could either make a new backup of only the table (see

Re: Security related! Not possible to hide table structure. I couldn't find..... ?

what is so bad at seeing the table structure? i mean to work with the table, you need to know the fields and their types to avoid syntax errors. and what should happen on a SELECT * FROM...? do you want to see nothing, because it would let the user know about the structure, or all fields, as

RE: Security related! Not possible to hide table structure. I couldn't find..... ?

If you give access rights to a user on a DB, he will always be able to see the table structure. This is how it is implemented in MySQL (which does not mean that I like this). Cheers /rudy -Original Message- From: QWERTY [mailto:[EMAIL PROTECTED] Sent: maandag 4 augustus 2003 14

Security related! Not possible to hide table structure. I couldn't find..... ?

. and you did not assign any other permission to USER1.   Now everything is OK! USER1 can only select FIELD1 and FIELD4, and can not see data or change or etc.. to FIELD2 or FIELD3..   So we think that everything is OK! But, USER1 is still able to see the table structure of TABLE1. He see fields

Re: How to export db or table structure?

On 26-Jul-2003 Priscilla Walther wrote: > > We have a very large MySQL database, and the designer of the database no > longer works for us. I need to re-create the same table structure, but > without the content, on a separate machine. > > Is there some kind of export

Re: How to export db or table structure?

Sent: Friday, July 25, 2003 9:42 PM Subject: Re: How to export db or table structure? > mysqldump --opt > > -Jackson > > > On Friday 25 July 2003 10:39, Jim McAtee wrote: > > > We have a very large MySQL database, and the designer of the database no > > >

RE: How to export db or table structure?

> Sent: Friday, July 25, 2003 11:39 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: How to export db or table structure? > > > > We have a very large MySQL database, and the designer of > the database no > > longer works for us. I need to re-create the same ta

Re: How to export db or table structure?

mysqldump --opt -Jackson On Friday 25 July 2003 10:39, Jim McAtee wrote: > > We have a very large MySQL database, and the designer of the database no > > longer works for us. I need to re-create the same table structure, but > > without the content, on a separate machine. &g

Re: How to export db or table structure?

> We have a very large MySQL database, and the designer of the database no > longer works for us. I need to re-create the same table structure, but > without the content, on a separate machine. > > I know I can do a show tables on the existing db, and also a describe on > those

How to export db or table structure?

Hi All - I'm a newbie to the database area, but have inherited a MySQL database to manage along with my development duties. We have a very large MySQL database, and the designer of the database no longer works for us. I need to re-create the same table structure, but without the content,

Re: oscom table structure

ase included in the > milestone releases. it's in the top directory named > tep_database_2.2CVS.pdf or something like that. > > olinux > > --- Andrew <[EMAIL PROTECTED]> wrote: > > Thanks Nils, I will just add a little to the > > original question, I am familar

RE: oscom table structure

CTED] > >Sent: 19 July 2003 01:25 > >To: [EMAIL PROTECTED]; MySQL-Lista > >Subject: Re: oscom table structure > > > > > >Hi Andrew, > > > > > >Unfortunately I am not, but I figured that it would > probbaly take only 30-60 > >minutes to get th

RE: oscom table structure

y 2003 09:51 >To: Nils Valentin; [EMAIL PROTECTED]; MySQL-Lista >Subject: RE: oscom table structure > > >Thanks Nils, I will just add a little to the original question, I am >familar with the table structure in that I have access to the tables >ect. I have even installed a fe

RE: oscom table structure

Thanks Nils, I will just add a little to the original question, I am familar with the table structure in that I have access to the tables ect. I have even installed a few versions of osc ;) I am asking if anyone has gone beyond looking at .sql and actually worrking out how all the tables

Re: oscom table structure

/Japan 2003年 7月 19日 土曜日 01:24、Andrew さんは書きました: > are there any of you guys really familar with the mysql table structure of > oscommerce and in particular the search queries? > > Andrew -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp

oscom table structure

are there any of you guys really familar with the mysql table structure of oscommerce and in particular the search queries? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Security question: Possible to hide table structure? I couldn't find...

. and you did not assign any other permission to USER1.   Now everything is OK! USER1 can only select FIELD1 and FIELD4, and can not see data or change or etc.. to FIELD2 or FIELD3..   So we think that everything is OK! But, USER1 is still able to see the table structure of TABLE1. He see fields

Validate Table Structure With XML Structure

I have created tables in a MySQL Database for importing data from an XML file. My aim is to have MySQL table structures that correspond accurately with the XML structure. What are the available ways to validate the two structures or create the first structure from the second? Also: From a proper

  1   2   >