How to change a database table prefix in PhpMyAdmin?

Here, to Change the database table prefix from previous to new one, OR add table_prefix to the tables.

How to change e database table prefix:

  1. First Log In to PhpMyAdmin.
  2. Now, Select the Database want to change.
  3. Click on the Structure and here all tables are listed.
  4. Now, in the bottom position, mark check all or Select the tables want to update or modify.
  5. A Modal will Pop Up, here fill the fields.
  6. In Modal: From : Enter Old table prefix
  7. In Modal: To: Enter new table prefix
  8. In Modal: Click Continue.
  9. Now all done. Check your tables.

Warning: mysqli_error() expects exactly 1 parameter, 0 given error

Warning: mysqli_error() expects exactly 1 parameter, 0 given error::

 

mysqli_error() needs you to pass the connection to the database as a parameter. Documentation here has some helpful examples:

Try altering your problem line like so and you should be in good shape:

$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error($myConnection));

 

source: http://php.net/manual/en/mysqli.error.php

Database engine difference of InnoDB, MyISAM, Memory

Database engine difference of InnoDB, MyISAM, Memory

InnoDB:: 

This is the default storage engine for MySQL 5.5 and higher.  It provides transaction-safe (ACID compliant) tables, supports FOREIGN KEY referential-integrity constraints.  It supports commit, rollback, and crash-recovery capabilities to protect data.  It also support row-level locking. It’s “consistent nonlocking reads” increases performance when used in a multiuser environment.  It stores data in clustered indexes which reduces I/O for queries based on primary keys.

MyISAM::

This storage engine, manages non transactional tables, provides high-speed storage and retrieval, supports full text searching.

MEMORY::

Provides in-memory tables, formerly known as HEAP.  It sores all data in RAM for faster access than storing data on disks.  Useful for quick looks up of reference and other identical data.

 

 

For Database engines Please visit the link below,

http://stackofcodes.in/2018/03/13/database-engine-php/

Database engine in php

Database engine in php

Storage engines (underlying software component) are MySQL components, that can handle the SQL operations for different table types to store and manage information in a database. InnoDB is mostly used general-purpose storage engine and as of MySQL 5.5 and later it is the default engine. There are many storage engines available in MySQL and they are used for different purposes.

Version : MySQL 5.6

Storage engines of MySQL

EnginesDescription
InnoDBThis is the default storage engine for MySQL 5.5 and higher. It provides transaction-safe (ACID compliant) tables, supports FOREIGN KEY referential-integrity constraints. It supports commit, rollback, and crash-recovery capabilities to protect data. It also support row-level locking. It’s “consistent nonlocking reads” increases performance when used in a multiuser environment. It stores data in clustered indexes which reduces I/O for queries based on primary keys.
MyISAMThis storage engine, manages non transactional tables, provides high-speed storage and retrieval, supports full text searching.
MEMORYProvides in-memory tables, formerly known as HEAP. It sores all data in RAM for faster access than storing data on disks. Useful for quick looks up of reference and other identical data.
MERGEGroups more than one similar MyISAM tables to be treated as a single table, can handle non transactional tables, included by default.
EXAMPLEYou can create tables with this engine, but can not store or fetch data. Purpose of this is to teach developers about how to write a new storage engine.
ARCHIVEUsed to store a large amount of data, does not support indexes.
CSVStores data in Comma Separated Value format in a text file.
BLACKHOLEAccepts data to store but always returns empty.
FEDERATEDStores data in a remote database.

 

For , List of Storage Engines supported by your MySQL installation, Visit here,

http://stackofcodes.in/2018/03/13/list-storage-engines-supported-mysql-installation/

List of Storage Engines supported by your MySQL installation

source:  https://www.w3resource.com/