Re: Database Creation

2008-09-22 Thread Arjan Hulshoff
Hi Andrew, You can do this with MySQL Administrator, but you have to look for Catalogs in the left pane. After that right click in the bottom part of the left pain and select 'Create Schema'. Provide a database name and click on ok. That should do the trick. Arjan On Sun, 2008-09-21 at 21:26

Re: Administrative Tools

2007-06-05 Thread Arjan Hulshoff
Hi Martijn, Any plans to port Database Workbench to linux? Regards, Arjan. Martijn Tonies wrote: Hello I am looking for the tools that I would use to be able to do administrative duties and to be able to create and update databases (tables, indexes and so forth). I would rather do

Re: MAX + SUM in one query

2006-11-06 Thread Arjan Hulshoff
Are you looking for a query like this? select r.Stock_StockID, sum(r.RequestTotal), r.RequestPrice from Request r join (select x.Stock_StockID, max(x.RequestPrice) as MaxRequestPrice from Request x group by x.Stock_StockID) s on r.Stock_StockID = s.Stock_StockID and s.MaxRequestPrice =

Re: Could someone help this guy :-?

2006-09-09 Thread Arjan Hulshoff
Paul DuBois wrote: Behrang Saeedzadeh wrote: Hi, Could someone help this guy work around this problem in MySQL: http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html I think the answer to his questions lies in the manual:

Source code about user authentication in MySQL 5

2006-08-10 Thread Arjan Hulshoff
Can someone tell me where I can find the source code files whit th user authentication in it? I want to see if I can integrate LDAP authentication myself. _ Express yourself instantly with MSN Messenger! Download today - it's FREE!

RE: MySQLDump and Restore

2006-04-21 Thread Arjan Hulshoff
Or use mysqlimport... Typ 'mysqlimport --help' for further assistance. There are more usefull tools in the bin directory of your mysql installation. HTH, Arjan. -Original Message- From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] Sent: Friday, April 21, 2006 09:03 AM To: Jim Cc:

How to create a query to get right commencing date

2006-04-13 Thread Arjan Hulshoff
| +-+++-+-++-- + How can I create a query to get this result? Can somebody help me? TIA, Arjan Hulshoff. -- The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use

RE: Populate values in an Excel sheet from MySQL

2005-09-02 Thread Arjan Hulshoff
Hello Nick, This you can do with the MySQL ODBC Driver installed (http://dev.mysql.com/downloads/connector/odbc/3.51.html). Further more you need to activate Microsoft ActiveX Data Objects in the references. You can use the following code: --Begin Code-- Dim cn As ADODB.Connection Dim rs As

RE: 'ODBC'@'localhost' instead of 'root'@'invalid_hostname.com' ?!??

2005-08-22 Thread Arjan Hulshoff
Martin, Have you defined a user? Because Windows automatically uses 'ODBC'@'localhost' as a standard account, when there is no username submitted. According to http://www.php.net/manual/en/function.mysql-errno.php the mysql-errno function should still work. But it might be interesting to know

RE: MSSQL to MySQL mapping

2005-08-11 Thread Arjan Hulshoff
Have you adjusted your queries? MSSQL uses a different dialect (T-SQL), then MySQL uses. There are quite some difference, although some queries still might work. Arjan. -Original Message- From: John c [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 08:12 PM To:

RE: how to find out the name of the server

2005-08-09 Thread Arjan Hulshoff
Hello, If the clients and servers are both Windows systems, then you might want to try the following script. You need administrator rights for it on the network and the server must be running as it tries to retrieve a running process from the server. I am not sure if there is another way and it