sqlite、npm等各种总结

sqlite总结

查询表数据，显示表头，并且列对齐

命令

• 打开表头显示：".header on"
• 列对齐命令： “.mode column”

效果：

*.schema 表名：显示建表语句

npm总结

• 清除缓存
  npm cache clear
• 更新npm版本
  npm install -g npm
  *设置淘宝源
  npm config set registry https://registry.npm.taobao.org
• 查看源
  npm config get registry

根据预定义宏区分系统平台

#if defined(WIN32) || defined(_WIN32) || defined(__WIN32__) || defined(__NT__)
   //define something for Windows (32-bit and 64-bit, this part is common)
   #ifdef _WIN64
      //define something for Windows (64-bit only)
   #else
      //define something for Windows (32-bit only)
   #endif
#elif __APPLE__
    #include <TargetConditionals.h>
    #if TARGET_IPHONE_SIMULATOR
         // iOS Simulator
    #elif TARGET_OS_IPHONE
        // iOS device
    #elif TARGET_OS_MAC
        // Other kinds of Mac OS
    #else
    #   error "Unknown Apple platform"
    #endif
#elif __linux__
    // linux
#elif __unix__ // all unices not caught above
    // Unix
#elif defined(_POSIX_VERSION)
    // POSIX
#else
#   error "Unknown compiler"
#endif