MySQL 5.0 - What is really available?

[mike . griffin]

I've downloaded and installed 5.0, it seems to be working fine. However, I
need a graphical user interface to create tables and such (when I say I
need, trust me, I need). I'm running on XP (that explains a lot I know)

So:

Is Control Center for 5.0 available?
Is MyODBC 5.0 available?

I'm having a hard time find from the rather extensive 'manual.html' what
other than the actual database engine is available.

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

Are you willing to test a free product?

[Mike Griffin]

Our product, although written in .NET can be used to create anything, stored 
procedures, data objects, business object that map database tables to 
properties and so on.  We support MySql, Microsoft SQL, DB2, Oracle and 
Access.  We are very interested in supporting the MySql community and plan 
to be ready for the 5.0 release -- will be able to generate all of your 
stored procedures for you with a click of a button (fully customizable of 
course).  Our templates can be written in JScript of VBscript.  We use OLEDB 
to gather the meta data and there is a free OLEDB provider for MySql if you 
want to try our application.

Download your free copy today and help us to support the MySql community.
http://www.MyGenerationSoftware.com
_
There are now three new levels of MSN Hotmail Extra Storage!  Learn more. 
http://join.msn.com/?pgmarket=en-uspage=hotmail/es2ST=1

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

Re: mysql statement autogenerator...

[Mike Griffin]

I have written a .NET class library (fully scriptable via java script and 
vbscript too) that serves up all of the meta data for MySql, Sql, Oracle, 
Access, DB2 and a few others.  Not just the normal meta data but all kinds 
of custom meta data that's hard to get to.  So, if you're running on a 
Microsoft machine you can do stuff like this (java script example):

==

var dbMeta = new ActiveXObject(MyMeta.Root);
dbMeta.Connect(MySql, MyConnectionString);
var columns = 
dbMeta.Databases.Item(Northwind).Tables.Item(Employees).Columns;
for (var i = 0; i  columns.Count; i++)
{
  var col = columns.Item(i);

  output.write(col.TableName);
  output.write(col.Name);
  output.write(col.PhysicalName);
  output.write(col.TypeName);  // int,varchar, whatever ...
  output.write(col.IsInPrimaryKey);
  output.write(col.IsComputed);
  output.write(col.NumericScale);
  // and on and on, ...
}
==
We have meta data for views, stored procedures (the next MySql), indexes, 
foreignkeys, and so on. We also allow you to override column, view, and 
tables names, for instance, if you have a poorly named database with bad 
fields names and you want to generate a business entity from it you supply a 
xml file that maps the names (each object has a Name, and PhysicalName, Name 
will match PhysicalName unless you override it). MyMeta will even generate 
the XML file for you, you just supply the Name attribute next to the 
proper PhysicalName attribute.

It's been months and months of work and unit tested against all kinds of 
databases. If anybody is interested in a beta let me know, it's near 
completion and a real time saver, you can generate stored procedures with 
it, business objects, ui code, anything.

Mike Griffin



From: dan orlic To: Subject: mysql statement autogenerator... Date: Tue, 
14 Oct 2003 14:01:52 -0500

Is anyone aware of an open source project that provides a graphical 
representation of tables that can then generate a database schema in sql 
statements. Something like Posiedon auto generating java beans. Perhaps one 
should be started? ;-)

dan
_
See when your friends are online with MSN Messenger 6.0. Download it now 
FREE! http://msnmessenger-download.com

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

SHOW FIELDS FROM table?

[Mike Griffin]

My code is shown below, I can select * from employees but I cannot get
any data back from SHOW FIELDS, I do not receive an error, in fact,
something is returned but I'm not sure what. I can execute the
command:
SHOW FIELDS FROM test.employees

in the Control Center just fine, even cmd.ExecuteReader will enter
reader.Read() once, something is returned but what does it look like?
This is .NET code



OleDbConnection cn = new OleDbConnection(@Provider=MySQLProv;Data
Source=test;DB=test;UID=;PWD=;PORT=3306);
cn.Open();
OleDbCommand cmd = new OleDbCommand(SHOW FIELDS FROM test.employees,
cn);
cmd.CommandType = CommandType.Text;
DataTable metaData = new DataTable();
OleDbDataAdapter ad = new OleDbDataAdapter();
ad.SelectCommand = cmd;
ad.Fill(metaData);
===

_
Help protect your PC.  Get a FREE computer virus scan online from McAfee. 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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