Tags » Mysql

MySQL Transactional and Locking Statements

MySQL5.0 supports local transactions by statements like START TRANSACTION, SET AUTOCOMMIT, COMMIT and ROLLBACK. Transaction means a group of SQL Statements, which executes as a unit. 452 more words

Mysql

MariaDB Notes

Create database

 CREATE DATABASE menagerie;

Create user

CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'mypass';

Create table

create table if not exists test (
    a bigint auto_increment primary key,
    name varchar(128) charset utf8,
    key name (name(32))
) engine=InnoDB default charset latin1; 82 more words
Computers

MySQL DELETE JOIN

MySQL DELETE JOIN with INNER JOIN

You often use the INNER JOIN clause in the SELECT statement to select records from a table that have corresponding records in other tables. 151 more words

Mysql

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ctrl-C' at line 1

When i import sql file through cmd prompt i got below error

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Ctrl-C’ at line 1…

162 more words
Import

To restore the only the mysql tables:

To restore the tables:

http://linuxfortechies.wordpress.com/2014/03/03/restore-a-table-from-mysql-database/

step1: create one new database
mysqladmin create imagineh_i2012_new_04
step2: Restore the database to the new database from backup file.
mysql imagineh_i2012_new_04 < /old_backup_July/cpbackup/daily.working/imagineh/mysql/imagineh_i2012.sql… 130 more words

Mysql

Установка Apache2 с PHP5 и MySQL + phpmyadmin для Debian/Ubuntu/Mint

Установка Apache2 с PHP5 и MySQL + phpmyadmin для Debian/Ubuntu/Mint
Хотелось бы рассказать как я устанавливал apache2 c php5 и mysql, а так же phpmyadmin на Debian, Ubuntu и Linux Mint в своей статье «Установка Apache2 с PHP5 и MySQL + phpmyadmin для Debian/Ubuntu/Mint». У меня установ…

MySQL Thread Pool Improvements @ Twitter

At Twitter, MySQL is an important part of our storage story. We can have a typical database node with thousands of open connections. It works mostly fine because generally only a few of these connections actively working inside the server. 1,944 more words

Mysql