Re: auto-increment more than one field

2013-05-12 Thread Michael Dykman
refer to http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html





On Sun, May 12, 2013 at 9:39 AM, rounak jain rounak.m...@gmail.com wrote:

 I have a table which needs two fields with auto-increment.
 I have the found the answer here:

 http://stackoverflow.com/questions/13642915/mysql-table-with-more-than-one-auto-incremented-
 coloumn?rq=1

 I am  using MySqlWorkbench. I can see Triggers section below the table. I
 don't know how to use the trigger script suggested in the link. Thanks.




-- 
 - michael dykman
 - mdyk...@gmail.com

 May the Source be with you.


Re: NET START MYSQL QUESTION?

2013-05-12 Thread shawn green

Hello Reindl,

On 5/11/2013 11:52 AM, Reindl Harald wrote:

...  virtually
nonofy is using mysql on windows seriously as i have
not touched windows since 2006 at all



Your experience is not indicative of the population as a whole. Many 
important and mission-critical installations exist on Windows.


You may not, or ever, choose to use Windows as a base platform but many 
people do and do superbly with their choice of OS.


--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



RE: [Suspected Spam][Characteristics] Re: NET START MYSQL QUESTION?

2013-05-12 Thread Robinson, Eric
 why not answer the question another user made hours ago?
 under which account do you try to start mysqld?
 

Agreed. Chances are good that if he goes into the Windows Services control 
panel and gets the properties of the mysql service, he will find that it is 
configured to start under a Windows account other than the System account, and 
that the Windows account in question either does not have the required 
privileges or it is locked. I'd probably just change it to start under the 
System account.

--Erio


 

Disclaimer - May 12, 2013 
This email and any files transmitted with it are confidential and intended 
solely for Reindl Harald,mysql@lists.mysql.com. If you are not the named 
addressee you should not disseminate, distribute, copy or alter this email. Any 
views or opinions presented in this email are solely those of the author and 
might not represent those of Physicians' Managed Care or Physician Select 
Management. Warning: Although Physicians' Managed Care or Physician Select 
Management has taken reasonable precautions to ensure no viruses are present in 
this email, the company cannot accept responsibility for any loss or damage 
arising from the use of this email or attachments. 
This disclaimer was added by Policy Patrol: http://www.policypatrol.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: problems with relationships created by mysql

2013-05-12 Thread rounak jain
oops..sorryproblem seems to be with base...so i meant to post it in
base mailing list


On Mon, May 13, 2013 at 9:37 AM, rounak jain rounak.m...@gmail.com wrote:

 I have connected MySql to Base. I created some relationships in MySql.
 They are properly visible in the Relationships chart in Base. See image.
 http://imgur.com/qtM8fVN,jwvJpen

 Other than that, they are non-existent. For example, while I try to create
 a sub-form, I see that the option to create subform via existing
 relationship is disabled. See image.
 http://imgur.com/qtM8fVN,jwvJpen#1

 Kindly guide me.