my sql data base
Apologies in advance: I am a developer with mysql and active and my work involved CAPI of MYSQl,Database DeZign with Dezign and database development. Currently looking out for job opportunities in mySQl related areas.Can suggest me any exclusive websites and openings in mysql related areas. ..I do apologize in advance for asking this in this forum.I am hoping that someone will get back to me. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
my sql database query retrieval order
Hi, I wonder to know if mysql follows any order in retrieving the data from a table.i.e Is it based on ascending row order or descending row order. --Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
my sql query retrieval(Urgent)
Hi, Is there a way to retrieve the field values in the same order as during insertions based on something like rowid or so?? Eg: Insertion order into a table for a text field: bbb abaa aa Retrieval order: I want to have the retrieval order also the same.The output of the query on that field should give : bbb abaa aa Any ideas?? --Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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:delete
Auto_increment is one of the options --Ravi --- Martin Quevedo [EMAIL PROTECTED] wrote: Hi all, When I perform a delete command and then I insert a new row, this new row is placed in the row just deleted. Is it possible to place newly inserted rows always at the end of the table??? Martin - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 size limit
Hi, For most of the platforms Mysql has reasonably enough space for each table itself(in GB).Database wise, also there should not be any problem for the database size you are mentioning.For sure,I can say that I have not worked on Mandrake.But, I feel the size you have mentioned should not be a problem. Regards, Ravi --- Ali Kemal YURTSEVEN [EMAIL PROTECTED] wrote: Well, my server is running on Mandrake 8.0. We're trying to implement database hosting at our site, therefore people should probably have database spaces between 10-50 MB. In Microsoft SQL server you can limit the size of a database when creating it. Is it possible in MySQL ? VVM Ravikumar Sarma Chengalvala wrote: No need to worry.On NT each table can have upto4GB.Database there is predefined limit.It can go even upro 20GB or more also. --- Ali Kemal YURTSEVEN [EMAIL PROTECTED] wrote: Hi, I'm new in this list and new to MySQL also. What I want to know is how to limit the size of a database. Thanks. -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
my sql and patter matching ....bug(Urgent)
Hi, I am facing the following problem in pattern matching: I want to check the pattern matching using LIKE on a field that is declared as Binary and also contains back slashes. eg: ID INT, NAME VARCHAR(128) BINARY I am using C-API of mysql to escape the characters like '\' for this field. The samples field values for the above are: XYZ\ABC,PQR\ABC,DEFABC. If I use the follwoing statement for pattrn matching: SELECT NAME FROM [TABLE-NAME] WHERE NAME LIKE %\\ABC% . Tried the other way too like this: SELECT NAME FROM [TABLE-NAME] WHERE NAME LIKE %\\ABC% it returns all the three values instead of only two Is this a bug or what is the solution. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: my sql pattern search and support for backslash??
It is not working even after escaping it.I am working on WINNT4.0 and mysql 3.23 --Regards, Ravi --- Scott Baker [EMAIL PROTECTED] wrote: It depends on what you mean by pattern search? You probably have to escape the \ character. If you put a \ in front of a character it means this next character is what I say it is not it's MySQL representation. This would allow you to put a ; or ) in your query. Simply put \\ to mean a backslash. Scott At 04:15 PM 6/18/2001 +0100, VVM Ravikumar Sarma Chengalvala wrote: Hi, Did mysql pattern search support a backslash character? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] PGP KeyID: 0xC2153655 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
my sql and pattern search--bug(most urgent)
Hi, Can someone get back to me at the earliest regarding mysql's support for backslash characters in pattern search.I am not able to search based on the string which contains a backslash character even after escaping.. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 size limit
No need to worry.On NT each table can have upto4GB.Database there is predefined limit.It can go even upro 20GB or more also. --- Ali Kemal YURTSEVEN [EMAIL PROTECTED] wrote: Hi, I'm new in this list and new to MySQL also. What I want to know is how to limit the size of a database. Thanks. -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My sql database and faster queries
Hi, I wonder to know which of the following is better in performance and faster . Using table joins for queries. OR Multiple queries without joins using MySql C API Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: My sql database and faster queries
Hi, THe maximum number of table joins I ned is not more than three.Most of the search criteria is based on Unique or Primary keys and hence I did not opt for indexing.I am using the default myISAM table types of mysql and mysql C_API. Previously someone suggested using C_API functions over joins will make the queries run faster.The database may have to search for all the queries from about 10 rows in each table. Regards, Ravi --- Brandon Lewis [EMAIL PROTECTED] wrote: The all horrible answer depends. The database is just that, a database, and it is intended to be used to store and retrieve relational data. The structure of your tables, and indexes will play a big role, also table\page\row locking factors in greatly. I am sorry to say the answer is not black and white. Sometimes it is better to pull the data out and process it, sometimes it better to do a little of both. Without details I am afraid I can't help much. -Original Message- From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 7:45 AM To: [EMAIL PROTECTED] Subject: My sql database and faster queries Hi, I wonder to know which of the following is better in performance and faster . Using table joins for queries. OR Multiple queries without joins using MySql C API Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My sql queries...Which is better??
Hi, I am using my sql CAPI.I am able to access the database well but there is one performance issue that came into my mind. Is it better to have a single query on multiple tables using joins? (OR) Multiple queries without joins on each table,in a sequential order . If I use joins also,there won't be more than 3 tables. I got the issue especially keeping in view of the factor that I am using C API and I can achieve the effect of having joins through C/C++ language. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Bug in my sql ......mysql.exe?
Hi, I donot think it is supposed to show the number of rows deleted or it should not show anything at all.I agree if it is not a bug,at least it is an unwanted thing . When it always shows the affected number of rows as zero though it actually deletes a million records,it must be removed or made oK REgards, Ravi --- Adrian D'Costa [EMAIL PROTECTED] wrote: Ravi, That is not a bug. It works like that. I use linux the same here. Adrian On Thu, 31 May 2001, VVM Ravikumar Sarma Chengalvala wrote: Hi, i) I am using mysql.exe. ii) I could observe a small bug.Whenever I use a delete or update command,it always gives a message on my console window stating that zero rows affected.Ofcourse the actual statement works fine.Only the post command message on console window misleads me many times. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: ASP and my sql??
Hi everyone, 1) Thanks for all your ideas. 2) Infact I am already using C-API for data retrieval from mySQL and I want to provide admin utility to my application which runs on a web server.I donot want to use ODBC.It tends to bind my application mostly to windows.Currently I am considering the fllowing options: i) ASP ii) Using java swing in applets iii) A CGI program iv) Using AWT and applets v)Any other Your views will be of great value in selecting the right technology... Regards, Ravi --- Jorge del Conde [EMAIL PROTECTED] wrote: Hi Dennis, You CAN NOT, as far as I know, connect to a MySQL database, through ASP (or any other program, I believe), without having at least the MyODBC driver installed on the server. This is not entirely correct. ODBC is merely just one more way to connect to MySQL. MySQL just like many other databases in the industry has an API which can be used to connect to the server with out going through all the Microsoft imposed protocols such as ODBC ADO. A good example of this is PHP (http://www.php.net) . In general, PHP does not use nor require ODBC to be installed in order to access a MySQL database. So is the case for Zeos (http://www.zeoslib.org/) which is a free set of components for accessing MySQL (and other databases) directly by means of the API calls rather than ODBC (for Delphi C++ Builder). In terms of Microsoft's software, which all support ActiveX, there is at least one COM object that I know of that can connect directly to MySQL without using MyODBC. Such component is called MySQLX and can be found in http://www.scibit.com . Regards, Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: Dennis Salguero [EMAIL PROTECTED] To: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 7:06 PM Subject: Re: ASP and my sql?? It depends on what you mean by without using ODBC. You CAN connect to a MySQL database without a DSN name, you can just declare an IP address and a DB name, but I'm pretty sure that this method still uses the MySQL ODBC driver and it must be installed on the server. You CAN NOT, as far as I know, connect to a MySQL database, through ASP (or any other program, I believe), without having at least the MyODBC driver installed on the server. PLUG I wrote a case study for ASPToday on ASP and MySQL integration. You can view the synopsis and the article by going to: http://www.asptoday.com/content/casestudies/20010302.asp /PLUG Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Original Message - From: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 1:03 PM Subject: ASP and my sql?? Hi, I wonder to know of any other ways to connect to mySQL from ASP without using ODBC Regards, Ravi - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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:my sql and ASP??
Hi, I have checked up MYSQLX at www.scibit.com but it ties me down to IIS.I cannot use it to apache etc... I am curious to know about any more available components.! Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
Bug in my sql ......mysql.exe?
Hi, i) I am using mysql.exe. ii) I could observe a small bug.Whenever I use a delete or update command,it always gives a message on my console window stating that zero rows affected.Ofcourse the actual statement works fine.Only the post command message on console window misleads me many times. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Insert Automatically
Hi, You can write a script file and run it. Regards, Ravi --- KAMRY [EMAIL PROTECTED] wrote: database,sql,query Hi guys, I appreciate it if some can help here Is it possible to do a script file like in Oracle with statements like these: insert into countries (id,country,country2) values(IDDI, Venezuela, ); insert into countries (id,country,country2) values(IDDI, Vietnam, ); insert into countries (id,country,country2) values(IDDI, Western Sahara, ); insert into countries (id,country,country2) values(IDDI, Yemen, ); insert into countries (id,country,country2) values(IDDI, Yugoslavia, ); insert into countries (id,country,country2) values(IDDI, Zambia, ); All what I found an understood from Load Data is that I have to follow some kind of syntax/delimiters/etc... Yet the question is that can I load a data file containing the above statements, and how? Thanks, Kal _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My sql and BINARY column?
Hi, I wonder to know whether declaring a column as BINARY will take the characters like \,' etc into binary form and stores it in the database? Then we may not need to specify the escape sequences.. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
ASP and my sql??
Hi, I wonder to know of any other ways to connect to mySQL from ASP without using ODBC Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My sql and system time
Hi, Can some one let me know how can I insert current time into the MySQL table's time column. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My sql and indexing
Hi, I would like to have answers/confirmation regarding the following: i) Primary and Unique key fields are autoindexed by mysql. ii) Indexing on a single or multiple fields will create a overhead on database memory.To what extent iii) Indexing Vs Perfromance based on a query frequency on a particular field. iv) When indexing is not recommended? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 performance question
Joshua, Comparing Oracle vs. MySQL myisam tables, MySQL will save disk space, and provide you with much faster queries, but you have to be aware of the table locking issues if you are doing updates/inserts/deletes mixed with reads. MySql documentation says that mysql enforces table level locking if no explicit locking is there.If I am using non transaction sensitive tables can I go ahead without providing any explicit locking?I am using myISAM. Regards, Ravi _ Joshua Chamas Chamas Enterprises Inc. NodeWorks free web link monitoring Huntington Beach, CA USA http://www.nodeworks.com 1-714-625-4051 - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 shutdown!
Hi, 1. Anyone recommends a particular shutdown procedure for mysql database? 2. The reason: i)I get some weardy errors on NT4.0 workstation like memory referencing while doing the shutdown ii) Some times I get an error while shutting down the mysql server .Once I use SHOW Databases after the shutdown command the problems never occur. 3. I am not using mysql as an NTService and I installed mysql in 'D:/' drive. 4. Your experience and suggestions will be highly appreciated Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My Sql and default installation
Hi, I have installed mysql on WIN NT4.0.By default ,will mysql use ISAM as the default? When to opt for BDB? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
my sql database and locking issues(URGENT)
Hi, 1. Does mysql inherently implement locking implicitly? 2. The following is the extract from mysql documentation: In MySQL Version 3.23.7 and above, you can insert rows into MyISAM tables at the same time other threads are reading from the table. Note that currently this only works if there are no holes after deleted rows in the table at the time the insert is made. ACTUALLY,VERSION 3.23.7 IS NOT RELEASED.ARE THESE THE EXPECTED FEATURES IN THE COMING VERSION? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My sql and myISAM
Hi, Do someone have answers to these questions: 1. Maximum table size myISAM type tabes can handle? 2. Default maximum database size for a particular database. Your help will be highly appreciated. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
my sql admin site
Can some one let me know about the URL to go through the mysql Admin issues. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
Data base memory capacity in my sql
Hi, I wonder whether mysql has any default memory allocation and has a similar procedure for extending the memory as does Oracle. Can someone throw some light on this? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
Expilicit locking-Does my sql recommend one?
Hi, I was going through my sql documentation and found the stability of mysql for locking is Gamma.Does mysql recommend the usage of explicit locking for sensitive data or will it automatically handle concurrent requests? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
Important questions(Help needed )
Hi, 1. What is the default memory allocated by mysql to a newly created database? 2. If I make any changes to a database(either by adding a new table or by adding or deleting a column of a table) is there a way ,I can have a version control of my database and retain the old tables and new tables of the database also? 3.How does mysql implement concurrency control?Will it lock the table automatically in case multiple users try to access the same table at a time?If so, what is the type of locking it enforces by default? 4. Your replies are highly appreciable. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My sql database Important questions(Help needed )
Hi, 1. What is the default memory allocated by mysql to a newly created database? 2. If I make any changes to a database(either by adding a new table or by adding or deleting a column of a table) is there a way ,I can have a version control of my database and retain the old tables and new tables of the database also? 3.How does mysql implement concurrency control?Will it lock the table automatically in case multiple users try to access the same table at a time?If so, what is the type of locking it enforces by default? 4. Your replies are highly appreciable. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Varchar binary field auto-trimmed??
Hi, We can decalre a varchar field as BINARY if we need case sensitive storage of field values. Regards, Ravi --- ryc [EMAIL PROTECTED] wrote: Varchar fields are not binary, blobs are. ryan Hi Help! I would like to store some short binary data (encrypted). I used a varchar(24) binary field for this. But it seems that MySQL cuts white-spaces from the end when storing the data in the table. When the encrypted string now has a white-space at end, MySQL will cut it and this will result in a wrong decryption (next time when the string is read and decrypted). When using TinyBlob instead of varchar binary, all works fine. Is this a feature of varchar binary? In my opinion, binary data shouldn't be trimmed! Please answer me via mail as I don't receive the mailing list. Thanks for your support! ... tobias wiersch - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My Sql Database memory(new bie to admin)
Hi, Can some one tell me the default memory the mysql allocates when we initially create a database and how to increase the memory subsequently. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Bug in CAPI of My Sql
Sinisa, 1. Thanks for the mail. 2. I observed that mysql_escape_string()soes not work either.If I want to store a file name with back slashes,I feel mysql_escape_string() should introduce the additional backslash required .But it does not do so.It is just copying from source string to destination string. 3. Because of this I am unable to store the escape string into the database.By the way can you send me the exact syntax for mysql_escape_string() so that I can check it up to further confirm that I am not missing out on any thing. 4. mysql_escape_string() does not complain but I feel it is not doing what it is supposed to do. Regards, Ravi --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: VVM Ravikumar Sarma Chengalvala writes: Hi, 1. I am using MySQL3.23 on WindowsNT4.0 platform. 2. Whenever I try to use mysql_real_escape_string() method,it works well with the compiler and fails while linking.I am using VC++6.0 as environment .The reason that I have traced out is: i) The function mysql_real_escape_string() is not coming in the downloaded MySQL.I have checked up the .def file in the Includes directory and found that the function is not there in the .def file as well. ii) Then I tried to use mysql_escape_string(),but the documentation says to use mysql-real_escape-string. iii) Pl note that mysql_escape_string is present in the .def file in the includes directory but not mysql_real_escape_string(). 3. I request you to suggest remedy for the same. Regards, Ravikumar Sharma Chengalvala Software Engineer Hi! I must say I do not truly know how that error crept into Win32 source, but that function is truly simple : ulong STDCALL mysql_real_escape_string(MYSQL *mysql, char *to,const char *from, ulong length) { return mysql_sub_escape_string(mysql-charset,to,from,length); } Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\ Developers Team - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Bug in CAPI of My Sql
Hi Sinisa, Thanks for the detailed mail.Can you send me the syntax for mysql_escape_string() please so that I can check up with what I have been trying out. Regards, Ravi --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: VVM Ravikumar Sarma Chengalvala writes: Sinisa, 1. Thanks for the mail. 2. I observed that mysql_escape_string()soes not work either.If I want to store a file name with back slashes,I feel mysql_escape_string() should introduce the additional backslash required .But it does not do so.It is just copying from source string to destination string. 3. Because of this I am unable to store the escape string into the database.By the way can you send me the exact syntax for mysql_escape_string() so that I can check it up to further confirm that I am not missing out on any thing. 4. mysql_escape_string() does not complain but I feel it is not doing what it is supposed to do. Regards, Ravi Hi! mysql_escape_string() will escape all chars properly. I use it everyday in many programs without a single glitch. You probably did not pass a correct parameters, as mysql_escape_string will escape them properly. Here is an excerpt from the function itself: switch (*from) { case 0: /* Must be escaped for 'mysql' */ *to++= '\\'; *to++= '0'; break; case '\n':/* Must be escaped for logs */ *to++= '\\'; *to++= 'n'; break; case '\r': *to++= '\\'; *to++= 'r'; break; case '\\': *to++= '\\'; *to++= '\\'; break; case '\'': *to++= '\\'; *to++= '\''; break; case '': /* Better safe than sorry */ *to++= '\\'; *to++= ''; break; case '\032': /* This gives problems on Win32 */ *to++= '\\'; *to++= 'Z'; break; default: *to++= *from; As you can see '\\' is escaped too... Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\ Developers Team Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: Bug in CAPI of My Sql
Hi Sinisa, Thanks for spending the time.Here are few observations on mysql_escape_string().I have checked it up and found to be working but with the following problems. i) It works well when I want to insert strings like: 'xyz or x'yz. ii) When I use x\yz with the function I see a junk character appearing like x(junt char)yz in mysql console window and as x|yz in GUI window. Please note that the line shown ablove appears as a thick line. iii) If I want to store something like\x\yz,it even ignores the first backslash. iv) This happens when I pass it through the function.Otherwise if I send something like\\x\\yz directly without going through the function then it stores it as \x\yz. v) This is the problem with the function itself or shall I have to do something else. Regards, Ravi --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: VVM Ravikumar Sarma Chengalvala writes: Hi Sinisa, Thanks for the detailed mail.Can you send me the syntax for mysql_escape_string() please so that I can check up with what I have been trying out. Regards, Ravi Here is an example from C++ : char* s = new char[in.size()*2+1]; mysql_escape_string(s, const_castchar *(in.c_str()), in.size() ); Actually, it is quite simple : unsigned long mysql_escape_string(char *to,const char *from, unsigned long from_length); You pass to char array of at least 2 * from_length + 1 bytes. You pass original char array as a second parameter and it's total length as a third parameter. The above function returns a new length of `to' char array. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\ Developers Team . - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
my sql_escape_string()--Bug?
Hi Sinisa, 1. Thanks for the detailed mails .I got to the problem I am facing with '\' character. 2. Actually I am expecting the function to add an additional \ when a single '\' comes as a part of string.For example: I want to insert a File path like \Program Files\xy\xyz.geo I n expecting the function mysql_escape_string() to convert it into \\Program Files\\xy\\xyz.geo which it is not doing precisely. Am I right in my perspective?i.e mysql_escape_string does not provide support for a single backslash characher which comes as part of the string. Even the function code which you have sent does not say anything about it. Shall I have to write a small code to replace '\' with a '\\'? Then :Is it a Bug? 3. Once again thanks for your patience .I am putting down the problem in detail as it provides scope for improvement in next version. Regards, Ravi Regards, Ravi --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: VVM Ravikumar Sarma Chengalvala writes: Hi Sinisa, Thanks for the detailed mail.Can you send me the syntax for mysql_escape_string() please so that I can check up with what I have been trying out. Regards, Ravi Here is an example from C++ : char* s = new char[in.size()*2+1]; mysql_escape_string(s, const_castchar *(in.c_str()), in.size() ); Actually, it is quite simple : unsigned long mysql_escape_string(char *to,const char *from, unsigned long from_length); You pass to char array of at least 2 * from_length + 1 bytes. You pass original char array as a second parameter and it's total length as a third parameter. The above function returns a new length of `to' char array. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\ Developers Team . Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
Can some one send me the My Sql API Sample code?
Hi, Can some one send me the sample working code of C API for MYSQL for the following functions(The platform on which MySQl data base was downloaded is WINDOWS NT-4.0 work station): Functions for which I need the dample code: mysql_real_escape_string() mysql_escape_string() Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: What does my sq l_escape_string do exactly?
Hi Rolf, Your guess is not true.I am using MySQL C-API for accessing the My SQL data base on Windows N T 4.0. Regards, Ravi --- Rolf Hopkins [EMAIL PROTECTED] wrote: Ok, I'm going to make a guess here. You're using Apache web server with php4 to store and retrieve info from a mysql DB, right? If this is correct then this is not a mysql problem but an apache/php problem. Go to the php site and have a read of the user commented on-line manual. In the installation section, I've submitted an explanation on how to set the php init flags. - Original Message - From: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 13, 2001 13:35 Subject: What does my sq l_escape_string do exactly? Hi, I am working on with mysql_escape_string() what it does precisely is to copy the content from source string to destination string. It's not introducing the additional backslash character (\\) required if I need to save a string likeabc\def. If we enter the string as abc\\def then it is stored in the DataBase as abc\def.If we have to externally introduce the back slash into the string to store ,then what does this my sql function do? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: My Sql C_API(Urgent)
Hi , Infact I tried it out that way.There is a problem with my_sql_real_escape_string() .I.e at the time of linking it is giving an Unresolved External Symbol for this function.For rest of the API functions it's OK. I checked up with the .def file in the includes directory and found that this functionis not listed in that.Tried it out with another download of MYSQL but same is the case. Regards, Ravi --- Shambhu Kumar singh [EMAIL PROTECTED] wrote: Hi, Instead of working with the strmov function use pointers to work on it, like I had to Ex: char myQuery[1024]=; CurrentAddress = myQuery; CurrentAddress+= mysql_real_escape_string( MysqlStruct,CurrentAddress, string, strlen(string) ); Best of Luck, S.K. Singh. - Original Message -- =?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?= [EMAIL PROTECTED] wrote: To:[EMAIL PROTECTED] From:=?iso-8859-1?q?VVM=20Ravikumar=20Sarma=20Chengalvala?= [EMAIL PROTECTED] Date:Fri, 11 May 2001 16:35:21 +0100 (BST) Subject: My Sql C_API(Urgent) Hi, I am using my_sql_real_escape_string and in that the strmov function of mysqlclient library. I am getting the following errors while compiling: d:\program files\mysql\include\m_string.h(143) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(146) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(147) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(149) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(151) : error C2061: syntax error : identifier 'pchar' d:\program files\mysql\include\m_string.h(154) : error C2061: syntax error : identifier 'my_string' d:\program files\mysql\include\m_string.h(155) : error C2146: syntax error : missing ';' before identifier 'strinstr' d:\program files\mysql\include\m_string.h(155) : fatal error C1004: unexpected end of file found Error executing cl.exe. I could not locate the identifiesrs strinstr etc in any of the include files. Can some one guide me for a way out. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
Bug in CAPI of My Sql
Hi, 1. I am using MySQL3.23 on WindowsNT4.0 platform. 2. Whenever I try to use mysql_real_escape_string() method,it works well with the compiler and fails while linking.I am using VC++6.0 as environment .The reason that I have traced out is: i) The function mysql_real_escape_string() is not coming in the downloaded MySQL.I have checked up the .def file in the Includes directory and found that the function is not there in the .def file as well. ii) Then I tried to use mysql_escape_string(),but the documentation says to use mysql-real_escape-string. iii) Pl note that mysql_escape_string is present in the .def file in the includes directory but not mysql_real_escape_string(). 3. I request you to suggest remedy for the same. Regards, Ravikumar Sharma Chengalvala Software Engineer Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
Is mysql_escape_string() in CAPI of My Sql working?
Hi, I want to use mysql_escape_string(0 to store the File Names with back slash character('\'). Unless I enter \\ in the File name it is not taking in. Will the function automatically add the additional '\' required. What is the exact role of this function? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
What does my sq l_escape_string do exactly?
Hi, I am working on with mysql_escape_string() what it does precisely is to copy the content from source string to destination string. It's not introducing the additional backslash character (\\) required if I need to save a string likeabc\def. If we enter the string as abc\\def then it is stored in the DataBase as abc\def.If we have to externally introduce the back slash into the string to store ,then what does this my sql function do? Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My Sql C_API(Urgent)
Hi, I am using my_sql_real_escape_string and in that the strmov function of mysqlclient library. I am getting the following errors while compiling: d:\program files\mysql\include\m_string.h(143) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(146) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(147) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(149) : error C2061: syntax error : identifier 'uint' d:\program files\mysql\include\m_string.h(151) : error C2061: syntax error : identifier 'pchar' d:\program files\mysql\include\m_string.h(154) : error C2061: syntax error : identifier 'my_string' d:\program files\mysql\include\m_string.h(155) : error C2146: syntax error : missing ';' before identifier 'strinstr' d:\program files\mysql\include\m_string.h(155) : fatal error C1004: unexpected end of file found Error executing cl.exe. I could not locate the identifiesrs strinstr etc in any of the include files. Can some one guide me for a way out. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My Sql 3.2.3 and real_escape_string in C API
Hi, Does Mysql 3.2.3 support mysql_real_escape_string()? I donot find it included in the Libmysql. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
my sql _escape_string
Hi , Can some one send the exact function description of the following CAPI function: mysql_escape_string I need to use mysql_escape_string as the mysql-real_escape_string is not present in the .def file and is giveing linker error while linking. The C-API documentation says to refer mysql_real_connect instead. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My SQL Database and escape sequences
Can some one let me know all possible ways to provide escape characters in MYSQL inserts. I am using C API. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
my sql database and unique keys
Hi, How can I have an UNIQUE key in MYSQL which differentiates between case sensitive strings.i.e If I want to store XYZ,XYz and xyz differently.Currently mySQl is not accepting this type of strings and treating them as the same. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
My SQL C_API(urgent)
Hi, I am having a peculiar problem with C_API.How to execute a query string with its length more than 255 characters using mysql_query() function.My sql query is more than 255 characters long and is getting truncated. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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: auto_increment
Hi, There is no other go.I too had similar problems.But it does not hurt me as the auto_increment column is always being used as a primary key in my case. We have got to live with it until and unless we have some option to insert into the deleted row. Regards, Ravi --- Joseph Bueno [EMAIL PROTECTED] wrote: Stefan Wehowsky wrote: Let´s say I got a column id that is of type tinyint and has the extra auto_increment. Let´s further say that I have 50 entries in that column. Now if I delete e.g. entry No. 30 and right after that add another entry without naming an id (for ist auto_increment) MySQL gives it the id 51 AND NOT 30 which leads to more and more gaps between the id´s. Is there anything i can do about that ? No. Also, don't use TINYINT unless you are sure that you will never insert more than 127 records ! (Both issues have already been discussed in this mailing list, check the archives for more details). Best regards, Stefan Wehowsky Best Regards -- Joseph Bueno NetClub/Trader.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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 C API
Hi PAUL, 1.Thanks for the mail. 2.Regarding the return values I wonder anyone else has encountered other than the values -1,0 for mysql_query(). 3. I will try our the option suggested by you for mysql_real_connect(); 3. Another thing does mysql_api has any provision to send the error messages to the log files. Regards, Ravi --- Paul DuBois [EMAIL PROTECTED] wrote: At 8:13 PM +0100 5/3/01, VVM Ravikumar Sarma Chengalvala wrote: Hi, 1. I am using C_API for accessing data from MYSQL. 2. mysql_query() function returns the following values: 0 if the query is successful -1 if the query fails. No. It returns 0 if the query is successful and NON-ZERO if it fails. You cannot count on the non-zero value being -1. 3. At the same time mysql-C_API documentation specifies that it returns a non zero number if query is a failure.Does the function return any other values other than -1 if the query fails? Don't test for -1. Test for non-zero. 4. If I use the mysql_query() for INSERT or UPDATE statements I am facing the following problem: If the database column value I am trying to update is the same as the the value already existing in the database,then the mysql_query() returns 0 and the mysql_affected_rows() returns zero. It will be good if mysql_query either returns -1 for this case as the value being updated is same as that of existing one. Try setting the CLIENT_FOUND_ROWS option in your mysql_real_connect() call when you connect to the server and see what happens.. Regards, Ravi -- Paul DuBois, [EMAIL PROTECTED] - 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 Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 C API
Hi, 1. I am using C_API for accessing data from MYSQL. 2. mysql_query() function returns the following values: 0 if the query is successful -1 if the query fails. 3. At the same time mysql-C_API documentation specifies that it returns a non zero number if query is a failure.Does the function return any other values other than -1 if the query fails? 4. If I use the mysql_query() for INSERT or UPDATE statements I am facing the following problem: If the database column value I am trying to update is the same as the the value already existing in the database,then the mysql_query() returns 0 and the mysql_affected_rows() returns zero. It will be good if mysql_query either returns -1 for this case as the value being updated is same as that of existing one. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
CHECK CONSTRAINT
Hi, Any round about way of achieving CHECK CONSTRAINT FEATURE in MySQL before inserting a data into database? REgards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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
Drop Table
Hi, I am facing the following problem with MySQL3.2.3: OS:Windows NT 4.0 When ever I try to DROP A TABLE it gives the following "Error on delete of '.\dbhub\data_source_type.MYI' (Errcode: 13)" Can someone let me know the reason.It works fine sometimes.But the behaviour is not consistent. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 API for C
I am using MYSQLAPI for C in my C++ program.WHat are all the precautions while using this way and how should I proceed.Shall I need to provide an extern C for the mysql.h header file. Pl help if someone already worked. REgards, Ravi __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.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