Category: Category: MySQL

SQL data type Java data type VARCHAR, LONGVVARCHAR String BIT boolean TINYBIT byte SMALLINT short INTERGER int BIGINT long […]

GRANT ALL ON employees.* TO manish@localhost IDENTIFIED BY "eagle" The above command grants account (manish@localhost) all the permissions on […]

How to create a forward-only read-only result set: Statement statement = connection.createStatement(); ResultSet rs = statement.executeQuery("SELECT * FROM PRODUCTS"); […]

Methods of a ResultSet object that work with a result set Methods Description beforeFirst() Moves the cursor to the […]

How to use the getMetaData method to create a ResultSetMeataData object: Method Description getColumnCount() Returns the number of columns […]

Attached is a sample program to Select data from MySQL using the Muchach's DB. Here is the sample code: […]

Attached is a sample program to Delete data from MySQL using the Muchach's DB. Here is the sample code: […]

Attached is a sample program to Update data in MySQL using the Muchach's DB. Here is the sample code: […]

Attached is a sample program to Insert data into MySQL using the Muchach's DB. Here is the sample code: […]