|
|
Home
> IT > Database > Quick Answers
Quick Answers
Commands
| Operation | Oracle | Sybase | MySQL |
|---|---|---|---|
| show table structure | desc myTable | sp__helpcomumn myTable | describe myTable |
| change password | sp_password old_pass, new_pass |
Functions
| Function | Oracle | Sybase | MySQL |
|---|---|---|---|
| convert to string | to_char() | str() | |
| concat strings | '¦¦' | '¦¦' or '+' | |
| convert to date | to_date('20081201 010203', 'YYYYMMDD HH24MISS') | '20081201 010203' |
