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...

Advertisements

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

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

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

mysql tables - JDBC
mysql tables hi, I have a table in MySql, having fields, emp... mangager for MySQL, statements, preparedstatements,resultset. Please can you..."); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/databasename

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... The Tutorial illustrate an example from 'Mysql Join 3 Tables' using Left Join

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

Nest tables within tables
Nest tables within tables Can I nest tables within tables

Setting up MySQL Database and Tables
Setting up MySQL Database and Tables I am assuming that you have running instance of MySQL Database and you know how to work with the MySQL database. To access the database

Boolean functions present in Javascript
Boolean functions present in Javascript Explain about the Boolean functions present in Javascript

Logic Present Tag (<logic:present >...</logic:present >)
Logic Present Tag (<logic:present >...</logic:present >) ...; present tag -This tag evaluates its nested body contents if the specified value is present in the request. This tag checks the current request

tables for layout
tables for layout Are there any problems with using tables for layout

CSV tables
CSV tables hello, What are CSV tables? hii,ADS_TO_REPLACE_1 CSV Tables cannot be indexed.CSV Tables are the special tables, data for which is saved into comma-separated values files

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

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

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
the APIs, administrative tools, various different libraries etc. MySQL composes...MySQL In this section we will read about what is MySQL, MySQL distribution, MySQL features, MySQL architecture etc. MySQL unofficially, pronounced as My

use tables to structure forms
use tables to structure forms How can I use tables to structure forms

tables to structure forms
tables to structure forms How can I use tables to structure forms

Welcome to the MySQL Tutorials
the MySQL performs a join that linking the rows from multiple tables... will learn Most users concentrate on MySQL's databases and tables... of tables. MySQL Database

ModuleNotFoundError: No module named 'tables'
ModuleNotFoundError: No module named 'tables' Hi, My Python... 'tables' How to remove the ModuleNotFoundError: No module named 'tables'... to install padas library. You can install tables python with following command

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.... ADS_TO_REPLACE_1 Query show tables

program to create nested tables
program to create nested tables program to create nested tables

SQL All Tables
SQL All Tables SQL All Tables is used to show all the tables in database. Understand with ExampleADS_TO_REPLACE_1 The Tutorial illustrate an example from 'SQL All Tables

Join the two tables in sql
Join the two tables in sql How to join the two tables in SQL ..and return the value from common column in SQL Database

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

PL/SQL tables
PL/SQL tables hii, Describe the use of PL/SQL tables ? hello,ADS_TO_REPLACE_1 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

Joining tables using criteria
Joining tables using criteria How do i join more than three tables and retrieve one column from parent table and count of unique values in a single column from child table,the joined tables must be maintain primary key

Using criteria for multiple tables
Using criteria for multiple tables How to join more than three tables,those tables must be maintain primary key relation ship using Hql criteria & projections

Learn how to take MySQL Backups and restore the same.
Learn how to take and then restore the MySQL database backup. You can use mysqldump utility to take the backup of MySQL database and tables with or without.... Following example shows how to take MySQL backup.ADS_TO_REPLACE_1

types of relationships in tables
-to-many and many-to-many relationships while designing tables? hi... tables with primary and foreign key relationships.ADS_TO_REPLACE_1 One-to-Many relationships are implemented by splitting the data into two tables with primary

Mysql Switch CASE
Mysql Switch CASE Mysql Switch Case perform one of several different actions based on several different conditions. Understand with ExampleADS_TO_REPLACE_1

how to present the excel to the web browser in jsp
how to present the excel to the web browser in jsp How to present the content of the newly created excel file in the following jsp to the web browser: <%@ page import="java.io.InputStream" %> <%@ page import

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

Different tables present in MySQL

Questions by Category