mysql> select name,name like '%ns' ends_in_ns
-> from department
-> ;
+----------------+------------+
| name | ends_in_ns |
+----------------+------------+
| Operations | 1 |
| Loans | 1 |
| Administration | 0 |
+----------------+------------+
3 rows in set
、
mysql> select cust_id,cust_type_ed,fed_id,
-> fed_id regexp '.{3}-{2}-.{4}' is_ss_no_format
-> from customer;
1054 - Unknown column 'cust_type_ed' in 'field list'
mysql>
mysql> select @@global.time_zone,@@session.time_zone
-> ;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| SYSTEM | SYSTEM |
+--------------------+---------------------+
1 row in set
编写查询返回当前的日期所在的月份。
mysql> select extract(MONTH from current_date());
+------------------------------------+
| extract(MONTH from current_date()) |
+------------------------------------+
| 7 |
+------------------------------------+
1 row in set
EXTRACT() 函数用于返回日期/时间的单独部分,比如年、月、日、小时、分钟等等。
CURDATE() 函数返回当前的日期。
http://www.w3school.com.cn/sql/func_curdate.asp参考资料: