Browsing articles in "mysql"
Apr
15

MySQL Workbench cross platform visual database design tool

By admin  //  mysql  //  1 Comment

I found this very interesting and useful for database designers and It’s absolutely free also have commerial version but free version is enough for developer…

MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench will be available as a native GUI tool on Window, Linux and OS X.

For Download please vist http://wb.mysql.com/

For more information and detailed tutorial please visits

http://dev.mysql.com/doc/workbench/en/wb-tutorials.html
http://downloads.mysql.com/docs/workbench-en.pdf

http://www.packtpub.com/article/visual-mysql-database-design-in-mysql-workbench
http://yensdesign.com/2008/10/making-mysql-forum-database-from-scratch/

Apr
14

Database Migration Toolkit

By admin  //  Softwares, mysql  //  1 Comment

ESF Database Migration Toolkit Professional is a program that allows you to convert between different database formats. ESF Database Migration Toolkit Professional can directly connect to MySQL, SQL Server, PostgreSQL, Oracle, Access, Excel, Paradox, Lotus, dBase, Visual FoxPro, Text and other formats, and convert between these formats (SQL Server to MySQL, MySQL to Access etc.).

Features
• The software is wizard-like; it’s so easy and quickly, everyone can use it. You convert one database to the other just only 3 steps
• Supports various database formats. It can interchangeably convert MySQL, SQL Server, PostgreSQL, Oracle, Access, Excel, dBase,Paradox, Text, Visual FoxPro
• Supports table Primary Keys, Indexes, and Autoincrement(Auto-ID)
• Supports Batch Insert/Update records to increase converssion speed! It lets ESF Database Convert run faster than other program
• You can interchangeably convert MySQL to Access, Access to Oracle, Oracle to SQL Server, SQL Server to MySQL, … and etc in one product
• Via ODBC DSN, you can convert datas from any type database
• Map table & field name in converting
• You can use SQL statement to filter datas to be converting
• Supports all the UNICODE characterset (UTF8, LATIN, CP1250, ASCII and so on)

http://hotfile.com/dl/37831596/7121862/ESF.Database.Migration.Toolkit.Professional.Edition.v6.3.14.Incl.Keygen-Lz0.rar.html

http://letitbit.net/download/1169.1c1ad6b8124e03eb91940c4dc524797c/ESF.Database.Migration.Toolkit.Professional.Edition.v6.3.14.Incl.Keygen_Lz0.rar.html

http://uploading.com/files/m967af35/ESF.Database.Migration.Toolkit.Professional.Edition.v6.3.14.Incl.Keygen-Lz0.rar/

Mar
16

overview of the features and architecture of ext/mysqli

By admin  //  mysql  //  No Comments

In this article, we have provided an overview of the features and architecture of ext/mysqli, along with a quick summary of its development history. You should now understand how to use and benefit from MySQL’s prepared statements, and should be fairly comfortable using the object-oriented interface to ext/mysqli.

The MySQLi extension provides various benefits with respect to its predecessor

  • An object-oriented interface
  • Support for prepared statements
  • Support for multiple statements
  • Support for transactions
  • Enhanced debugging support
  • Embedded server support

Glossary

ext/mysql – PHP’s old MySQL extension. Does not support the full feature set of MySQL version 4.1

ext/mysqli - The new MySQL extension for PHP 5. Supports the features available in MySQL versions 3.22 to 5.0

MySQL client library - The component of the MySQL RDBMS[*] that allows programs to communicate with the RDBMS

MySQL server - The component of the MySQL RDBMS that does the work of processing and responding to queries, managing the disk-level representation of data within the database, etc.

Read Complete article @ Read article