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
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
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
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
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 the record
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
Hi Jerry,
there's a (commercial
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
tables
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
indicator that your data is not normalized
-
From: Jerry Schwartz [EMAIL PROTECTED]
To: 'Martijn Tonies' [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Friday, August 08, 2008 8:44 PM
Subject: RE: Transplanting table structure changes
You might want to try our Schema Compare tool inside Database Workbench.
This tool also has a script
of table structure.
Thanks.
Velen
-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 columns to two tables in my development
environment, and now
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 a
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
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 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 PHPMyAdmin, so I
and with both the column.
Any suggestion.
Thanks
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,
Below is the user_delivery table structure.
CREATE TABLE
.
Thanks
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,
Below is the user_delivery table structure.
CREATE TABLE `user_delivery` (
`user_id` decimal(22,0
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
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
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 the MySQL
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_delivery_comp1
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_id` decimal(22,0) NOT NULL default '0',
`send_to_regulator` char
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_delivery_comp1` (`user_id
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_delivery_comp1` (`user_id
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,
# 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
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
]
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?
At present the only way I can
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
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
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
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] wrote:
Hi;
I need to see the table structure of all the tables
Yes, please, email it to me.
Tony
-Original Message-
From: Olaf Stein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; MySql mysql@lists.mysql.com
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
That works. Thanks.
Tony
-Original Message-
From: Mogens Melander [EMAIL PROTECTED]
To: Olaf Stein [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; MySql mysql@lists.mysql.com
Sent: Mon, 23 Jul 2007 12:29 pm
Subject: Re: Seeing Table Structure
Try this:
# mysqldump -d DBNAME tables.sql
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 information_schema
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
[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,
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
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
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
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
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.
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
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
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
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
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
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.
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 course then INSERTS
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
/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]
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 to use
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
Justin Smith mailto:[EMAIL PROTECTED]
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...
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
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
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
Subject: RE: 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;
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)
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 that
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 size
:
Fax to:
06/30/2004 08:26 Subject: Best table structure
AM
are 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 MySQL and can't seem to find the right
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 scriptfile.sql
What is the right syntax for this.
I managed to unpack my table structure from the same script into another machine on
Win2000 Server. However, I remember
;
\. 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:\mysql, you
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
be compared whether
they are files containing table definitions or existing databases, local or
remote.
Hope it's what you're looking for..
Cheers,
Andrew
-Original Message-
From: Pointer [mailto:[EMAIL PROTECTED]
Sent: Saturday 20 March 2004 10:28
To: [EMAIL PROTECTED]
Subject: Batch table
;
#
#
# 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,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=14
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 unsubscribe:http
-
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? Something like: Id, int, not
null, autoincrement name
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.com/mysql
To unsubscribe
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 table
or even
DESCRIBE table
These commands return recordsets exatly line SELECT commands.
Alec
* 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
[] beetle
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
* 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
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
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
[]
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 mysqldump
manual).
mysqldump --help
Or you edit the backup file you have directly and save it under
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 mysqldump
manual).
mysqldump --help
Or you edit
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 but it will populate
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 but it will populate the
databasename
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.
Hi Binary,
I see you want to use the original
.
and you did not assignany 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 which i
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
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
On 26-Jul-2003 Priscilla Walther wrote:
snipage
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 command
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
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 tables, so I know what
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.
I know I can do a show
, 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 table
structure, but
without the content
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.
I know I
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
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 few versions of osc ;)
I am asking
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 with the table
structure in that I have access to the tables ect.
I
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]
/Japan
2003 7 19 01:24Andrew :
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
Personal URL: http
.
and you did not assignany 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 which i
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
PROTECTED]
Sent: Thursday, April 03, 2003 12:37 AM
Subject: table structure design
is there any table structure design program in a graphical layout for
windows available ? i have tables and fields on paper but would like a way
to be able to lay them out on a screen and show which table joins to what
?) Great tool, expensive though.
=C=
- Original Message -
From: Daniel Rossi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 12:37 AM
Subject: table structure design
is there any table structure design program in a graphical layout for
windows available
1 - 100 of 138 matches
Mail list logo
