tee" followed by a filename turns on MySQL logging to a specified file. It can be stopped by command notee. Read More

SELECT c1.CategoryID c1.Name c2.CategoryID c2.Name FROM category AS c1 category AS c2 WHERE c1.CategoryID c2.ParentID ORDER BY c1.CategoryID c2.CategoryID Read More

There are eleven drivers in MYSQL .Six of them from MySQL AB and five by MYSQL Communities.They are1.PHP Driver2.ODBC Driver3.JDBC Driver4.ado.net5.mxj6.CAPI1PHP DRIVER2.PERL DRIVER3.PYTHON DRIVER4.RUBY DRIVER5.C++ WRAPPER Read More

MYSQL is a relational data base model and most widely RDBMS all over the world. It provides multi user access to databases. Source code for this database is available under General public license. It became popular for web applications and this is... Read More

Applying specific rules (normal forms) to the database is the primary process. These rules should be applied in the order specified starting with the first normal form. These rules should be adhered by every database they are 1) Each column should... Read More

MySql has many advantages in comparison with Oracle.<br><br>1 - MySql is Open source, which can be available any time <br><br>2 - MySql has no cost of development purpose.<br><br>3 - MySql has most of features ,... Read More

Yes, and name it ~/.my.conf. You might want to change the permissions on the file to 600, so that it?s not readable by others. Read More

CREATE DATABASE command will create you a database with the assigned name by the user. This is an optional statement but when you actually assign a name it checks for similarity and gives error if it encounters one. CREATE DATABASE models help you to... Read More

There are many different ways to establish users and privileges in MYSQL. Client and GRANT command assure you about a safe connection. The syntax for establishing new users and privileges is as follows GRANT privileges ON database.* TO ?username?@... Read More

/etc/init.d/mysql start Read More

mysqli is the object-oriented version of mysql library functions. Read More

Naming MYSQL databases has to be very careful because any database starting with the test name can be accessed by every one on the network. Make sure that you don?t start the databases naming with test. It should be used only for experimental... Read More

Those are the special tables, data for which is saved into comma-separated values files. They cannot be indexed. Read More

mysql_stat(); Read More

MYSQL allows only one primary key. This primary key can be used on multiple tables. There are many rules which should be followed such as it shouldn?t be null and it can never change. Primary key assigned should be unique it cannot be matched with... Read More

<%<br>String connectionURL = "jdbc:mysql://localhost:3306/database_name";<br> Connection connection = null;<br> Statement statement = null;<br><br>Class.forName("com.mysql.jdbc.Driver").newInstance();<br>... Read More

Some of the features presented by MYSQL are 1) Multiple storage engines, Native storage engines, Partner developed storage engines, custom storage engines, community developed storage engines and commit grouping. Some of these features present in... Read More

Mysql is widely used for web applications. This acts as a database component for many languages such as BAMP, WAMP, LAMP and MAMP. PHP and ruby added to popularity to the language. PHP and MYSQL are very much used for managing database and web... Read More

net start MySQL, net stop MySQL Read More

MYSQL standard has diverted on the standards of implementation of Null and default values. Arithmetic operations are susceptible to integer over flow. Mode of operation of SQL is set to unusual tolerant state which developers hate. Read More

A username has a maximum length of 16 characters. Spaces should be avoided while creating username because they are case sensitive. Hostname will be the computer from which you are going to connect. The best way to specify a username is to connect... Read More

mysqldump -h mysqlhost -u username -p mydatabasename > dbdump.sql Read More

There is no user without a password. There is no user without a user name. There is no user whose Host column contains % (which here indicates that the user can log in from anywhere in the network or the Internet). There are as few users as possible ... Read More

It compressed the MyISAM tables, which reduces their disk usage. Read More

Two considerations which can improve the performance of MYSQL are as follows: - 1) Fixed length fields take up more space than variable length fields but they are a bit faster. 2) Size of the field should be restricted to the smallest possible... Read More

HEAP tables are in-memory. They are usually used for high-speed temporary storage. No TEXT or BLOB fields are allowed within HEAP tables. You can only use the comparison operators = and <=>. HEAP tables do not support AUTO_INCREMENT. Indexes... Read More

MySQL config variable max_heap_table_size. Read More

TIMESTAMP filed occurs when an INSERT and UPDATE field occurs when there is no value specified for the field. There are many behaviors for TIMESTAMP field and it depends upon the version of MYSQL. Read More

Introduced in MySQL 5.0, federated tables allow access to the tables located on other databases on other servers. Read More

BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT Read More

Prior to MySQL 5.0.3: those are all synonyms. After MySQL 5.0.3: BIT data type can store 8 bytes of data and should be used for binary data. Read More

The column exhibits the same behavior as a single timestamp column in a table with no other timestamp columns. Read More

On initialization places a zero in that column, on future updates puts the current value of the timestamp in. Read More

Every column in a database table is assigned a data type. The data type maybe native to the database management system or may be a custom data type. Each Oracle9i Database native data type belongs to one of six categories: character number date large... Read More

mysql 4.0 onwards support subquery. Read More

1. SQL is structural quary language but mysql is database package. 2.MySQL is an opensource database but SQL is an microsoft product. Read More

%ROWTYPE allows you to associate a variable with an entire table row. The %TYPE associates a variable with a single column type. Read More

Oracle provides the DBMS_ series of packages. There are many which developers should be aware of such as DBMS_SQL, DBMS_PIPE, DBMS_TRANSACTION, DBMS_LOCK, DBMS_ALERT, DBMS_OUTPUT, DBMS_JOB, DBMS_UTILITY, DBMS_DDL, UTL_FILE. If they can mention a... Read More

PL/SQL tables are scalar arrays that can be referenced by a binary integer. They can be used to hold values for use in later queries or calculations. In Oracle 8 they will be able to be of the %ROWTYPE designation, or RECORD. Read More

The syntax in the previous answer (where count(*) > 1) is very questionable. suppose you think that you have duplicate employee numbers. there's no need to count them to find out which values were duplicate but the followin SQL will show only... Read More

Query: SELECT sal FROM `emp` order by sal desc limit (n-1),1If the question: "how to display 4th highest (salary) record from customer table."The query will SELECT sal FROM `emp` order by sal desc limit 3,1 Read More

If console option is not present or used during the start of MYSQL then all the output will be written to the error log file. It is always better to use the console option because it reduces problem on the server. Error log file will be stored with... Read More

3306 is the default port for MySQL. Read More

mysqladmin -u root -p password "newpassword" Read More

Some of the security recommendations which should be followed while using MYSQL are as follows: - 1) Minimal privileges to users in the network. 2) Super and process privileges should be granted minimally. 3) File privileges should be granted... Read More

Database design is also called as Data modeling. It is used for long-term management of database. This process is used to store information and to keep data for long term. Creating an efficient structure helps you to channelize information into... Read More

MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even... Read More

This feature is a default type for tables. This table is not so much considered for transactions because it is not considered as safe but this kind of table is very fast in execution. The maximum key length is 1024 bytes and 64 keys per table. Size... Read More

This type of table is stored in the memory. Speed of execution of this table is very commendable. There are associated disadvantages associated with this table the primary one being loss of stored memory which occurs when there is power failure and... Read More

It stops incrementing. It does not overflow to 0 to prevent data losses, but further inserts are going to produce an error, since the key has been used already. Read More

That field gets the current timestamp whenever the row gets altered. Read More

Any attribute that is uniquely identify a row in a table is candidate key for the table. We select one of the candidate key as Primary key. All candidate keys which are not chosen as primary key are Alternate keys. The key which uniquely identify the... Read More

select sname,phone,feebal,feepaid from student s left outer join fees f on s.sid=f.sid; union select sname,phone,feebal from student s right outer join fees f on s.si d=f.sid; Read More

As row id is in oracle same as id is in mysql but in mysql there is no concept of rownum. Read More

For the configuration of MySql these dependencies are required as: mysql-5.0 mysql-server-5.0 mysqlclient9-5.0 mysql-devel-5.0 php-mysql-5.0 install by rpm -i vh mysql-server-5.0.rpm and others also same If configured in RHEL the .rpm are... Read More

The DECLARE statement is used in PL/ SQL anonymous blocks such as with stand alone, non-stored PL/SQL procedures. It must come first in a PL/SQL stand alone file if it is used. Read More