<FeatureProvider>
<Name>OSGeo.MySQL.3.2</Name>
<DisplayName>OSGeo FDO Provider for MySQL </DisplayName>
<Description>Read/write access to MySQL-based data store.
Supports spatial data types and spatial query operations. </Description>
<IsManaged>False</IsManaged>
<Version>3.2.1.0</Version>
<FeatureDataObjectsVersion>3.2.1.0</FeatureDataObjectsVersion>
<LibraryPath>MySQLProvider.dll</LibraryPath>
</FeatureProvider>
<FeatureProvider>
<Name>OSGeo.MySQL.3.3</Name>
<DisplayName>OSGeo FDO Provider for MySQL </DisplayName>
<Description>Read/write access to MySQL-based data store.
Supports spatial data types and spatial query operations. </Description>
<IsManaged>False</IsManaged>
<Version>3.3.0.0</Version>
<FeatureDataObjectsVersion>3.3.0.0</FeatureDataObjectsVersion>
<LibraryPath>MySQLProvider.dll</LibraryPath>
SHOW GRANTS;
# will display the privileges of the current userSHOW PRIVILEGES
# will display all the privileges availableCREATE TABLE gisengin_ccrec.trash AS
SELECT a.*, b.namesid, b.partycode, b.partycodedesc, b.partylastname, b.partymidname, b.partyfullname
FROM gisengin_ccrec.instrument a
LEFT OUTER JOIN gisengin_ccrec.names b
ON a.instrno = b.instrno;
CREATE TEMPORARY TABLE IF NOT EXISTS gisengin_ccrec.tmpnames
DROP TEMPORARY TABLE IF EXISTS gisengin_ccrec.tmpnames
SELECT * FROM t1.table1 AS DatabaseName.table1 INNER JOIN t2 AS DatabaseName.table2 ON t1.id = t22.id WHERE t2.name = 'somevalue'
SET SQL_BIG_SELECTS=1;
SELECT a.*, b.* FROM gisengin_ccrec.instrument a
LEFT OUTER JOIN gisengin_ccrec.names b ON a.instrno=b.instrno;
SET SQL_BIG_SELECTS=1;
SELECT a.*, b.* FROM gisengin_ccrec.instrument a
LEFT OUTER JOIN gisengin_ccrec.names b
ON a.instrno = b.instrno
HAVING b.instrno is null;
SET SQL_BIG_SELECTS=1;
SELECT a.*, b.* FROM gisengin_ccrec.instrument a
LEFT OUTER JOIN gisengin_ccrec.names b
ON a.instrno <> b.instrno;
SELECT CONCAT_WS(' ', a.firstname, a.lastname) AS fullname
FROM gisengin_ccrec.names a;
CREATE INDEX idxNamesInstrno
ON ccrec.names (instrno)
DROP INDEX idxNamesInstrno
SELECT COUNT(a.namesid) FROM gisengin_ccrec.names a
SHOW TABLE STATUS FROM gisengin_ccrec;
SELECT MAX(a.namesid) FROM gisengin_ccrec.names a
SELECT COUNT(DISTINCT n.instrno) FROM gisengin_ccrec.names n;
SELECT *, COUNT(a.instrno) AS qty
FROM gisengin_ccrec.instrument a
GROUP BY a.instrno
HAVING qty > 1;
RENAME TABLE current_db.tbl_name TO other_db.tbl_name; (see MySQL 5.0 Reference Manual, 12.1.19. RENAME TABLE Syntax)