segment fault when using mysql++
below is my code;these code works very fine until, the length of the field content exceeds 30, then segment fault happened. how can I avoid this? mysqlpp::Query query = conn.query(); query select content from pages where id=id; mysqlpp::ResUse res = query.use(); if (!res) { std::cerr Result set is empty! std::endl; return 1; } mysqlpp::Row r; while (r = res.fetch_row()) { printf (r[content]); } -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: segment fault when using mysql++
actually I am using this piece of code,but I replaced fprintf to printf just to simplify the problem. and the field content actually stores string content. Shall this mean some thing different from your explanation? while (r = res.fetch_row()) { FILE *fp1; char *fname=new char[50]; fname[0]='\0'; strcat(fname,HTML_HOME.c_str()); strcat(fname,id); strcat(fname,.html); fp1 = fopen(fname, w); fprintf (fp1, r[content]); fclose(fp1); delete fname; } Warren Young wrote: I'm replying to you both personally and to the MySQL++ mailing list, where this message is on topic. Please reply only on the list, not to me directly. wangxu wrote: below is my code;these code works very fine until, the length of the field content exceeds 30, How certain are you about this threshold? It seems a very odd number for a computer to care about. If you'd said 65536 bytes, or 16.7 MB, I'd put a lot more credence in your assertion. mysqlpp::Row r; while (r = res.fetch_row()) { printf (r[content]); } I'm not sure it's the problem, but you really shouldn't use printf() for this. The main reason is that printf() will scan the resulting string for % signs and try to interpret them as formatting options. If it finds any, it will then try to find varargs, and fail; this would easily explain your segfault. The byte count does affect the chances that this will happen, so maybe that's where your perception that it's data size related comes from. Other reasons not to use printf() with MySQL++ data types are inefficiency and type safety. See examples/cgi_jpeg.cpp for the right way to emit bulk MySQL++ to stdout. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
alter engine
Now i want to change myisam table to innodb table using alter table ... engine innodb. But the process is too slow! Need i increase key_buffer_size? Need i increase innodb_buffer_pool size?
Re: when rebuilding keys?
- Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 12, 2007 3:17 PM Subject: Re: when rebuilding keys? yes. before load data. You want to rebuild the indices after loading data, correct? Then what exactly is the question? Please write your answer BELOW, not above. 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 sorry ,my english is poor. There is a observable event. My table's engine is myisam. Rows above 100 in my table. I did alter table ..disable keys before loading data. I did alter table ..enable keys after loading data. The operation of enable keys is so fast! I am not sure than if the keys have been rebuild.I think the course of rebuilding should need very long time.
Can I create a index on a column of Type datetime?
I will very often do query like this: select * from mytable where create_date ='...' and create_date ='' can I create a index on the column create_date? what is the best practise? Thanks, shell. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: when rebuilding keys?
before load data. - Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Wednesday, April 11, 2007 7:45 PM Subject: Re: when rebuilding keys? My table is myisam. I disable key using alter table ... disable keys before load data in the table. The manual tell me MySQL to stop updating non-unique indexes for a MyISAM table. When mysql server updating non-unique index after loading data? When you run ALTER TABLE ... ENABLE KEYS Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com
Re: dumpfile question
no, please use load data infile function. - Original Message - From: Wm Mussatto [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, April 12, 2007 12:44 AM Subject: Re: dumpfile question On Tue, April 10, 2007 19:45, Paul DuBois said: At 10:15 AM +0800 4/11/07, wangxu wrote: follow is my sql: select * into dumpfile '/home/wangxu/test4.data' from mytable ; mysql server report: Result consisted of more than one row why?how to use the select into dumpfile? From the manual: If you use INTO DUMPFILE instead of INTO OUTFILE, MySQL writes only one row into the file, without any column or line termination and without performing any escape processing. This is useful if you want to store a BLOB value in a file. http://dev.mysql.com/doc/refman/5.0/en/select.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com Related question. does mysqldump properly escape blobs so that they can be restored via 'mysql -u xxx -p databaseName dumpFile' ? -- William R. Mussatto Systems Engineer http://www.csz.com 909-920-9154 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: when rebuilding keys?
yes. - Original Message - From: Martijn Tonies [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday, April 12, 2007 1:43 AM Subject: Re: when rebuilding keys? before load data. You want to rebuild the indices after loading data, correct? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com My table is myisam. I disable key using alter table ... disable keys before load data in the table. The manual tell me MySQL to stop updating non-unique indexes for a MyISAM table. When mysql server updating non-unique index after loading data? When you run ALTER TABLE ... ENABLE KEYS
Re: Can I create a index on a column of Type datetime?
Thank you, what 's the meaning of using a datetime field unless it's the last field in the index.? the below is the desc result;Should I create an index on (source_url,create_date)? for these two fields are to be often queried by. +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id | bigint(20) | NO | PRI | NULL | auto_increment | | create_date | datetime | NO | | | | | brand | varchar(255) | YES | | NULL | | | category | varchar(255) | YES | | NULL | | | description | text | YES | | NULL | | | detailed_desc | text | YES | | NULL | | | imageUrl | varchar(255) | YES | | NULL | | | name | varchar(255) | YES | | NULL | | | price | varchar(255) | YES | | NULL | | | properties | text | YES | | NULL | | | sku | varchar(255) | YES | | NULL | | | source_url | varchar(255) | YES | | NULL | | | link_path | varchar(255) | YES | | NULL | | | site_name | varchar(255) | YES | MUL | NULL | | | page_score | float | YES | | NULL | | | tag | varchar(255) | YES | | NULL | | | dumped | bit(1) | YES | | NULL | | +---+--+--+-+-++ Brent Baisley wrote: You can create an index on just about any field. Just remember that the data in a datetime field is fairly unique, so it would do much good to create a compound index (2 or more fields) using a datetime field unless it's the last field in the index. - Original Message - From: wangxu [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, April 11, 2007 8:08 PM Subject: Can I create a index on a column of Type datetime? I will very often do query like this: select * from mytable where create_date ='...' and create_date ='' can I create a index on the column create_date? what is the best practise? Thanks, shell. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can I create a index on a column of Type datetime?
No,I am just asking for a solution to speed up my queries. Martijn Tonies wrote: I will very often do query like this: select * from mytable where create_date ='...' and create_date ='' can I create a index on the column create_date? Have you tried it? what is the best practise? 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]
dumpfile question
follow is my sql: select * into dumpfile '/home/wangxu/test4.data' from mytable ; mysql server report: Result consisted of more than one row why?how to use the select into dumpfile?
Fw: dumpfile question
oh,yes. There is a blob column in mytable.So i use dumpfile instead of outfile. There are more than 100 rows in mytable. The follow sql is successful: select * into dumpfile '/home/wangxu/test4.data' from mytable where id=1 or id=2; Why it is false that select all rows in mytable? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Wednesday, April 11, 2007 10:45 AM Subject: Re: dumpfile question At 10:15 AM +0800 4/11/07, wangxu wrote: follow is my sql: select * into dumpfile '/home/wangxu/test4.data' from mytable ; mysql server report: Result consisted of more than one row why?how to use the select into dumpfile? From the manual: If you use INTO DUMPFILE instead of INTO OUTFILE, MySQL writes only one row into the file, without any column or line termination and without performing any escape processing. This is useful if you want to store a BLOB value in a file. http://dev.mysql.com/doc/refman/5.0/en/select.html -- 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]
help me optimize this sql
sql: select * from table_one inner join table_two on table_two.column_one = table_one.column_one left join (SELECT * from table_three) table_four on table_four.column_two = table_one.column_three and table_four.column_four= table_one.column_five where column_six like '%dsc%' and column_seven like '%aaa%' explain: *** 1. row *** id: 1 select_type: PRIMARY table: table_one type: ALL possible_keys: key: NULL key_len: NULL ref: NULL rows: 481 Extra: Using where *** 2. row *** id: 1 select_type: PRIMARY table: table_two type: ref possible_keys: idx_column_one key: idx_column_one key_len: 153 ref: table_one.column_one rows: 1 Extra: Using where *** 3. row *** id: 1 select_type: PRIMARY table: derived2 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 2297 Extra: *** 4. row *** id: 2 select_type: DERIVED table: table_three type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 2250 Extra: Can I optimize this sql ? thanks!
help me optimize this ALL
sql: SELECT * FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one = table_one.column_two INNER JOIN table_one table_one2 ON table_one2.column_one = table_one.column_three explain: *** 1. row *** id: 1 select_type: SIMPLE table: table_one type: ALL possible_keys: idx_column_two,idx_column_three key: NULL key_len: NULL ref: NULL rows: 2037 Extra: *** 2. row *** id: 1 select_type: SIMPLE table: table_one1 type: ref possible_keys: idx_column_one key: idx_column_one key_len: 5 ref: table_one.column_two rows: 1 Extra: Using where *** 3. row *** id: 1 select_type: SIMPLE table: table_one2 type: ref possible_keys: idx_column_one key: idx_column_one key_len: 5 ref: table_one.column_three rows: 1 Extra: Using where Can I optimize this ALL on table one? thanks!
Re: help me optimize this ALL
thank you - Original Message - From: Jay Pipes [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, March 06, 2007 4:29 AM Subject: Re: help me optimize this ALL No, because you have no WHERE condition. wangxu wrote: sql: SELECT * FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one = table_one.column_two INNER JOIN table_one table_one2 ON table_one2.column_one = table_one.column_three explain: *** 1. row *** id: 1 select_type: SIMPLE table: table_one type: ALL possible_keys: idx_column_two,idx_column_three key: NULL key_len: NULL ref: NULL rows: 2037 Extra: *** 2. row *** id: 1 select_type: SIMPLE table: table_one1 type: ref possible_keys: idx_column_one key: idx_column_one key_len: 5 ref: table_one.column_two rows: 1 Extra: Using where *** 3. row *** id: 1 select_type: SIMPLE table: table_one2 type: ref possible_keys: idx_column_one key: idx_column_one key_len: 5 ref: table_one.column_three rows: 1 Extra: Using where Can I optimize this ALL on table one? thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
oracle transfer question
There is a oracle SQL: SELECT employee_id, salary, hire_date, STDDEV(salary) OVER (ORDER BY hire_date) Std Deviation of Salary FROM employees WHERE job_id = 'ST_CLERK'; The result is: EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- -- --- 137 3600 14-7月 -95 0 141 3500 17-10月-95 70.7106781 133 3300 14-6月 -96 152.752523 142 3100 29-1月 -97 221.735578 131 2500 16-2月 -97 435.889894 125 3200 16-7月 -97 389.871774 129 3300 20-8月 -97 357.903951 138 3200 26-10月-97 331.393163 130 2800 30-10月-97 339.116499 139 2700 12-2月 -98 352.136337 143 2600 15-3月 -98 369.028208 EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- -- --- 140 2500 06-4月 -98 388.762606 144 2500 09-7月 -98 399.679359 134 2900 26-8月 -98 384.664832 126 2700 28-9月 -98 377.586319 127 2400 14-1月 -99 390.72582 132 2100 10-4月 -99 427.974023 135 2400 12-12月-99 430.116263 136 2200 06-2月 -00 443.800703 128 2200 08-3月 -00 453.379126 I transfer the oracle sql to mysql sql: SELECT employee_id, salary, hire_date, STDDEV_pop(salary)Std Deviation of Salary FROM employees WHERE job_id = 'ST_CLERK' Group by employee_id, salary, hire_date ORDER BY hire_date; But the result are: +-+++-+ | employee_id | salary | hire_date | Std Deviation of Salary | +-+++-+ | 137 | 3600 | 1995-07-14 | 0. | | 141 | 3500 | 1995-10-17 | 0. | | 133 | 3300 | 1996-06-14 | 0. | | 142 | 3100 | 1997-01-29 | 0. | | 131 | 2500 | 1997-02-16 | 0. | | 125 | 3200 | 1997-07-16 | 0. | | 129 | 3300 | 1997-08-20 | 0. | | 138 | 3200 | 1997-10-26 | 0. | | 130 | 2800 | 1997-10-30 | 0. | | 139 | 2700 | 1998-02-12 | 0. | | 143 | 2600 | 1998-03-15 | 0. | | 140 | 2500 | 1998-04-06 | 0. | | 144 | 2500 | 1998-07-09 | 0. | | 134 | 2900 | 1998-08-26 | 0. | | 126 | 2700 | 1998-09-28 | 0. | | 127 | 2400 | 1999-01-14 | 0. | | 132 | 2100 | 1999-04-10 | 0. | | 135 | 2400 | 1999-12-12 | 0. | | 136 | 2200 | 2000-02-06 | 0. | | 128 | 2200 | 2000-03-08 | 0. | +-+++-+ Why all the compute column values are 0?What is the correct sql? thanks!
How to transfer the oracle function PERCENT_RANK to mysql
How to transfer the oracle function PERCENT_RANK to mysql? oracle example: SELECT PERCENT_RANK(11000) WITHIN GROUP (ORDER BY salary DESC) Rank of $11,000 among managers FROM employees WHERE job_id LIKE '%MAN' OR job_id LIKE '%MGR';
How to transfer the oracle function PERCENT_RANK to mysql
How to transfer the oracle function PERCENT_RANK to mysql? oracle example: SELECT PERCENT_RANK(11000) WITHIN GROUP (ORDER BY salary DESC) Rank of $11,000 among managers FROM employees WHERE job_id LIKE '%MAN' OR job_id LIKE '%MGR';
oracle transfer question
There is a oracle SQL: SELECT employee_id, salary, hire_date, STDDEV(salary) OVER (ORDER BY hire_date) Std Deviation of Salary FROM employees WHERE job_id = 'ST_CLERK'; The result is: EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- -- --- 137 3600 14-7月 -95 0 141 3500 17-10月-95 70.7106781 133 3300 14-6月 -96 152.752523 142 3100 29-1月 -97 221.735578 131 2500 16-2月 -97 435.889894 125 3200 16-7月 -97 389.871774 129 3300 20-8月 -97 357.903951 138 3200 26-10月-97 331.393163 130 2800 30-10月-97 339.116499 139 2700 12-2月 -98 352.136337 143 2600 15-3月 -98 369.028208 EMPLOYEE_ID SALARY HIRE_DATE Std Deviation of Salary --- -- -- --- 140 2500 06-4月 -98 388.762606 144 2500 09-7月 -98 399.679359 134 2900 26-8月 -98 384.664832 126 2700 28-9月 -98 377.586319 127 2400 14-1月 -99 390.72582 132 2100 10-4月 -99 427.974023 135 2400 12-12月-99 430.116263 136 2200 06-2月 -00 443.800703 128 2200 08-3月 -00 453.379126 I transfer the oracle sql to mysql sql: SELECT employee_id, salary, hire_date, STDDEV_pop(salary)Std Deviation of Salary FROM employees WHERE job_id = 'ST_CLERK' Group by employee_id, salary, hire_date ORDER BY hire_date; But the result are: +-+++-+ | employee_id | salary | hire_date | Std Deviation of Salary | +-+++-+ | 137 | 3600 | 1995-07-14 | 0. | | 141 | 3500 | 1995-10-17 | 0. | | 133 | 3300 | 1996-06-14 | 0. | | 142 | 3100 | 1997-01-29 | 0. | | 131 | 2500 | 1997-02-16 | 0. | | 125 | 3200 | 1997-07-16 | 0. | | 129 | 3300 | 1997-08-20 | 0. | | 138 | 3200 | 1997-10-26 | 0. | | 130 | 2800 | 1997-10-30 | 0. | | 139 | 2700 | 1998-02-12 | 0. | | 143 | 2600 | 1998-03-15 | 0. | | 140 | 2500 | 1998-04-06 | 0. | | 144 | 2500 | 1998-07-09 | 0. | | 134 | 2900 | 1998-08-26 | 0. | | 126 | 2700 | 1998-09-28 | 0. | | 127 | 2400 | 1999-01-14 | 0. | | 132 | 2100 | 1999-04-10 | 0. | | 135 | 2400 | 1999-12-12 | 0. | | 136 | 2200 | 2000-02-06 | 0. | | 128 | 2200 | 2000-03-08 | 0. | +-+++-+ Why all the compute column values are 0?What is the correct sql? thanks!
query cache about the federated engine
It bring great effect in performance if federated engine can't use the cache. If mysql intend to support it in the future? - Original Message - From: Michael Loftis [EMAIL PROTECTED] To: wangxu [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday, August 03, 2006 1:27 AM Subject: Re: query cache about the federated engine --On August 2, 2006 5:25:51 PM +0800 wangxu [EMAIL PROTECTED] wrote: I have a problem about the performance of federated engine. The mysql5.0 reference manual says that the FEDERATED tables do not work with the query cache, aren't they? How about the query cache used by the federated engine in the mysql5.1? If the query cache cann't be used with the federated engine tables still, how to enhance the query performance against to the federated tables effectively? Well for one if the machine isn't on the same LAN you'll never have good DB performance -- not sure if this is the case or not, just a helpful hint. For two, the reason why federated doesn't use the query cache is then you have to somehow invalidate the remote cache(s) which would require some form of protocol extension, either in the SQL or the over the wire protocol so that the server with the federated table could ask if it could cache a result, and the server that's serving to the federated client could inform that server when it's cache isn't valid. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question about the query against to the federated engine tables
who can help me? - Original Message - From: wangxu [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, August 02, 2006 5:29 PM Subject: question about the query against to the federated engine tables I have a question about the query against to the federated engine tables. As the following example: select Id,name from e01_system.category Note: the e01_system.category is a federated table. I select only tow fields from the federated table category with the above sql statement. But it seemed as if gets all the fields of the table (the table has more then ten fields actually), so the performance of the sql stetement is very slow when the table's size is very big.I conclude this through monitoring the throughput of the network with a network tool named sniffer. I think the federated table works not as what i expected.
How does the federated engine table work
please help me thanks. - Original Message - From: wangxu [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, August 02, 2006 5:27 PM Subject: How does the federated engine table work How does the federated engine table work when the query statement include a join substatement, it joins a local table with innodb engine and a federated table. How does the server deal with the query substatement like this?
query cache about the federated engine
I have a problem about the performance of federated engine. The mysql5.0 reference manual says that the FEDERATED tables do not work with the query cache, aren't they? How about the query cache used by the federated engine in the mysql5.1? If the query cache cann't be used with the federated engine tables still, how to enhance the query performance against to the federated tables effectively?
How does the federated engine table work
How does the federated engine table work when the query statement include a join substatement, it joins a local table with innodb engine and a federated table. How does the server deal with the query substatement like this?
question about the query against to the federated engine tables
I have a question about the query against to the federated engine tables. As the following example: select Id,name from e01_system.category Note: the e01_system.category is a federated table. I select only tow fields from the federated table category with the above sql statement. But it seemed as if gets all the fields of the table (the table has more then ten fields actually), so the performance of the sql stetement is very slow when the table's size is very big.I conclude this through monitoring the throughput of the network with a network tool named sniffer. I think the federated table works not as what i expected.
Re: split a datafile
No,i don't want to do this. My previous variable is innodb_data_file_path=ibdata1:2G;ibdata2:10M:autoextend. But ibdata2 had exceed 3G! I changed the variable to innodb_data_file_path=ibdata1:2G;ibdata2:2G;ibdata3:10M:autoextend. But Server couldn't start. How can i to achieve my idea? - Original Message - From: Ow Mun Heng [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, February 07, 2006 4:07 PM Re: split a datafile On Tue, 2006-02-07 at 15:48 +0800, wangxu wrote: I want to split a datafile to two datafiles.How can i do? Will this do? $ split --help Usage: split [OPTION] [INPUT [PREFIX]] Output fixed-size pieces of INPUT to PREFIXaa, PREFIXab, ...; default PREFIX is `x'. With no INPUT, or when INPUT is -, read standard input. Mandatory arguments to long options are mandatory for short options too. -a, --suffix-length=N use suffixes of length N (default 2) -b, --bytes=SIZEput SIZE bytes per output file -C, --line-bytes=SIZE put at most SIZE bytes of lines per output file -d, --numeric-suffixes use numeric suffixes instead of alphabetic -l, --lines=NUMBER put NUMBER lines per output file --verbose print a diagnostic to standard error just before each output file is opened --help display this help and exit --version output version information and exit SIZE may have a multiplier suffix: b for 512, k for 1K, m for 1 Meg. Report bugs to bug-coreutils@gnu.org. -- Ow Mun Heng Gentoo/Linux on DELL D600 1.4Ghz 1.5GB RAM 98% Microsoft(tm) Free!! Neuromancer 16:06:57 up 1 day, 7:07, 4 users, load average: 1.56, 1.02, 0.81 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dump a xml result
When i dump a table to a xml result mysqldump throw a warning: - Warning: Can't set SQL_QUOTE_SHOW_CREATE option () - If i dump the table to a txt result mysqldump don't throw the warning. What't the warning mean?How to avoid this warning?
split a datafile
I want to split a datafile to two datafiles.How can i do?
Re:Can not get answers
Thank to Mike give the result about the third question. But the first and second question not answer. The first question related to the function of mysql-administrator's subassembly.A picture about this question in the accessories. http://forums.mysql.com/read.php?34,61375,61375#msg-61375 The second question related to the RAID setup in mysql-administrator. http://forums.mysql.com/read.php?34,61374,61374#msg-61374 - Original Message - From: wangxu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, January 23, 2006 3:57 PM Subject: Can not get answers I can not recieve answer about follow url for a long time. I very need the answers of those. Please help me. thanks! http://forums.mysql.com/read.php?34,61375,61375#msg-61375 http://forums.mysql.com/read.php?34,61374,61374#msg-61374 http://forums.mysql.com/read.php?34,60411,60411#msg-60411 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question about recovery with binlog
I execute follow statement. - shellreplace @@session.sql_mode=0 @@session.sql_mode=1 -- 1.01 - But string @@session.sql_mode=0 doesn't replace to @@session.sql_mode=1. - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, January 23, 2006 7:56 PM Subject:Re: question about recovery with binlog Hello. There a lot of different ways to perform this operation. See: http://dev.mysql.com/doc/refman/5.0/en/replace-utility.html man sed man awk wangxu wrote: How to replace it? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question about mysqlbinlog
I do the follow statement: [EMAIL PROTECTED] mysql]# /usr/bin/mysqlbinlog -h192.168.55.55 -uroot -R --to-last-log /var/lib/mysql/1.01 But the results are: --- /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; Got error reading packet from server: Could not find first log file name in binary log index file # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET [EMAIL PROTECTED]/; --- But the information about the binary log index(1.index) is very clear:./1.01,./02,./1.03 Why?
Re: question about recovery with binlog
How to replace it? The output is a binary file. - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, January 20, 2006 10:11 PM Subject: Re: question about recovery with binlog Hello. Just a possible workaround - you can parse the output of mysqlbinlog and replace the buggy statement with the correct one. wangxu wrote: My mysql version is 5.0.16. My problem is similar to the bug. My sql mode is ANSI and TRADITIONAL If mysql can't do recovery with mysqlbinlog at my sql mode until the bug will be fixed? Follow is the information of my binlog. -- /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; # at 4 #060119 13:55:30 server id 1 end_log_pos 98Start: binlog v 4, server v 5.0.16-standard-log created 060119 13:55:30 # Warning: this binlog was not closed properly. Most probably mysqld crashed writing it. # at 98 #060119 13:57:41 server id 1 end_log_pos 165 Query thread_id=4 exec_time=0 error_code=0 use wangxu; SET TIMESTAMP=1137650261; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1; SET @@session.sql_mode=501481487; SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33; insert ht_detail values('79NK0006','79NK0006',1),('79NK0007','79NK0007',1),('79NK0008','79NK0008',1); # at 263 #060119 13:57:41 server id 1 end_log_pos 290 Xid = 215 COMMIT; # at 290 #060119 14:08:30 server id 1 end_log_pos 445 Query thread_id=7 exec_time=0 error_code=0 SET TIMESTAMP=1137650910; SET @@session.foreign_key_checks=0, @@session.unique_checks=0; SET @@session.sql_mode=524288; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wangxu` /*!40100 DEFAULT CHARACTER SET latin1 */; # at 445 #060119 14:08:30 server id 1 end_log_pos 542 Query thread_id=7 exec_time=0 error_code=0 SET TIMESTAMP=1137650910; DROP TABLE IF EXISTS `ht_detail`; # at 542 #060119 14:08:40 server id 1 end_log_pos 639 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1137650920; DROP TABLE IF EXISTS `ht_detail`; # at 639 #060119 14:23:13 server id 1 end_log_pos 733 Query thread_id=11 exec_time=0 error_code=0 SET TIMESTAMP=1137651793; SET @@session.foreign_key_checks=1, @@session.unique_checks=1; SET @@session.sql_mode=501481487; create table ht_header(a int); # at 733 #060119 14:23:53 server id 1 end_log_pos 818 Query thread_id=12 exec_time=0 error_code=0 SET TIMESTAMP=1137651833; drop table ht_header; # at 818 #060119 14:28:10 server id 1 end_log_pos 915 Query thread_id=15 exec_time=0 error_code=0 SET TIMESTAMP=1137652090; SET @@session.foreign_key_checks=0, @@session.unique_checks=0; SET @@session.sql_mode=524288; DROP TABLE IF EXISTS `ht_detail`; # at 915 #060119 14:29:44 server id 1 end_log_pos 998 Query thread_id=16 exec_time=0 error_code=0 use test; SET TIMESTAMP=1137652184; SET @@session.foreign_key_checks=1, @@session.unique_checks=1; SET @@session.sql_mode=501481487; drop table ht_detail; # at 998 #060119 14:30:29 server id 1 end_log_pos 1160 Query thread_id=16 exec_time=0 error_code=0 SET TIMESTAMP=1137652229; create table ht_detail(hth varchar(30),sbh varchar(15),sbsl int,primary key(hth,sbh)) type = innodb; # at 1160 #060119 14:54:50 server id 1 end_log_pos 1243 Query thread_id=20 exec_time=0 error_code=0 SET TIMESTAMP=1137653690; drop schema wangxu; # at 1243 #060119 14:54:57 server id 1 end_log_pos 1328 Query thread_id=20 exec_time=0 error_code=0 SET TIMESTAMP=1137653697; create schema wangxu; # at 1328 #060119 14:55:17 server id 1 end_log_pos 1422 Query thread_id=20 exec_time=0 error_code=0 use wangxu; SET TIMESTAMP=1137653717; create table ht_detail(a int); # at 1422 #060119 17:10:13 server id 1 end_log_pos 1505 Query thread_id=24 exec_time=0 error_code=0 SET TIMESTAMP=1137661813; drop schema wangxu; # at 1505 #060119 17:10:17 server id 1 end_log_pos 1590 Query thread_id=24 exec_time=0 error_code=0 SET TIMESTAMP=1137661817; create schema wangxu; # at 1590 #060119 17:10:47 server id 1 end_log_pos 1687 Query thread_id=25 exec_time=0 error_code=0 SET TIMESTAMP=1137661847; SET @@session.foreign_key_checks=0, @@session.unique_checks=0; SET @@session.sql_mode=524288; DROP TABLE IF EXISTS `ht_detail`; # at 1687 #060119 17:10:47 server id 1 end_log_pos 1959 Query thread_id=25 exec_time=0 error_code=0 SET TIMESTAMP=1137661847; CREATE TABLE `ht_detail` ( `hth` varchar(30) NOT NULL
Can not get answers
I can not recieve answer about follow url for a long time. I very need the answers of those. Please help me. thanks! http://forums.mysql.com/read.php?34,61375,61375#msg-61375 http://forums.mysql.com/read.php?34,61374,61374#msg-61374 http://forums.mysql.com/read.php?34,60411,60411#msg-60411
Re: question about CONTAINS SQL
Hello Paul, If it like your mean,these parameters aren't beneficial to help user to ensure the correctness with their code. On the contrary,mysql depend on these parameters to ensure the integrality and security. If it like this,these parameters increase use difficulty about user. Should mysql to perfect these function? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED]; wangxu [EMAIL PROTECTED] Cc: mysql mysql@lists.mysql.com Sent: Friday, January 20, 2006 3:20 PM Subject:Re: question about CONTAINS SQL At 8:29 -0500 1/19/06, Rhino wrote: I am copying the rest of the list with this so that everyone may benefit from the discussion. If your routine modifies data, in other words if it does SQL Update, Insert or Delete but your routine definition says only CONTAINS SQL, I would expect your routine to fail at runtime. I can't say this with certaintly because I don't have one of the newer versions of MySQL that supports these routines but I'm pretty sure that you will have a runtime failure. After all, CONTAINS SQL implies only that you are creating objects like tables within your routine; CONTAINS SQL does not permit the execution of Insert, Update, or Delete. Therefore, I expect that you will get a runtime error as soon as you do your first Insert, Update, or Delete. If you want to avoid the error, use MODIFIES SQL instead of CONTAINS SQL. Of course the best way to be sure is to try this for yourself. Try the routine with CONTAINS SQL and see what happens at runtime. If it fails, as I strongly expect, change CONTAINS SQL to MODIFIES SQL DATA and your error will almost certainly go away. No, these characteristics are merely advisory. The server doesn't impose any restraints based on them. Rhino - Original Message - From: wangxu [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED] Sent: Thursday, January 19, 2006 2:54 AM Subject: Re: question about CONTAINS SQL If I create a routine with modification operation and not spectify characteristic in CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA. In the maunal,the default value is CONTAINS SQL if i haven't spectify a values. If it's meaning that the routine with CONTAINS SQL include modification operation? Should many problem happen? - Original Message - From: Rhino [EMAIL PROTECTED] To: wangxu [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday, January 19, 2006 12:21 AM Subject:Re: question about CONTAINS SQL If you are writing something that does INSERT, UPDATE, or DELETE, you need to use the MODIFIES SQL DATA option. Rhino - Original Message - From: wangxu [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Wednesday, January 18, 2006 3:05 AM Subject: Re: question about CONTAINS SQL But what is INSERT OR UPDATE need? - Original Message - From: Rhino [EMAIL PROTECTED] To: wangxu [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, January 17, 2006 9:49 PM Re: question about CONTAINS SQL - Original Message - From: wangxu [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, January 17, 2006 12:35 AM Subject: question about CONTAINS SQL I notice there are one section in the manual: CONTAINS SQL indicates that the routine does not containstatements that read or write data. And that the option is default. It's true? If i wouldn't do read or write in routine.What can i do yet? Commands like GRANT or REVOKE or CREATE TABLE don't read or write data within tables but they involve SQL so commands like this need CONTAINS SQL, rather than the NO SQL, READS SQL DATA or MODIFIES SQL DATA options. Rhino -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.19/231 - Release Date: 16/01/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.20/233 - Release Date: 18/01/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.20/233 - Release Date: 18/01/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.20/233
question about recovery with binlog
Mysqlbinlog throw out a error ERROR 1231 (42000) at line 10: Variable 'sql_mode' can't be set to the value of '501481487' when i recovery a binlog. What can i do?
Re: question about recovery with binlog
My mysql version is 5.0.16. My problem is similar to the bug. My sql mode is ANSI and TRADITIONAL If mysql can't do recovery with mysqlbinlog at my sql mode until the bug will be fixed? Follow is the information of my binlog. -- /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; # at 4 #060119 13:55:30 server id 1 end_log_pos 98Start: binlog v 4, server v 5.0.16-standard-log created 060119 13:55:30 # Warning: this binlog was not closed properly. Most probably mysqld crashed writing it. # at 98 #060119 13:57:41 server id 1 end_log_pos 165 Query thread_id=4 exec_time=0 error_code=0 use wangxu; SET TIMESTAMP=1137650261; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1; SET @@session.sql_mode=501481487; SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33; insert ht_detail values('79NK0006','79NK0006',1),('79NK0007','79NK0007',1),('79NK0008','79NK0008',1); # at 263 #060119 13:57:41 server id 1 end_log_pos 290 Xid = 215 COMMIT; # at 290 #060119 14:08:30 server id 1 end_log_pos 445 Query thread_id=7 exec_time=0 error_code=0 SET TIMESTAMP=1137650910; SET @@session.foreign_key_checks=0, @@session.unique_checks=0; SET @@session.sql_mode=524288; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wangxu` /*!40100 DEFAULT CHARACTER SET latin1 */; # at 445 #060119 14:08:30 server id 1 end_log_pos 542 Query thread_id=7 exec_time=0 error_code=0 SET TIMESTAMP=1137650910; DROP TABLE IF EXISTS `ht_detail`; # at 542 #060119 14:08:40 server id 1 end_log_pos 639 Query thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1137650920; DROP TABLE IF EXISTS `ht_detail`; # at 639 #060119 14:23:13 server id 1 end_log_pos 733 Query thread_id=11 exec_time=0 error_code=0 SET TIMESTAMP=1137651793; SET @@session.foreign_key_checks=1, @@session.unique_checks=1; SET @@session.sql_mode=501481487; create table ht_header(a int); # at 733 #060119 14:23:53 server id 1 end_log_pos 818 Query thread_id=12 exec_time=0 error_code=0 SET TIMESTAMP=1137651833; drop table ht_header; # at 818 #060119 14:28:10 server id 1 end_log_pos 915 Query thread_id=15 exec_time=0 error_code=0 SET TIMESTAMP=1137652090; SET @@session.foreign_key_checks=0, @@session.unique_checks=0; SET @@session.sql_mode=524288; DROP TABLE IF EXISTS `ht_detail`; # at 915 #060119 14:29:44 server id 1 end_log_pos 998 Query thread_id=16 exec_time=0 error_code=0 use test; SET TIMESTAMP=1137652184; SET @@session.foreign_key_checks=1, @@session.unique_checks=1; SET @@session.sql_mode=501481487; drop table ht_detail; # at 998 #060119 14:30:29 server id 1 end_log_pos 1160 Query thread_id=16 exec_time=0 error_code=0 SET TIMESTAMP=1137652229; create table ht_detail(hth varchar(30),sbh varchar(15),sbsl int,primary key(hth,sbh)) type = innodb; # at 1160 #060119 14:54:50 server id 1 end_log_pos 1243 Query thread_id=20 exec_time=0 error_code=0 SET TIMESTAMP=1137653690; drop schema wangxu; # at 1243 #060119 14:54:57 server id 1 end_log_pos 1328 Query thread_id=20 exec_time=0 error_code=0 SET TIMESTAMP=1137653697; create schema wangxu; # at 1328 #060119 14:55:17 server id 1 end_log_pos 1422 Query thread_id=20 exec_time=0 error_code=0 use wangxu; SET TIMESTAMP=1137653717; create table ht_detail(a int); # at 1422 #060119 17:10:13 server id 1 end_log_pos 1505 Query thread_id=24 exec_time=0 error_code=0 SET TIMESTAMP=1137661813; drop schema wangxu; # at 1505 #060119 17:10:17 server id 1 end_log_pos 1590 Query thread_id=24 exec_time=0 error_code=0 SET TIMESTAMP=1137661817; create schema wangxu; # at 1590 #060119 17:10:47 server id 1 end_log_pos 1687 Query thread_id=25 exec_time=0 error_code=0 SET TIMESTAMP=1137661847; SET @@session.foreign_key_checks=0, @@session.unique_checks=0; SET @@session.sql_mode=524288; DROP TABLE IF EXISTS `ht_detail`; # at 1687 #060119 17:10:47 server id 1 end_log_pos 1959 Query thread_id=25 exec_time=0 error_code=0 SET TIMESTAMP=1137661847; CREATE TABLE `ht_detail` ( `hth` varchar(30) NOT NULL default '', `sbh` varchar(15) NOT NULL default '', `sbsl` int(11) default NULL, PRIMARY KEY (`hth`,`sbh`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; # at 1959 #060119 17:10:47 server id 1 end_log_pos 2072 Query thread_id=25 exec_time=0 error_code=0 SET TIMESTAMP=1137661847; /*!4 ALTER TABLE `ht_detail` DISABLE KEYS */; # at 2072 #060119 17:10:47 server id 1 end_log_pos 188 Query thread_id=25 exec_time=0 error_code=0 SET TIMESTAMP=1137661847; INSERT INTO `ht_detail` VALUES ('79NK0001/0003','79NK0001',1),('79NK0001/0003','79NK0002',1),('79NK0001/0003','79NK0003',1); # at 2260 #060119 17:10:47 server id
Re: question about CONTAINS SQL
Thank you Rhino. Your description is very detailed. But my try was fail.No error has been throw out. Follow is the process. Please help me to analyse the result. -- [EMAIL PROTECTED] bin]# mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.0.16-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | db1| | db2| | mysql | | test | | wangxu | ++ 6 rows in set (0.03 sec) mysql use wangxu; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql show tables; +--+ | Tables_in_wangxu | +--+ | ht_detail| +--+ 1 row in set (0.00 sec) mysql select * from ht_detail; +---+--+--+ | hth | sbh | sbsl | +---+--+--+ | 79NK0001/0003 | 79NK0001 |1 | | 79NK0001/0003 | 79NK0002 |1 | | 79NK0001/0003 | 79NK0003 |1 | +---+--+--+ 3 rows in set (0.01 sec) mysql delimiter // mysql create procedure test() - deterministic - contains sql - begin - insert ht_detail values('sdf','ser',4); - end - // Query OK, 0 rows affected (0.02 sec) mysql delimiter ; mysql show create procedure test \G *** 1. row *** Procedure: test sql_mode: REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER Create Procedure: CREATE PROCEDURE test() DETERMINISTIC begin insert ht_detail values('sdf','ser',4); end 1 row in set (0.00 sec) mysql call test(); Query OK, 1 row affected (0.00 sec) mysql select * from ht_detail; +---+--+--+ | hth | sbh | sbsl | +---+--+--+ | 79NK0001/0003 | 79NK0001 |1 | | 79NK0001/0003 | 79NK0002 |1 | | 79NK0001/0003 | 79NK0003 |1 | | sdf | ser |4 | +---+--+--+ 4 rows in set (0.00 sec) mysql -- - Original Message - From: Rhino [EMAIL PROTECTED] To: wangxu [EMAIL PROTECTED] Cc: mysql mysql@lists.mysql.com Sent: Thursday, January 19, 2006 9:29 PM Subject:Re: question about CONTAINS SQL I am copying the rest of the list with this so that everyone may benefit from the discussion. If your routine modifies data, in other words if it does SQL Update, Insert or Delete but your routine definition says only CONTAINS SQL, I would expect your routine to fail at runtime. I can't say this with certaintly because I don't have one of the newer versions of MySQL that supports these routines but I'm pretty sure that you will have a runtime failure. After all, CONTAINS SQL implies only that you are creating objects like tables within your routine; CONTAINS SQL does not permit the execution of Insert, Update, or Delete. Therefore, I expect that you will get a runtime error as soon as you do your first Insert, Update, or Delete. If you want to avoid the error, use MODIFIES SQL instead of CONTAINS SQL. Of course the best way to be sure is to try this for yourself. Try the routine with CONTAINS SQL and see what happens at runtime. If it fails, as I strongly expect, change CONTAINS SQL to MODIFIES SQL DATA and your error will almost certainly go away. Rhino - Original Message - From: wangxu [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED] Sent: Thursday, January 19, 2006 2:54 AM Subject: Re: question about CONTAINS SQL If I create a routine with modification operation and not spectify characteristic in CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA. In the maunal,the default value is CONTAINS SQL if i haven't spectify a values. If it's meaning that the routine with CONTAINS SQL include modification operation? Should many problem happen? - Original Message - From: Rhino [EMAIL PROTECTED] To: wangxu [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday, January 19, 2006 12:21 AM Subject:Re: question about CONTAINS SQL If you are writing something that does INSERT, UPDATE, or DELETE, you need to use the MODIFIES SQL DATA option. Rhino - Original Message - From: wangxu [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Wednesday, January 18, 2006 3:05 AM Subject: Re: question about CONTAINS SQL But what
a question about innodb log file
There are many information about different logs in manual but innodb log file. Please tell me where can i find it? What's innodb log file different to binlog? Where can i find data about redo and undo? thanks
question about master_pos_wait
Slave server should automatically catch up master server when it be started. When i need use master_pos_wait?
Re: Do mysql support command-level trigger?
help - Original Message - From: wangxu [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, January 10, 2006 2:58 PM Subject:Do mysql support command-level trigger? Do mysql support command-level trigger?
Re: Do mysql support command-level trigger?
sorry. In general,there are two kinds of trigger's activity. One is row activity. The other is SQL-statement activity. I want to know if mysql support the second. Do you understand? thanks - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: wangxu [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, January 17, 2006 11:23 AM Subject: (ÈðÐÇÌáʾ-´ËÓʼþ¿ÉÄÜÊÇÀ¬»øÓʼþ)Re: Do mysql support command-level trigger? At 11:09 +0800 1/17/06, wangxu wrote: help It might be that you're getting no answer because we don't know what you're asking. - Original Message - From: wangxu [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, January 10, 2006 2:58 PM Subject:Do mysql support command-level trigger? Do mysql support command-level trigger? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
question about CONTAINS SQL
I notice there are one section in the manual: CONTAINS SQL indicates that the routine does not contain statements that read or write data. And that the option is default. It's true? If i wouldn't do read or write in routine.What can i do yet?
Re: question about sql security
thank you gleb. But,the sql securityd description in the manual is not particular. I mistaked the concept. I understand the limit is procedure limit but not database object limit. So,i believe this concept should more definitude if you add the example in this part of manual. - CREATE PROCEDURE p26 () SQL SECURITY INVOKER SELECT COUNT(*) FROM t // CREATE PROCEDURE p27 () SQL SECURITY DEFINER SELECT COUNT(*) FROM t // GRANT INSERT ON db5.* TO peter; // - - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, January 04, 2006 5:22 PM Subject: Re: question about sql security Hello. In my opinion, a good description can be found here: http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html wangxu [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
about mysql security
I get a concept about mysql security. It's named five-tiered access control.Can you tell me the detail of this concept?
an backup syntax error
Follow is my preform and result: - mysql backup table ht_detail to '/'; +++--+--+ | Table | Op | Msg_type | Msg_text | +++--+--+ | test.ht_detail | backup | error| Failed copying .frm file (errno: 13) | | test.ht_detail | backup | status | Operation failed | +++--+--+ 2 rows in set, 1 warning (0.00 sec) - How to solve it? I use 5.0.16.
Can i get a mysql technology standard
Can i get a technology standard? It include database capability,table capability,row number limit in table,blob object capability etc
question about sql security
I refer a question about sql security option of create procedure syntax at 2005-12. But i can't quite understood with that answer. Can you give me a example to describe the effect of set sql security option ?
Re: (ÈðÐÇÌáʾ-´ËÓʼþ¿ÉÄÜÊÇÀ¬»øÓʼþ)RE: set sql mode
thanks - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday, December 29, 2005 10:38 PM Subject: (ÈðÐÇÌáʾ-´ËÓʼþ¿ÉÄÜÊÇÀ¬»øÓʼþ)RE: set sql mode An error is only thown during an INSERT or UPDATE statement, otherwise you just get a warning. - ERROR_FOR_DIVISION_BY_ZERO Produce an error in strict mode (otherwise a warning) when we encounter a division by zero (or MOD(X,0)) during an INSERT or UPDATE. If this mode is not given, MySQL instead returns NULL for divisions by zero. If used in INSERT IGNORE or UPDATE IGNORE, MySQL generates a warning for divisions by zero, but the result of the operation is NULL. Ed -Original Message- From: wangxu [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 28, 2005 7:23 PM To: Gleb Paharenko; mysql@lists.mysql.com Subject: Re: set sql mode My sql_mode is STRICT_TRANS_TABLES,ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO. But when i execute select 1/0 from ht_detail,the result is Null. No error throw out. Why? - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, December 28, 2005 9:26 PM Re: set sql mode Hello. But now i wish sql mode only include REAL_AS_FLOAT,PIPES_AS_CONCAT. Do you want this: mysql set @@sql_mode='REAL_AS_FLOAT,PIPES_AS_CONCAT'; Query OK, 0 rows affected (0.00 sec) mysql select @@sql_mode; +---+ | @@sql_mode| +---+ | REAL_AS_FLOAT,PIPES_AS_CONCAT | +---+ It showing REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI when i set sql mode is ansi. But now i wish sql mode only include REAL_AS_FLOAT,PIPES_AS_CONCAT. Can I achieve it?wangxu wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Re: create function with space
Yes,I already read this section. But, maybe there are haven't relation to my question. Are the effect of setting IGNORE_SPACE in sql mode allowing add space between function name and (? If my attitude is right,then if i haven't setting IGNORE_SPACE in sql mode,I shouldn't add space between function name and (.But fact not like this. Please note example in my reference. - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 30, 2005 2:04 AM Subject: Re: create function with space Hello. From the manual: ANSI Equivalent to REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE. Before MySQL 5.0.3, ANSI also includes ONLY_FULL_GROUP_BY. See Section 1.8.3, ���Running MySQL in ANSI Mode��? wangxu wrote: I set my sql_mode = 'STRICT_TRANS_TABLES,ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO'. Note,IGNORE_SPACE not include sql mode. But i still execute statement as follow : CREATE FUNCTION wangxu.user () RETURNS int(11) BEGIN return 1; END - There is a space in function name and there is a space between function name and (.In mysql word,this funciton can't be created.But i created it well. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
question about sql mode = ansi
AS 1.7.3. Running MySQL in ANSI Mode explain: -- Running the server in ANSI mode is the same as starting it with these options (specify the --sql_mode value on a single line): --transaction-isolation=SERIALIZABLE --sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES, IGNORE_SPACEIf transaction isolation auto setting as SERIALIZABLE when i setting sql mode equal to ansi?On this condition,if the transation-isolation make no effect?What will happened if i set sql mode equal to ansi and transation-isolation equal to READ COMMITTED?
set sql mode
It showing REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI when i set sql mode is ansi. But now i wish sql mode only include REAL_AS_FLOAT,PIPES_AS_CONCAT. Can I achieve it?
Re: set sql mode
My sql_mode is STRICT_TRANS_TABLES,ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO. But when i execute select 1/0 from ht_detail,the result is Null. No error throw out. Why? - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, December 28, 2005 9:26 PM Re: set sql mode Hello. But now i wish sql mode only include REAL_AS_FLOAT,PIPES_AS_CONCAT. Do you want this: mysql set @@sql_mode='REAL_AS_FLOAT,PIPES_AS_CONCAT'; Query OK, 0 rows affected (0.00 sec) mysql select @@sql_mode; +---+ | @@sql_mode| +---+ | REAL_AS_FLOAT,PIPES_AS_CONCAT | +---+ It showing REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI when i set sql mode is ansi. But now i wish sql mode only include REAL_AS_FLOAT,PIPES_AS_CONCAT. Can I achieve it?wangxu wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
create function with space
I set my sql_mode = 'STRICT_TRANS_TABLES,ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO'. Note,IGNORE_SPACE not include sql mode. But i still execute statement as follow : CREATE FUNCTION wangxu.user () RETURNS int(11) BEGIN return 1; END - There is a space in function name and there is a space between function name and (.In mysql word,this funciton can't be created.But i created it well. Why?
how to use sql security
User_one create a procdure named proc with option sql security invoker. User_two only have execute privilege in the database that the proc in. But the User_two still call the proc. What effect do the sql security option producing?
Re: how to use sql security
How sql security option restrict privileges? - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: wangxu [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Wednesday, December 28, 2005 3:21 PM Subject:Re: how to use sql security At 15:17 +0800 12/28/05, wangxu wrote: User_one create a procdure named proc with option sql security invoker. User_two only have execute privilege in the database that the proc in. But the User_two still call the proc. What effect do the sql security option producing? proc runs with the invoker's privileges, that is, User_two's privileges. -- 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: insert utf8 character in Linux commind-line tool
No effect. I use chinese in konsole no problem but in mysql commind-line.So in my word, this problom maybe happen in mysql commind-line setup. - Original Message - From: 古雷 [EMAIL PROTECTED] To: wangxu [EMAIL PROTECTED]; Andreas Streichardt [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, December 20, 2005 11:47 AM Subject: Re: insert utf8 character in Linux commind-line tool export LANG=zh_CN.UTF-8 - Original Message - From: wangxu [EMAIL PROTECTED] To: Andreas Streichardt [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, December 20, 2005 10:10 AM Subject:Re: insert utf8 character in Linux commind-line tool Are there two option? How to use them? - Original Message - From: Andreas Streichardt [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, December 20, 2005 3:55 AM Subject: : insert utf8 character in Linux commind-line tool On Monday 19 December 2005 08:47, wangxu wrote: I can't operate utf8 characters within command-line in linux operating system. Mysql doesn't support? --without-libedit –with-readline=/usr/include/readline that fixed it for me Kind Regards, Andreas Streichardt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: (瑞星提示-此邮件可能是垃圾 邮件)Re: (鐟炴槦鎻愮ず-姝ら偖浠 跺彲鑳芥槸鍨冨溇閭欢)Re: insert ut f8 character in Linux commind-li ne tool
Are you mean this problom only disposed in compile ? - Original Message - From: Andreas Steichardt [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, December 20, 2005 4:34 PM Subject: (瑞星提示-此邮件可能是垃圾邮件)Re: (鐟炴槦鎻愮ず-姝ら偖浠跺彲鑳芥槸鍨冨溇閭欢)Re: insert utf8 character in Linux commind-line tool On Tuesday 20 December 2005 03:10, wangxu wrote: Are there two option? How to use them? These are just two options which you will have to use when ./configure'ing the source distribution if you are using a binary distribution of mysql try downloading the source distribution... then read http://dev.mysql.com/doc/refman/4.1/en/installing-source.html and add the two options to the configure. I can't operate utf8 characters within command-line in linux operating system. Mysql doesn't support? --without-libedit –with-readline=/usr/include/readline -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: insert utf8 character in Linux commind-line tool
Follow is the result. +--+-+ | Variable_name| Value | +--+-+ | character_set_client | utf8| | character_set_connection | utf8| | character_set_database | utf8| | character_set_results| utf8| | character_set_server | utf8| | character_set_system | utf8| I I use chinese in konsole no problem but in mysql commind-line.So in my word, this problom maybe happen in mysql commind-line setup. - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, December 20, 2005 8:02 PM insert utf8 character in Linux commind-line tool Hello. Please, provide the output of this statement: show variables like '%char%'; I import utf8 character in terminal commind-line is well.So in my word,there aren't error in my terminal settings. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: (瑞星提示-此邮件可能是垃圾邮 件)Re: insert utf8 character in L inux commind-line tool
Are there two option? How to use them? - Original Message - From: Andreas Streichardt [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, December 20, 2005 3:55 AM Subject: (瑞星提示-此邮件可能是垃圾邮件)Re: insert utf8 character in Linux commind-line tool On Monday 19 December 2005 08:47, wangxu wrote: I can't operate utf8 characters within command-line in linux operating system. Mysql doesn't support? --without-libedit –with-readline=/usr/include/readline that fixed it for me Kind Regards, Andreas Streichardt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: insert utf8 character in Linux commind-line tool
I import utf8 character in terminal commind-line is well.So in my word,there aren't error in my terminal settings. I can't import utf8 character when mysql commind-ling tool start only. - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, December 19, 2005 10:01 PM Subject: Re: insert utf8 character in Linux commind-line tool Hello. Check your terminal settings. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/charset.html http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html I can't operate utf8 characters within command-line in linux operating system. Mysql doesn't support? wangxu wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: use deterministic within procedure
It is a doubt.What do the deterninistic option do? You ever gave me the follow example: - create procedure unsafe_sp() begin if @@server_id=2 then drop databaseaccounting; enf if; end - This is a non-deterninistic procedure. In your word,The procedure can work in master and slave without any warning .But the procedure should produce different results on master and slave if master has server_id=1 and slave has server_id=2. If i add deterninistic option in the procedure.As follow: - create procedure unsafe_sp() DETERMINISTIC begin if @@server_id=2 then drop databaseaccounting; enf if; end - In your word,syntax check doesn't find the error and the procedure be executed without warning,too.And the different result also produce in the master and slave. What ever DETERMINISTIC option do? - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 16, 2005 5:38 PM Subject: (瑞星提示-此邮件可能是垃圾邮件)Re: use deterministic within procedure Hello. In the example,routine_body is non-deterministic.But the function defined DETERNINISTIC.Do mysql throw a exception in creating process? In my opinion, it shouldn't, but you can check this by yourself. I want to say,if i my funciton is a non-deterministic function.But i define then function with deterministic option. for example: - create function test() return int DETERNINISTIC routine_body -- In the example,routine_body is non-deterministic.But the function defined DETERNINISTIC.Do mysql throw a exception in creating process? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
insert utf8 character in Linux commind-line tool
无法显示邮件 Outlook Express 在显示此邮件时遇到了意外的问题。请检查你的计算机是否有足够的内存或磁盘空间,然后再试。 -- Outlook Express
insert utf8 character in Linux commind-line tool
I can't operate utf8 characters within command-line in linux operating system. Mysql doesn't support?
invalidation rollback?!
I execute follow procedure: --- create procedure test_transation_rollback() begin start transaction; create table t_34d (c1 int,c2 char(30)); rollback; end After execute this procedure,i find the table t_34d in my schema.Why?
Re: use deterministic within procedure
NO,no. I want to say,if i my funciton is a non-deterministic function.But i define then function with deterministic option. for example: - create function test() return int DETERNINISTIC routine_body -- In the example,routine_body is non-deterministic.But the function defined DETERNINISTIC.Do mysql throw a exception in creating process? - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, December 15, 2005 10:44 PM Subject: Re: use deterministic within procedure Hello. In my opinion, master shouldn't have any problems, but slave can have different data than master. What would happen if i call a non-deterministic function that have been declared deterministic. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: change a variables value
Now,i use default_character_set=utf8 in my.ini. When i restart my server,character_set_database and character_set_server change to utf8 but not character_set_client. Other, i don't hope character_set_database and character_set_server change. - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, December 14, 2005 6:25 PM Subject: Re: change a variables value Hello. You can use default_character_set=utf8 (be aware that it sets to utf8 character_set_results and characters_set_connections, but usually they're should be the same). How can i set character_set_client to utf8 in my.ini?Maybe there are not the variable.thanks! wangxu wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: use deterministic within procedure
thanks. I have read the links with you said. But i have a question,too. What would happen if i call a non-deterministic function that have been declared deterministic. - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, December 14, 2005 6:19 PM Subject: Re: use deterministic within procedure Hello. This not a complete answer for your questions, but you can find a lot of useful information from it (I hope). This procedure should produce different results on master and slave if master has server_id=1 and slave has server_id=2: mysql delimiter // mysql CREATE PROCEDURE unsafe_sp () - BEGIN - IF @@server_id=2 THEN DROP DATABASE accounting; END IF; - END; - // mysql delimiter ; mysql CALL unsafe_sp(); I've taken this procedure from: http://dev.mysql.com/doc/refman/5.0/en/stored-procedure-logging.html Example of non-deterministic data modifications you can find here as well: http://dev.mysql.com/doc/refman/5.0/en/open-bugs.html You can check by your self if it is possible to replicate functions which was declared NOT DETERMINISTIC. I have read the replicate document in reference manual.But i have some question. 1.If a deterministic storeprocedure only use in replication? 2.If a procedure within replication must be deterministic? 3.When a procedure result is non-deterministic?Can i get a example? wangxu wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
check a table column
I create a table using the follow statement: CREATE TABLE test_check(NO_W_ID int ,NO_D_ID int,MM int,CT int,CHECK(MM 3)); But server allow a insert statement as follow,why? insert into test_check values(1,1,1,1);
use deterministic within procedure
I have read the replicate document in reference manual.But i have some question. 1.If a deterministic storeprocedure only use in replication? 2.If a procedure within replication must be deterministic? 3.When a procedure result is non-deterministic?Can i get a example? thanks!
about innodb_safe_binlog option
My mysql version is 5.0.12-linux. I use show variables like 'innodb_safe_binlog'. But i can't find this option.Why?
about increment backup
Mysql increment backup technique is different from others.When a binlog file be created after enable binlong? thanks!
Re: a question of specifying Times for Recovery
Follow is a part of my my.ini. --- [client] port=3306 default-character-set=utf8 --- If default-character-set can't set in [client]? - Original Message - From: sheeri kritzer [EMAIL PROTECTED] To: wangxu [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, November 18, 2005 5:44 AM Subject: Re: a question of specifying Times for Recovery What does your my.cnf configuration for mysql say? Check out: http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html I think you want character_set as your variable, not default_character_set. Just my guess, not seeing any of your config files. -Sheeri On 11/16/05, wangxu [EMAIL PROTECTED] wrote: I specifying Times for Recovery with mysqlbinlog. Follow is my command: mysqlbinlog --database=menagerie --stop-data=2005-11-14 9:22:01 C:\Program Files\MySQL\MySQL Server 5.0\data\1.01 | mysql -uroot -p11 menagerie Mysql server throw a exception: mysqlbinlog: unknown variable 'default-character-set=utf8' please help me. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]