Creating table using MySQLi Procedural procedure

mysqli mysql table creation 5 years, 5 months ago

<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "newDB"; // Checking connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } // sql code to create table $sql = "CREATE TABLE employees ( id INT(2) PRIMARY KEY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(50) )"; if (mysqli_query($conn, $sql)) { echo "Table employees created successfully"; } else { echo "Error creating table: " . mysqli_error($conn); } mysqli_close($conn); ?>

2148

0

0

Posted By

Please Login to Comment Here


                            <?php
$servername = "localhost";
$username = "username";

mysqli table creation mysql


                            CREATE TABLE `user` (
    `username` VARCHAR(25) NOT NULL,
    `email` VARCHAR(150) NOT NULL,


                            # pip install mysql-connector

from mysql import connector

python mysql mysql-connector


                            Drop table Table_name;


                            SELECT 
IFNULL(
  (SELECT NAME


                            SELECT BIN(5);

SELECT BIN(12);


                            RENAME USER 'RAJ' @ 'localhost' TO 'AMIT

RENAME USER 'PRIYA' @ 'localhost' TO 'DI


                            ALTER TABLE TABLE_NAME RENAME TO NEW_TAB

alter table mysql


                            ALTER TABLE TABLE_NAME RENAME COLUMN TO

alter column mysql


                            SELECT DEFAULT (COLUMN_NAME) FROM TABLE_

default() mysql


                            DROP USER 'user' @ 'host';


                            SET PASSWORD FOR 'user' @ 'localhost' =

mysql set password


                            ALTER USER user@localhost IDENTIFIED BY

alter password mysql


                            UPDATE USER SET AUTHENTICATION_STRING = 
WHERE USER = 'USER_NAME' AND
HOST = 'LOCALHOST';

password changing using update mysql


                            CREATE USER 'user_name' @ 'localhost' ID

create user mysql


                            CREATE USER
'user_name' @ 'localhost' IDENTIFIED BY 
'user_name' @ 'localhost' IDENTIFIED BY

creating multiple users mysql


                            SELECT COUNT(SALARY)
FROM EMPLOYEES
WHERE SALARY >= 40000;


                            SELECT AVG(SALARY) FROM EMPLOYEES;

SELECT MAX(column_name)

mathematical functions mysql


                            SELECT DATABASE();

SELECT CURRENT_USER();

mysql current user database


                            SELECT MAX (column_name) 
FROM table_name 
WHERE column_name NOT IN (SELECT Max (co

mysql second largest