Tutorial by Topics: my

MySQL is an open-source Relational Database Management System (RDBMS) that is developed and supported by Oracle Corporation. MySQL is supported on a large number of platforms, including Linux variants, OS X, and Windows. It also has APIs for a large number of languages, including C, C++, Java, ...

mysqldump -u [username] -p[password] [other options] db_name > dumpFileName.sql /// To Backup single database mysqldump -u [username] -p[password] [other options] db_name [tbl_name1 tbl_name2 tbl_name2 ...] > dumpFileName.sql /// To Backup one or more tables mysqldump -u [username] -...

In this topic you will learn how to integrate with Node.js using MYSQL database management tool. You will learn various ways to connect and interact with data residing in mysql using a nodejs program and script.

SQLALCHEMY'S PHILOSOPHY From the SQLAlchemy Website: SQL databases behave less like object collections the more size and performance start to matter; object collections behave less like tables and rows the more abstraction starts to matter. SQLAlchemy aims to accommodate both of these principl...

The -- style of comment, which requires a trailing space, differs in behavior from the SQL standard, which does not require the space.

The mysqli interface is an improvement (it means "MySQL Improvement extension") of the mysql interface, which was deprecated in version 5.5 and is removed in version 7.0. The mysqli extension, or as it is sometimes known, the MySQL improved extension, was developed to take advantage of ne...

MySQLi is a PHP Extension which enables PHP to communicate with MySQL Databases. MySQLi comes built in with PHP. MySQLi was introduced with PHP 5.0. MySQLi is available in procedural & Object Oriented style. MySQLi supports CRUD queries, prepared statements,Multiple statements,Transaction and...

Flask-SQLAlchemy adds some additional functionality such as automatic destruction of the session assuming some things for you which are very often not what you need.

Over the years, InnoDB has improved to the point where it is almost always better than MyISAM, at least the currently supported versions. Bottom line: Don't use MyISAM, except maybe for tables that are truly temporary. One advantage of MyISAM over InnoDB remains: It is 2x-3x smaller in space r...

Oh-my-zsh is one of many configuration frameworks for interactive use of zsh (it is not relevant for writing zsh scripts). It can be useful if you'd like to start with an experienced user's configuration.

ParameterDescription--delete -Dempty the table before importing the text file--fields-optionally-enclosed-bydefine the character that quotes the fields--fields-terminated-byfield terminator--ignore -iignore the ingested row in case of duplicate-keys--lines-terminated-bydefine row terminator--passwo...

LOCK TABLES table_name [READ | WRITE]; // Lock Table UNLOCK TABLES; // Unlock Tables Locking is used to solve concurrency problems.Locking is required only when running a transaction, that first read a value from a database and later write that value in to the database. Locks are n...

SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2; SELECT column_name(s) FROM table1 UNION ALL SELECT column_name(s) FROM table2; SELECT column_name(s) FROM table1 WHERE col_name="XYZ" UNION ALL SELECT column_name(s) FROM table2 WHERE col_name="XYZ&qu...

phpMyAdmin is a free software used to manage MySQL databases via web interface. It is much easier than using MySQL console where the user must use commands to manage databases. By using phpMyAdmin, with a few mouse clicks people can create database and grant privileges for MySQL user for that data...