- 浏览: 4340818 次
- 性别:
- 来自: 湛江
博客专栏
-
SQLite源码剖析
浏览量:79510
-
WIN32汇编语言学习应用...
浏览量:68563
-
神奇的perl
浏览量:101699
-
lucene等搜索引擎解析...
浏览量:281627
-
深入lucene3.5源码...
浏览量:14651
-
VB.NET并行与分布式编...
浏览量:65823
-
silverlight 5...
浏览量:31400
-
算法下午茶系列
浏览量:45307
文章分类
最新评论
-
yoyo837:
counters15 写道目前只支持IE吗?插件的东西是跨浏览 ...
Silverlight 5 轻松开启绚丽的网页3D世界 -
shuiyunbing:
直接在前台导出方式:excel中的单元格样式怎么处理,比如某行 ...
Flex导出Excel -
di1984HIT:
写的很好~
lucene入门-索引网页 -
rjguanwen:
在win7 64位操作系统下,pygtk的Entry无法输入怎 ...
pygtk-entry -
ldl_xz:
http://www.9958.pw/post/php_exc ...
PHPExcel常用方法汇总(转载)
dmd
Construct database metadata object
Syntax
dbmeta = dmd(conn)
Description
dbmeta = dmd(conn) constructs a database metadata object for the database connection conn. Use get and supports to obtain properties of dbmeta. Use dmd and get(dbmeta) to obtain information you need about a database, such as table names required to retrieve data.
For a list of functions that operate on database metadata objects, enter:
help dmd/Contents
Examples
dbmeta = dmd(conn) creates a database metadata object dbmeta for the database connection conn.
v = get(dbmeta) lists properties of the database metadata object.
=================================
supports
Detect whether property is supported by database metadata object
Syntax
a = supports(dbmeta)
a = supports(dbmeta, 'property')
a.property
Description
a = supports(dbmeta) returns a structure that contains the properties of dbmeta and its property values, 1 or 0. A value of 1 indicates that the property is supported, and 0 indicates that the property is not supported.
a = supports(dbmeta, 'property') returns 1 or 0 for the property field of dbmeta. A value of 1 indicates that the property is supported, and 0 indicates that the property is not supported.
a.property returns the value of property after you have created a using the supports function.
Examples
Check if dbmeta supports group-by clauses.
a = supports(dbmeta, 'GroupBy')
a =
1
View the value of all properties of dbmeta.
a = supports(dbmeta)
The returned result is a list of properties and their values.
See the value of the GroupBy property by running:
a.GroupBy
a =
1
===============================
tables
Return database table names
Syntax
t = tables(dbmeta, 'cata')
t = tables(dbmeta, 'cata', 'sch')
Description
t = tables(dbmeta, 'cata') returns a list of tables and table types in the catalog cata, for the database whose database metadata object is dbmeta.
t = tables(dbmeta, 'cata', 'sch') returns a list of tables and table types in:
The schema sch
Of the catalog cata
For the database whose database metadata object is dbmeta
Tip For command-line help on tables, use the overloaded method:
help dmd/tables
Examples
Get the table names and types for the schema SCOTT in the catalog orcl, for the database metadata object dbmeta.
t = tables(dbmeta,'orcl', 'SCOTT')
t =
'BONUS' 'TABLE'
'DEPT' 'TABLE'
'EMP' 'TABLE'
'SALGRADE' 'TABLE'
'TRIAL' 'TABLE'
上机 操作
>> myconn=database('students','mytest','deepfuture','com.mysql.jdbc.Driver','jdbc:mysql://localhost:3306/students')
myconn =
Instance: 'students'
UserName: 'mytest'
Driver: 'com.mysql.jdbc.Driver'
URL: 'jdbc:mysql://localhost:3306/students'
Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
Message: []
Handle: [1x1 com.mysql.jdbc.JDBC4Connection]
TimeOut: 0
AutoCommit: 'on'
Type: 'Database Object'
>> mydbmetaa=dmd(myconn)
mydbmetaa =
DMDHandle: [1x1 com.mysql.jdbc.JDBC4DatabaseMetaData]
>> myv=get(mydbmetaa)
myv =
AllProceduresAreCallable: 0
AllTablesAreSelectable: 0
DataDefinitionCausesTransactionCommit: 1
DataDefinitionIgnoredInTransactions: 0
DoesMaxRowSizeIncludeBlobs: 1
Catalogs: {3x1 cell}
CatalogSeparator: '.'
CatalogTerm: 'database'
DatabaseProductName: 'MySQL'
DatabaseProductVersion: '5.5.25a'
DefaultTransactionIsolation: 2
DriverMajorVersion: 5
DriverMinorVersion: 1
DriverName: 'MySQL-AB JDBC Driver'
DriverVersion: [1x60 char]
ExtraNameCharacters: '#@'
IdentifierQuoteString: '`'
IsCatalogAtStart: 1
MaxBinaryLiteralLength: 16777208
MaxCatalogNameLength: 32
MaxCharLiteralLength: 16777208
MaxColumnNameLength: 64
MaxColumnsInGroupBy: 64
MaxColumnsInIndex: 16
MaxColumnsInOrderBy: 64
MaxColumnsInSelect: 256
MaxColumnsInTable: 512
MaxConnections: 0
MaxCursorNameLength: 64
MaxIndexLength: 256
MaxProcedureNameLength: 0
MaxRowSize: 2.1475e+009
MaxSchemaNameLength: 0
MaxStatementLength: 65531
MaxStatements: 0
MaxTableNameLength: 64
MaxTablesInSelect: 256
MaxUserNameLength: 16
NumericFunctions: [1x144 char]
ProcedureTerm: 'PROCEDURE'
Schemas: {}
SchemaTerm: ''
SearchStringEscape: '\'
SQLKeywords: [1x1116 char]
StringFunctions: [1x374 char]
StoresLowerCaseIdentifiers: 1
StoresLowerCaseQuotedIdentifiers: 1
StoresMixedCaseIdentifiers: 0
StoresMixedCaseQuotedIdentifiers: 0
StoresUpperCaseIdentifiers: 0
StoresUpperCaseQuotedIdentifiers: 1
SystemFunctions: [1x78 char]
TableTypes: {3x1 cell}
TimeDateFunctions: [1x289 char]
TypeInfo: {40x1 cell}
URL: [1x36 char]
UserName: 'mytest@localhost'
NullPlusNonNullIsNull: 1
NullsAreSortedAtEnd: 0
NullsAreSortedAtStart: 0
NullsAreSortedHigh: 0
NullsAreSortedLow: 1
UsesLocalFilePerTable: 0
UsesLocalFiles: 0
数据库项目(包含的数据库)
>> myv.Catalogs
ans =
'information_schema'
'students'
'test'
>>
元数据对象支持和不支持的属性
>> mys=supports(mydbmetaa)
mys =
AlterTableWithAddColumn: 1
AlterTableWithDropColumn: 1
ANSI92EntryLevelSQL: 1
ANSI92FullSQL: 0
ANSI92IntermediateSQL: 0
CatalogsInDataManipulation: 1
CatalogsInIndexDefinitions: 1
CatalogsInPrivilegeDefinitions: 1
CatalogsInProcedureCalls: 1
CatalogsInTableDefinitions: 1
ColumnAliasing: 1
Convert: 0
CoreSQLGrammar: 1
CorrelatedSubqueries: 1
DataDefinitionAndDataManipulationTransactions: 0
DataManipulationTransactionsOnly: 0
DifferentTableCorrelationNames: 1
ExpressionsInOrderBy: 1
ExtendedSQLGrammar: 0
FullOuterJoins: 0
GroupBy: 1
GroupByBeyondSelect: 1
GroupByUnrelated: 1
IntegrityEnhancementFacility: 0
LikeEscapeClause: 1
LimitedOuterJoins: 1
MinimumSQLGrammar: 1
MixedCaseIdentifiers: 0
MixedCaseQuotedIdentifiers: 0
MultipleResultSets: 1
MultipleTransactions: 1
NonNullableColumns: 1
OpenCursorsAcrossCommit: 0
OpenCursorsAcrossRollback: 0
OpenStatementsAcrossCommit: 0
OpenStatementsAcrossRollback: 0
OrderByUnrelated: 0
OuterJoins: 1
PositionedDelete: 0
PositionedUpdate: 0
SchemasInDataManipulation: 0
SchemasInIndexDefinitions: 0
SchemasInPrivilegeDefinitions: 0
SchemasInProcedureCalls: 0
SchemasInTableDefinitions: 0
SelectForUpdate: 1
StoredProcedures: 1
SubqueriesInComparisons: 1
SubqueriesInExists: 1
SubqueriesInIns: 1
SubqueriesInQuantifieds: 1
TableCorrelationNames: 1
Transactions: 1
Union: 1
UnionAll: 1
某个数据库包含的表
>> tables(mydbmetaa,'students')
ans =
'student' 'TABLE'
>>
发表评论
-
R语言与数据分析
2015-05-15 20:58 2080当今计算机系统要处理的数据类型变得多种多样,并且为了深入理 ... -
机器学习实践指南:案例应用解析
2014-04-17 19:53 1005试读及购买链接 《机器 ... -
matlab-矩阵合并
2013-06-10 13:56 3137a = 1 2 3 2 -
人工智能与数据分析所需要的知识
2013-04-30 18:27 292想较好得在数据分析和人工智能相关领域发展,最好具备以下基础: ... -
麦哈普的AI乐园【myhaspl@qq.com】我的另一个博客(机器学习、数据分析、智能计算的原创)
2013-04-28 10:52 11http://blog.csdn.net/u0102556 ... -
R-并行计算
2013-04-28 10:50 6072啊。。。找了一下,R 居然真的有办法可以多cpu平行运算!! ... -
谱聚类
2013-04-11 10:44 26711. 谱聚类 给你博客园上若干个博客,让你将它 ... -
对变化建模-用差分方程-动力系统及常数解
2013-04-09 15:24 1385差分表示在一个时间周期里考察对象的变化量。 差分表示在一个时 ... -
逻辑斯蒂映射-伪随机数
2013-04-04 15:28 3310逻辑斯蒂映射的形式为 x_(n+1)=ax_n( ... -
matlab-多项式乘除法及式子和导数
2013-03-21 15:06 4598>> a=[22 12 4 54] ... -
matlab-数组-元胞数据与结构数组
2013-03-20 17:45 3237y、z是元胞数组,num2cell完成由数值数组到元胞数组的 ... -
矩阵-范数
2013-03-13 17:30 1855>> a a = 12 33 ... -
向量-范数
2013-03-13 16:06 2284>> b=a(3,:) b = 22 ... -
矩阵-求逆
2013-02-27 15:51 2467设R是一个交换环,A是 ... -
lisp-猜数字算法与全局函数、变量
2013-01-30 17:55 1608* (defvar *big* 100) *BIG* ... -
开源 Lisp 相关项目
2013-01-19 22:38 3857IOLib 项目 (http://common-lisp.n ... -
四分位数求法
2012-11-22 20:18 2793四分位数间距:是上四分位数与下四分位数之差,用四分位数间距可反 ... -
matlab-神经网络-自定义多层感知器解决异或(2)
2012-10-10 22:33 2460继续定义单元神经元 net.inputs{i}.ran ... -
matlab-神经网络-自定义多层感知器解决异或(1)
2012-10-09 22:41 5148>> net=network net = ... -
matlab-模态对话框
2012-10-05 16:59 3491modal dialog box with the comm ...
相关推荐
matlab开发-数据库工具箱。Matlabadt允许通过元数据轻松访问和过滤音频数据库,如Timit。
matlab开发-数据库图像融合。图像融合采用主成分分析法。
matlab开发-数据库中的大型数据处理案例研究。这些是2011年2月23日网络研讨会上使用的文件。
matlab开发-数据库地窖射线。单元arrray数据库的演示以及如何在其中保存新信息
零散MATLAB资料分享-Matlab数据库编程入门.pdf 最近在用MATLAB做一个项目,自然需要查很多东西,在网上搜集了一点资料,并非原创。本着分享的精神,希望能帮助到部分人。 包括以下内容 在MATLAB图形用户...
matlab开发-访问数据库。(与MYM.M)
约翰霍普金斯大学湍流数据库 web servier-matlab-tool包
matlab开发-从映像创建数据库。数据库
matlab开发-dbarraypackandunpackdatabasearraystomatlabrays数据库。dbarray允许您直接将array[]类型的数据库字段发送/获取到本地的MATLAB变量中
matlab开发-ChangeSystemDSNToadifferencesAccess数据库。更改将哪个ms access数据库(.mdb)设置为数据源名称(DSN)的matlab脚本
该项目包含来自有限元求解器LS-DYNA的ascii结果文件的阅读器,以及用于从MATLAB中以编程方式运行LS-DYNA模拟的包装器。 该项目与LS-DYNA的创建者或发行者没有任何关系,因此是完全非官方的。 目前,matlab-lsdyna是...
基于MATLAB的数据库开发文档,主要介绍了用MATLAB进行数据库开发的三种方法
基于MATLAB的数据库开发.pdf
matlab开发-HeartVi1模拟数据库的重新同步。模块库Simulink HeartVi1
matlab开发-加权数据库。加权数据分块。
原创Matlab通过ODBC的方式调用数据库-Matlab数据库编程指南-Godman.rar 以下内容为Matlab中文论坛会员,Godman原创。 如果需要转载,请联系Godman会员: 如有疑问可以邮件联系 tntuyh@163.com Godman 2009...
包括MATLAB GUI中与数据库链接、访问数据库、SQL编写等代码。是MATLAB与数据库联合编程的典型代码集。
使用matlab读取mit-bih的心电图信号
matlab开发-人脸识别系统数据库。基于PCA的人脸识别系统
matlab开发-指纹灰度图像数据库2。作者:Ujwalla Gawande博士、Kamal Hajari和Yogesh Golhar