small help

ALTER TABLE TimeTracker.TT_ProjectMembers ADD CONSTRAINT FK_Roles_Projects FOREIGN KEY ( ProjectID ) REFERENCES TimeTracker.TT_Projects ( ProjectID ) ON DELETE CASCADE , CONSTRAINT FK_WorksOn_Users FOREIGN KEY (

errors in mysql syntax

ALTER TABLE TimeTracker.TT_ProjectMembers ADD CONSTRAINT FK_Roles_Projects FOREIGN KEY ( ProjectID ) REFERENCES TimeTracker.TT_Projects ( ProjectID ) ON DELETE CASCADE , CONSTRAINT FK_WorksOn_Users FOREIGN KEY

Re: MYSQL CLIENT PROBLEM

Krishna Chandra Prajapati wrote: Hi All, I am using mysql-client 5.0.15 on fedora system. Server is a Debian box with mysql 5.0.32 After getting connected to the server(192.168.1.7) using the command below mysql -h 192.168.1.7 -D dip -u dip -p When a record deleted from a table on server

MYSQL CLIENT PROBLEM

Hi All, I am using mysql-client 5.0.15 on fedora system. Server is a Debian box with mysql 5.0.32 After getting connected to the server(192.168.1.7) using the command below mysql -h 192.168.1.7 -D dip -u dip -p When a record deleted from a table on server (192.168.1.7) Then that changes are not

Re: MySQL 5.1.21 won't build on OpenBSD unless...

Hi Jake ! Jake Conk wrote: Hello, Not sure if this is known or not but I just wanted to let you guys know that MySQL 5.1.21 fails the make. I've never had this problem on other versions of mysql. It looks like GNU make worked all the way through but why won't regular make work anymore?

Re: Ouch! ibdata files deleted. Why no catastrophe?

Hi ! Jerry Schwartz wrote: I don't know Linux that well, but I know that HP-UX lets you do most anything to an open file, including deleting it. The file will continue to exist as long as it is open by at least one process. Yes - that is standard Unix semantics; it should be that way on any

MySQL 5.0.27 replication problems

Hi, I keep getting the below in the error log. I can't see any problems (no other errors and replication is working) and the master DB is available the whole time. 070928 12:07:31 [Note] Slave: received end packet from server, apparent master shutdown: 070928 12:07:31 [Note] Slave I/O thread:

I keep getting an error as attached

Michael Mostert State Manager - WA Suite 13, Level 4 231 Adelaide Terrace Perth, WA 6000 P: (08) 9218 8922 F : (08) 9218 8755 M : 0401 235 703 mailto:[EMAIL PROTECTED] Email: [EMAIL PROTECTED]

Storing Devnagari unicode data in MySQL

Namaskar, I am using Windows Xp SP2 and Mysql 5.0.45 and MyODBC 3.51.19 with Microsoft Marathi Indic IME 1 version 5. I am storing data in both languages i.e. Marathi and English. So I changed database character set to 'utf8 -- UTF-8 Unicode' and collation to 'utf8_unicode_ci'. Also I changed the

Re: DB Schema Comparison Utility ?

Hello John, I am new to MySQL. We have a development environment where we have three systems 1) Developement Database on Machine A 2) Test Databasae on Machine B 3) Live Database on Machine C So we make changes to the Developement Database, then move them to test then to live. My

RE: Count syntax

Thanks - it works, but what does the 1 and 0 do in this - SUM(IF(supportertype = 'L', 1, 0)) -Original Message- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Sent: September 28, 2007 1:00 PM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Count syntax Beauford wrote: Hi,

RE: Count syntax

Beauford, you might find this article on cross joins interesting, it was something shown to me a few weeks ago that discusses this kind of function. http://dev.mysql.com/tech-resources/articles/wizard/print_version.html Cheers, craig This

Re: Count syntax

Beauford wrote: Hi, I have the following line of code and I keep getting wrong results from it. Can someone let me know what I'm doing wrong here. I just can't quite figure out the syntax that I need. select count(*) as numrows, count(supportertype) as leadcar from registrar where

Re: Count syntax

1 means that 1 will be added to the sum if the condition tests, otherwise 0 will be added to the sum. the condition in this case is (supportertype = 'L') and will be applied to every row. On 9/28/07, Beauford [EMAIL PROTECTED] wrote: Thanks - it works, but what does the 1 and 0 do in this -

Count syntax

Hi, I have the following line of code and I keep getting wrong results from it. Can someone let me know what I'm doing wrong here. I just can't quite figure out the syntax that I need. select count(*) as numrows, count(supportertype) as leadcar from registrar where supportertype = 'L'; What I

RE: Storing Devnagari unicode data in MySQL

Try upgrading to a version 5 of the ODBC connector. It worked for our Chinese data. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com

Re: Storing Devnagari unicode data in MySQL

Thanks for your help. I upgraded MyODBC 3.51.19 to 5.1 beta, and tried it for Devnagari data entry and it worked well. But now a new problem of showing newly added record as '#Deleted' is there. and even after adding a time stamp field in the table, this problem exists,(this problem is solved in

Re: MySQL 5.1.21 won't build on OpenBSD unless...

In the last episode (Sep 27), Jake Conk said: Not sure if this is known or not but I just wanted to let you guys know that MySQL 5.1.21 fails the make. I've never had this problem on other versions of mysql. It looks like GNU make worked all the way through but why won't regular make work

Re: MySQL 5.1.21 won't build on OpenBSD unless...

In the last episode (Sep 28), Dan Nelson said: In the last episode (Sep 27), Jake Conk said: Not sure if this is known or not but I just wanted to let you guys know that MySQL 5.1.21 fails the make. I've never had this problem on other versions of mysql. It looks like GNU make worked all

RE: Count syntax

Thanks to all. -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: September 28, 2007 1:36 PM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Count syntax 1 means that 1 will be added to the sum if the condition tests, otherwise 0 will be added to the