473,320 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

COMMENTS in columns

Hi,

The MySQL SQL syntax allows COMMENTS to be added while creating columns and tables.
In the manner of Access, one could expect to retreive these comments in the REMARKS
field when calling SQLColumns() in the ODBC driver.
However, this field alwas comes back empty, whatever comments were given when the columns
were created.

--
_______________________________________

(Please send any spam to this address: pi*******@internetique.com)
Thanks.
Jul 20 '05 #1
1 1523
Same problem with comments in tables, except that here the REMARK field is always returned as "MySQL table",
not really useful actually ;-)

--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/cus...s/tagstore.cfm
(Please send any spam to this address: pi*******@internetique.com)
Thanks.
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Claude Schneegans | last post by:
Hi, The MySQL SQL syntax allows COMMENTS to be added while creating columns and tables. In the manner of Access, one could expect to retreive these comments in the REMARKS field when calling...
0
by: Jonathan | last post by:
In the organisation where I work we currently have a public sanitised version of our existing HR personnel database. This is very widely used as the main source of employee info by many internal...
4
by: www.Search24-7.com | last post by:
I am working on a project site. The url is www.search24-7.com. I am looking for feedback (both negative and positive). I am new here and want to learn ways to drive traffic, improve my rank etc....
28
by: Benjamin Niemann | last post by:
Hello, I've been just investigating IE conditional comments - hiding things from non-IE/Win browsers is easy, but I wanted to know, if it's possible to hide code from IE/Win browsers. I found...
4
by: Greg G | last post by:
This is just a personal photo site I've been cobbling together in my spare time. It's still very much unfinished. Once you get away from the home page youll see a navigation panel on the side. My...
0
by: Alice Bag | last post by:
groovy feature request: I think comments on COLUMNs should be inherited from the "parent" table when the "child" table is created. If you make use of inheritance, this would be a big time...
3
by: Dirk Deimeke | last post by:
Hello, I need help generating a sql statement for showing columns and comments of a table. Something like: db2 select columname,comment from dontknow where tablename='table' Thanks for...
1
by: Brett Magill | last post by:
Hello all, Looking for some help here. BTW, to e-mail me directly, should you prefer, take the *nomail*. out the reply address. I uploaded data from another program ( GNU R-2.2.0 @...
1
by: dhall5 | last post by:
Hi everyone, My company advertises "not off the shelf" programming and what we provide can be fit to each clients needs. With that the biggest goal I have is to have the 80% of what everyone...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.