Ok, ThanQ very much sir
I'll try to follow your guidelines
thanx
sarma
sarma
Last Activity: Jun 5 '07, 03:11 AM
Joined: Sep 7 '06
Location: Mumbai
-
Thanx sir............ ..
I am using One of My RDBMS as MySQL and I am using 'C' to connect to DB. Now I am looking to have another RDBMS.
thanx
sarmaLeave a comment:
-
Can I Have 2 different RDBMS for a single application
Hi friends,
Happy New Year.
Can I have two different RDBMS for a single application, like i would like to store one set of database in MySQL and another set of databases in PostGreSQL. Is it possible? If so, How can I implement it???????
thanx
sarma -
Hello folks, Thanx for paying attention to my post.
I wrote a stored procedure to execute query "Select * from Emp" and Emp table have Empno, Empname fields.
I called this stored procedure from C using mysql_query(han dle, "call sp()");
But i m unable to get result set using mysql_use_resul t or mysql_store_res ult.
Im using MySQL 5.0.24a on Linux. This is FYI.
...Leave a comment:
-
How to call Stored Procedure from C program
Hi friends,
I created a stored procedure in MySQL like
create procedure p()
select NOW();
I write a C program, from which i wish to call this stored procedure, i used both mysql_query() and mysql_real_quer y() functions, but unable to call this stored procedure. Can U please help me out in this......
"CALL p() failed: PROCEDURE sarma.p can't return a result set in the... -
Thanks shashi.
I re-compiled with --openssl option and encountered same error. So I decided to use aes_encrypt() and aes_decrypt() functions instead of des_encrypt() and des_decrypt().
Anyways thanks shashi.
regards
sarma...Leave a comment:
-
need help on MySQL error:1289(--openssl missing)
Hi friends,
I am using MySQL 5.0.24a on Linux.
When I try to use des_encrypt() function, I am getting the warning like des_encrypt() is disabled and You need MySQL built with '--with-openssl' to have it working.
To be specific, Output is
Error (Code 1289): The 'des_encrypt' feature is disabled; you need MySQL built with '--with-openssl' to have it working.
can u please... -
need help on Performance parameters
Hi Guys,
I wrote a small C program, which will connect to MySQL Client and execute "select * from Emp" SQL statement infinite times(say 50,000 times). After running for n(say 1000) times, Query execution time is increased, it is running very slowly.
Structure of Emp Table is Emp(EmpId INT, EmpName Char(20))
Can anybody please suggest me some parameters(MySQ L Variables) to change so that I can get... -
Hi,
U can write a simple join query as
select id from emp e, dept d
where e.id !=d.id;
This will give emp ids which are not included in any depts.(change the table names according to your names)
regards
sarmaLeave a comment:
-
need help on show variables query_prealloc_size
Hi,
I am using MySQL 5 as my database
I am not able to set variables query_alloc_blo ck_size, query_prealloc_ size and read_buffer_siz e. I tried SET GLOBAL command. I tried in Windows env and Linux env.
When I executed SQL Statement,
SET GLOBAL query_prealloc_ size = 32768;
Its not giving any error, but when i checked in variables, it is same as 8192(old value).... -
Hi one and all,
ThanQ very much for your response....... ............... ............
thanx
sarmaLeave a comment:
-
I would like to write some shell program which will be automatically run by crond and take data which is effected on that day. It will store only updates or modifications.
regards
sarmaLeave a comment:
-
backup script
i would like to write a shell script to store database on daily basis. I am using MySQL 5 as my database. Any inputs are welcome...
regards
sarma -
U can limti the no. of records using command LIMIT.
for example,
select account_id from tbl
where client_id = 10
LIMIT 10;
so it will display only 10 records which satisfy condition in where clause.
sarmaLeave a comment:
-
I am using MySQL as my database....... in that i want to know command to know how many users are created on a particular database...
sarmaLeave a comment:
-
need help on USERs of MySQL
dear frens,
Can u tell me the command to know the no. of users created for a single database?
like if i create a user test for database "sample", is there any command to know whether it is created. Show tables will show all the tables in that database, is there any command for users of that kind?????
thank in advance
sarma -
how to know users in MySQL
dear frens,
Can u tell me the command to know the no. of users created for a single database?
like if i create a user test for database "sample", is there any command to know whether it is created. Show tables will show all the tables in that database, is there any command for users of that kind?????
thank in advance
sarma
No activity results to display
Leave a comment: