Que: 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))?
Ans: 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.
Que: Which is the default port for MySQL Server?
Ans: 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.
Que: Which is the default port for MySQL Server?
Ans: The default port for MySQL Server is 3306.
Que: Can you save your connection settings to a conf file?
Ans: Yes you can.
Que:
Que: Can you save your connection settings to a conf file?
Ans: Yes you can.
Que:
No comments:
Post a Comment