SELECT *
FROM table_name;
Above
statement gives you all the contents of given table.
mysql> SELECT * FROM employee; +----+--------------+---------------+---------------------+ | id | name | mailId | dateOfBirth | +----+--------------+---------------+---------------------+ | 1 | Hari Krishna | hari@hari.com | 1989-05-06 07:30:00 | | 2 | Gopi | gopi@gopi.com | 1987-11-06 17:30:00 | | 3 | PTR | ptr@ptr.com | 1988-06-06 23:30:00 | | 4 | Rama Krishna | rama@rama.com | 1988-11-06 03:54:00 | +----+--------------+---------------+---------------------+ 4 rows in set (0.00 sec)
Get specific fields information
SELECT
(column1, column2 ....columnN) FROM table_name;
Above
statement return specific fields information.
mysql> SELECT name, dateOfBirth FROM employee; +--------------+---------------------+ | name | dateOfBirth | +--------------+---------------------+ | Hari Krishna | 1989-05-06 07:30:00 | | Gopi | 1987-11-06 17:30:00 | | PTR | 1988-06-06 23:30:00 | | Rama Krishna | 1988-11-06 03:54:00 | +--------------+---------------------+ 4 rows in set (0.00 sec)
No comments:
Post a Comment