Skip to main content

Home/ MySQL/ Group items tagged from

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Vincent Tsao

MySQL里获取当前week、month、quarter的start_date/end_date - hideto - JavaEye技术网站 - 0 views

hideto.javaeye.com/255816

mysql Tips

shared by Vincent Tsao on 06 Nov 08 - Cached
  • 当前week的第一天： select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 1 DAY) 当前week的最后一天： select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) - 5 DAY) 前一week的第一天： select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 8 DAY) 前一week的最后一天： select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 2 DAY) 前两week的第一天： select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 15 DAY) 前两week的最后一天： select date_sub(curdate(),INTERVAL WEEKDAY(curdate()) + 9 DAY)
  • 当前month的第一天： SELECT concat(date_format(LAST_DAY(now()),'%Y-%m-'),'01') 当前month的最后一天： SELECT LAST_DAY(now()) 前一month的第一天： SELECT concat(date_format(LAST_DAY(now() - interval 1 month),'%Y-%m-'),'01') 前一month的最后一天： SELECT LAST_DAY(now() - interval 1 month) 前两month的第一天： SELECT concat(date_format(LAST_DAY(now() - interval 2 month),'%Y-%m-'),'01') 前两month的最后一天： SELECT LAST_DAY(now() - interval 2 month)
  • 当前quarter的第一天： select concat(date_format(LAST_DAY(MAKEDATE(EXTRACT(YEAR FROM CURDATE()),1) + interval QUARTER(CURDATE())*3-3 month),'%Y-%m-'),'01') 当前quarter的最后一天： select LAST_DAY(MAKEDATE(EXTRACT(YEAR FROM CURDATE()),1) + interval QUARTER(CURDATE())*3-1 month) 前一quarter的第一天： select concat(date_format(LAST_DAY(MAKEDATE(EXTRACT(YEAR FROM CURDATE()),1) + interval QUARTER(CURDATE())*3-6 month),'%Y-%m-'),'01') 前一quarter的最后一天： select LAST_DAY(MAKEDATE(EXTRACT(YEAR FROM CURDATE()),1) + interval QUARTER(CURDATE())*3-4 month) 前两quarter的第一天： select concat(date_format(LAST_DAY(MAKEDATE(EXTRACT(YEAR FROM CURDATE()),1) + interval QUARTER(CURDATE())*3-9 month),'%Y-%m-'),'01') 前两quarter的最后一天： select LAST_DAY(MAKEDATE(EXTRACT(YEAR FROM CURDATE()),1) + interval QUARTER(CURDATE())*3-7 month)
melvinahebert

Does Your Device Keep Disconnecting From Wifi? - 0 views

www.techgill.com/-keeps-disconnecting-from-wifi

laptop keeps disconnecting from wifi

shared by melvinahebert on 24 Jul 23 - No Cached
  • melvinahebert on 24 Jul 23
     
    Windows troubleshooter in order to fix all the hardware or software problems affiliated with your device. Although they do not have the ability to fix each and every problem, the problem of your Wi-Fi being disconnected from your laptop can using this.
Justin Pierce

Tested And Trusted Bookkeeping Service - 1 views

When I opened my mini grocery last year, I immediately asked Bookkeepers On Call to do the bookkeeping services for me because I know it from my sister that they provide the most trusted bookkeeper...

started by Justin Pierce on 29 Oct 12 no follow-up yet
mikhail-miguel

convert xml csv mysql export xml converter, XML Converter Professional Edition - odbc t... - 0 views

rustemsoft.com/XMLConverterPro.htm

xml dev windows mysql sql csv dados database

shared by mikhail-miguel on 05 Mar 18 - No Cached
  • mikhail-miguel on 05 Mar 18
     
    XML Converter is the Windows based graphical transformation engine for creating XML documents from your database. It allows organizations to quickly and easily share information, captured within corporate data, with anyone in the world by utilizing established XML document definitions. Using this software, enterprises can share data with customers, suppliers or partners as well as distribute data across business units. The resulting XML document will be built in strong compliance with XSL specifications that make it possible to convert it into other wellknow formats, such as HTML using a variety of XSL processors. The converter is a secial software and can be run using Windows NT/2000/XP.
mikhail-miguel

mdb xml,csv xml,convert access xml transform XML Converter Professional Edition - Excel... - 0 views

rustemsoft.com/xmlconverter3.htm

xml dev windows mysql sql csv dados database

shared by mikhail-miguel on 05 Mar 18 - No Cached
  • mikhail-miguel on 05 Mar 18
     
    XML Converter is the Windows based graphical transformation engine for creating XML documents from your database. It allows organizations to quickly and easily share information, captured within corporate data, with anyone in the world by utilizing established XML document definitions. Using this software, enterprises can share data with customers, suppliers or partners as well as distribute data across business units. The resulting XML document will be built in strong compliance with XSL specifications that make it possible to convert it into other wellknow formats, such as HTML using a variety of XSL processors. The converter is a secial software and can be run using Windows NT/2000/XP.
mikhail-miguel

PHP - 0 views

kromann.info/php.php

mysql sql database

shared by mikhail-miguel on 05 Mar 18 - No Cached
  • mikhail-miguel on 05 Mar 18
     
    Continuing from my earlier post on PHP performance, I thought I'd share a few Mysql tips that I've learnt over the years. Hope it helps someone and please leave a comment with your own tips or provide any corrections to the ones mentioned.
melvinahebert

Settings App Not Working in Windows 10? Here Are the Fixes - Techgill - 0 views

www.techgill.com/windows-10-settings-wont-open

Settings App Not Working in Windows 10

shared by melvinahebert on 24 Jul 23 - No Cached
  • melvinahebert on 24 Jul 23
     
    When you see a message, asking if you want to merge the folders from your old account to your new one. You have to click Yes. That is all about, the fixes for Settings App Not Working in Windows 10. You must have known that the Settings app is very important in Windows.
Ken Wei

Live Backups of MySQL Using Replication - 0 views

www.onlamp.com/...MySQLian.html

mysql replication

shared by Ken Wei on 05 May 07 - Cached
  • The --master-data option above locks all of the tables during the dump to prevent data from being changed, but allows users to continue reading the tables. With exclusive access, this feature isn't necessary. However, this option also adds a few lines like the following to the end of the dump file:
seth kutcher

The Best Remote PC Support I Ever Had - 1 views

The Remote PC Support Now excellent remote PC support services are the best. They have skilled computer tech professionals who can fix your PC while you wait or just go back to work or just simpl...

remote PC support

started by seth kutcher on 12 Sep 11 no follow-up yet
1 - 11 of 11
Showing 20▼ items per page