Different tables present in MySQL

What are the different tables present in MySQL? Which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2),ename varchar(10))?

View Answers

December 27, 2010 at 5:22 PM

Hi friends,

Total 5 types of tables we can create

1. MyISAM
2. Heap
3. Merge
4. INNO DB
5. ISAM

MyISAM is the default storage engine as of MySQL 3.23. When you fire the above create query MySQL will create a MyISAM table.

Thanks...

Ads

Advertisements

Mysql List Tables
Mysql List Tables The Tutorial illustrate an example from 'Mysql List Tables... to show the list of tables present in database. show tables

Create Database and tables in MySQL
Create Database and tables in MySQL Hi, How to create database and tables in MySQL Database? Explain me step-by-step as I am beginner in MySQL. Thanks Hi, First of all you have to connect to MySQL database through

inserting same data to different tables in oracle
inserting same data to different tables in oracle Hi there ...! i have to insert un,pwd, to three oracle tables, like admin, user, stud, but i want pickup these table names from a drop down list in html...is there any chance can

mysql select from multiple tables
mysql select from multiple tables how can i select the date field from multiple tables in mysql? "UNION" can be used to select data from multiple tables in my sql... for example (SELECT * from name where `name

Purge Data from Mysql tables
Purge Data from Mysql tables Hi, i have to write a mysql procedure to purge data from tables. but written procedure clear entire tables data. Please give me the solution for purging data. CREATE DEFINER=`root`@`localhost

Mysql Join 3 Tables
Mysql Join 3 Tables Mysql Join 3 Tables is used to join 3 Tables using left join... an example from 'Mysql Join 3 Tables' using Left Join. To grasp this example

how to store array values into two different tables in java?
how to store array values into two different tables in java? I have use 4/5 textboxes with same name(e.g.text1) and I get the values in a array and now I want to store these values in two different tables(i.e store 2 array

java code to validate column content of 2 different tables in 2 different databases.
java code to validate column content of 2 different tables in 2 different.... how to compare 2 columns(different col_name) in 2 different databases placed at different server and display output( in excel format) using JAVA. if matched

how to get values for same column name from two different tables in SQL
how to get values for same column name from two different tables in SQL how to get values for same column name from two different tables in SQL???? column name is emp_id loacated in these two tables company,employee

PHP and MySQL BETWEEN dates with different years
PHP and MySQL BETWEEN dates with different years I have a database which holds a bunch of events. Each event has a start date and an end date, so they should only show on the site when the date chosen falls between those dates

Comparing tables
Comparing tables How to compare two or more tables in the Mysql database using jdbc

JSP with Mysql
not get an answer. My questions are 1. How to inserting same field data to different mysql table using jsp. That is creating a form with 5 fields,data's are same but these values storing 3 different tables based on conditions (ex) tables

MySQL
. MySQL Features MySQL server can be run on different architecture...MySQL In this section we will read about what is MySQL, MySQL distribution, MySQL features, MySQL architecture etc. MySQL unofficially, pronounced as My

Mysql List
Mysql List Mysql List elaborate you an Query for listing databases,tables... illustrate an example from 'Mysql List'. To grasp this example, We show you

Mysql List
Mysql List Mysql List elaborate you an Query for listing databases, tables, Procedure... illustrate an example from 'Mysql List'. To grasp this example, We show you

Mysql Switch CASE
Mysql Switch CASE Mysql Switch Case perform one of several different actions based on several different conditions. Understand with Example The Section of Tutorial

Mysql Else Condition
Mysql Else Condition Mysql Else Condition evaluate the statements in database to perform different actions based on different conditions. Understand with Example The Tutorial

MySQL Create Database
Administrator, enabling the visual creation and modification of tables. The MySQL... MySQL Create Database ... to create the database on MySQL Server. MySQL Database server is one of the very

MYSQL
MYSQL How to create time and date based trigger in mysql MySQL Time Trigger

Different JRE
Different JRE Java is platform independent. The why different JRE's there for differen operating systems

mysql
mysql how to open\import table in .dbf format in mysql

Java Cross Join MySQL
Java Cross Join MySQL In this section we will read about how the two tables can be joined using cross join in MySQL. Here we will see cross joining using... different tables and then we will insert some bulk values in both tables

Mysql Alter Tables
Mysql Alter Tables This example illustrates how to alert the table and how it is used in query. In this example you will see all tables in test database.... Query show tables

mysql
you need to download the mysql-connector jar file for connecting java program from mysql database....... Hi friend, MySQL is open source database... is the link for the page from where you can understand how to Download and Install MySQL

Ads