Tag Archives: interview questions in mysql

What is mean by mysql partitioning ?

#splits large database into smaller and manageable ones. #partitioning large database into numberof rows or number of columns. # bewlow command will provide whether the mysql support parition SHOW VARIABLES LIKE ‘%partition%’;– it will show yes SHOW PLUGINS;– it will show partition active # following are the different type of partitioning . Range Prtitioning .… Read More »

Creating database table using php

use sql query to create tables in the particulardatabase using mysql_query() function See the below example

<?php
$databasehost = 'localhost';
$databaseuser = 'root';
$databasepassword = '';
$connection = mysql_connect($databasehost, $databaseuser, $databasepassword);
if(! $connection )
{
  die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
$sqlqry = 'CREATE TABLE mydoubts_data( '.
       'id INT NOT NULL AUTO_INCREMENT, '.
       'name VARCHAR(20) NOT NULL, '.
        'primary key (id ))';

mysql_select_db('mydoubts');
$output = mysql_query( $sqlqry, $connection);
if(! $output)
{
  die('Could not create table: ' . mysql_error());
}
echo "Table employee created successfully\n";
mysql_close($connection);
?>

<?php

$databasehost = 'localhost';

$databaseuser = 'root';

$databasepassword = '';

$connection = mysql_connect($databasehost, $databaseuser, $databasepassword);

if(! $connection )

{

die('Could not connect: ' . mysql_error());

}

echo 'Connected successfully';

$sqlqry = 'CREATE TABLE mydoubts_data( '.

'id INT NOT NULL AUTO_INCREMENT, '.

'name VARCHAR(20) NOT NULL, '.

'primary key (id ))';

mysql_select_db('mydoubts');

$output = mysql_query( $sqlqry, $connection);

if(! $output)

{

die('Could not create table: ' . mysql_error());

}

echo "Table employee created successfully\n";

mysql_close($connection);

or you can use the phpmyadmin to create table in the particular database.

Difference between mysql and mysqli

mysqli is the oop version of mysql,mysqli suppport some aditional functions that not in mysql(for example prepared statements,multiple statements and transactions,debugging capabilities and enhanced server support etc).