 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
Few Tips. This is Part-I of the tips. Hope you will come back for Part-II 1] Under unix Database names are case sensitive, under windows this restriction does not apply, although you must refer to databases and tables using the same lettercase throughout a given query. 2] To get list of tables in MySQL mysql>use show tables; 3] MySQL Display Date in Format - 'YYYY-MM-DD' 4] MySQL Display DateTime in Format - 'YYYY-MM-DD HH:MM:SS' 5] MySQL Display Time in 'HH:MM:SS' 6] To verify table in MySQL DB use DESCRIBE tablename; 7] To redirect MySQL Console output to a text file - Use \T filename.txt 8] KEYWORD can be entered in anycase 9] To cancel a command which is in the process of entering use \C mysql>select ; now; \c; mysql> 10] Prompt - If you are getting mysql prompt in '> or "> instead of ->, you've inadvertantly left out a quote character. 11] mysql> select * from productinfo where pr_exp>=now() and is_it_suppl="y"> There should be a quote after y, so simply cancel command using \c 12] MySQL, SQL patterns are case insensitive by default. 13] Regular expressions are case sensitive in MySQL. 14] Prior to MySQL Version 3.23.4, REGEXP is case sensitive. 15] From MySQL 3.23.4 on, to force a REGEXP comparison to be case sensitive, use the BINARY keyword mysql> select * from productinfo where pr_name regexp binary "^a"; Empty set (0.01 sec). | |||||
| Related Code Examples | |||||
