Merge-table Question

Hello, I remember some activity regarding some flakiness when using merge-tables. I searched out and reviewed this: http://bugs.mysql.com/bug.php?id=26881 Using 5.0.51a on RHEL 4 box, I'm still seeing similar issues. The INFORMATION_SCHEMA shows the merge table as follows TABLE_CATALOG: NUL

Re: Lookup Table Question...

Mark, can you provide a sample of a query you're currently using to retrieve data from this table / joining on this table? Also, how big is this table? It may not be worth your time to change things around as this is a very simple structure and should remain speedy even if it grows pretty large.

Lookup Table Question...

hello all this is my first post...I haven't been able to find a way to half my table size through a primary key relationship that can exist once. If I want to relate "person1 (id = 4)" to "person2 (id = 1)" I have have had good success with the following table below. However, if i

Re: null data in table question

Hi, don't forget to apply the correct changes to your queries. Having NULLs or not, let you write for example : select ... from ... where midinials is NULL; And be aware about NULL indexation in some storages. Those values are not indexed for example in oracle. I'm not sure about innodb, but thi

Re: null data in table question

Hi Scott, > I have created a web-based simple application, and used mysql for data storage. All has worked well. But I do have a simple question I would like to ask the group. > > I have some web-based forms that match table structure. Most of the important fields have validation, and I ensure goo

Re: null data in table question

"Scott Purcell" <[EMAIL PROTECTED]> wrote on 07/05/2005 04:21:06 PM: > Hello, > > I have created a web-based simple application, and used mysql for > data storage. All has worked well. But I do have a simple question I > would like to ask the group. > > I have some web-based forms that match ta

null data in table question

Hello, I have created a web-based simple application, and used mysql for data storage. All has worked well. But I do have a simple question I would like to ask the group. I have some web-based forms that match table structure. Most of the important fields have validation, and I ensure good dat

RE: MERGE Table Question

ject: Re: MERGE Table Question At 09:00 AM 6/10/2005, you wrote: >Hello everyone, > We're going to be using the "MERGE TABLE" option of Mysql when we > build our Data Warehouse. Basically (for you Oracle folks), we're going > to mimic PARTITIONS. My question

Re: MERGE Table Question

At 09:00 AM 6/10/2005, you wrote: Hello everyone, We're going to be using the "MERGE TABLE" option of Mysql when we build our Data Warehouse. Basically (for you Oracle folks), we're going to mimic PARTITIONS. My question is this: Other than dumping syntax through a utility and comparing te

MERGE Table Question

Hello everyone, We're going to be using the "MERGE TABLE" option of Mysql when we build our Data Warehouse. Basically (for you Oracle folks), we're going to mimic PARTITIONS. My question is this: Other than dumping syntax through a utility and comparing text, is there any way I can read the

Re: intermediate table question

I would first store your original query's results in a temp table: CREATE TEMPORARY TABLE tmpTracks SELECT AudioTrack.* FROM AudioTrack INNER JOIN AudioTracks_Categories ON AudioTrack.AudioTrack_id = AudioTracks_Categories.AudioTrack_id WHERE AudioTracks_Categories.Category_id IN (cat1,ca

intermediate table question

I have two tables, let's say AudioTrack and Category Every AudioTrack record can belong to one or more ( or none ) Categories. I have created an intermediate table, AudioTracks_ Categories containing only the IDs of AudioTrack and Category to keep track of the link. to find all tracks belonging

Re: Validation/Linking Table Question

al Message - From: "Bart Nessux" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 10, 2004 8:07 PM Subject: Re: Validation/Linking Table Question > Thanks Lou, I'll give this a go! > > > >From: "Lou Olsten" <[EMAIL PROTECTED]> > &

Re: Validation/Linking Table Question

t;[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 10, 2004 1:38 PM Subject: Validation/Linking Table Question > I have three tables in a MySQL DB... among others: > > 1. computers > 2. users > 3. comp_user_link > > This particular DB is used for inventory and

Validation/Linking Table Question

I have three tables in a MySQL DB... among others: 1. computers 2. users 3. comp_user_link This particular DB is used for inventory and tracking purposes. I think the table names are self explanatory. Computers has 'comp_id'... users has 'user_id' as their primary indexed keys. These keys are li

RE: Alter Table question

Alter table 'tablename' change column 'columnname' 'new-columnname' not null default 0 If you have any null values in that column, you will not be able to make the change. J.R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c

Alter Table question

This seems very basic to me but I can't find (though only really looked for a little bit) the syntax for issuing an alter table statement that will force a field to no longer allow NULL values. I have some fields in a MyISAM table of MySQL 3.23 and wish to require them to contain a value. What is

Re: backup table/restore table question

:20 AM Subject: Re: backup table/restore table question > I use mysqldump which generates sql for you and it > works like a charm. Eg, > > mysqldump --user=root databasename.table > output.sql > > The output.sql file then has SQL statements to > generate and exact copy. > &g

Re: backup table/restore table question

At 20:23 -0400 4/12/04, Andy B wrote: hi... i have a server where there are 5 tables inside a database. i was wondering if i did the following command from inside a script: backup table dbname.tablename to /home/users/my_dir/ then with a different script gzip/tar them, after gzipped ftp them to my

backup table/restore table question

hi... i have a server where there are 5 tables inside a database. i was wondering if i did the following command from inside a script: backup table dbname.tablename to /home/users/my_dir/ then with a different script gzip/tar them, after gzipped ftp them to my test server into say c:/db_backup/db_

Re: php temp table question

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael McTernan wrote: > Hi Larry, > > I was wondering a similar thing, but for JDBC using connection pooling. In > your example you say that 2 people will hit the script at the same time; if > they are using independent connections this should caus

Re: php temp table question

At 03:04 PM 10/27/2003, you wrote: Does anyone know whether the use of persistent connections with php will allow a temp table created by a script to linger around and cause a problem with the next execution of the script when it tries to create the temp table again? It won't. If the client looses

RE: php temp table question

age- > From: Larry Brown [mailto:[EMAIL PROTECTED] > Sent: 27 October 2003 21:44 > To: MySQL List > Subject: RE: php temp table question > > > Thanks, I got the answer from a php developer. In case anyone is > wondering, > according to him the table is dropped at the end

Re: php temp table question (for mysql)

Larry Brown wrote: Does anyone know whether the use of persistent connections with php will allow a temp table created by a script to linger around and cause a problem with the next execution of the script when it tries to create the temp table again? You are right. There is a simple workaround th

RE: php temp table question

, October 27, 2003 4:04 PM To: MySQL List Subject: php temp table question Does anyone know whether the use of persistent connections with php will allow a temp table created by a script to linger around and cause a problem with the next execution of the script when it tries to create the temp table

php temp table question (for mysql)

Does anyone know whether the use of persistent connections with php will allow a temp table created by a script to linger around and cause a problem with the next execution of the script when it tries to create the temp table again? Also if it does present a problem with the next script execution

php temp table question

Does anyone know whether the use of persistent connections with php will allow a temp table created by a script to linger around and cause a problem with the next execution of the script when it tries to create the temp table again? Also if it does present a problem with the next script execution

RE: Temporary table question

t: Re: Temporary table question Also, sometimes one needs to copy the content of a table in itself but earlier versions of MySQL don't support something like INSERT INTO some_table SELECT * FROM some_table /* the select table and insert tables are not different */ So, you may create a temporary tabl

Re: Temporary table question

From: "Nitin" <[EMAIL PROTECTED]> To: "Susan Ator" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 16:39 Subject: Re: Temporary table question > basically used to make queries easier running from within scripts. it could > be

Re: Temporary table question

version, which doesn't support union and for other functions you want to perform on some rows selected from multiple tables. Enjoy Nitin - Original Message - From: "Susan Ator" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 7:39

Temporary table question

I would like to know the circumstances in which a temporary table would be used. What is the rationale behind temporary tables? I have searched the manual and the 'net but only find out information about creating or manipulating them. Thanks, Susan -- MySQL General Mailing List For list archive

Re: Newbie Table question

Hi, - Original Message - From: "Eternal Designs, Inc" Sent: Saturday, August 30, 2003 9:46 PM Subject: Re: Newbie Table question > To copy table A to table B(non-existent) use this command: > > CREATE TABLE B SELECT * FROM A; > > Note. If your two tables are fro

Re: Newbie Table question

To copy table A to table B(non-existent) use this command: CREATE TABLE B SELECT * FROM A; Note. If your two tables are from different databases the syntax is still the same. For instance if table A is in database Da and table B is in database Db then use the MySQL command: CREATE TABLE Db.B S

Newbie Table question

Hi, How do you copy a table in mySQL. I know I can do it in phpMyAdmin but I want the actual syntax. Thanks!! Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PR

Re: Alter Table Question...

Of course, I'd figure it out right after sending this. For the interested: "alter table XYZ drop key foo;" Take care, --Noel - Original Message - Given an existing table with a field defined as: "foo" char(60) not null unique What would be the proper syntax for an ALTER TA

Alter Table Question...

Hi all, Hopefully a simple question for anyone who cares to take a swing at it: Given an existing table with a field defined as: "foo" char(60) not null unique What would be the proper syntax for an ALTER TABLE statement, to remove the unique constraint / key on this field? A "modify" doesn'

Duplicating a table question

These spam filters are really annoying. It's hard to get an answer to my question when my message gets bounced 'cause it doesn't have MySQL or query in the message. In any event, Is there a way to duplicate a complete table. I am making some modifications and don't want to use the working table

Re: Create child table question

Jannie, - Original Message - From: "Jannie Qu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:18 AM Subject: Create child table question > sql, query, mysql > > Hi, all, > I met a problem with creating the following

Re: Create child table question

t: Tuesday, October 29, 2002 10:18 AM Subject: Create child table question > sql, query, mysql > > Hi, all, > I met a problem with creating the following table: pub_user. > -- Parent table > CREATE TABLE pub_access_type( > access_type_id INT UNSIGNED NOT NULL, &g

Create child table question

sql, query, mysql Hi, all, I met a problem with creating the following table: pub_user. -- Parent table CREATE TABLE pub_access_type( access_type_id INT UNSIGNED NOT NULL, access_type_name VARCHAR(25), PRIMARY KEY(access_type_id) ) TYPE=INNODB; -- Child table CREATE TABLE pub_user( user_id INT UNS

Re: MyISAM and Lock table question

At 14:41 +0200 9/2/02, David Bordas wrote: >Hi all, > >Just a little question on the MyISAM table lock implementation ... >I just see ( with show full processlist ) that my version of mysql ( 3.23.45 >binary linux tar.gz ) locked my MyISAM table at every query and not only for >update / delete / i

MyISAM and Lock table question

Hi all, Just a little question on the MyISAM table lock implementation ... I just see ( with show full processlist ) that my version of mysql ( 3.23.45 binary linux tar.gz ) locked my MyISAM table at every query and not only for update / delete / insert. Why is it locking table for select query ?

RE: Mysql newbie show table question

* marc malacarme > I can¹t seem to make any of the describe or show queries work > when I apply a search statement: > Query=show table status from demo; > Works fine. Now I¹m trying to get info from only one table: > Query=show table status from demo where name like "user_access"; > Does no work.

Re: Mysql newbie show table question

Hrm. Closest I can think of is EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access'; I think this is what you mean. Adam Hooper [EMAIL PROTECTED] On Fri, 31 May 2002 08:44:49 -0700 marc malacarme <[EMAIL PROTECTED]> wrote: > I can¹t seem to make any of the describe or show queries work wh

Re: Mysql newbie show table question

marc, Friday, May 31, 2002, 6:39:54 PM, you wrote: mm> I can¹t seem to make any of the describe or show queries work when I apply a mm> search statement: mm> Query=show table status from demo; mm> Works fine. Now I¹m trying to get info from only one table: mm> Query=show table status from demo w

Re: Mysql newbie show table question

Hrm. Closest I can think of is EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access'; I think this is what you mean. Adam Hooper [EMAIL PROTECTED] On Fri, 31 May 2002 08:44:49 -0700 marc malacarme <[EMAIL PROTECTED]> wrote: > I can¹t seem to make any of the describe or show queries work wh

Mysql newbie show table question

I can¹t seem to make any of the describe or show queries work when I apply a search statement: Query=show table status from demo; Works fine. Now I¹m trying to get info from only one table: Query=show table status from demo where name like "user_access"; Does no work. Thank You

Mysql newbie show table question

I can¹t seem to make any of the describe or show queries work when I apply a search statement: Query=show table status from demo; Works fine. Now I¹m trying to get info from only one table: Query=show table status from demo where name like "user_access"; Does no work. Thank You

RE: Newbie table question

D] Subject: Newbie table question Hi, I have a newbie question, to which my mysql books didn't have an answer! It is: I have two tables with identical structures. I wish to copy the data from table B into (append) table A. What sql statement will achieve this please? kind regards,

RE: Newbie table question

To: [EMAIL PROTECTED] Subject: Newbie table question Hi, I have a newbie question, to which my mysql books didn't have an answer! It is: I have two tables with identical structures. I wish to copy the data from table B into (append) table A. What sql statement will achieve this please?

Newbie table question

Hi, I have a newbie question, to which my mysql books didn't have an answer! It is: I have two tables with identical structures. I wish to copy the data from table B into (append) table A. What sql statement will achieve this please? kind regards, Graham Nichols.

Re: Table Question.

Thank you much - I somewhat understand the query that you posted now. The problem that I'm dealing with NOW however is that it will only display results if there is a second level referree. I need to get results despite whether there are six levels or referrals, or only one. I added a third

Re: Table Question.

The queries will be a little complicated using a self join, but the table is simple should include: CUSTOMERID REFERRERID (Which is the CUSTOMERID of their referrer) CUSTOMERFIRSTNAME CUSTOMERLASTNAME ETC! The queries will then use a self join and table aliases to determine the commissions for

Table Question.

Hi, I just now signed up for this list a second ago and thought I'd say howdy to everyone. I'm not sure what the typical discussions are like on this list, so I'll go ahead and ask anyhow. If there is another list that would be better suited to this type of question, please let me know. A fr

ALTER TABLE question

however, I get the following message - Access denied for user: '[EMAIL PROTECTED]' to database 'chrisdb' The query used to add some fields to an already created table called "question" is as follows - ALTER TABLE question ADD NumberOfStaff VARCHAR (20) , ADD

SQL/Table question

How would I select all the tables _names_ in a particular database? Is it possible? i.e. Select table_names from tables; Thanks. Blessings, Mike Revelation 1:8 I am the Alpha and Omega, the Beginning and the Ending, says the Lord, who is and who was and who is to come, the Almighty. -- The

Re: ALTER TABLE question

ble called > "question" is as follows - > > ALTER TABLE question ADD NumberOfStaff VARCHAR (20) , ADD PortfolioProducts > TEXT , ADD PortfolioClients TEXT , ADD AdditionalInfo TEXT it appears that your isp needs to turn on 'alter_priv' permission for user '[

Re: SQL/Table question

M> How would I select all the tables _names_ in a particular database? Is it possible? M> i.e. Select table_names from tables; SHOW TABLES FROM database_name; or SHOW TABLES; -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)

RE: REPAIR TABLE question...

Hi, > The manual > > http://www.mysql.com/doc/R/E/REPAIR_TABLE.html > > mentions the QUICK and EXTENDED options for REPAIR TABLE. But it does > not say which is the default. Anyone know? I think the default might actually be neither. I think the two options correspond roughly to two options

REPAIR TABLE question...

The manual http://www.mysql.com/doc/R/E/REPAIR_TABLE.html mentions the QUICK and EXTENDED options for REPAIR TABLE. But it does not say which is the default. Anyone know? Thanks, Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (

Re: Deleting table question...

Thank you, I learned that I needed: Drop *table* tablename Thanks for your help, guys. I appreciate it Joel - Original Message - From: <[EMAIL PROTECTED]> To: Joel Holtzman <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, February 02, 2001 3:51 PM Subject:

Re: Deleting table question...

why don´t you try use database drop tablename Mensaje citado por: Joel Holtzman <[EMAIL PROTECTED]>: > Hello, via telnet with mysql server on linux, I try > to delete a table, but it won\'t work. I\'m browsing > the documentation, I can\'t see what will work. I can > do this via asp, but I\'d

Re: Deleting table question...

Joel Holtzman wrote: > > Hello, via telnet with mysql server on linux, I try to delete a table, but it won't >work. I'm browsing the documentation, I can't see what will work. I can do this via >asp, but I'd love to know the command for something that should be as simple as > > mysql> Delete (

Deleting table question...

Hello, via telnet with mysql server on linux, I try to delete a table, but it won't work. I'm browsing the documentation, I can't see what will work. I can do this via asp, but I'd love to know the command for something that should be as simple as mysql> Delete (tablename) from (Database name);