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/include \ mys.c -o mys_5_7.o In file included from /opt3/dbs/mys/5.7/include/mysql_com.h:22:0, from /opt3/dbs/mys/5.7/include/mysql.h:58, from mys.c:41: /opt3/dbs/mys/5.7/include/binary_log_types.h:68:8: error: C++ style comments are not allowed in ISO C90 [-Werror] #endif // __cplusplus */ Seb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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?
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 obviously, any idea how I could do this? did you tried in your mysql console? please add the output here and add GROUP BY - this is required by SQL standard SELECT comments.content, SUM(votes.votes) FROM comments LEFT JOIN votes ON comments.id = votes.comment_id GROUP BY comments.id -- Sebastian Mendel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 idea how I could do this? Thanks in advance, Pat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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,stored procs and functions, triggers) and the COMMENT option is nice to add some descriptive text Thanks Olaf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 then be easily decoded into an actual data structure for the scripting language (Python in my case) being used. The setup seems to work well. One shortcoming is that the maximum size of a COMMENT is 256 characters. Do you have any comments about this approach? What could possibly go very bad about relying on this usage of the COMMENT? I am currently using mysql 5.0.27-standard-log. Thanks in advance for your comments, Cheers, Ezequiel -- Ezequiel Panepucci -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 (JavaScript Object Notation) string which can then be easily decoded into an actual data structure for the scripting language (Python in my case) being used. The setup seems to work well. One shortcoming is that the maximum size of a COMMENT is 256 characters. 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 in the Comment part. In short, I would say that the use of COMMENT isn't what it actually does. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. For example, in InnoDB, what you get returned from SHOW FULL COLUMNS is not what you stored in the Comment part. I currently use MyISAM, but I just tried a simple create(InnoDB)/show full columns from/ and it actually does return the JSON strings I put in. In short, I would say that the use of COMMENT isn't what it actually does. No arguing here. Thanks for you comment. Ezequiel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, what you get returned from SHOW FULL COLUMNS is not what you stored in the Comment part. I currently use MyISAM, but I just tried a simple create(InnoDB)/show full columns from/ and it actually does return the JSON strings I put in. Try it on columns with a foreign key constraint. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: using column comment to store metadata
I currently use MyISAM, but I just tried a simple
create(InnoDB)/show full columns from/ and
it actually does return the JSON strings I put in.
Try it on columns with a foreign key constraint.
I did and it still works (maybe the behaviour is version
dependent?).
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}',
parent_id INT comment '{com: the foreing key}',
INDEX par_ind (parent_id),
FOREIGN KEY (parent_id) REFERENCES parent(id)
ON DELETE CASCADE
) ENGINE=INNODB;
mysql show full columns from parent;
+---+-+---+--+-+-+---+-+---+
| Field | Type| Collation | Null | Key | Default | Extra |
Privileges | Comment
|
+---+-+---+--+-+-+---+-+---+
| id| int(11) | NULL | NO | PRI | | |
select,insert,update,references | {com: the primary key of the
parent.} |
+---+-+---+--+-+-+---+-+---+
1 row in set (0.00 sec)
mysql show full columns from child;
+---+-+---+--+-+-+---+-++
| Field | Type| Collation | Null | Key | Default | Extra |
Privileges | Comment|
+---+-+---+--+-+-+---+-++
| id| int(11) | NULL | YES | | NULL| |
select,insert,update,references | {com: the primary key} |
| parent_id | int(11) | NULL | YES | MUL | NULL| |
select,insert,update,references | {com: the foreing key} |
+---+-+---+--+-+-+---+-++
2 rows in set (0.00 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: using column comment to store metadata
I currently use MyISAM, but I just tried a simple create(InnoDB)/show full columns from/ and it actually does return the JSON strings I put in. Try it on columns with a foreign key constraint. I did and it still works (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 Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 COMMENT 'topic for the forum', title varchar(10) default null COMMENT 'title for the forum topic'); mysql show full columns from test\G *** 1. row *** Field: topic Type: varchar(10) Collation: latin1_swedish_ci Null: YES Key: Default: NULL Extra: Privileges: select,insert,update,references Comment: topic for the forum *** 2. row *** Field: title Type: varchar(10) Collation: latin1_swedish_ci Null: YES Key: Default: NULL Extra: Privileges: select,insert,update,references Comment: title for the forum topic 2 rows in set (0.01 sec) Hope Useful ! and Welcome for your interest. Thanks ViSolve DB Team. - Original Message - From: Gilles MISSONNIER [EMAIL PROTECTED] To: ViSolve DB Team [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, February 09, 2007 6:54 AM Subject: Re: revoke SELECT on a column [ MySQL 4.1 ] + column Comment Hello, thanks again to ViSolve DB Team. so, it turns out that for MySQL4.1, il will have to built a sql file, built with script (shell or perl). [ note that so far I use MySQL 4.1 on production server, and I only test features on MySQL 5 on an other machine linux Debian]. at last, my LAST 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='a_base' and Table_name='a_tab'; AND THERE IS NO COMMENT. but, from the page : http://dev.mysql.com/doc/refman/4.1/en/charset-show.html it seems that one could use Comment mysql SHOW FULL COLUMNS FROM a_tab; displays : Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | I cannot find how to set these Comment ? An idea ? thanks. -Gilles- On Thu, 8 Feb 2007, ViSolve DB Team wrote: Hi, The thing is, we cannot dynamically pass columnnames to GRANT or REVOKE statements through procedures from mysql. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: revoke SELECT on a column [ MySQL 4.1 ] + column Comment
Hello, thanks again to ViSolve DB Team. so, it turns out that for MySQL4.1, il will have to built a sql file, built with script (shell or perl). [ note that so far I use MySQL 4.1 on production server, and I only test features on MySQL 5 on an other machine linux Debian]. at last, my LAST 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='a_base' and Table_name='a_tab'; AND THERE IS NO COMMENT. but, from the page : http://dev.mysql.com/doc/refman/4.1/en/charset-show.html it seems that one could use Comment mysql SHOW FULL COLUMNS FROM a_tab; displays : Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment | I cannot find how to set these Comment ? An idea ? thanks. -Gilles- On Thu, 8 Feb 2007, ViSolve DB Team wrote: Hi, The thing is, we cannot dynamically pass columnnames to GRANT or REVOKE statements through procedures from mysql. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 MySQL manual works when you know where is the problem. Funny that the keywords were in my question to the list : DEC column name forbidden, but did not made sens to me to query with these word. first, I tried on the error code [ ERROR 1064 (42000) ] : not understandable to me. then I tried keyword DEC(matching all of the words) 2 pages : helpless then I tried keyword list 17 pages, off topics [ from excerpt ] - Now If you ask me why I used keyword DEC instead of reserved word the answer is right in the begining of the page : http://dev.mysql.com/doc/refman/4.1/en/numeric-types.html keyword DEC or reserved word DEC are the same !! for instance : The keyword INT is a synonym for INTEGER, and the keyword DEC is a synonym for DECIMAL. bla bla bla ... Regards. == On Tue, 30 May 2006, Paul DuBois wrote: At 15:46 +0200 5/30/06, Gilles MISSONNIER wrote: Hello I could not find the answer through the online Search the MySQL manual. I run MySQL 4.1 In the 4.1 manual, the reserved words are listed here: http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html DEC is in the list. Identifier-quoting guidance is here: http://dev.mysql.com/doc/refman/4.1/en/legal-names.html In astronomy, RA and DEC are widely used coordinate names. Then I try to add a column named DEC : mysql alter table my_table add dec float; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'dec float' at line 1 UPPER case lead to the same error. It seems that the reason is that DEC is a keyword standing for decimal. I do not understand why this cannot be allowed for a column name. Is there a turn around ? This is annoying ; I add to name the column as DECL which is much less meaning full in the astronomy community. thanks, =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question+comment : Re: set DEC as a column name : forbidden
At 17:38 +0200 5/31/06, Gilles MISSONNIER wrote: Thank you Paul DuBois. I have 2 questions for you : 1-Why the error code (1064) can't lead explicitly to the syntax problem ? I'm sorry, I don't understand the question. 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 ] 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 question to the list : DEC column name forbidden, but did not made sens to me to query with these word. first, I tried on the error code [ ERROR 1064 (42000) ] : not understandable to me. then I tried keyword DEC(matching all of the words) 2 pages : helpless then I tried keyword list 17 pages, off topics [ from excerpt ] - Now If you ask me why I used keyword DEC instead of reserved word the answer is right in the begining of the page : http://dev.mysql.com/doc/refman/4.1/en/numeric-types.html keyword DEC or reserved word DEC are the same !! No, not all keywords are reserved. The list at the bottom of http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html shows some examples. for instance : The keyword INT is a synonym for INTEGER, and the keyword DEC is a synonym for DECIMAL. bla bla bla ... Regards. == On Tue, 30 May 2006, Paul DuBois wrote: At 15:46 +0200 5/30/06, Gilles MISSONNIER wrote: Hello I could not find the answer through the online Search the MySQL manual. I run MySQL 4.1 In the 4.1 manual, the reserved words are listed here: http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html DEC is in the list. Identifier-quoting guidance is here: http://dev.mysql.com/doc/refman/4.1/en/legal-names.html In astronomy, RA and DEC are widely used coordinate names. Then I try to add a column named DEC : mysql alter table my_table add dec float; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'dec float' at line 1 UPPER case lead to the same error. It seems that the reason is that DEC is a keyword standing for decimal. I do not understand why this cannot be allowed for a column name. Is there a turn around ? This is annoying ; I add to name the column as DECL which is much less meaning full in the astronomy community. thanks, =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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/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 or 1065 are far more explicit. Why the error code (1064) is not telling : wrong usage of reserved word or something like this ? that could be linked to a page showing some exemple of what to do ? === 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 ] 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. I'm not so childish : just like to have more pieces, but smaller pieces, ORTHOGONAL, so that each could be adressed with appropriate search : you give me a perfect opportunity to explain my point : the following page DO exist : http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html but http://dev.mysql.com/doc/refman/4.1/en/keyword.html http://dev.mysql.com/doc/refman/4.1/en/keywords.html http://dev.mysql.com/doc/refman/4.1/en/keyword-words.html http://dev.mysql.com/doc/refman/4.1/en/keywords-words.html do not exist. also, why is there a keyword list in the reserved-words.html page ? this is not orthogonal. In what keyword and reserved-words differ ? also, the relevant point for me was : The identifier quote character is the backtick (`): And it is found on the same page telling about - maximum length, - Unicode, - ANSI_QUOTES SQL mode, - default character set - recommendation on naming == Hope not being asking too much. regards. -Gilles Missonnier - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 1063 or 1065 are far more explicit. Why the error code (1064) is not telling : wrong usage of reserved word or something like this ? that could be linked to a page showing some exemple of what to do ? If MySQL's parser could easily tell that you had used a reserved word in a place where it can't be used as such, they wouldn't need to be reserved words, would they? :) Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 : Field | Comment and ALSO modify the Comment column after it has been created ; the alter syntax do not seem to be the good way, I cannot figure out how to do that ... If the syntax is described somewhere in the documentation, well... it is somehow burried deep... cheers =_==_==_==_==_==_= =¯==¯==¯==¯==¯==¯= Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 http://www.eweek.com/article2/0,1895,1926600,00.asp Specifically on referential integrity issues raised in the article. Regards and thank you Mikhail Berman
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 being misused by InnoDB to describe the FK constraints... What's wrong with introducing a new clause? With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 changed before the final 5.0 release. comment is next to useless like this. It's already being misused by InnoDB to describe the FK constraints... What's wrong with introducing a new clause? The manual states: The use of COMMENT for specifying the connection string is non-optimal and will likely change in MySQL 5.1. Keep this in mind when you use FEDERATED tables, because it means you'll need to make some modifications when that happens. So I'd guess they know full well it's not the best way to do it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 changed before the final 5.0 release. comment is next to useless like this. It's already being misused by InnoDB to describe the FK constraints... Urm, where does it do that - my 4.1 server says CONSTRAINT `login_properties_ibfk_1` FOREIGN KEY (`prop_login_id`) REFERENCES `login_master` (`login_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `login_properties_ibfk_2` FOREIGN KEY (`ref_prop_name`) REFERENCES `login_properties_master` (`prop_name`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Properties for a login' nothing in the comment field about key constraints - or is that new in 5? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 changed before the final 5.0 release. comment is next to useless like this. It's already being misused by InnoDB to describe the FK constraints... Urm, where does it do that - my 4.1 server says CONSTRAINT `login_properties_ibfk_1` FOREIGN KEY (`prop_login_id`) REFERENCES `login_master` (`login_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `login_properties_ibfk_2` FOREIGN KEY (`ref_prop_name`) REFERENCES `login_properties_master` (`prop_name`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Properties for a login' nothing in the comment field about key constraints - or is that new in 5? show table status eg: InnoDB free: 10240 kB; (`card_id`) REFER `test/card`(`pkey`) ON DELETE NO ACTION ON UPDATE NO ACTION; (`card_id`) REFER `test/card`(`pkey`) ON DELETE NO ACTION ON UPDATE NO ACTION; (`trans_id`) REFER `test/trans`(`pkey`) ON DELETE NO ACTION ON UPDATE NO ACTION Where's my original comment, if any? All in all, bad! With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 release. This is fixed in 5.0.13, the documentation just hasn't caught up with the change yet. The new syntax is CONNECTION = '...'. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 hope it will be changed before the final 5.0 release. This is fixed in 5.0.13, the documentation just hasn't caught up with the change yet. The new syntax is CONNECTION = '...'. Great, that's much better :-) :-) With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
Hi Karam, Comments per *column* were added in 4.1.0. Comments per *table* were added in 3.23.0. http://www.mysql.com/doc/en/News-4.1.0.html http://www.mysql.com/doc/en/News-3.23.0.html Hope that helps. Matt - Original Message - From: Karam Chand Sent: Monday, November 10, 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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Column comment
Hi, I am aware of the fact that with 4.1.0, you can specify comments on a column by column by basis. I was wondering if this functionality could somehow be simulated in 4.0.x? It is high priority for me, but I cannot deploy the alpha stage 4.1.0 in a production environment. 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 the corresponding label read from the column field. Is there any way this can be accomplished with MySQL 4.0.12? Thanks, Ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, and display the corresponding label read from the column field. MySQL could do something that would make MySQL more complete and more able to satisfy these Codd rules: 0. A relational database must be able to manage databases entirely through its relational capabilities. 1. The Information Rule. All information in a relational database (including table and column names) is represented explicitly as values in tables. The metadata would be loaded into tables (real, virtual, heap or temporary?). It would be refreshed as necessary by mysqld, when processing ALTER, DROP, CREATE, etc. Normal SELECTs would be used to efficiently view those metadata tables. Why should it be necessary for tools such as MySQLfront to use?: SHOW TABLE STATUS, SHOW FIELDS FROM table, SHOW KEYS FROM table. Thanks, Stephen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Description: Brandon If an innodb table is created with a comment with the words foreign Brandon key, the table creation fails. cut Just a short note about this. Currently the InnoDB table handler scans the CREATE statement and handles the foreign key definition infernally in InnoDB. In 4.1 MySQL will handle the parsing of the foreign key definition and will store the foreign key definitions in the normal table definition file. This will fix these kind of problems once and for all. Regards, Monty -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: comment with foreign key text causes innodb CREATE TABLE failure
Brandon, thank you for the bug report. I will try to fix this in 4.0.xx. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query - Original Message - 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 TABLE failure Description:=09 If an innodb table is created with a comment with the words foreign key, the table creation fails.=20 The syntax used to work with MySQL-4.0.4-beta-win and earlier, running on both Linux and Windows. This query (missing the comment) executes successfully: CREATE TABLE a(a INT) TYPE=3Dinnodb; I consider this bug pretty important since many of our existing scripts use this style of comments. How-To-Repeat:=09 Execute this query: CREATE TABLE a(a INT /* foreign key */) TYPE=3Dinnodb; =20 You'll get this output: ERROR 1005: Can't create table '.\a\a.frm' (errno: 150)=09 Fix:=09 Change the /* foreign key */ comment in all database scripts. foreign-key works. Synopsis: comment with foreign key text causes innodb table creation failure Submitter-Id:=09 Originator: Brandon Bird Organization: Pacer/CATS MySQL support: none Severity: serious Priority:=09 Category: mysqld Class: sw-bug Release: mysql-4.0.11 Exectutable: mysqld-max-nt=20 Environment: dell 4400; ntfs System:WinXP Compiler: =20 Architecture: i - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 MySQL-4.0.4-beta-win and earlier, running on both Linux and Windows. This query (missing the comment) executes successfully: CREATE TABLE a(a INT) TYPE=innodb; I consider this bug pretty important since many of our existing scripts use this style of comments. How-To-Repeat: Execute this query: CREATE TABLE a(a INT /* foreign key */) TYPE=innodb; You'll get this output: ERROR 1005: Can't create table '.\a\a.frm' (errno: 150) Fix: Change the /* foreign key */ comment in all database scripts. foreign-key works. Synopsis: comment with foreign key text causes innodb table creation failure Submitter-Id: Originator: Brandon Bird Organization: Pacer/CATS MySQL support: none Severity: serious Priority: Category: mysqld Class: sw-bug Release:mysql-4.0.11 Exectutable: mysqld-max-nt Environment: dell 4400; ntfs System:WinXP Compiler: Architecture: i - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 SELECT | mysql
{servername}
Correct?
If setting up a semi-automated version of this pipe is all it requires
to do replication (a few greps and pipes), then writing such a program
would allow for multi-to-multi replication (for example).
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL and Service Pack 3 Hello, Reinstall your MySQL service using mysqld((-max)-nt) --install SP3 somehow manages to remove the service registration in some cases. Regards, Iikka On Thu, 29 Aug 2002, Marc Hus wrote: Hello, I have a very strange problem with all of the Windows versions of MySQL. I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will not work period. Has anyone ran into this problem and or know of a fix? Marc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Database Developer Natural Resources Canada [EMAIL PROTECTED] Pacific Forestry Center Phone: (250) 383-8074 506 West Burnside Road Fax: (250) 363-0775 Victoria, BC V8Z 1M5 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 command without
supplying a second quote):
/* MySQL's handling of comments is kind of flaky. */
SELECT * FROM MYTABLE;
Fix:
Work around the problem by not using the apostrophe character (')
in the comments of MySQL code.
Originator:Godless Infidel
MySQL support: none
Synopsis: Single-quotes in comments cause problems.
Severity: non-critical
Category: mysql
Class: sw-bug
Release: mysql-3.23.51 (Official MySQL Binary)
Environment:
System: Linux devnull 2.4.7-10custom #1 Wed May 1 13:07:29 EST 2002 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs
-Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings
-Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts
-Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual
-Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors
-fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 May 2 17:07 /lib/libc.so.6 - libc-2.2.4.so
-rwxr-xr-x2 root root 1285788 Apr 2 11:58 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27332668 Apr 2 11:42 /usr/lib/libc.a
-rw-r--r--1 root root 178 Apr 2 11:42 /usr/lib/libc.so
lrwxrwxrwx1 root root 10 May 24 19:56 /usr/lib/libc-client.a -
c-client.a
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler
--with-extra-charsets=complex --enable-thread-safe-client
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary'
--prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client
--enable-local-infile 'CFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment
-W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused
-mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type
-Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses
-Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder
-Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti
-mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLGUI Version 1.7.5 Question and Comment
Marion Berryman writes: I've been trying out MySQLGUI Version 1.7.5, and it seems to work fine on my Win 98SE client. I do have a question about the menu entries under Commands, Tables for Edit table and Create tables. I've searched through the 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 is that the help needs to have a section relating functional capabilities to user interface items such as menus and mouse actions. I really liked your program, but it wasn't so easy to decipher how to operate the user interface, which I thought was clean and useful once I begin to see how things worked. Something along the lines of a short How-To list would be useful. Or, one could make a list of all user interface items with a description of what they do. Thank you for your consideration. Marion Berryman [EMAIL PROTECTED] Edit table is 50 % over and Create table is on TODO. And yes, our help system should be better. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLGUI Version 1.7.5 Question and Comment
I've been trying out MySQLGUI Version 1.7.5, and it seems to work fine on my Win 98SE client. I do have a question about the menu entries under Commands, Tables for Edit table and Create tables. I've searched through the 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 is that the help needs to have a section relating functional capabilities to user interface items such as menus and mouse actions. I really liked your program, but it wasn't so easy to decipher how to operate the user interface, which I thought was clean and useful once I begin to see how things worked. Something along the lines of a short How-To list would be useful. Or, one could make a list of all user interface items with a description of what they do. Thank you for your consideration. Marion Berryman [EMAIL PROTECTED] __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 number on different queries, it's not always easy to find from where a query, which is for example locking Mysql, as been executed. Where do you find this locking query? I have seen a mysql process staying for a long time and wondered what this might be. In this case I only have the pid and no idea which domain and program may have started this. It would really help here to be able to track the process down, as I have no means to find out what that thing does. If I know a query, I search for the query string. If this string is not generated, I have good chances to find it in the code. If mysql reports an error, I send myself an email with the error code. Example: Sender: [EMAIL PROTECTED] Errno: 1030, Error: Got error 127 from table handler, query: Invalid SQL: SELECT * FROM sessData WHERE sid = '5235'; URI: REFERER: This is no problem and built into the class. So I can search for this string in my code. I never had a case where I could not find the appropriate code piece. BTW, I am struggling with this kind of error quite a lot. As a rule, the index got wrong. So I stop writing session data, repair the table, check that it is ok and reenable session writing. After some time, I get this error again. I tried INSERT DELAYED to cope with this, but this doesn't work for sessions, as session data has to be there instantly. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 in a client and want to know exactly what mysqld thought the client sent to it. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[3]: Proposition: Attach a comment to each connection
Bonjour Werner, My web site as a lot of hits (really!), it's load balanced on the web side on more than 30 servers. I've to save database load as much as possible. The problem with your implementation is that it needs at least one more insert query for each page or even more if there are more than one query on the page. Web pages (PHP) are not the only things doing queries on my Mysql servers. There are a lot of cronjobs in Perl or C which are recording data, doing some maintenance and that from many machines. Implementing recording a query log like the one you described would generate really to much queries and would ask a lot of work. What I though was to had an information in Mysql on it's clients connection. For example, we could add one more parameter to mysql_real_connect : MYSQL *mysql_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,mypass,mydb,3306,null,0,From page .phtml on server X); Mysql would keep in memory, with other data about that connection, the comment From page .phtml on server X. Then mysqladmin process would return : +--+---+-+--+-+--+---+-+-+--+ | Id | User | Host| db | Command | Time | State | Comment | | Info | +--+---+-+--+-+--+---+---+--+ | 1405 | me| xxx.xxx.xxx.xxx | mydb | Query | 3| | From page |.phtml on server X | SELECT FORM ... | | 5973 | root | localhost | | Query | 0| | | | show processlist | +--+---+-+--+-+--+---+---+--+ This would be really helpful, in my opinion not to hard to implement in Mysql and easy to use from the client. This would not use much memory (only a string for each connection which number is limited) and would not ask more work to Mysql and the server. Regards, Alex. WS How about tracking your own record until then? Create a table and WS insert a record for each connection. WS If you would use a class to connect like db_mysql.inc from WS PHPLIB, it would be a snap to implement. From php, you know all WS sorts of variables to identify your general setting. WS I assume that the query itself will identify the job quite WS easily, so you use that in a text field to track your query. WS The Link-ID would identify your connection, which would be a WS permanent connection most probably. I think that this is what you WS call process, right? WS If you don't need all that information, just drop some of that. WS The table will grow pretty big very fast, if you record all WS connections, but so what? Any tracking record is of that kind, WS and Apache does well recording all hits, so this should't be much WS of a problem. WS You might as well normalize your table to get the most out of it. WS If you invest a little more work or don't work with a class, you WS would introduce, say two parameters, file name and line number, WS and go through all your code and supplement the queries with this WS information (and wirte a wrapper function for it, in case of no WS class, to issue the query and record the data). WS It is a one time work. Then you would have no problem finding out WS where any query comes from. WS This is exactly the kind of information you might be interested WS in, which MySQL cannot provide by itself, AFAICS. WS Am I naive or is this a viable proposition? WS Sie schrieben am Mittwoch, 4. Juli 2001, 23:59:44: Bonjour, I sent this post a few days ago but it didn't get a lot of contributions. Wouldn't it be an interresting feature ? 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. 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 be really helpful in some situations ! As this already been discussed ? Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http
Re[4]: Proposition: Attach a comment to each connection
Bonjour Werner, Am I naive or is this a viable proposition? 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 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 by the mysqladmin process command. And something that would not add more load to Mysql nor more coding in the client. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. This would be helpful for hosters with many client-connectors to identify them. It could contain for example the name of the client-application (useragent), client-OS and some version-info. i think 100 chars will do. Greetings, Ansgar http://www.mysqlfront.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. AB Yes!! Great idea. This would be helpful for hosters with many AB client-connectors to identify them. It could contain for example the name of AB the client-application (useragent), client-OS and some version-info. i AB think 100 chars will do. It would be some char where you can put any comment you would like depending on your needs. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposition: Attach a comment to each connection
This thread has been interesting to follow. But I considered it completely blue sky. Are you guys supporting a change to the MySQL wire protocol? Are you guys supporting a change to _all_ API's that currently use MySQL that would then have to stick somewhere all these 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. On a typical web site running Apache/PHP/MySQL, the sequence would have to be, I think: 1. PHP gets the user agent 2. PHP passes the arg to the connection request 3. This user agent sticks in the data in the wire protocol. 4. MySQL sticks this user agent into a (new) datastructure somewhere associated with the connection. 5. A (new) API call to MySQL can fetch this information What am I missing here? It seems to me that all you are asking for is 1. Change in the wire protocol 2. Design change in the MySQL API 3. Upgrade of all applications using the API in the world 4. Depending on all programs to stick data in this requested comment field in the same consistent manner, unless you are asking for more riders/piggybacks and more fields in the wire protocol such as user agent. Again, what am I missing here? I don't see this as a so-called trivial thingy. It maybe could be done in one local place (as first requested), but this isn't trivial, and has no trivial impact, if it is to be used generally. _jef Ansgar Becker wrote: 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 with many client-connectors to identify them. It could contain for example the name of the client-application (useragent), client-OS and some version-info. i think 100 chars will do. Greetings, Ansgar http://www.mysqlfront.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposition: Attach a comment to each connection
I don't know why I got interested in this thread... I suppose you don't need a change to the wire protocol if you have, logically, something like below. The API has to be changed, however. id = do_a_connedtion(arg) set_comment_on_connection(id, this_is_my_comment) // 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 returning data to a Windows client with Screw Bill Gates prepended to his blob requests, or kicking off connections to, say, any client in Tana Tuva. For readers like me, sitting on the sidelines, the need for this facility is obscure. Please make your case more evident. _jef -- Ansgar Becker wrote: 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 with many client-connectors to identify them. It could contain for example the name of the client-application (useragent), client-OS and some version-info. i think 100 chars will do. Greetings, Ansgar http://www.mysqlfront.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Proposition: Attach a comment to each connection
Bonjour Justin, user agent was just an example of what the commentary could be. You could put what you want as long as it's a string. I agree with you and I already had this reflection that it could be a modification that could create some problems to some. Instead of modifying the protocol and the connection handshake, we could maybe do that through a query. This would be a new type of query which would only modify a field in the connection's data : ... mysql_real_connect(,,,.); mysql_query(SET CONNECTION_COMMENTARY 'Query from page xxx.phtml on server X'); ... JF 4. MySQL sticks this user agent into a (new) JF datastructure somewhere associated with JF the connection. Yes. But once more user agent was an example. On my own I think that there are other information more interesting that could go there. JF 5. A (new) API call to MySQL can fetch this JF information Not necessarily. I mentioned that this connection's commentary could be return in the process list of Mysql (when you do a 'mysqladmin process' for example). Or it could be returned by a query like : mysql_query(GET CONNECTION_COMMENTARY); My idea of this feature is that it could really help a lot in administrating a big database with a lot of connections. JF It seems to me that all you are asking for is JF 1. Change in the wire protocol No. JF 2. Design change in the MySQL API No modification of the API. Only a new query understood by Mysql. I've already been at the source of some modifications in the SQL syntax of Mysql (SQL_BUFFER_RESULT) so I know that when something improves Mysql, something can be coded in Mysql. JF 3. Upgrade of all applications using the API JF in the world No. By default the commentary 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 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 in the connection structure + a new query type. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Proposition: Attach a comment to each connection
Bonjour Justin, JF I don't know why I got interested in this thread... More important (or less), why are you so negative ? JF I suppose you don't need a change to the wire protocol if JF you have, logically, something like below. The API has JF to be changed, 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. Read my previous email. JF Question: Why, again, do you want this? You must see some utility JF in this other than academic interest, or taking statistics, or JF mischief, such as munging some field returning data to a Windows JF client with Screw Bill Gates prepended to his blob requests, or JF kicking off connections to, say, any client in Tana Tuva. I see an interest has an administrator of a really big site with 10 Mysql servers each answering more than 1000 queries each seconds. Queries that could come from hundreds of dynamic web pages, scripts, cronjobs, applications ... When something goes wrong, this feature would really help to debug and to fine a lot more quickly where the problems comes from. JF For readers like me, sitting on the sidelines, the need for this JF facility is obscure. Please make your case more evident. Hope this is more clear to you now. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 experience, you usually don't care much SH about connections which aren't currently running a query. A really good idea !!! Is the /* comment */ shown in the Info column when you run 'mysqladmin process' ? Or is it showing only the Query itself ? I have to test that. Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposition: Attach a comment to each connection
BAUMEISTER Alexandre wrote: Bonjour Justin, JF I don't know why I got interested in this thread... More important (or less), why are you so negative ? Je ne suis pas contre. I just haven't felt the need for this, but after reading your scenario, I can't understand why. Email obscures a lot of preconceptions of the writer. Hope this is more clear to you now. And, it is. I can see the utility of this functionality if I was tracing a suspect that was trying to get, as an example, credit card numbers out of our database BY NOT GOING THROUGH OUR CLIENTS. However, it would not help at all if the attacker was sophisticated, because he ain't gonna write in any comments. Without thinking too much, I can see the utility of knowing which of YOUR ten servers was going bonkers, from which of, say, YOUR 250 web sites using 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 and the DNS resolves to 12345.nasty.net. I just would not have thought about your idea. Et alors, bonne chance with this request _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposition: Attach a comment to each connection
Bonjour, I sent this post a few days ago but it didn't get a lot of contributions. Wouldn't it be an interresting feature ? 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. 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 be really helpful in some situations ! As this already been discussed ? Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. 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 be really helpful in some situations ! As this already been discussed ? Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposition: Attach a comment to each connection
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 now. I like your idea though. D'Arcy Rittich - Original Message - From: BAUMEISTER Alexandre [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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 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 be really helpful in some situations ! As this already been discussed ? Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposition: Attach a comment to each connection
Yes, but it is usually among separate applications that I use different names. In a web app, though, I would use different users for admin stuff versus regular stuff. You want to make use of persistent connections where possible of course, and changing usernames a lot can get in the way 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 of users and use their usernames to connect to the database in differente points of your application and track then by the names you provided for usernames??? Sio From: D'Arcy Rittich [EMAIL PROTECTED] 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 now. I like your idea though. D'Arcy Rittich - Original Message - From: BAUMEISTER Alexandre [EMAIL PROTECTED] To: [EMAIL PROTECTED] 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 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 be really helpful in some situations ! As this already been discussed ? Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: Datatype for comment field
I would recommend the book MySQL by Paul Dubois to anybody that want to do some seriou work on MySQL . It is a really god book with everything explained. I am not earning money by recommending it nor have any financial ties with them. I am just a satisfied customer of that book From: [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 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's my SQL and the error I got. SQL create table test (comment varchar(7000)); ERROR --- Character field too long See this? v http://www.mysql.com/manual.php (the manual) It's in there how long a varchar can be. But before flaming starts: VarChar can take no more than 255 characters. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 do conduct our queries from a mysql client or a program written in tcl/tk and/or perl? Thanks, Fethiye _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 was wondering how we can extract only this field when we do conduct our queries from a mysql client or a program written in tcl/tk and/or perl? If you play with it a little, you'll find that running "show columns from table" returns a recordset, just like a select statement, and you can search for your comments that way. Very convenient :) -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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' -Original Message- From: Sasha Pachev [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, January 03, 2001 7:37 AM Subject: [DOCS COMMENT] Section 'TODO_MySQL_4.0' The following comment was submitted to the MySQL Manual. From: Sasha Pachev [EMAIL PROTECTED] Regarding: http://www.mysql.com/manual.php?section=TODO_MySQL_4.0 I want 4.0 now! -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php sounds good YOURS SINCERELY SHIVAKANTH -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php hey i am online and got a lot of time to waste comming - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
