![]() |
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| MySQL DevZone RSS MySQL Developer Zone RSS |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Detection Theory: Signature Versus Anomaly Detection | iBot | IT Security RSS | 0 | 11-29-2008 03:40 AM |
| MySQL University - Training on MySQL Development & Internals | iBot | Solaris BigAdmin RSS | 0 | 11-12-2008 09:10 AM |
| MySQL Workbench for Database Change Management | iBot | MySQL DevZone RSS | 0 | 09-09-2008 10:31 AM |
| mysql would not start: missing mysql.sock | xnightcrawl | UNIX for Advanced & Expert Users | 2 | 05-26-2006 10:06 AM |
| MySQL problem >> missing mysql.sock | _hp_ | UNIX for Advanced & Expert Users | 8 | 11-03-2002 02:44 PM |
![]() |
|
|
LinkBack | Thread Tools | Search this Thread |
Rating:
|
Display Modes |
|
||||
|
Thanks. I got the information from INFORMATION_SCHEMA COLUMNS.
While retrieving the data from the result of query I faced following problem. mysql> select select COLUMN_NAME, DATA_TYPE, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION from INFORMATION_SCHEMA.COLUMNS where table_name='account'); In coding I run the query using mysql_real_query() whose result is stored in pResult = mysql_store_result(pMySQLDB); fields = mysql_fetch_field(pResult); my_ulonglong noOfRows = mysql_num_rows(pResult); row = mysql_fetch_row(pResult); it will not return any rows. But in fields I get select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION that I don't want. I want the value of these field like "amit, "MY_VAR_STRING", '10', '0'. I want to store these data inot another variable however not getting it. Can you please tell me how do I fetch the data what I want from the query output or I am doing anything wrong? |
|
||||
|
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, m_errorHandle); It will return &datatype value for: VARCHAR2 - 1 NUMBER - 2 Date - 12 How do we achieve this in MYSQL 5.1? I saw in manual but not found any pointer. There is no any point described for native data types value. |
|
||||
|
I recommend that you open a new topic for every issue you are facing, because that will give people a better understanding of how to help you. If there are multiple issues in each thread, that makes it hard to understand and resolve the latest issue.
|
|
||||
|
Ok. I will create new thread.
|
| Sponsored Links | ||
|
|