error LNK2001: unresolved external symbol _mysql_real_escape_string

Hi, I am trying to use mysql_real_escape_string() C API for escaping the special characters. When I tried to compile the program using the Visual Studio, I am getting the following link error error LNK2001: unresolved external symbol _mysql_real_escape_string fatal error LNK1120: 1

error LNK2001: unresolved external symbol _mysql_real_escape_string

Hi, I am trying to use mysql_real_escape_string() C API for escaping the special characters. When I tried to compile the program using the Visual Studio, I am getting the following link error error LNK2001: unresolved external symbol _mysql_real_escape_string fatal error LNK1120: 1

Storing a string value with slash(\)

Hi, From the front end I need to use double slashes i.e (\\) to enter one slash (\) into the MySQL database. I.e, if I enter Gelb\Paha, it stores in the mySQL as GlebPaha, If I enter S\\Greeen, it stores as S\Green in the database. Is there any way in MySQL so that I can enter any

RE: Regarding the date values loading into the tables from a text file

Hi, From the front end I need to use double slashes i.e (\\) to enter one slash (\) into the MySQL database. I.e, if I enter Gelb\Paha, it stores in the mySQL as GlebPaha, If I enter S\\Greeen, it stores as S\Green in the database. Is there any way in MySQL so that I can enter any number

Regarding the date values loading into the tables from a text file

Hi, I am trying to load the data from a text file into the table. I have two datetime datatype fileds in my table. When I loaded the data into the table using the Load Data INFILE syntax, In the table my date fileds values are loaded as -00-00 00:00:00. The datetime value in the

Reg insertion of data

Hi, We are inserting the text data into mysql. But, when we see the dump of that table, we are seeing '\r' at the end of the value of that text. Actually we are not inserting the data with '\r'. Can any one of you help me in removing that '\r', imean I donot want to see that '\r' even in

RE: Reg insertion of data

Sorry, I forgot to mention theat I am inserting into mysql using load data infile. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 04, 2005 9:04 PM To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Subject: Reg insertion of data Hi,

RE: Reg insertion of data

Green, Thank you very much for your reply. Yes, if i see in the hex(), 0D 0A are coming at the end of each line. While dumping data i am using just LOAD DATAINFILE My.LST' INTO TABLE My_Table; Please let me know what deleimiters i have to use to avoid '\n\r' at teh end of line.

RE: Reg insertion of data

Green, Actaully i am dumping that data from oracle into .lst file which will be in the mysql format. We are not getting any \n\r in that case. Thanks, Narasimha -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 04, 2005 10:55 PM

RE: Regarding the cpu utilization of mysqld

Hi, We are using the same set of query's what we re using in some other process, where the mysqld CPU utilization is minimum. But for this process particularly, mysqld is utilising more than 90 % of CPU. Even in 2GB RAM machine also, behaving same. We are using Windows XP/ 2000/ 2003

Regarding the cpu utilization of mysqld

Hi, When running a process which is a part of my apllication, mysqld.exe is using 90%-95% of cpu utilization. Here I used mysqld for starting the mysql server. For other processes in the application, CPU utilization is very minimum. I used optimization (for order by, select and like) in

Regarding the usage of mutex in the mysql connection threading

Hi, We migrated a NMS project from oracle 7.3 database to mysql 4.0.23. In the migration we kept the mutex mechanism followed in the oracle for connection threading. Actually these mutex are mainly used before executing the sql statements which returns multiple number of records and

RE: Regarding the usage of mutex in the mysql connection threading

Hi Green, Thanks a lot for your reply. In brief if I explain the architecture it something goes like this:- - Element management Apllications uses MySQL database through DB access layer. - DB access layer provides the application some APIs needed for DB opearations. - for Each DB transactions

RE: Regarding the usage of mutex in the mysql connection threading

hi , Could any one of you please let me know in mysql/myODBC that the session control is now under their management meaning - handles different queries/write from different threads within the same connection - handles different queries (or batch fetches) from multi-connections

RE: Regarding the usage of mutex in the mysql connection threading

Hi, Please advise us whether mysql/myodbc - handles different queries/write from different threads within the same connection or not? - handles different queries (or batch fetches) from multi-connections or not? Thanks, Narasimha -Original Message- From: Lakshmi NarasimhaRao

RE: Regarding the usage of mutex in the mysql connection threading

Hi Green, We are at the last stage of the project (migration from Oracle to MySQL). We are demanded to adopt the MYODBC as a customer requrement. As mutex was implemented for oracle so it is there in our code. Now we are thinking to remove that because application level we have connection id.

Any limit for MyODBC connections?

Hi, Is there any database login restriction for myODBC? meaning there is any upper limit of number of connections? Please help me in this. Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this

FW: Slow queries, why?

Hi, Thank you. I have a doubt, you mentioned one equation as Memory Used By MySQL = Innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + max_connections*2MB Is it against mysqld or for each mysql prompt?. Could you please

RE: Slow queries, why?

Hi, I have an interesting problem, i.e upto 20k data is inserted in 20 min. But for 39k it took 3.5 hours. Could you please help me in this, what are all the possible scenarios which leads to this kind of problems. Is there any fine tuning mechanism in Mysql 4.0.23 with innodb? Please help

Regarding the loading of data usning load data infile

Hi, I had 99,990 records to be loaded into a table which is having unique constraints and foreign-key constraints as below CREATE TABLE `teldir` ( `NAME` varchar(21) default '', `PHONE_NO` varchar(26) default '', `PRIME_VALUE` char(1) default '', `COMMENT_TEXT1` varchar(30)

Regarding the loading of data usning load data infile

Hi, I had 99,990 records to be loaded into a table which is having unique constraints and foreign-key constraints as below CREATE TABLE `teldir` ( `NAME` varchar(21) default '', `PHONE_NO` varchar(26) default '', `PRIME_VALUE` char(1) default '', `COMMENT_TEXT1` varchar(30)

RE: Wrong bytesec nightmare!

Hi, we are facing problem with the sql queries given below query number one gives the output as workstation and total logon failure attempts from that workstation which is fine 1) select logonsvr,workstnid, count (username) from winadlogon where evtid=681 group by workstnid order by workstnid;

Regarding NULL and '' (null string) treatment in MYSQL

Hi, MySQL treats NULL, '' (empty string) as different. I mean when I select from/insert into a table, its behaviour is different. Select * from table1 where name=''; is different from Select * from table1 where name=NULL; Similarly Insert into table1(name)

Regrading Heading off and Pause on

Hi, Is there any equivalent of set head off, set pause on in mysql 4.0.21. set head off, set pause on work fine in oracle. Please help me in this. Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this

RE: Reg creating log

Hi, Thank you for your reply. I tried even with --tee option with mysql as follows Mysql -uroot db_name --tee = test 'input_file' 'output_file' But in the out put file I am getting as below Logging to file 'test' Actual error is not logging into the ouput file. I am able to see the

Reg creating log

Hi, What is the command to create log file while executing mysql command. I.e I want to run a file using mysql as follows Mysql -uroot db_name Inputfile I want to log the above results into a log file, to do the same what option I have to use here with mysql

Reg Text field data

Hi, How to read a text type field from the data base. By simple select I am not able to see the whole data at a time. Please advise me here. Thanks, Narasimha -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 9:06 PM To:

SQLSTATE mapping problem

Hi all, We are using MySQL ODBC 3.51 driver for db connection. When executing an SQL statement using SQLExecDirect() function and if there is a syntax error in the SQL statement, the SQLSTATE returned by the driver is 23000 (which stands for invalid constraint/duplicate keys.) instead of

RE: SQLSTATE mapping problem

Hi all, Can anybody suggest whether it is due to version incompatibility?? We are using MySQL 4.0.21 and MySQL ODBC Driver 3.51. Thanks in advance Narasimha -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 2:53 PM To:

SubQueries

Hi, Thank you. Could you please help me in writing an equvivalent query in mysql for the following oracle subquery?. update macvm set embedded='Y' where vm_server in (select a.vm_server from macvm a, component b, element c where a.vm_server = b.name (+) and b.id

SubQueries

Hi, Could you please help me in writing an equvivalent query in mysql 4.0.21 for the following oracle subquery?. update macvm set embedded='Y' where vm_server in (select a.vm_server from macvm a, component b, element c where a.vm_server = b.name (+) and b.id = c.id (+) and c.sxvariant =

Regarding replication

Hi, Is replication of database is possible in MySQL 4.0.21?. If not from which version it is available?. Could any one of you please provide some helpful information about how to do the replication?. Thanks, Narasimha Confidentiality Notice The information contained in this

MySQL database and user creation from script file

Hi, I have to create user and database using script file. My requirements are given below. 1. Login as root 2. Execute the script file for database and user creation. 3. Exit My script file should have mysql -u root create database mnms; user creation command The script

RE: backup/restore

Hi, Thank you for your reply. Even though I used the --add-drop-table option, I am getting the error messages. Actually I am taking the backup for a group of tables as following D:\Code\OPS\6.9.1.12\NetMgmt\OPS_src\C_src\backupmnms\Debugmysqldump -uMNMSDBA -p MNMSDBA --databases mnms

backup/restore

Hi, I am doing backup for tables using Mysqldump. But while doing the restore I am not able to do that using the same Mysqldump. Could you please help me in that. For backup : using Mysqldump -databases db_name ---tables table1 table2 dump.dmp For restore : used Mysqldump

RE: backup/restore

Hi, Thank you for your reply. If I have the create table info in my dump file, while doing the restore using mysql dbname dump.dmp, I am getting errors like mysql -uMNMSDBA -pMNMSDBA -f mnms c:\progra~1\mitel\opsman~1\temp\almhist.dmp ERROR 1050 at line 11: Table 'alarm' already

auto commit

Hi All, I am using ODBC interface to access MySQL database. All DML oparations like insert, update and delete are performed using ODBC API's ( C program and ODBC API's). We start the transaction in the following order. 1.create savepoint a 2. do dml operation 3. commit if dml is

Query

Hi all, We are using MySQL 4.0.21 with MyODBC connectivity. We are getting a crash when attempting to perform batch fetch using SQLFetchScroll() funciton. Since the function is a generic one for which we have defined a global variable (a two dimentional void* array to hold the field values

RE: Regarding User creation and loading data

Hi, Thank you for your reply. When I log in as a DBA user and try to load data from a file, I am getting an error as Access Denied, so, here I want to know what type of permissions I have to give for a user to load data infile form a file. Thanks, Narasimha -Original Message- From:

Regarding User creation and loading data

Hi, Could any one of you help me in creating two users like First user with all dba privileges as root and the Second user with only dml operations. And in loading data using LOAD DATA INFILE, if I use the file full path, I am getting error. And if I put the file in mysql\bin it is

Building C string for Insert!!

Hi, I am building the insert string for inserting into particular table t1 using C program. The below string is stored in a variable. say sqlstmt = 'INSERT INTo T1 values(:id,:ename);' The values for the field's id, name will come from the front end. The sql string will be executed using Pro

Help Required!

Hi, I am building the insert string for inserting into particular table t1 using C program. The below string is stored in a variable. say sqlstmt = 'INSERT INTo T1 values(:id,:ename);' The values for the field's id, name will come from the front end. The sql string will be executed using Pro

Building C string for Insert!!

I am building the insert string for inserting into particular table t1 using C program. The below string is stored in a variable. say sqlstmt = 'INSERT INTo T1 values(:id,:ename);' The values for the field's id, name will come from the front end. The sql string will be executed using Pro *C in

RE: User variables

Hi, Set the value as SET @SoftwareID:=7; Now, use WHERE s.softwareID = @SoftwareID at the end of your query. Thanks, Narasimha -Original Message- From: Erich Beyrent [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 8:30 PM To: [EMAIL PROTECTED]

RE: Regarding Connection Context

Hi, Thanks for your reply. A runtime context, usually simply called a context, is a handle to a an area in client memory which contains zero or more connections, zero or more cursors, their inline options (such as MODE, HOLD_CURSOR, RELEASE_CURSOR, SELECT_ERROR, and so on.) and other

Please put this question in MySQL

Hi ALL, CONTEXT USE Example: #include sqlca.h #include ociextp.h main() { sql_context ctx1; char *usr1 = scott/tiger; EXEC SQL CONTEXT ALLOCATE :ctx1; //Create Context EXEC SQL CONTEXT USE :ctx1; // Use Context EXEC SQL CONNECT :usr1; EXEC SQL CONTEXT USE DEFAULT; EXEC SQL INSERT INTO

Regarding Connection Context

Hi ALL, CONTEXT USE Example: #include sqlca.h #include ociextp.h main() { sql_context ctx1; char *usr1 = scott/tiger; EXEC SQL CONTEXT ALLOCATE :ctx1; //Create Context EXEC SQL CONTEXT USE :ctx1; // Use Context EXEC SQL CONNECT :usr1; EXEC SQL CONTEXT USE DEFAULT; EXEC SQL INSERT INTO emp

SubQueries

Hi, I have a sub query in oracle, I want to convert it into Mysql 4.0.21 compatible SELECT PAGE_SERVICE.TIMEOUT, PAGE_SERVICE.PAGE_SERVICE_COMMENT, PAGE_SERVICE.NUMERICMSGMAXSIZE, PAGE_SERVICE.ALPHAMSGMAXSIZE, PAGE_SERVICE.PASSWORD, PAGE_SERVICE.PHONE_NO, PAGE_SERVICE.NAME,

Backup and Restore

Hi All, I need to backup and restore MySQL database using ODBC from my client machine. My database is in the remote server. I am building my backup command using C program. Example: My backup will have the following. Mysqldump -h host name -u username -p password --databases database

Indices and Constraints.

Hi All, In oracle I can query user_constraints, user_indexes for getting the constraints and indices for a particular table. User_constraints and user_idexes are view which holds all the constraints and indices for a particular table. Need to know the similar one in MySQL. Do we have views

RE: Indices and Constraints.

Hi, Thank you. But I want select the constraints and indices used on the table. How can we get this information?. Please help me in this. Thanks, Narasimha -Original Message- From: Ian Sales [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 5:07 PM To: Lakshmi NarasimhaRao

RE: Reg SubQuery

Hi, Thanks for the reply. The main aim is to select the first record or the last record. Is there any direct command for these. Please help me in this. Thanks, Narasimha -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 7:30 PM

Reg SubQuery

Hi, I need to get all the details of an employee whose salary is the lowest. I can do like this in Oracle select * from emp where id = (select min(id) from emp). Can we have any alternative in MySQL for the above query, as sub queries are not supported in MySQL 4.0.21 Regards,

Diffrence between MySQL 4.0.21 and MySQL 4.0.17

Hi, Is there any functional differences between 4.0.21 and 4.0.17?. Please help me in knowing it. Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s)

Reg Table spaces and Rollback segments in MySQL 4.0.21

Hi ALL, We are using MySQL 4.0.21 with InnoDB. For creating the tablespace mentioned as innodb_data_file_path = ibdata1:10M:autoextend in my.cnf file. Here, is there a facility to know the table space name?. Shall we create multiple table spaces like the above in MySQL 4.0.21 and assign

RE: Database Connection using DSN

Hi, Thank you for your reply. After establishing a connection to the Database using ODBC API, can we use the mysql API's like mysql_query() instead of using MyODBC API's. Thanks in Advance. Regards, Narasimha -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent:

Database Connection using DSN

Hi, I would like to know how to connect to the mysql database using a DSN in mysql API's. I am using myodbc 3.51 driver. Used the following API code for the connection MYSQL *link = mysql_init(NULL); MYSQL *connectHandle = mysql_real_connect(link,localhost,root,,test,0,NULL,0);

Mysql Sysem files and packages

Hi, I am doing a dbconversion form oracle to mysql. I would like to know the equivivalents in mysql for 1) Parameter file like init.ora in oracle 2) system package like diutil in oracle Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and

offer

Hi, I need a person who worked on oracle and mysql for a PCMM Level company in Bangalore, India on a contract basis for 4 months. If any one is interested please forward the resume asap. Min 3 years exp is required. It is a very urgent requirement. Thanks, Narasimha Confidentiality

Sequences and Synomyms

Hi, I am new to mysql. I want to create sequences in mysql 4.0 which should be equivalent to oracle sequences. I gone through the mysql manual, Auto_Increment(), C API mysql_insert_id() and LAST_INSERT_ID() are there for sequences. Last_insert_id() gives the last value. I want actual

Sequences and Synomyms

Hi, I am new to mysql. I want to create sequences in mysql 4.0 which should be equivalent to oracle sequences. I gone through the mysql manual, Auto_Increment(), C API mysql_insert_id() and LAST_INSERT_ID() are there for sequences. Last_insert_id() gives the last value. I want actual

User Defined functions

Hi, How to call a user defined function. I am using C as the programming language. I write a small function in C. Created .dll. Then how to run it from mysql pompt?. How to call or use it?. will any one of you help me in this. Thanks, Narasimha -Original Message-

RE: Reg REstore

Hi, I want to restore the database from the back up of the database taken using mysqldump. I took the backup into a .sql file of my wholw database. Now, i want to run that sql file, i.e i want to recreate the tables/data of that database from the backup of .sql file. How to do this?.

Inserting/Updating data into/on multiple tables

Hi, In mySQL: 4.0 with out innodb, is there any facility/command to write data into mutiple tables at a time?. Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of

Reg Database creation

Hi, How to create database in mysql 4.0 with out classic. What i mean is 1. How to create database 2. How to create users and hhow to give privilages to them 3. How to create table space 4. How to create rollback segment 5. How to allocate tables to table space Please help me in

RE: Migrating from Oracle to mySql [online stats]

Hi, I am also doing migration from oracle 7.3 to mysql 4.0 classic. May i know how to handle Oracle Views, stored procedures/triggers in MySQL 4.0 ?. May i know how to create database, table space, roll back segments, users, allocating tables to table spaces (as we do in oracle) in

Reg Backup

Thank you very much. One more question i.e Is there any command to take the Backup in MySQL 4.0 (windows) classic which does not support innodb. I know 2 commands like mysqldump and mysqlhotcopy. mysqlhotcopy seems to support myism but only in linux and

Reg Backup

Hi, Is there any suitable command in MySQL 4.0 with out InnoDB for taking the backup. Please suggest. Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive

RE: Reg Backup

mysqlhotocpy supports only Linux and Netware software. Will it support windows operating system. Please clarify. Thanks, Narasimha -Original Message- From: Greg Donald [mailto:[EMAIL PROTECTED] Sent: Mon 10/4/2004 10:06 PM To: [EMAIL PROTECTED]

Reg REstore

Hi, Thank you backup is working fine. Any one can help me how to restore the back up database?. Not at table level. At the database level. How to run a sql file from mysql prompt?. While restoring any more things to be taken care, regarding database?. Thanks, NARasimha

Reg Backup

Thank you very much. One more question i.e Is there any command to take the Backup in MySQL 4.0 (windows) classic which does not support innodb. I know 2 commands like mysqldump and mysqlhotcopy. mysqlhotcopy seems to support myism but only in linux and netware os. But i need it in

views/cursors in mysql 4.0

Hi, How to implement views/cursors in mysql 4.0?. Normally in mysql how the selected data is maintained in the recordsets?. Is there any other alternatives to implement views/cursors in mysql 4.0?. Please advise me for the better solution. Thanks, Narasimha Confidentiality Notice

RE: views/cursors in mysql 4.0

Hi, Thank you for your response. Strictly we have to use mysql 4.0 only. Actually the source data base is oracle 7.3, we need to migrate that database to mysql 4.0 . In oracle 7.3 views/cursors are used. That is why i need an alternative for views/cursors in mysql 4.0. We use C/C++ for

RE: views/cursors in mysql 4.0

Hi, Thank you very much for your reply. The existed system , a network management tool , is developed using C as program lanuage and oracle 7.3 as the database. There are 3 layers in the database like table layer, view layer and DBview layer. The DBView layer communicates

RE: views/cursors in mysql 4.0

Hi, Thank you very much for your reply. So for the cursors result set C API's will be suitable ..right?. thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of

importing data into mysql from oracle using a text file

Title: Message Hi, I tried with the spool option to get the data from the tables in the oracle. For this go to pl/sql editor, go to file menu, select spool, asks for a file name give the file name you want, later type the select command from which you want the data.

RE: importing data into mysql from oracle using a text file

Title: Re: importing data into mysql from oracle using a text file The sample lines are like this in alarm.txt ARRIVED DETECTED NAME TYPE ALARMLEVEL V DISCLOSED CATEGORY_NUM EVENTID - - - -- - -

RE: importing data into mysql from oracle using a text file

Thanks, it is working for the mentioned format. Is there any method for importing directly the spooled file from oracle without changing the file format into the required format like using tab and newline. thanks, narasimha -Original Message- From: Andrey Hristov

importing data into mysql from oracle

Hi, Could any one of you suggest me a better way to bump the data in oracle 7.3 to mysql 4.0 classic. Thanks, Narasimha -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tue 9/28/2004 8:58 PM To: martin fasani

reg backup

Hi, Is there any way to handle backup in the mysql 4.0 classic with out innoDB?. And may i know the differences between transaction - safe and transaction -full locks ?. And what is the best way to confirm whether innodb is running or not in mysql 4.0?. Thanks, Narasimha

RE: ResultSet NotUpdatable problem

Hi, help me in getting answer for the following What is the difference in MySql between transaction-safe tables (like Innodb or BDB) and non-safe Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this

Choosing the option file

Hi, Actually i want mysql 4.0 classic version which donot support innodb engine. As classic version is a commercial base one, i installed the mysql 4.0 standard one (which includes innodb). Here my problem is , i have to inactivate the innodb engine. For that what we need to do is

List of Questions

Hi, I have some questions. I need urgent solutions for these. Could you spare some time for me for helping me. I hope you can. 1) Is MySQL 4.0 Classic version is free downlodable?. If so, can you give me the url please?. 2) What will be the equivalent of Pro*C API's in MySql?. For

RE: Migration tools/plan from oracle 7.3 to Mysql 4.0

Hi, I have to migrate oracle 7.3 database to MySql , for oracle used Pro*C. In the front end used Java, JNI, RMI and Pro*C. In the migration process what will be the best equivalent of Pro*C in MySql. Ans also need to use XML, for the above environment what are the best langauge suit

RE: Migration tools/plan from oracle 7.3 to Mysql 4.0

Hi, Thank you for your response. Could any one give more clarification on the alternatives for Views, Stored procedures, triggers and contraints of oracle in Mysql 4.0 classic, as MySql 4.0 classic wonot support the InnoDB storage engine. Thanks, Narasimha -Original

Migration tools/plan from oracle 7.3 to Mysql 4.0

Hi, I am new to MySql. Could you please let me know the different migration tools avialable for the migration of oracle 7.3 database to mysql 4.0 classic version. Out of those which one is the best in performance and cost wise. As per my knowledge views, stored procedures and triggers