Hi, I have build one application which uses static reference of MySQL 4.0 old version library and dynamic reference of new version as MySQL 5.1...
Hi, I have created table -== account(acct_num INT, amount INT); I have created view using CREATE VIEW v AS SELECT acct_num AS value FROM...
How do I get the native data type like we get in ORACLE using OCIAttrGet(colHandle, OCI_DTYPE_PARAM, (dvoid *) &dataType, 0, OCI_ATTR_DATA_TYPE,...
How can we get the table schema information in MYSQL 5.1.34? Like we use in ORACLE to get it as: OCIDescribeAny() // //get the describe handle...
How do I get the Parameter information of table? I have table like mysql> desc account;...
Yes it is giving the correct result. However I have written an application in which input is table name and need to get the database name...
Hi, I am trying to fire a query in MyLSQ 5.1.34 like mysql> select table_schema from INFORMATION_SCHEMA.TABLES where table_name='table11';...
Resolved the problem. Thanks Pradeep for answering me.
I have installed MySQl using "mysql-essential-5.1.34-win32.msi". I have installed server so no need of client seperately. While i trying to...
Hi I am trying to connect to MySQL database. But it is giving me error as "ERROR 1130: Host '' is not allowed to connect to this MySQL server"...
Yes it is working fine.
i got solution as : mysql> CREATE TABLE "test" (col INT); ERROR 1064: You have an error in your SQL syntax... mysql> SET sql_mode='ANSI_QUOTES';...
what is the default escape character in MySQL? We have in ORACLE like ' " ', in MSSQL like ' [] ' which is used while creating table. MSSQL...
What is the default schema name in MySQL 5.1.34 like in ORACLE is username (system), in MSSQL is "dbo"? I think it is database name Isn't it?
Thanks pradeep answering my question. I solved the problem. As MySQL support "For Each Row" mechanisam, we get the directly the output which...
Yes, we can use the dual table but not like the Oracle. If we don't have any table reference then we can use dual in MySQL. like for arithmatic...
Exactly, I need to specify the table name here. I was asking for the table name to specify in my query like DUAL, INSERTED, DELETED in ORACLE,...
created table account : +----------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra |...
IS there any default table mysql server automatically creates and manages these tables like INSERTED, DELETED table in MSSQL, DUAL table in...
Hi, I have created a trigger which is giving me an error "ERROR 1415 (0A000): Not allowed to return a result set from a trigger": CREATE TABLE...
Separate names with a comma.