Forum for Table Spaces http://forums.mysql.com/list.php?134 Sat, 18 May 2013 10:52:45 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?134,586685,586685#msg-586685 http://forums.mysql.com/read.php?134,586685,586685#msg-586685
I'm wondering, where the difference between theoretical und real storage is coming from:

For example: I have one table with only one row.
The table has one integer-attribute (primary key) and ten VarChar(45) Attributes.
In theoretical the size needed for the table would be the size of the integer and the size of the ten VarChar(45), as there is only one row.
This would be: 4 Byte + 10 * (45Byte + 1 Byte) = 464 Bytes

(The one extra Byte per VarChar is explained in the MySQL Reference about Data Types)

If I run the following query, it says, that the size of the table is 466 Bytes:
SELECT table_name AS 'Table', data_length 'Size' FROM information_schema.TABLES WHERE table_schema = 'inheritance' AND table_name = 'testtable'

Does anyone know, where the two extra Bytes are coming from?

I think this could be Meta-Data, the two Bytes could be pointers to the beginning of the row.
Is there a reference about this?

Thanks for your help]]> Leo Kotschenreuther Table Space Sat, 18 May 2013 09:38:28 +0000 http://forums.mysql.com/read.php?134,583150,583150#msg-583150 http://forums.mysql.com/read.php?134,583150,583150#msg-583150 I am new to MySql. Please help me out to solve this query.

I need to combine two columns of data and insert in new column

I have two columns -
col1 col2
1 2
6 3
8 1
9 6

Now I need the table to look like below -

col1 col2 col3
1 2 12
6 3 63
8 1 81
9 6 96]]> Harshada Thakur Table Space Sat, 06 Apr 2013 04:20:36 +0000 http://forums.mysql.com/read.php?134,578419,578419#msg-578419 http://forums.mysql.com/read.php?134,578419,578419#msg-578419
I want to have these database under two different schema or databases, test1 and test2.

So that both test1 and test2 database has three databases each:

test1.db1, test1.db2 and test1.db3 AND

test2.db1, test2.db2 and test3.db3

This was done using tablespace in Oracle.

How can I do this in MySQL?

Need help..]]> Akash Gupta Table Space Tue, 05 Feb 2013 03:48:20 +0000 http://forums.mysql.com/read.php?134,573646,573646#msg-573646 http://forums.mysql.com/read.php?134,573646,573646#msg-573646 http://phpeasystep.com/phptu/12.html

I have a primary key set w/auto increment on the 'create' table but am unsure how to set up the second table. I need referential integrity but don't know that I NEED a primary key on the second table (which is for answers).

Any thoughts on how I should set the second table key(s) through PHPmyAdmin ???

TIA]]> hris verland Table Space Fri, 16 Nov 2012 02:06:18 +0000 http://forums.mysql.com/read.php?134,568815,568815#msg-568815 http://forums.mysql.com/read.php?134,568815,568815#msg-568815 Jorge Mendez Table Space Fri, 21 Sep 2012 03:41:35 +0000 http://forums.mysql.com/read.php?134,557940,557940#msg-557940 http://forums.mysql.com/read.php?134,557940,557940#msg-557940
we are facing a problem concerning the undo space. We have a large table using a tablespace. When we are deleting entries from the table which uses the tablespace, the undo space is growing until we get:

SQL Error: 1297, SQLState: HY000
Got temporary error 1501 'Out of undo space' from NDBCLUSTER

We are creating the LOGFILE GROUP with the following statements:

CREATE LOGFILE GROUP LG_CMN_FREE
ADD UNDOFILE 'undo_cmn_free_1.dat'
INITIAL_SIZE 256M
UNDO_BUFFER_SIZE 100M
ENGINE NDB;

ALTER LOGFILE GROUP LG_CMN_FREE
ADD UNDOFILE 'undo_cmn_free_2.dat'
INITIAL_SIZE 256M
ENGINE NDB;


The tablespace is generated with these staments:

CREATE TABLESPACE ts_cmn_free
ADD DATAFILE 'data_cmn_free_1.dat'
USE LOGFILE GROUP LG_CMN_FREE
EXTENT_SIZE = 32M
INITIAL_SIZE = 16G
ENGINE NDB;

ALTER TABLESPACE ts_cmn_free
ADD DATAFILE 'data_cmn_free_2.dat'
INITIAL_SIZE = 16G
ENGINE NDB;

ALTER TABLESPACE ts_cmn_free
ADD DATAFILE 'data_cmn_free_3.dat'
INITIAL_SIZE = 16G
ENGINE NDB;

ALTER TABLESPACE ts_cmn_free
ADD DATAFILE 'data_cmn_free_4.dat'
INITIAL_SIZE = 16G
ENGINE NDB;


Finally we do the following to use the generated tablespace:

ALTER TABLE `MeasurementData` TABLESPACE ts_cmn_free STORAGE DISK ENGINE NDBCLUSTER;


We thought, when deleting data from the table which uses the tablespace the used undo space must also shrink. But the undo space is growing until we get the described error.

Can somebody help?

Thx]]> Georg Kompacher Table Space Wed, 20 Jun 2012 01:59:54 +0000 http://forums.mysql.com/read.php?134,537050,537050#msg-537050 http://forums.mysql.com/read.php?134,537050,537050#msg-537050 SHOW TABLES FROM mydb WHERE COLUMN_NAME = "my column"
?]]> Phillip Harris Table Space Sun, 20 May 2012 14:57:56 +0000 http://forums.mysql.com/read.php?134,526092,526092#msg-526092 http://forums.mysql.com/read.php?134,526092,526092#msg-526092 SELECT user.name, SUM(pts) as total_points FROM points INNER JOIN user ON (points.knytroID = user.id) GROUP BY knytroID ORDER BY total_points DESC;

I would like to have a second column order by which 'knytroID' got the total_points value first. If I remove DESC from the statement, I preserve the order of which ID gets the points first because each entry in points is depentand upon time. However, when I add DESC, is seems to reverse the table before calculating SUM and changes the order.]]> Milton Griggs Table Space Fri, 20 Apr 2012 04:52:54 +0000 http://forums.mysql.com/read.php?134,520660,520660#msg-520660 http://forums.mysql.com/read.php?134,520660,520660#msg-520660 and if Colum1 is diferent than colum2 , delete the record

it's possible? thanks! and sorry for my english :(]]> federico chel Table Space Thu, 22 Mar 2012 17:12:36 +0000 http://forums.mysql.com/read.php?134,504855,504855#msg-504855 http://forums.mysql.com/read.php?134,504855,504855#msg-504855
I have a table called clients, which is about 103,000 records, all text and numbers -- no binary or anything huge. Only about 3000 records are actually clients per se -- the rest are "potential clients". I inherited the DB from the last developer as an Access DB with two tables for this -- clients and marketing and there was code to synchronize changes to clients to the marketing table and vice versa. I have redesigned the DB (as MySQL) and felt it better to simply put them all in one table and have a tinyint(1) field to indicate whether they are real clients or marketing.

Was this a bad idea? Should I have created two tables and move records between them when marketing records become clients? It seems to me that the original design where there were duplicates between the tables goes against good practice. The business requirement that was specified by the client is that the two sets of data must remain in sync, otherwise I would recommend simply keeping them separate and not sweating the changes -- marketing is imprecise anyway, but it's not my call.

My design seemed fine until executing the following query:
SELECT id, name, address, city, state, zip, county, client, flag FROM clients WHERE id IN (SELECT client_id FROM contacts WHERE email LIKE '%test@abc.org%') ORDER BY name ASC
This query chokes the mysql server.

I was able to improve the response by adding the following condition to the WHERE clause and building an index on clients.client (the tinyint(1) field that determines whether record is a real client or not):
client=1
so the new query is:
SELECT id, name, address, city, state, zip, county, client, flag FROM clients WHERE id IN (SELECT client_id FROM contacts WHERE client=1 AND email LIKE '%test@abc.org%') ORDER BY name ASC

Now the query does return a result, but takes almost 10 seconds on my local test server. I fear that this could still be problematic, especially on web host's server.

Any help would be appreciated.

Thank you,

JP]]> JP Howlett Table Space Mon, 12 Dec 2011 18:15:27 +0000 http://forums.mysql.com/read.php?134,433030,433030#msg-433030 http://forums.mysql.com/read.php?134,433030,433030#msg-433030
I have two tables. First contains info about some tasks - task id , task due time, task description and id of user assigned to this task. Second table contains user info user id , user email, user name etc.

I want to display info from both tables and be able to sort the results by columns from both tables. What kind of join i need? Do I need some kind of group or union?

Please help.
Thanks in advance.]]> Łukasz Korona Table Space Wed, 07 Sep 2011 01:30:49 +0000 http://forums.mysql.com/read.php?134,432947,432947#msg-432947 http://forums.mysql.com/read.php?134,432947,432947#msg-432947
Can any one let me know Why this is happening ?]]> ragen sol Table Space Wed, 07 Sep 2011 01:31:34 +0000 http://forums.mysql.com/read.php?134,429646,429646#msg-429646 http://forums.mysql.com/read.php?134,429646,429646#msg-429646
This is what I see, when I do show variables like 'innodb_data_file_path';
ibdata1:300M;ibdata2:300M;ibdata3:300M;ibdata4:300M;ibdata5:300M;ibdata6:300M;ibdat73:300M;ibdata8:300M;ibdata9:300M;ibdata10:300M;ibdata11:300M;ibdata12:300M;ibdata13:300M;

So as per, 3.8G Tablespace is allocated, but to calculate, how much is used


Thanks,
katie]]> katie c Table Space Sun, 07 Aug 2011 18:25:51 +0000 http://forums.mysql.com/read.php?134,416817,416817#msg-416817 http://forums.mysql.com/read.php?134,416817,416817#msg-416817
i am using this syntax trying to create tabel on SSD Disk,
the statement completed successfully but i cant see the file under the data directory.
do i have to enable the file per table option first ?

statement :
"
create table NewTbl
like OldTbl; DATA DIRECTORY='/mntr/daily', INDEX DIRECTORY='/mntr/daily'
"

Thanks,

Cman.]]> Cman Pr Table Space Tue, 19 Apr 2011 03:12:37 +0000 http://forums.mysql.com/read.php?134,416313,416313#msg-416313 http://forums.mysql.com/read.php?134,416313,416313#msg-416313
So if :


1 2
2 4
3
4
5
____ ____
t1.col1 t2.col1


result will be is :
1
3
5
I want select statement to do that ???!!!
Any help would be greatly appreciated.
Thanks in advance.]]> selly M.Ail Table Space Sat, 16 Apr 2011 04:39:16 +0000 http://forums.mysql.com/read.php?134,414518,414518#msg-414518 http://forums.mysql.com/read.php?134,414518,414518#msg-414518
I have the follow table definition
( I need work mandatory with ENGINE=InnoDB due transactions control)

CREATE TABLE item (
idItem bigint(20) unsigned NOT NULL auto_increment,
idArticulo bigint(20) unsigned NOT NULL ,
texto varchar(40),
PRIMARY KEY (idItem,idArticulo)
)ENGINE=InnoDB;

consider idArticulo like the PK from a Master table
Therefore Articulo (Master Table, Father) and Item (Sub Master Table, child)

Here to fill with simple data

insert into item(idArticulo,texto)values(1,'one');
insert into item(idArticulo,texto)values(1,'two');
insert into item(idArticulo,texto)values(1,'three');

insert into item(idArticulo,texto)values(2,'one');
insert into item(idArticulo,texto)values(2,'two');
insert into item(idArticulo,texto)values(2,'three');

If I do the follow query, I get

mysql> select idarticulo,iditem,texto from item order by iditem,idarticulo;
+------------+--------+-------+
| idarticulo | iditem | texto |
+------------+--------+-------+
| 1 | 1 | one |
| 1 | 2 | two |
| 1 | 3 | three |
| 2 | 4 | one |
| 2 | 5 | two |
| 2 | 6 | three |
+------------+--------+-------+
6 rows in set (0.00 sec)

mysql>

Realize yourself that iditem is 1,2,3,4,5,6

I want some way, I dont care if is necessary edit the table, to get something like this (desired output) when I insert my items (child table)

+------------+--------+-------+
| idarticulo | iditem | texto |
+------------+--------+-------+
| 1 | 1 | one |
| 1 | 2 | two |
| 1 | 3 | three |
| 2 | 1 | one |
| 2 | 2 | two |
| 2 | 3 | three |
+------------+--------+-------+

Realize yourself that iditem is 1,2,3 and 1,2,3 according for each idarticulo

I mean, each Master table (for each PK) has
its own control from its childs (for its FK)

Please I need a way to work in this, I would have 3 buildings/local in different places on my city working in real time, I need strict control for this generation for the fields, I assume that MySQL latest versions perhaps would handle this situation

Thanks in advance]]> Dr Pompeii Table Space Tue, 05 Apr 2011 18:23:49 +0000 http://forums.mysql.com/read.php?134,397301,397301#msg-397301 http://forums.mysql.com/read.php?134,397301,397301#msg-397301

1. To create a composite key at the time of table creation -

CREATE TABLE table1
(key1 CHAR(#),
key2 CHAR(#),
key3 (CHAR(#),
PRIMARY KEY(key1, key2));

2. To create a composite key after-the-fact (no primary key specified when table created) -

ALTER TABLE (tablename)
ADD PRIMARY KEY(key1, key2);

I also tried...

ALTER TABLE (tablename)
ADD PRIMARY KEY(key1);
[and then ran it again for "key2"]

3. I tried not including the key1 and key2 attributes at the time of table creation, and instead using both of the two previous commands (not at the same time) to add the new attribute to the table along with its Primary Key status, as indicated in item 2 above.


All of these methods failed! I read that its definitely possible to do. So, I wonder if there's some bug or problem with my software version that doesn't allow composite keys to be created for some reason?. Has anyone got a clue what's wrong here, or how to fix the problem? I'm relatively new to MySQL.

Thanks!]]> Robert Walden Table Space Sun, 05 Dec 2010 19:22:04 +0000 http://forums.mysql.com/read.php?134,397263,397263#msg-397263 http://forums.mysql.com/read.php?134,397263,397263#msg-397263 The solution was using different column privileges.
Now in the config table there is one column for the actual value, one for the default value and one saying if this is a user-editable item. All users except the admin may only edit the "actual value" column. And a trigger resets the actual value before updating to the default value if the item is not user-editable, so that in effect normal users cannot edit protected rows. Normal users may only select and update unprotected rows, not delete and insert.
This amounts to having sort of table spaces where certain users can only access or update certain rows. I wonder if there is a more "natural" way to achieve this in MySQL.
The nice thing about this is that I can trust the users now with any sort of interface tools - command line, Navicat, Heidi, my app - without having fear of them ruining the configuration.]]> a b Table Space Sun, 05 Dec 2010 19:18:21 +0000 http://forums.mysql.com/read.php?134,396520,396520#msg-396520 http://forums.mysql.com/read.php?134,396520,396520#msg-396520
The thing is, when I try to create an index on a field of a string type, I sometimes get this error:

#1170 - BLOB/TEXT column '(...)' used in key specification without a key length

What's that? Is there any way to avoid it?]]> ?! ?! Table Space Mon, 29 Nov 2010 15:20:34 +0000 http://forums.mysql.com/read.php?134,396407,396407#msg-396407 http://forums.mysql.com/read.php?134,396407,396407#msg-396407
is a junction table necessary or we can do without it. Which one is better with or without.
these are all InnoDB tables

this is the master to all table

p_t_all(
slt__cd int primary key,
dy_code int foreign key,
slt_id int foreign key
)


Tables those are
t1(
ds_id int primary key,
slt_cd int foreign key,
dfc_id forign key,
)
.......
.......
.......

junctio table is

jt(
slt_cd int,
ds_id int,
tpf_id int,
tpf1_id int,
tpsb_id int,
tpspl_id,
primary key(slt_cd,ds_id,tpf_id,tpf1_id,tpsb_id,tpspl_id,)
)
engine= InnoDB;

Should I go for it or not?]]> ragen sol Table Space Mon, 29 Nov 2010 15:43:13 +0000 http://forums.mysql.com/read.php?134,384914,384914#msg-384914 http://forums.mysql.com/read.php?134,384914,384914#msg-384914
ie:
$sql="insert into my_1st_tbl (id, date, status)
$sql="insert into my_2nd_tbl (id, reason, amount)]]> Petro Smit Table Space Sat, 11 Sep 2010 18:59:09 +0000 http://forums.mysql.com/read.php?134,384108,384108#msg-384108 http://forums.mysql.com/read.php?134,384108,384108#msg-384108
I'm currently workin on a application for multiple users which uses mysql.
The application should be able to determine whether a client has the most recent version of the data in the application. Basically I want want to check if someone else committed updates and then download them.

Therefore I want to use the update_time value in the incormation_schema table. And compare it to the last time a client downloaded the data from the DB.

The problem is that the update_time field is not always set when I perform operations on the table. Does it only react to certain actions or is this some sort of bug?

Thanks for your help]]> Fabian Gampfer Table Space Tue, 07 Sep 2010 11:04:07 +0000 http://forums.mysql.com/read.php?134,380959,380959#msg-380959 http://forums.mysql.com/read.php?134,380959,380959#msg-380959 +---------+-------------+-----------+------+
| prod_id | prod_source | prod_type | flag |
+---------+-------------+-----------+------+
| 1 | USA | 2 | 0 |
| 2 | USA | 2 | 0 |
| 3 | USA | 2 | 0 |
| 4 | USA | 3 | 1 |
| 5 | USA | 4 | 1 |
| 6 | BRA | 1 | 1 |
| 7 | BRA | 2 | 1 |
+---------+-------------+-----------+------+



Required resulset
==================
+-----------+----------+
| prod_type | count(*) |
+-----------+----------+
| 2 | 3 |
| 3 | 0 |
| 4 | 0 |
+-----------+----------+


where condition
prod_source = USA
flag=0


but the resultset i'm getting is

+-----------+----------+
| prod_type | count(*) |
+-----------+----------+
| 2 | 3 |
+-----------+----------+


with the query SELECT prod_type ,count(*)
FROM products
WHERE prod_source='USA' and flag=0
GROUP by prod_type
ORDER by prod_type;


HOW do i get the resulset with count of all the prod_type's in USA ? It must display all the prod_type's in USA even if the count is 0 .






TABLE DEFINITION
===================

CREATE TABLE `products` (
`prod_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`prod_source` VARCHAR(45) NOT NULL,
`prod_type` INTEGER UNSIGNED NOT NULL,
`flag` INTEGER UNSIGNED NOT NULL,
PRIMARY KEY (`prod_id`)
)
ENGINE = InnoDB;


DATA INSERTION
===============

INSERT INTO `products` VALUES (1,'USA',2,0),(2,'USA',2,0),(3,'USA',2,0),(4,'USA',3,1),(5,'USA',4,1),(6,'BRA',1,1),(7,'BRA',2,1);]]> ajoe joseph Table Space Tue, 07 Sep 2010 12:18:09 +0000 http://forums.mysql.com/read.php?134,378027,378027#msg-378027 http://forums.mysql.com/read.php?134,378027,378027#msg-378027 I’m trying to insert and display an art gallery on a web page from my mysql DB. I would like the user to check the art they would like, using the (check box and submit button that would be available) have it post and be entered into my DB as an order. How do I insert the art into the DB and retrieve it to fill the order. This is a ColdFusion page. And yes, I am new to all this. Thanks so much :)]]> lee Green Table Space Tue, 07 Sep 2010 11:47:51 +0000 http://forums.mysql.com/read.php?134,377348,377348#msg-377348 http://forums.mysql.com/read.php?134,377348,377348#msg-377348
Basically the site is about casting for a show in which Casting company will generate show and the users would apply for the show.
I made one table called 'shows' which stores all the basic details for show(e,g name,description,date,image).
Now i have to develope one module which generates questions dynamically for the registration form of the show which users would fill up at the time of registration.

Currently i have two choice.

1.Either i can make a new table for every show and store the answer of the users.

Table Schema:show_1(Table name)

id
user_id
question_1
question_2
question_3

show_2(Table name)

id
user_id
question_4
question_5
question_6

2.I store the answers by concating them to make one string and then store it into
the 'user_show_mapping' table.

Could anyone suggest me which is the best option to choose and why?

Is there any performance issue exist with the more number of tables in the database?]]> Saumil Shah Table Space Tue, 07 Sep 2010 11:58:06 +0000 http://forums.mysql.com/read.php?134,374891,374891#msg-374891 http://forums.mysql.com/read.php?134,374891,374891#msg-374891 Ward Ricker Table Space Wed, 07 Jul 2010 21:03:39 +0000 http://forums.mysql.com/read.php?134,374342,374342#msg-374342 http://forums.mysql.com/read.php?134,374342,374342#msg-374342
I have a table with date coloumn and an amount column. I am storing the extracted amount in the amount column i.e the outstanding amount.

i need to fetch the last date value of every month, can any one help on this?]]> Raj Shekar Table Space Tue, 06 Jul 2010 15:02:44 +0000 http://forums.mysql.com/read.php?134,373281,373281#msg-373281 http://forums.mysql.com/read.php?134,373281,373281#msg-373281
Basically I am a Oracle DBA and new in MySQL DBA job. I am facing prblem as follows:-

When I am trying to check the metadata about the files of MySQL from table FILES.INFORMATION_SCHEMA, It is showing no rows.

-----------------------------------------------
mysql> use information_schema
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select count(*) from files;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)

mysql>
mysql>
-----------------------------------------------

Can some please help me, why it is happening...

Thanks
-Naveen]]> Naveen Gangil Table Space Tue, 07 Sep 2010 04:51:52 +0000 http://forums.mysql.com/read.php?134,370837,370837#msg-370837 http://forums.mysql.com/read.php?134,370837,370837#msg-370837
I have a strange issue with one query:

UPDATE aur_Projects set Status='Completed' WHERE ProjectId='1750';

as you can see....maybe the simplest query on the planet! the problem is that the query is setting to 0 another field (and only this one):

select ID_TEAM from aur_Projects where ProjectId='1750';

result:
ID_TEAM = 0


I've tested this from the shell command, it is not related to anything else I wrote!!

I've tried copying the table, rename it to aur_Projects2 and the issue dissapear!

This is the table:

CREATE TABLE IF NOT EXISTS `aur_Projects` (
`ProjectId` int(11) NOT NULL auto_increment,
`ProjectNumber` varchar(100) NOT NULL,
`DateCreated` datetime NOT NULL,
`Description` text,
`Status` varchar(100) NOT NULL,
`IsActive` enum('no','yes') NOT NULL default 'yes',
`ProjectNumber` varchar(100) default NULL,
`BidId` int(10) NOT NULL,
`RegisteredDate` date NOT NULL,
`EndDate` date default NULL,
`ContactId` int(11) NOT NULL,
`ID_WORKGROUP` int(11) NOT NULL,
`ID_LOCATION` int(11) NOT NULL,
`PATH_FOLDER` varchar(100) NOT NULL,
`archive_id_location` int(11) NOT NULL,
`archive_tape_id` varchar(500) NOT NULL,
`ID_TEAM` int(11) NOT NULL,
PRIMARY KEY (`ProjectId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2058 ;

any idea?]]> Luca Rondanini Table Space Tue, 07 Sep 2010 12:23:25 +0000 http://forums.mysql.com/read.php?134,363880,363880#msg-363880 http://forums.mysql.com/read.php?134,363880,363880#msg-363880
I have the follow table definition

CREATE TABLE item (
idItem bigint(20) unsigned NOT NULL auto_increment,
idArticulo bigint(20) unsigned NOT NULL ,
texto varchar(40),
PRIMARY KEY (idItem,idArticulo)
)ENGINE=InnoDB;

consider idArticulo like the PK from a Master table
Therefore Articulo (Master Table, Father) and Item (Sub Master Table, child)

Here to fill with simple data

insert into item(idArticulo,texto)values(1,'one');
insert into item(idArticulo,texto)values(1,'two');
insert into item(idArticulo,texto)values(1,'three');

insert into item(idArticulo,texto)values(2,'one');
insert into item(idArticulo,texto)values(2,'two');
insert into item(idArticulo,texto)values(2,'three');

If I do the follow query, I get

mysql> select idarticulo,iditem,texto from item order by iditem,idarticulo;
+------------+--------+-------+
| idarticulo | iditem | texto |
+------------+--------+-------+
| 1 | 1 | one |
| 1 | 2 | two |
| 1 | 3 | three |
| 2 | 4 | one |
| 2 | 5 | two |
| 2 | 6 | three |
+------------+--------+-------+
6 rows in set (0.00 sec)

mysql>

I want some way, if is necessary edit the table no problem, to get something like this (desired output)

+------------+--------+-------+
| idarticulo | iditem | texto |
+------------+--------+-------+
| 1 | 1 | one |
| 1 | 2 | two |
| 1 | 3 | three |
| 2 | 1 | one |
| 2 | 2 | two |
| 2 | 3 | three |
+------------+--------+-------+

I mean, each Master table has its own control from its childs
I need this solution to apply too for warehouse documentation control, something like

+------------+------------------+-------+
| series | warehouse-number | type |
+------------+------------------+-------+
| 1 | 1 | in |
| 1 | 2 | out |
| 1 | 3 | in |
| 2 | 1 | out |
| 2 | 2 | out |
| 2 | 3 | out |
+------------+------------------+-------+

Thanks in advanced for your guidance]]> Dr Pompeii Table Space Sun, 09 May 2010 05:19:22 +0000