Interested to Buy Any Domain ? << Click Here >> for more details...
Write a C/C++ program to add a user to MySQL. The user should
be permitted to only "INSERT" into the given database
- 2 Answers
- 11057 Views
- TCS, Unisys, Webyog, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkat
The C API code is distributed with MySQL. It is included in
the mysqlclient library and enables C programs to access a
database.
Many of the clients in the MySQL source distribution are
written in C. If you are looking for examples that
demonstrate how to use the C API, take a look at these
clients. You can find these in the client directory in the
MySQL source distribution.
Most of the other client APIs (all except Connector/J and
Connector/Net) use the mysqlclient library to communicate
with the MySQL server. This means that, for example, you can
take advantage of many of the same environment variables
that are used by other client programs, because they are
referenced from the library. See Chapter 4, MySQL Programs,
for a list of these variables.
The client has a maximum communication buffer size. The size
of the buffer that is allocated initially (16KB) is
automatically increased up to the maximum size (the maximum
is 16MB). Because buffer sizes are increased only as demand
warrants, simply increasing the default maximum limit does
not in itself cause more resources to be used. This size
check is mostly a check for erroneous statements and
communication packets.
The communication buffer must be large enough to contain a
single SQL statement (for client-to-server traffic) and one
row of returned data (for server-to-client traffic). Each
thread's communication buffer is dynamically enlarged to
handle any query or row up to the maximum limit. For
example, if you have BLOB values that contain up to 16MB of
data, you must have a communication buffer limit of at least
16MB (in both server and client). The client's default
maximum is 16MB, but the default maximum in the server is
1MB. You can increase this by changing the value of the
max_allowed_packet parameter when the server is started. See
Section 7.9.2, “Tuning Server Parameters”.
The MySQL server shrinks each communication buffer to
net_buffer_length bytes after each query. For clients, the
size of the buffer associated with a connection is not
decreased until the connection is closed, at which time
client memory is reclaimed.
For programming with threads, see Section 19.8.16.2, “How to
Write a Threaded Client”. For creating a standalone
application which includes the "server" and "client" in the
same program (and does not communicate with an external
MySQL server), see Section 19.7, “libmysqld, the Embedded
MySQL Server Library”.
Note
If, after an upgrade, you experience problems with compiled
client programs, such as Commands out of sync or unexpected
core dumps, you probably have used old header or library
files when compiling your programs. In this case, you should
check the date for your mysql.h file and libmysqlclient.a
library to verify that they are from the new MySQL
distribution. If not, recompile your programs with the new
headers and libraries. Recompilation might also be necessary
for programs compiled against the shared client library if
the library major version number has changed (for example
from libmysqlclient.so.15 to libmysqlclient.so.16.
| Is This Answer Correct ? | 14 Yes | 9 No |
How to write a multi-statement macro?
why u join this call center?
How is a structure member accessed?
Technical Ability Test: This was difficult. three questions to be attempted in 60 min. The Coplete Technical Paper was as follows: Write the Pseudo code for the following: 1. Wrie a function which returns the most frequent number in a list of integers. Handle the case of more than one number which meets this criterion. public static int[] GetFrequency(int[] list) 2. Counting in Lojban, an artificial language developed over the last fourty years, is easier than in most languages The numbers from zero to nine are: 0 no 1 pa 2 re 3 ci 4 vo 5 mk 6 xa 7 ze 8 bi 9 so Larger numbers are created by gluing the digit togather. For Examle 123 is pareci Write a program that reads in a lojban string(representing a no less than or equal to 1,000,000) and output it in numbers. 3. Where now stands that small knot of villages known as the Endians, a mighty forest once stood. Indeed, legand has it that you could have stoodon the edge of the wood and seen it stretch out for miles, were it not for the trees getting in the way. In one section of the forest, the trees stood in a row and were of hight from 1 to n, each hight occurring once and once only. A tree was only visible if there were no higher trees before it in the row. For example, if the heights were 324165, the only visible trees would have been those of height 3,4 & 6. Write a Program that takes an array of integers representing the heights of the trees in the row as input and prints the list of the visible trees. //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// ////////////////// Ques1: Given an array containing k nos in the range 1..n and another scratch array of size n. Write an program to remove the duplicates from the array. Ques2: Given a table of the form: Product Sold on A 1/1/1980 B 1/1/1980 C 1/1/1980 A 1/1/1980 B 1/1/1980 C 2/1/1980 A 2/1/1980 There are 30 products and 10,000 records of such type. Also the month period during which sales happened is given to u. Write the program to display the result as: Product Month No. of copies A January 12 A February 15 A March 27 B January 54 B February 15 B March 10 C January 37 Ques3: Definition of priority queue was given. We have to implement the priority queue using array of pointers with the priorities given in the range 1..n. The array could be accessed using the variable top. The list corresponding to the array elements contains the items having the priority as the array index. Adding an item would require changing the value of top if it has higher priority than top. Extracting an item would require deleting the first element from the corresponding queue. The following class was given: Ques4: An array of size 5X5 is given to us. The elements from 1 to 25 are to be inserted in the array, such that starting from a particular position for an element i, the next element i+1can be inserted only at the mentioned positions (u,v), and if these all positions are occupied then it returns giving a count of how many positions have been occupied in the array: //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// ////////////////// Example: if the starting element is 1 with the given positions (1,2), then next element 2 can be placed at any one of the positions marked with *. _ _ _ _ _ 1 _ _ _ * _ _ _ _ _ _ _ * _ _ * _ _ _ _ 2. Four questions of programming in c++, questions were:( 1:30 hr) a) Bubble sort through recursion b) Display Pattern: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 … c) Perform the functionality of 2-D array through 1-D array and in it the functions to be performed were: (1) Display the array in 2-D format (2) Display a particular element (3) Display a particular row (4) Display a particular column d) Give an efficient program for string matching like: Text: this is the code in the text which you have to search by code Pattern: Code Count the no. of occurrences of the pattern to be searched //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// ////////////////// a) suppose u r given a 4*3 rectangle like (take these values from user) Now u have to calculate the no. of squares in this rectangle like: No. of squares of dimension 1 is 12 No. of squares of dimension 2 is 6 No. of squares of dimension 3 is 2 No. of squares of dimension 4 is 0 Total no. of squares are 20. b) Suppose u r given a string. U have to find the occurance of the characters A-Z in that string. Each character must appear in the string and must appear only once. If It that occurs in string more than one time return 1 showing it is a perfect string otherwise return 0 showing it is not a perfect string. c) Suppose u r given 10000 marks. U have to pick up top 20 top marks from them and display it on the screen. (Use the optimal sorting algorithm) d) Suppose u have a chess board. U have to insert 8 queens on the chessboard in the style that the queens don’t intersect in the diagonals, columns and rows. If they intersect return 1 else return 0.(that is no more than one queen should be present either in row or column or diagonals.) If the queen is inserted at a position in the chessboard, its count is 1.
How can you restore a redirected standard stream?
What is a pointer in c plus plus?
What is #define used for in c?
Differentiate between the expression “++a” and “a++”?
What are the three constants used in c?
What is s in c?
What does #pragma once mean?
When can a far pointer be used?
C 
