C++ comment in binary_log_types.h header

Hi all, In version 5.7.10, I found a C++ comment in the .h headers: #endif // __cplusplus Should be: #endif /* __cplusplus */ To avoid: cc -g -fsanitize=address -fno-omit-frame-pointer -W -Wall -pedantic -Wmissing-prototypes \ -Wno-long-long -Werror -fPIC \ -I/opt3/dbs/mys/5.7

CREATE VIEW COMMENT ''

To endow CREATE VIEW with COMMENT would be splendid. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: how to select total votes for each comment?

On Wed, 05 Mar 2008 09:29:03 +0100, Sebastian Mendel wrote: > SELECT > comments.content, > SUM(votes.votes) > FROM > comments > LEFT JOIN > votes > ON > comments.id = votes.comment_id > GROUP BY > comments.id Interesting :) -Thufir -- MySQL General Mailing Lis

Re: how to select total votes for each comment?

Patrick Aljord schrieb: Hey all, I have comments(id,content) and votes(comment_id,vote). vote is a tinyint. I would like to select total votes for each comment, I tried: "select content, sum(v.votes) from comments c left join votes v on c.id=v.comment_id" but it only returns fi

how to select total votes for each comment?

Hey all, I have comments(id,content) and votes(comment_id,vote). vote is a tinyint. I would like to select total votes for each comment, I tried: "select content, sum(v.votes) from comments c left join votes v on c.id=v.comment_id" but it only returns first result obviously, any

Trigger COMMENT question

Hey all, Is there any way to add a COMMENT to a trigger like for a stored proc. Ideally it would be the same mechanism like for the stored proc but other options are welcome too. I basically need this for a tool that I am writing that outputs everything about a database that is available (schemas

Re: using column "comment" to store metadata

s (maybe the behaviour is version > dependent?). Hmm, could be. I remember all sorts of information being returned in the COMMENTS section, all that was different from my actual comment :-) Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL

Re: using column "comment" to store metadata

ndent?). Here is what I did: CREATE TABLE parent ( id INT NOT NULL comment '{"com": "the primary key of the parent."}', PRIMARY KEY (id) ) ENGINE=INNODB; CREATE TABLE child ( id INT comment '{"com": "the primary key"}',

Re: using column "comment" to store metadata

> > > Do you have any comments about this approach? > > > What could possibly go very bad about relying on > > > this usage of the COMMENT? > > > > Yes, in different storage engines, different stuff is returned. > > > > For example, in InnoDB,

Re: using column "comment" to store metadata

On 9/17/07, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > Do you have any comments about this approach? > > What could possibly go very bad about relying on > > this usage of the COMMENT? > > Yes, in different storage engines, different stuff is returned. > >

Re: using column "comment" to store metadata

Hi, > I'm thinking of using the "COMMENT" of columns when > creating tables to store some metadata about the > column, for instance: valid_range of numbers, > validation regexp, etc. > > I did some tests with including this information as > a JSON (JavaScri

using column "comment" to store metadata

Hi, I'm thinking of using the "COMMENT" of columns when creating tables to store some metadata about the column, for instance: valid_range of numbers, validation regexp, etc. I did some tests with including this information as a JSON (JavaScript Object Notation) string which can

Re: revoke SELECT on a column [ MySQL 4.1 ] + column "Comment"

Hi, The thing is you want to add "comments" to column, which is presently null, as per SHOW FULL COLUMNS FROM ; Then add " COMMENT 'your comment for the column name' ", for the columns you want comments. For Instance, mysql> create table test

Re: revoke SELECT on a column [ MySQL 4.1 ] + column "Comment"

QUESTION concerns column "Comment" In MySQL 5, I can do : mysql> select column_name,COLUMN_COMMENT from information_schema.columns where table_schema="a_base" and table_name='a_tab'; in MySQL 4.1 , the "equivalent" would be : mysql>

Re: question+comment : Re: set "DEC" as a column name : forbidden

Hi Gilles, I search in the manual with "ERROR 1064", and then get the page : http://dev.mysql.com/doc/refman/4.1/en/error-messages-server.html Error: 1064 SQLSTATE: 42000 (ER_PARSE_ERROR) Message: %s near '%s' at line %d I cannot figure out what is wrong from this info, whereas error code 106

Re: question+comment : Re: set "DEC" as a column name : forbidden

Hello again Paul, 1-Why the error code (1064) can't lead explicitly to the syntax problem ? I'm sorry, I don't understand the question. The mysql command returned the error code [ ERROR 1064 (42000) ] I search in the manual with "ERROR 1064", and then get the page : http://dev.mysql.com/do

Re: question+comment : Re: set "DEC" as a column name : forbidden

e relevant page ? [ Hard for you to feel like a lambda user in MySQL ] It sounds like you mean, "When I have a problem, how can I instantly find the solution?" I don't think I can answer that. my comment : The "Search the MySQL manual" works when you know where is the p

question+comment : Re: set "DEC" as a column name : forbidden

Thank you Paul DuBois. I have 2 questions for you : 1-Why the error code (1064) can't lead explicitly to the syntax problem ? 2-Could you tell me how I could go directly to the relevant page ? [ Hard for you to feel like a lambda user in MySQL ] my comment : The "Search the My

describe table : comment (some progress done, but...)

hello, I run MySQL 4.1.11 [ available for Linux Debian stable ]. and now, ok, the following command display 9 columns : mysql> SHOW FULL COLUMNS FROM a_table; Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment BUT now I would just display 2 columns : Fi

Any comment to this article from the LIST?

Dear List, Does anyone can offer any comments on: "Oracle Gives MySQL a Raspberry for Valentine's Day" http://www.eweek.com/article2/0,1895,1926600,00.asp Specifically on referential integrity issues raised in the article. Rega

Re: Federated engine and "comment"???

Hello Jim, > On Wed, Sep 21, 2005 at 12:23:57PM +0200, Martijn Tonies wrote: > > Did I just see in the documentation that the "comment" clause > > is being misused to supply a connection string for the federated > > engine? > > > > If so, I sure h

Re: Federated engine and "comment"???

On Wed, Sep 21, 2005 at 12:23:57PM +0200, Martijn Tonies wrote: > Did I just see in the documentation that the "comment" clause > is being misused to supply a connection string for the federated > engine? > > If so, I sure hope it will be changed before the final 5.0 r

Re: Federated engine and "comment"???

> > On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > > > Hi there, > > > > > > Did I just see in the documentation that the "comment" clause > > > is being misused to supply a connection string for the federated > > > eng

Re: Federated engine and "comment"???

> On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > > Hi there, > > > > Did I just see in the documentation that the "comment" clause > > is being misused to supply a connection string for the federated > > engine? > > > > If

Re: Federated engine and "comment"???

On Wednesday 21 September 2005 11:23, Martijn Tonies typed: > Hi there, > > Did I just see in the documentation that the "comment" clause > is being misused to supply a connection string for the federated > engine? > > If so, I sure hope it will be chang

Federated engine and "comment"???

Hi there, Did I just see in the documentation that the "comment" clause is being misused to supply a connection string for the federated engine? If so, I sure hope it will be changed before the final 5.0 release. "comment" is next to useless like this. It's already b

General-list comment

Is there a problem with the mysql-general list? I haven't had any messages? Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: In which version of MySQL was ADD COMMENT added

0, 2003 11:42 PM Subject: In which version of MySQL was ADD COMMENT added > Hello > > Can somebody tell me the exact version of MySQL from > which the functionality of adding COMMENTS to columsn > was added. > > Karam -- MySQL General Mailing List For list archives:

In which version of MySQL was ADD COMMENT added

Hello Can somebody tell me the exact version of MySQL from which the functionality of adding COMMENTS to columsn was added. Karam __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailin

Re: Column comment / metadata tables

> Basically, what I would like to do is associate a human readable label with > each column (in the comment field) so that I can automatically generate > web-based forms for any given table. The script would look at the column's > metadata, display the appropriate HTML element

Column comment

would like to do is associate a human readable label with each column (in the comment field) so that I can automatically generate web-based forms for any given table. The script would look at the column's metadata, display the appropriate HTML element, and display the corresponding label read fro

comment with "foreign key" text causes innodb CREATE TABLE failure

Hi! >>>>> "Brandon" == Brandon Bird <[EMAIL PROTECTED]> writes: Brandon> From: [EMAIL PROTECTED] Brandon> To: [EMAIL PROTECTED] Brandon> Subject: comment with "foreign key" text causes innodb CREATE TABLE Brandon> failure Brandon> Descr

Re: comment with "foreign key" text causes innodb CREATE TABLE failure

- From: ""Brandon Bird"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, March 15, 2003 12:36 AM Subject: comment with "foreign key" text causes innodb CREATE TABLE failure > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Su

comment with "foreign key" text causes innodb CREATE TABLE failure

From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: comment with "foreign key" text causes innodb CREATE TABLE failure Description: If an innodb table is created with a comment with the words "foreign key", the table creation fails. The syntax used to work with MySQ

Replication comment

Just out of comment ... couldn't (shouldn't?) MySQL's replication been set up as a seperate process altogether from the server process? Replication *could* be done in its present form (afaict) by running something like: tail --follow=name --retry -n0 query_log | grep -v

RE: SQL Lists comment

To the MySQL group!Happy 2003 and have a safe holiday season... Hopefully this got past the filter LOL Chuck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: MySQL and Service Pack 3 - OT comment

This might explain how I lost my secondary IDE controller. I just unistalled SP3 to resolve my issue. On Thu, 29 Aug 2002, =?ISO-8859-1?Q?Iikka_Meril=E4inen?= wrote: > Date: Thu, 29 Aug 2002 23:10:06 +0300 (EEST) > From: =?ISO-8859-1?Q?Iikka_Meril=E4inen?= <[EMAIL PROTECTED]> > To: Marc Hus <[

COMMENT For tables

Hi all, I would like to confirm that MySQL only allows putting COMMENT in TABLE LEVEL but not in COLUMN LEVEL. Am I right? Regards, Michael --- Michael Tam - NFI

Comment-parsing bug in MySQL

>Description: Single quotes (') in comments may cause syntax errors. >How-To-Repeat: Run this MySQL code from a file, including the comment (running from the MySQL shell will also expose the bug, but you will not be able to complete the comm

Re: MySQLGUI Version 1.7.5 Question and Comment

help file and didn't >find any mention of these two menu entries, and when I select them nothing seems to >happen. What is the purpose of these menu items and shouldn't they at least give me >an "Info" message when I select them? > > My comment or suggestion i

MySQLGUI Version 1.7.5 Question and Comment

tion of these two menu entries, and when I select them nothing seems to happen. What is the purpose of these menu items and shouldn't they at least give me an "Info" message when I select them? My comment or suggestion is that the help needs to have a section relating functional

Re[5]: Proposition: Attach a comment to each connection

Do you know - would that be of any help? 23.2 The Query Log If you want to know what happens within mysqld, you should start it with --log[=file]. This will log all connections and queries to the log file (by default named `'hostname'.log'). This log can be very useful when you suspect an error

Re[5]: Proposition: Attach a comment to each connection

WS>> Oh, I see, you would like to connect this information with the WS>> pid, right? I wouldn't know how to do that. How do you get a pid? WS>> Is this something MySQL could provide? > No, not with the pid. > With the number of places from where sql queries are executed and > the numb

Re: Proposition: Attach a comment to each connection

sing the ten MySQL servers. If I had felt this need, I probably would have just added another field to the schema of a "sensitive" table, and had my apps write in a comment, like, for a shopping cart, "The guy using this credit card has IP so-and-so, and his user agent is so-and-so a

Re[2]: Proposition: Attach a comment to each connection

Bonjour Scott, SH> Beyond that, you can already accomplish 90% of what you'd want by SH> simply coding your queries as "/* Comment */ SELECT ...", and so SH> on. For connections which are not currently running a query, this SH> won't work - but in my ex

Re[2]: Proposition: Attach a comment to each connection

nged, however. JF> id = do_a_connedtion(arg) JF> set_comment_on_connection(id, "this_is_my_comment") JF> // later JF> some_array = get_connection_comments() JF> // parse the array comments JF> // do something or other as function of comment Not even have to modify the API.

Re[2]: Proposition: Attach a comment to each connection

ry would be empty or maybe any default information. You would not HATE TO give a commentary. JF> 4. Depending on all programs to stick data in JF> this requested "comment" field in the JF> same consistent manner, unless you are JF>

RE: Proposition: Attach a comment to each connection

Dropping into the thread late, but two points: For all of the standard reasons, different database clients should use different usernames. In the limit, you could just make the username contain the comment. Beyond that, you can already accomplish 90% of what you'd want by simply coding

Re: Proposition: Attach a comment to each connection

// later some_array = get_connection_comments() // parse the array comments // do something or other as function of comment Question: Why, again, do you want this? You must see some utility in this other than academic interest, or taking statistics, or mischief, such as munging some field returni

Re: Proposition: Attach a comment to each connection

hese "nice" things in the exchange connection handshake? What is the "idea" of the "user agent" in this case? I suppose what is meant is that the thinking is that this "comment" field in the wire protocol would be loaded up with whatever the API wanted. O

Re[6]: Proposition: Attach a comment to each connection

>> The only thing I would like is to be able to attach a comment to a >> connection id which could be returned by the "mysqladmin process" >> command. And something that would not add more load to Mysql nor >> more coding in the client. A

Re: Re[4]: Proposition: Attach a comment to each connection

> The only thing I would like is to be able to attach a comment to a > connection id which could be returned by the "mysqladmin process" > command. And something that would not add more load to Mysql nor > more coding in the client. Yes!! Great idea. Thi

Re[4]: Proposition: Attach a comment to each connection

ith the number of places from where sql queries are executed and the number on different queries, it's not always easy to find from where a query, which is for example locking Mysql, as been executed. The only thing I would like is to be able to attach a comment to a connec

Re[3]: Proposition: Attach a comment to each connection

real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned int client_flag, char *comment) Which could be use like : mysql_real_connect(&mysql,"myserver.com","me",&quo

Re[3]: Proposition: Attach a comment to each connection

> Am I naive or is this a viable proposition? Oh, I see, you would like to connect this information with the pid, right? I wouldn't know how to do that. How do you get a pid? Is this something MySQL could provide? -- Herzlich Werner Stuerenburg

Re[2]: Proposition: Attach a comment to each connection

applications ... connecting to Mysql, it's sometimes >> > > difficult to find from where a given query/connection comes from. >> > > And it's sometimes urgent to find the origin of a disturbing query. >> > > >> > > So, I think it

Re: Proposition: Attach a comment to each connection

x27;s sometimes > > > difficult to find from where a given query/connection comes from. > > > And it's sometimes urgent to find the origin of a disturbing query. > > > > > > So, I think it would be great to be able to give a comment when &g

Re: Proposition: Attach a comment to each connection

. D'Arcy - Original Message - From: "Siomara Pantarotto" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 02, 2001 1:52 PM Subject: Re: Proposition: Attach a comment to each connection > descriptive usernames??

Re: Proposition: Attach a comment to each connection

TECTED]> >To: <[EMAIL PROTECTED]> >Subject: Re: Proposition: Attach a comment to each connection >Date: Mon, 2 Jul 2001 13:42:42 -0400 > >I do this by using a whole bunch of descriptive usernames. It is more work >than your idea, but you could use this method for n

Re: Proposition: Attach a comment to each connection

]> Sent: Monday, July 02, 2001 11:38 AM Subject: Proposition: Attach a comment to each connection > Bonjour, > > When you have a big web site with a lot of pages, programs, > cronjobs, applications ... connecting to Mysql, it's sometimes > difficult

Proposition: Attach a comment to each connection

bing query. So, I think it would be great to be able to give a comment when connecting to Mysql. "mysqladmin processlist" could show this comment and this may be really helpful in some situations ! As this already been discussed

Comment

When I have created a comment on a table with "create table . comment = 'this is a comment' How do I view the comment afterwards? ...Jesper - Before posting, please check: http://www.mysql.com/ma

Re: Antwort: Datatype for comment field

rom: [EMAIL PROTECTED] >To: "Nguyen, David M" <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Antwort: Datatype for comment field >Date: Wed, 7 Mar 2001 11:25:02 +0100 > > >On 06.03.2001 18:43:32 Nguyen, David M wrote: > > > I try to create a new table a

Antwort: Datatype for comment field

On 06.03.2001 18:43:32 Nguyen, David M wrote: > I try to create a new table and setup a datatype for comment column that has > about 7000 characters long. How do I define it in Oracle? That's the MySQL mailing list, you know No idea how to do stuff in Oracle. > > **Here

Datatype for comment field

I try to create a new table and setup a datatype for comment column that has about 7000 characters long. How do I define it in Oracle? **Here's my SQL and the error I got. SQL> create table test (comment varchar(7000)); ERROR ---> Character field too long Th

Re: Comment field of a table

Fethiye Akbulut ([EMAIL PROTECTED]) writes: > I would like to see if all the tables in my database have the "comment" > field equal to a given value. I understand that "show table status" command > is able to show us the "comment" field's value. I w

Comment field of a table

I would like to see if all the tables in my database have the "comment" field equal to a given value. I understand that "show table status" command is able to show us the "comment" field's value. I was wondering how we can extract only this field when we

Re: [DOCS COMMENT] Section 'TODO_MySQL_4.0'

-Original Message- From: Mr.Y.SHIVAKANT <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; Sasha Pachev <[EMAIL PROTECTED]> Date: Thursday, January 04, 2001 8:48 PM Subject: Re: [DOCS COMMENT] Section 'TODO_MySQL_4.0' > >-Origina

[DOCS COMMENT] Section 'CREATE_TABLE'

The following comment was submitted to the MySQL Manual. - From: Ilia Lobsanov <[EMAIL PROTECTED]> Regarding: http://www.mysql.com/manual.php?section=CREATE_TABLE Would be nice if the DEFAULT parameter acce