...

Mysql tutorial, mysql tutorial, mysql and java tutorial, using mysql, mysql lessons, mysql,mysql tips,mysql cheat sheet!

Sycorax - complete tutorials

Programming Tutorials

" Java provides the industry - software companies and customer alike , an opportunity to create a true open computing environment where software is portable,
and customers benefit from increase competition. "

Java and the Future

December 1, 2008-LEJB 3.1: EJB New and Improved!
The EJB 3.0 specification was a huge improvement from what you were used to in the early versions of EJB. Available as an early draft, EJB 3.1 has many more features and is even easier to use.

December 1, 2008 -Should Java Assert that Network I/O Can't Occur on the UI Thread?
Doing network I/O on the user interface (UI) thread is bad. Most developers know that and can tell you why; unfortunately, it's still done.

Programmer Chat Room (New)

Live support, Live help, Live chat solutions

What is MySQL?

MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers.
The MySQL Web site (http://www.mysql.com/) provides the latest MySQL software

MySQL is a relational database management system.
MySQL software is Open Source.
The MySQL Database Server is very fast, reliable, and easy to use.
MySQL Server works in client/server or embedded systems.
Latest version of mysql is MySQL 5.1

Main Features of MySQL: -

Internals and Portability:

Written in C and C++.
Tested with a broad range of different compilers.
Works on many different platforms.
Fully multi-threaded using kernel threads. It can easily use multiple CPUs if they are available.

Data Types:
Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types.

Localization:

Full support for several different character sets, including latin1 (cp1252), german, big5, ujis, and more. For example, the Scandinavian characters 'a', 'ä' and 'ö' are allowed in table and column names. All data is saved in the chosen character set.

Clients and Tools:

MySQL AB provides several client and utility programs. These include both command-line programs such as mysqldump and mysqladmin, and graphical programs such as MySQL Administrator and MySQL Query Browser.

Connectivity:

Clients can connect to MySQL Server using several protocols:

Clients can connect using TCP/IP sockets on any platform.
On Windows systems in the NT family (NT, 2000, XP, 2003, or Vista), clients can connect using named pipes if the server is started with the --enable-named-pipe option. In MySQL 4.1 and higher, Windows servers also support shared-memory connections if started with the --shared-memory option. Clients can connect through shared memory by using the --protocol=memory option.
On Unix systems, clients can connect using Unix domain socket files.

Security:

A privilege and password system that is very flexible and secure, and that allows host-based verification.
Passwords are secure because all password traffic is encrypted when you connect to a server.

Scalability and Limits: