Recent Content by amit_27

  1. amit_27
    Thread

    Authentication errror on Solaris 10 for MySQl 5.1 version.

    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...
    Thread by: amit_27, Sep 7, 2009, 0 replies, in forum: MySQL
  2. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    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...
    Post by: amit_27, Jul 2, 2009 in forum: MySQL
  3. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    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,...
    Post by: amit_27, Jun 17, 2009 in forum: MySQL
  4. amit_27
    Thread

    Default How to get Table schema information ?

    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...
    Thread by: amit_27, Jun 12, 2009, 1 replies, in forum: MySQL
  5. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    How do I get the Parameter information of table? I have table like mysql> desc account;...
    Post by: amit_27, Jun 12, 2009 in forum: MySQL
  6. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    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...
    Post by: amit_27, Jun 11, 2009 in forum: MySQL
  7. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    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';...
    Post by: amit_27, Jun 11, 2009 in forum: MySQL
  8. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    Resolved the problem. Thanks Pradeep for answering me.
    Post by: amit_27, Jun 4, 2009 in forum: MySQL
  9. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    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...
    Post by: amit_27, Jun 4, 2009 in forum: MySQL
  10. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    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"...
    Post by: amit_27, Jun 4, 2009 in forum: MySQL
  11. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    Yes it is working fine.
    Post by: amit_27, May 27, 2009 in forum: MySQL
  12. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    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';...
    Post by: amit_27, May 27, 2009 in forum: MySQL
  13. amit_27
    Post

    IS there any MySQL Default tables like DUAL in ORACLE.

    what is the default escape character in MySQL? We have in ORACLE like ' " ', in MSSQL like ' [] ' which is used while creating table. MSSQL...
    Post by: amit_27, May 27, 2009 in forum: MySQL
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice