Different tables present in MySQL

Ads
 

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









Related Tutorials/Questions & Answers:
Different tables present in MySQL
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...; Hi friends, Total 5 types of tables we can create 1. MyISAM 2. Heap 3
Mysql List Tables
Mysql List Tables       The Tutorial illustrate an example from 'Mysql  List Tables... the list of tables present in database. show tables
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
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
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
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
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
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
MYSQL  How to create time and date based trigger in mysql   MySQL Time Trigger
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 open\import table in .dbf format in mysql
Different JRE
Different JRE  Java is platform independent. The why different JRE's there for differen operating systems
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
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

Ads