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
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
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 first result
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 List
For list
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 idea how I could
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
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
then be easily
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
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.
For example, in InnoDB, what you get returned from
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, what you get returned from
SHOW FULL COLUMNS is not what you stored
:
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}',
parent_id INT comment '{com: the foreing key}',
INDEX par_ind (parent_id),
FOREIGN KEY
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 Server
Upscene Productions
http://www.upscene.com
My thoughts:
http
Hi,
The thing is you want to add comments to column, which is presently null,
as per SHOW FULL COLUMNS FROM table;
Then add COMMENT 'your comment for the column name' , for the columns
you want comments.
For Instance,
mysql create table test
(topic varchar(10)default null
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 select distinct Column_name from columns_priv
where Db
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 MySQL manual
?
[ 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 problem.
Funny that the keywords were in my
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 :
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
1063
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 :
Field
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
http://www.eweek.com/article2/0,1895,1926600,00.asp
Specifically on referential integrity issues raised in the article.
Regards
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 being misused
by InnoDB
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 changed before the final 5.0 release.
comment is next
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 changed before the final 5.0 release.
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 changed before the final 5.0 release
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 release.
This is fixed in 5.0.13
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 hope it will be changed before the final 5.0 release
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]
: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: http://lists.mysql.com/mysql
To unsubscribe
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
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 from
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, and display
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 Description:
Brandon If an innodb table is created with a comment
-
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]
Subject: comment with foreign key text causes innodb CREATE
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 MySQL-4.0.4-beta-win
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 SELECT | mysql
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)
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 [EMAIL
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
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 command without
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 capabilities to user
, 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
capabilities to user interface items such as menus
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 number on
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
, 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,mypass,mydb,3306,null,0,From page
.phtml on server X
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
connection id which could be returned
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. This would be helpful for hosters
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.
AB Yes!! Great idea. This would be helpful
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.
On a typical web site running Apache/PHP/MySQL, the sequence would
have to be, I
= 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 returning data
to a Windows
this requested comment field in the
JF same consistent manner, unless you are
JF asking for more riders/piggybacks and more fields
JF in the wire protocol such as user agent.
Nothing new in the communication protocol.
A new field
= 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. Read my previous email.
JF Question: Why, again, do you want
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 experience, you usually don't care much
SH
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 and the DNS resolves to 12345.nasty.net.
I just would not have thought about
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
connecting to Mysql. mysqladmin processlist could show this
comment and this may
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
.
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 ?
Regards,
Alex
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 to find from where a given query/connection comes from
of this.
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??
Does that mean that you create a bunch
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/manua
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
Thanks,
David
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 and setup a datatype for comment column that
has
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 do co
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 was wonde
-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'
-Original Message-
From: Sasha Pachev [EMAIL
64 matches
Mail list logo