Re: Using Triggers to Maintain a Table to prevent complex join statements...

Cory Robin wrote: We have a statement that joins 8 different tables to pull multiple rows from each table. I have heard of people using triggers to create, update and delete records in a table based on statements in other tables. The obvious result of this would be to SPEED up results right

Re: Alter table - adding constraints?

Chris White wrote: Jay Paulson wrote: 2) both tables have data in them. This is most likely your issue then, depending on the table size, go through and make sure that anything in the referenced column matches the referencing column. You should also be able to use SHOW INNODB STATUS to s

Re: unauthenticated user

Would it be possible to prevent reverse lookup? Im using the latest GA version.. thanks, On Wednesday 21 February 2007 23:12, Nils Meyer wrote: > Hi JM, > > JM wrote: > > i got this results from "show processlist" > > > > | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect

My.cnf and my.ini

I¹m running MAMP (www.mamp.info) on my Mac OSX box as a local way of developing. I¹m running into a slight problem that the mamp site doesn¹t talk about. The 1.5 beta1 seems to have the option ‹skip-innodb enabled and I can¹t seem to find out where this is located to disable it and enable the use

Re: Retrieving foreign keys and references

On Wednesday 21 February 2007 17:51, Paul McCullagh wrote: > Hi Tim, Hello Paul > Foreign key definitions are parsed but ignored by MyISAM tables. Understood. Thanks > Try InnoDB or PBXT (http://www.primebase.com/xt) :) for the time being, I'm going to stick with MyISAM. I've got a possible solu

Re: MySQL Daylight Savings Time Patch

Yes they are; and 22 >= 3 - Original Message - From: "Jerry Schwartz" <[EMAIL PROTECTED]> To: "'Bryan S. Katz'" <[EMAIL PROTECTED]>; Sent: Wednesday, February 21, 2007 10:30 AM Subject: RE: MySQL Daylight Savings Time Patch > Aren't the time zone tables new in 4.1.3? > > Regards, > > J

Re: row count inconsistency

At 10:34 AM -0600 2/21/07, Gerald L. Clark wrote: Marty Landman wrote: The table was created and then loaded and not modified in any way I'm aware of afterwards. It's on a local, only accessible by me server. Really weird thing about it is that I wrote/ran a program specifically to find any gap

Re: Retrieving foreign keys and references

On Wednesday 21 February 2007 17:43, Rolando Edwards wrote: > SHOW INDEXES FROM `providers`; > > By the way, what version of MySQL are you using ??? 4.0.20 -- Tim Johnson <[EMAIL PROTECTED]> Palmer, Alaska, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: Retrieving foreign keys and references

Hi Tim, Foreign key definitions are parsed but ignored by MyISAM tables. Try InnoDB or PBXT (http://www.primebase.com/xt) :) On Feb 21, 2007, at 9:35 AM, Tim Johnson wrote: On Wednesday 21 February 2007 17:01, Rolando Edwards wrote: SHOW CREATE TABLE providers\G Hi Rolando: That doesn't do

Re: trigger

I keep getting this error ERROR 1415 (0A000): Not allowed to return a result set from a trigger --- Rolando Edwards <[EMAIL PROTECTED]> wrote: > insert into max_donations (donation_id, contact_id) > select donation_id, contact_id > from donation_test where conatct_id = (You > m

RE: Growing innodb size

+---++ | Variable_name | Value | +---++ | innodb_data_file_path | ibdata1:10M:autoextend | | innodb_data_home_dir | /var/lib/mysql/| +---+---

Re: Retrieving foreign keys and references

SHOW INDEXES FROM `providers`; By the way, what version of MySQL are you using ??? - Original Message - From: "Tim Johnson" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Wednesday, February 21, 2007 3:35:46 AM (GMT-0500) Auto-Detected Subject: Re: Retrieving foreign keys and referen

Re: Retrieving foreign keys and references

On Wednesday 21 February 2007 17:01, Rolando Edwards wrote: > SHOW CREATE TABLE providers\G Hi Rolando: That doesn't do it on my machine (linux, ver 4.0.2) Here's what I see mysql> SHOW CREATE TABLE providers\G *** 1. row *** Table: providers

Re: Retrieving foreign keys and references

SHOW CREATE TABLE providers\G - Original Message - From: "Tim Johnson" <[EMAIL PROTECTED]> To: "MySQL General Mailing List" Sent: Wednesday, February 21, 2007 2:59:35 AM (GMT-0500) Auto-Detected Subject: Retrieving foreign keys and references Hi: Below is the following relevant create t

Retrieving foreign keys and references

Hi: Below is the following relevant create table syntax CREATE Table providers( [snipped] FOREIGN KEY (status) REFERENCES provider_status(ID,title), UNIQUE KEY ID (ID) ) TYPE=MyISAM; and below is the relevant output from a describe query: mysql> show columns from providers; +---

Re: row count inconsistency

Marty Landman wrote: The table was created and then loaded and not modified in any way I'm aware of afterwards. It's on a local, only accessible by me server. Really weird thing about it is that I wrote/ran a program specifically to find any gaps in the id sequence - because of the size of the t

Re: trigger

insert into max_donations (donation_id, contact_id) select donation_id, contact_id from donation_test where conatct_id = (You missppelled contact_id) NEW.contact_id and total_amount = contact_max_amount; - Original Message - From: "Winn Johnston" <[EMAIL PROTECTED]> To: m

Re: Growing innodb size

Hi, Jean-Sebastien Pilon wrote: I would like to grow my innodb table space, the only problem that I have is that I did not declare any size in the config file since we were not using it to start with. If I modify the config file, will this override the current innodb file or will it grow it ? Or

trigger

Any way to get this to work inside an after update trigger? insert into max_donations (donation_id, contact_id) select donation_id, contact_id from donation_test where conatct_id = NEW.contact_id and total_amount = contact_max_amount; thanks winn ___

view data is inaccurate

I'm creating a view, but I'm having a problem. What you see when you "SELECT *" the view is different from what you would see if you just ran the SQL that is used to create the view. Here's an example of what I mean: So first of all here's the SQL that gets me the data I want: SELECT DISTINCT(appl

Re: row count inconsistency

The table was created and then loaded and not modified in any way I'm aware of afterwards. It's on a local, only accessible by me server. Really weird thing about it is that I wrote/ran a program specifically to find any gaps in the id sequence - because of the size of the table it took days to r

Growing innodb size

Hello list, I would like to grow my innodb table space, the only problem that I have is that I did not declare any size in the config file since we were not using it to start with. If I modify the config file, will this override the current innodb file or will it grow it ? Or should dump all the

Re: Mysql and FOREIGN KEY

Hi, Micol lupen wrote: FOREIGN KEY(of_idvillaggio),REFERENCES villaggio(idvillaggio) ^^^ check here! ON UPDATE CASCADE ON DELETE RESTRICT)ENGINE=INNODB; No comma before REFERENCES. REFERENCES is part of the foreign key definition. regards Nils -- MySQL General Mailing

Re: Mysql and FOREIGN KEY

Micol lupen wrote: Hi to all, I am a student, i am studing Mysql FOREIGN KEY for to do a little progect, but i have this problem: i create this table: CREATE TABLE Cliente( codcliente VARCHAR(6) NOT NULL, nome VARCHAR(10) NOT NULL,cognome VARCHAR(20) NOT NULL, citta VARCHAR(10), indirizzo VARCHAR

Result of select is broken by running another select

Hi all, I have an extremely strange problem here. A particular part of a project I work on has two SQL queries -- both selects, both join similar tables, and neither modifies anything. Running the first one works until I run the second. After that, running the first returns no results (it prev

Mysql and FOREIGN KEY

Hi to all, I am a student, i am studing Mysql FOREIGN KEY for to do a little progect, but i have this problem: i create this table: CREATE TABLE Cliente( codcliente VARCHAR(6) NOT NULL, nome VARCHAR(10) NOT NULL,cognome VARCHAR(20) NOT NULL, citta VARCHAR(10), indirizzo VARCHAR(20), tel VARCHAR(7)

Re: MySQL Daylight Savings Time Patch

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 If it's any consolation, I got the exact same warnings. However, I don't know if it's normal either. - -- Skype: cannona MSN/Windows Messenger: [EMAIL PROTECTED] (don't send email to the hotmail address.) - - Original Message - From: "Jerry

RE: MySQL Daylight Savings Time Patch

Aren't the time zone tables new in 4.1.3? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Bryan S. Katz [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 20, 2007 9:03 PM >

Re: unauthenticated user

Hi JM, JM wrote: i got this results from "show processlist" | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | NULL | login | | | 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | NULL | login | | That's jus

Arbitrary Docs Machinery

The MySQL documentation team has created a way that enables us to extract arbitrary pieces of MySQL documentation and recombine them into a new document. With that machinery for creating arbitrary docs, we could, for example, do this: * Bond the Cluster docs with the rest of the Storage Engines. *

RE: MySQL Daylight Savings Time Patch

I just ran mysql_tzinfo_to_sql on a CentOS (Linux) system, and it complained about the various Riyadh time zones: Warning: Unable to load '/usr/share/zoneinfo/right/Mideast/Riyadh87' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/right/Mideast/Riyadh88' as time zone. Skipp

RE: MySQL Daylight Savings Time Patch

I think that's only true if the server is using the default system time zone. In addition, you can set a per-connection time zone and use time zone sensitive functions such as CONVERT_TZ(). All of these mean that MySQL needs to be aware of time zone definitions. There could also be trouble if you a

Argh! Another Server Has Gone Away

Hi, I know this problem is already on forums and archives but I don't understand mine ! My MySQL Server works well, there are many scripts and website using it, without any problem. Since few days I'm working on a new project and if a do (php) a mysql_connect and a mysql_query() I directly

unauthenticated user

Hi, i got this results from "show processlist" | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | NULL | login | | | 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | NULL | login | | | 11188 | unauthenticated u

Re: Gaining statistics from MySQL

On 2/20/07, Clyde Lewis <[EMAIL PROTECTED]> wrote: I'm looking to find a way to determine the number of transactions that a particular database is processing each min/hour/day/month/year http://dev.mysql.com/doc/refman/4.1/en/show-status.html http://dev.mysql.com/doc/refman/4.1/en/server-statu

mysql problem

I have a database online and have a strange mysql problem. When I connect remotely from my desktop (same browse_database.php page) I get over 1000 results with the query below but when I run the same page on the remoted server this value is almost halved to 520. any ideas what is hapening? $

Re: Borland C++ Builder 2006 DLL Woes

I had to buy dbExpress libraries for MySQL from third party. Dusan [EMAIL PROTECTED] napsal(a): We just purchased The Borland Developer Studio 2006 IDE and are having significant problems using dbExpress objects to communicate with MySQL servers (both 4 and 5). Curiously, we can perform insert