i want know if syntax of select query different myisam , innodb. let suppose have run query on myisam , got resultset,call : run same query on innodb , resultset,call b. , b have difference or equal b.
please reply need
the 2 storage engines support same sql syntax.
however, there features supported in 1 storage engine not other. example, fulltext indexes supported in myisam not innodb.
as result sets returned myisam vs. innodb, should return same rows, rows may not in same order if don't include deterministic order by clause. example, if not include order by clause, or order by non-unique set of columns, extent rows sorted arbitrarily, means order different different storage engines.
Comments
Post a Comment