RE: Inserting '#' char as part of a field
Hi Are there any other characters with the same problem like #? Thanks -Original Message- From: Robby Tanner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 1:16 AM To: Stefan Hinz Cc: [EMAIL PROTECTED] Subject: RE: Inserting '#' char as part of a field I solved the issue (eventually) by using a different control. It seems the batch component interprets #'s differently than regular table and query components. I'll use query components in the future. Thanks anywaym, Rob -Original Message- From: Stefan Hinz [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 4:10 PM To: Robby Tanner Cc: [EMAIL PROTECTED] Subject: Re: Inserting '#' char as part of a field Robby, How can I get MySQL (via ZeosDBO in Delphi 5) to accept the # sign? Add extra quotes or a backslash before the character? Use double quotes? Some other method? I know about nothing of Delphi and Zeos, but I'd try a backslash before the # character. Here's what I get with the mysql client: mysql INSERT INTO mytest (bla) VALUES ('#'),('\#'); Query OK, 2 rows affected (0.03 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql SELECT bla FROM mytest; +--+ | bla | +--+ | #| | #| +--+ 2 rows in set (0.00 sec) Obviously, the backslash changes nothing, so I guess it won't hurt trying. Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] - 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 problems
Hi All I am trying to make a replication for my database. The master and the slave both in version 3.23.41 and i am working on windows 2000. I create user with FILE privilege and I flush all the tables and block write queries. Now I run the query SHOW MASTER STATUS and I get null in all the columns (file, position, Binlog_do_db and Binlog_ignore_db) What should I do? Thanks, Inbal - 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
two questions in mysql
Hi All, I have mysql 3.23.41 on windows 2000 I have two questions I need to ask. 1) I want bigger value for the max_connections variable. can I define the value in my.ini file? how can I define this variable? 2) I tried to insert into table a string with the char ' and mysql failed to do this. how can I solved this problem? are there any other chars like this? Thanks and please try to help Inbal - 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 in mysql
Hi All I am trying to make a replication for my database. The master and the slave both in version 3.23.41 I create user with FILE privilege and I flush all the tables and block write queries. Now I run the query SHOW MASTER STATUS and I get null in all the columns (file, position, Binlog_do_db and Binlog_ignore_db) What should I do? Thanks, Inbal - 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: database mirroring in mysql
Hi and thanks for the reply. After I read all about replication, I have a little question. In section 4.10.3 How To Set Up Replication, in step 3 it is written and then take a snapshot of the data on your master server. I am working on windows 2000 and I don't understand, how do I do the snapshot??? And another thing. Before I am doing all this steps, do I need to create the slave database? where do I need to create it? Thanks -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 12:29 AM To: Inbal Ovadia; [EMAIL PROTECTED] Subject: Re: database mirroring in mysql Inbal, Is there a possibility, in MySql, to define a mirror to my database, Yes. In MySQL, it's called replication, and it's quite easy to setup. More info: http://www.mysql.com/doc/en/Replication.html Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Inbal Ovadia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 02, 2003 4:56 PM Subject: database mirroring in mysql Hi all, Is there a possibility, in MySql, to define a mirror to my database, meaning that I define another database that will be a copy of my database and every operation that I will make on my database, will be done automatically in the second database? Or if I define database that contain only part of the tables in my database and when I will do some operations on one of those tables, the operations will be done in the second database? Thanks, Inbal - 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
database mirroring in mysql
Hi all, Is there a possibility, in MySql, to define a mirror to my database, meaning that I define another database that will be a copy of my database and every operation that I will make on my database, will be done automatically in the second database? Or if I define database that contain only part of the tables in my database and when I will do some operations on one of those tables, the operations will be done in the second database? Thanks, Inbal - 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: Recovery in MySql
Hi My tables are of type MYISAM. What exactly REPAIR does? Is this enough? If my database in not consistent is this command will help? Thanks, Inbal -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 10:10 PM To: Inbal Ovadia; MySQL Mailinglist Subject: Re: Recovery in MySql On 1/29/03 5:13 AM, Inbal Ovadia [EMAIL PROTECTED] wrote: Hi All, I have MySql on Windows. Today i had an electrical power interruption in the middle of working. The database remain not consistent and i could not continue working with it. Is there any Recovery after crash mechanism in mySql? Thanks, Inbal If you tables are of type MYISAM (find out with SHOW CREATE TABLE table) then most of the answers are here (myisamchk): http://www.mysql.com/doc/en/Table_maintenance.html Hth/h - 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
Recovery in MySql
Hi All, I have MySql on Windows. Today i had an electrical power interruption in the middle of working. The database remain not consistent and i could not continue working with it. Is there any Recovery after crash mechanism in mySql? Thanks, Inbal - 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
mysql - pro or classic?
Hi All how can i know if my mysql is pro or classic? - 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
access denied
Hi all I am working with mysql, in windows, visual c++. I am trying to run this query from c++ program: select * into outfile 'table_name.txt' FIELDS TERMINATED BY '\t' ESCAPED BY '\0' LINES TERMINATED BY '\r' from table_name And i get exception with this error: access is denied for user (If i run this query from the data base client, i am success) How can i solve this problem? Thanks, Inbal - 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
index in mysql
Hi all, I have a quation about index: In mysql, if i create table table_name with column loc_name (and another columns), and the col_name has PRIMARY KEY and UNIQUE constraints, Is an index created atoumaticly on this column? Thanks, Inbal - 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
information about the tables in the database
Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select tables from catalogName and get all the tables in the db thanks :) Inbal - 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
mysql and xml
Hi All Is MySQL works with XML? Thanks - 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
more than one query in mysql
Hi all, can I write a few queries in mysql , separate with suppose ; and run them together? if I can, in what version can I do that? thanks, Inbal - 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
installation question
Hi After i install mysql, there is a way that i can know on witch drive i installed it on? - 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
install MySql on drive other than C
Hi all, I read in the manual about building mysql not on c:\ and i found that i need to change the file my.ini my questions are: 1) can i build this file by my self and not with winmysqladmin.exe? 2) it is enough to change this file if i want to put mysql in drive d, or am i need to do another changes? thanks - 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
need help with installation
Hi I am working with Windows NT. I want to install mysql on drive d. Now i need to change the file my.cnf. In the manual they write that i need to put this file in c:\ BUT what if i don't have drive C?? and if now i want to write some program that find out the drive that mysql installed on. how can i do it? Thanks - 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
mysql++
Hi all, i want to know if i can work with mysql++ with both sql server and mySql thanks - 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
mysql-3.23.50
Hi all i have mysql-3.23.41 should i install 3.23.50? what are the differences between this versions? thanks - 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
Running Multiple MySQL Servers on the Same Machine
Hi all, I want to run multiple mySQL servers on my machine. Can i do this on windows 2000 or just on Unix? because the manual talk about Unix. How can i do this on windows? thanks - 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
in and not in
Hi i want to do in mysql query like that: SELECT col_name FROM table1 NOT IN (select col_nmae FROM tablse2) how can i do that? thanks - 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
limitation in mysql
Hi, Is there any limitation about the number of rows in a table and about the number of tables that i can put in mysql? - 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
mysql_affected_rows()
Hi I build a batch file that run a few sql queries. I want to know the results (how many rows affected) but it doesn't recognize the method mysql_affected_rows. What should i use to get the results? Thanks - 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