Share My Idea from life

Sign in Subscribe

database

Using PHP-FPM with Apache on Ubuntu 16.04

This tutorial exists for these OS versions * Ubuntu 16.04 (Xenial Xerus) * Ubuntu 12.10 (Quantal Quetzal) * Ubuntu 12.04 LTS (Precise Pangolin) * Ubuntu 11.10 (Oneiric Ocelot) On this page 1. 1 Preliminary Note 2. 2 Installing MySQL or MariaDB 1. 2.1 Install MySQL 5.7 2. 2.

Accessing SQLite with Bash, Perl and Python

Perl: #!/usr/bin/perl -w use DBI; use strict; my $db = DBI->connect("dbi:SQLite:test.db", "", "", {RaiseError => 1, AutoCommit => 1}); $db->do("CREATE TABLE n (id INTEGER PRIMARY KEY, f TEXT, l TEXT)"); $db->do("

Mass Virtual Hosting with mod_rewrite RewriteMap and PHP

Here is a simple possibility to control a lot of virtual hosts using a simple PHP script to map them to the right path. First of all you need to make sure that mod_rewrite is loaded: a2enmod rewrite Further we need these packages: php5-cli php5-mysql mysql-server What we'

MySQL 建立Foreign Key ( InnoDB ) 時要注意的一件事

今天在測試資料庫刪除資料時，發現了一件事在有被其他資料表 Reference 成 Foreign Key 的情況下刪除資料時資料庫會發出： Cannot delete or update a parent row: a foreign key constraint fails 後來才發現在建立資料庫時，如果不會自己的 Foreign Key 設定動作的話，資料庫預設是不會做連動的更改( NO ACTION )。 ————————————– CREATE TABLE parent( id INT NOT NULL, PRIMARY KEY (id) ) TYPE = INNODB; CREATE TABLE child( id INT, parent_id INT, INDEX par_

How to enable remote access of mysql in centos?

so do the following edit my.cnf: [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/English bind-address = xxx.xxx.xxx.xxx # skip-networking after edit hit service mysqld restart after

使用SqlBulkCopy將資料批次寫入資料庫

前demo有介紹利用SqlDataSoure和手動撰寫ADO.NET的方式大量新增資料的方法，雖然已經有效的改善了寫入的速度，但在發現了SqlBulkCopy以後，發現它更是威力強大，現在就來介紹SqlBulkCopy的猛。 3 SHARES FacebookGoogle+TwitterMore ★注意事項：本文是延續將資料大量寫入資料庫時的優化寫法的更優化如果對於文中有不清楚之意，可利用本文最下方相關的文章進入觀看資料大量寫入資料庫時的優化寫法一文 ▲說明都在程式註解中啦 //一開始我們先產生一個DataTable來裝我們要寫入的資料 DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(int)); dt.Columns.Add("name", typeof(string)); //因為SqlBulkCopy的猛就是大量的一次寫入，所以我們也來跑10萬筆吧 int i; for (i = 0; i < 100000; i++)

Oracle 11g 啟用 Archive Log Mode

Oracle 11g 啟用 Archive Log Mode 我從Oracle下載Pre-Built Developer VMs，內建11gR2的Database，但是並沒有啟用Archive Log Mode SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination Oldest online log sequence 389 Current log sequence 391 關閉DB，重啟到mount階段 SQL> startup mount SQL> alter database archivelog （alter