Import CSV File into MySQL

LOAD DATA INFILE ‘/var/lib/mysql/data.csv’ INTO TABLE MyTable FIELDS TERMINATED BY ‘\t’ LINES TERMINATED BY ‘\n’;

Advertisements

ezSQL Functions and Variables

Functions:

  1. $db->get_results
  2. $db->get_row
  3. $db->get_col
  4. $db->get_var
  5. $db->query
  6. $db->debug
  7. $db->vardump
  8. $db->select
  9. $db->get_col_info
  10. $db->hide_errors
  11. $db->show_errors
  12. $db->escape
  13. $db = new db

Variables:

  • $db->num_rows
  • $db->insert_id
  • $db->rows_affected
  • $db->num_queries
  • $db->debug_all
  • $db->cache_dir
  • $db->cache_queries
  • $db->cache_inserts
  • $db->use_disk_cache
  • $db->cache_timeout

Convert iPhone SMS Database to Excel File

  • Back up your iPhone using iTunes.
  • Open the directory ~/Library/Application Support/MobileSync/Backup/ for Mac or C:UsersYourUserNameAppDataRoamingApple ComputerMobileSyncBackup for Windows 7.
  • Find the file 3d0d7e5fb2ce288813306e4d4636395e047a3d28. This is a SQLite database file.
  • Open the database file by using a SQLite Editor such as SQLite Expert.
  • Your SMS messages are inside the database named “message”.