Tutorial by Topics: mysql

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.
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...
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...
mysql [OPTIONS] [database_name] ParameterDescription-D --database=namename of the database--delimiter=strset the statement delimiter. The default one is ';'-e --execute='command'execute command-h --host=namehostname to connect to-p --password=namepassword Note: there is no space between -p a...
We know that spring-boot by default runs using H2 database. In this article, we will see how to tweak the default configuration to work with MySQL database. As a pre-requisite, make sure that MySQL is already running on port 3306 and has your database created.
After MySQL 5.7, when we install MySQL sometimes we don't need to create a root account or give a root password. By default when we start the server, the default password is stored in the mysqld.log file. We need to login in to the system using that password and we need to change it. Recoverin...

Page 1 of 2