Skip to content
EscapeQuotes

EscapeQuotes

Blink your leds!

Menu

  • ESP8266
  • Micro:bit
  • Raspberry PI
  • Arduino
  • CodeIgniter

mysql

Yii2: create helper

How to create a new helper in Yii2 framework: Create a new file “Utils.php” in “app-basic\helpers” or in other folder, location is up to you, but keep things organized! <?php namespace yii\helpers; use Yii; class Utils { public static function

escapequotes November 27, 2014November 27, 2014 mysql, php, Yii2 No Comments Read more

mysqld Option/Variable Reference

This table that lists every MySQL Server option or variable, what version it was introduced or deprecated in, whether it’s dynamic or not, whether variables have session/global/both scope, and links to the version-specific documentation for that variable. Name Intr Depr

escapequotes November 6, 2013September 18, 2014 CodeIgniter, mysql No Comments Read more

MySQL Trigger – after insert trigger

I want to populate automaticaly another table when new data is inserted: For table “source_table” define a after insert trigger DELIMITER $$ CREATE TRIGGER `source_table_AINS` AFTER INSERT ON `source_table` FOR EACH ROW — Edit trigger body code below this line.

escapequotes August 28, 2013August 28, 2013 mysql No Comments Read more

MySQL Utilities – Brief overview of command-line utilities

MySQL Utilities This is a brief overview of the MySQL command-line utilities. See their respective manual pages for further details and examples: mysqlauditadmin Monitor the audit log. Copy, rotate, and configure the audit log mysqlauditgrep Search the audit log. Output results to

escapequotes April 11, 2013 bash, linux, mysql No Comments Read more

MySQL replication: PURGE BINARY LOGS and RESET MASTER

On MySQL master, “RESET MASTER” command, deletes all binary log files listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. This statement is intended to be used only

escapequotes April 10, 2013April 10, 2013 escapequotes, linux, mysql No Comments Read more

MySQL replication – master slave schema

Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous – slaves need not be connected permanently to receive updates from the master. This means

escapequotes January 10, 2013January 16, 2013 linux, mysql No Comments Read more

Save Apache log in MySQL database

Apache webserver can be configured to save access logs into database via Apache Module mod_log_config. This module provides for flexible logging of client requests. Logs are written in a customizable format, and may be written directly to a file, or to

escapequotes December 17, 2012December 17, 2012 apache, linux, mysql 5 Comments Read more

mysql: –i-am-a-dummy

This option prevents MySQL from performing update operations unless a key constraint in the WHERE clause and / or a LIMIT clause are provided. mysql –i-am-a-dummy -uroot test For beginners, a useful startup option is –safe-updates (or –i-am-a-dummy, which has

escapequotes December 13, 2012 linux, mysql No Comments Read more

Getting Started With CodeIgniter

If you are familiar with php, a good practice is to use a php framework to build your applications. One choice is CodeIgniter. CodeIgniter is based on the Model-View-Controller development pattern. MVC is a software approach that separates application logic

escapequotes December 13, 2012December 13, 2012 CodeIgniter, mysql, php No Comments Read more

Hello world!

First article! Definitely must be a “Hello World” examples article. A “Hello World” program is a computer program which prints out “Hello, world!” on a display device. It is used in many introductory tutorials for teaching a programming language. It

escapequotes December 11, 2012December 13, 2012 bash, javascript, linux, mysql, php No Comments Read more
Copyright © 2025 EscapeQuotes. Powered by WordPress. Theme: Spacious by ThemeGrill.