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.

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

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

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???

Re: Database size 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

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

Re: my sql pattern search and support for backslash??

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

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

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

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

RE: My sql database and faster queries

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

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

Re: Bug in my sql ......mysql.exe?

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

Re: ASP and my sql??

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

Re: Bug in CAPI of My Sql

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

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

Re: Bug in CAPI of My Sql

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

my sql_escape_string()--Bug?

[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

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

Re: What does my sq l_escape_string do exactly?

: 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

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

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

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

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

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) :

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

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

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

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

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

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

Re: MYSQL C API

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

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

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

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.

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