Database Security Related Matter....

Dear Sir/Madam, How can I Lock my database in MySQL with password. As we are having only password for User but what I have to do if I want to lock whole database. Waiting for your favorable reply. Thanks & Regards, Shripal. -

May be bug in MySQL Table!!!

Dear Sir/Madam, Here I've attached one Table of MySQL, named as "M_Filed". When I am trying to select all tables from VB, it gives me following error Run-time error '-2147467259 (80004005)': [TCX][MyODBC]Got error 127 from table handler Waiting for your reply. Regards, Shripal.

Some Problems with MySQL 3.23.54

Dear Sir/Madam, I can't able to do following things with MySQL 3.23.54. Sub-selects SELECT INTO TABLE Transactions Stored Procedures and Triggers Foreign Keys Views But, what can I do if I can't do anything without Transaction Support, Stored Pr

Which is more faster ...

Dear Sir/Madam I want to know that which is more faster in terms of loading data into table from file 1> MYSQL --quick -f -s -u root DBNAME < FILE.TXT 2> LOAD DATA INFILE. Thanks & Regards, Shripal. - Before posting, ple

Problem with mysqlimport

Dear Sir/Madam, I've one data file which is built with the help of mysqldump. This file contains structure & data of 2 tables of test database. Like this.. mysqldump -C --add-drop-table -e test patient hospital > UM.txt then I am trying to import data using this statement.. mysqlimport test UM