You are here

MySQL

What's the difference between MyISAM and InnoDB?

The main differences between InnoDB and MyISAM ("with respect to designing a table or database" you asked about) are support for "referential integrity" and "transactions".

If you need the database to enforce foreign key constraints, or you need the database to support transactions (i.e. changes made by two or more DML operations handled as single unit of work, with all of the changes either applied, or all the changes reverted) then you would choose the InnoDB engine, since these features are absent from the MyISAM engine.

Blog: 

javax.servlet.ServletException: Unknown initial character set index '48' received from server. Initial client character set can

This week I reinstalled my system, and I found one J2EE Servlet project can not be run after I reinstalled all of the programming softwares and eclipse, this project does connect MySQL database(This project had no problem before). I got this Exception: javax.servlet.ServletException: Unknown initial character set index
'48' received from server. Initial client character set can be forced
via the 'characterEncoding' property.

 Strange, I went to ask my Google friend and I found those information:

Blog: 

Get the right amount number of rows and columns in MySQL with Java

It is strange that there is no direct way to get the amount number of rows of records, when you programming with Java and MySql.  For example, now I get one result from one Sql quering, I can use this way to get the number of records:

Blog: 

GIS Developing Follow Me with PHP--How to input CSV file with WKT into MySQL

If you have one CSV file that containing the WKT format SQL spatial data, how to input the data into MySQL?
For testing, at first create a table containing spatial colomn:

CREATE TABLE `geometry` (
`id` int( 11 ),
`geom` GEOMETRY ,
PRIMARY KEY ( `id` )
) TYPE = MYISAM;

In MySQL's operation software, Admin or PHPMyAdmin, you could run such SQL code to input the data:

"INSERT INTO geometry (id, geom) VALUES ('1', GeomFromText('LINESTRING(1283074 10562093,1283074 10562093,1283074 10562093)'));

Blog: 

GIS and Spatial Extensions with MySQL(T)

MySQL 4.1 introduces spatial functionality in MySQL. This article describes some of the uses of spatial extensions in a relational database, how it can be implemented in a relational database, what features are present in MySQL and some simple examples.

Often the spatial functions are called geographic information system (GIS) functions, because GIS applications are the most obvious use-case for the spatial functionality. The spatial functions can be used both to provide a means to organize GIS data together with more traditional types of data and to represent non-GIS data with a spatial attribute.

Blog: 
Subscribe to RSS - MySQL