SHOW-TYPECAST

Name

SHOW TYPECAST

Description

View all type cast under the database. If the user specifies a database, then view the corresponding database, otherwise directly query the database where the current session is located

Requires SHOW permission on this database

grammar

1. SHOW TYPE_CAST [IN|FROM db]

Parameters

db: database name to query

Example

1. mysql> show type_cast in testDb\G
2. **************************** 1. row ******************** ******
3. Origin Type: TIMEV2
4. Cast Type: TIMEV2
5. **************************** 2. row ******************** ******
6. Origin Type: TIMEV2
7. Cast Type: TIMEV2
8. **************************** 3. row ******************** ******
9. Origin Type: TIMEV2
10. Cast Type: TIMEV2

12. 3 rows in set (0.00 sec)

Keywords

1. SHOW, TYPECAST

Best Practice