Skip to main content

Create table in mysql query used in php

Create table in mysql query used in php 

<?php
$sql="create table 'table name'('id' int[10] ,'name' varchar[50],'email'varchar[100]) "; 
mysql_query($con,$sql);
echo   "table succesfully created";
?> 
Labels:

Comments

Post a Comment

Popular posts from this blog

Minimum and maximum number with - and + 500 in Mysql and Sql query and Find out table scheema of our database in Mysql and sql query and Find out all table name of our database in Mysql and sql query and Find out current date and time in mysql and sql help of sql query

Minimum and maximum number with - and + 500 in Mysql and Sql query:- syntax:-  SELECT MIN(Used)-500 , max(Used)+500 FROM audit Find out current date and time in mysql and sql help of sql query:- syntax:- SELECT now() Find out database name in Mysql and sql query:- syntax:-  SELECT DATABASE(); Find out all table name of our database in Mysql and sql query:- syntax:- SHOW TABLES; Find out   table scheema   of our database in Mysql and sql query:- syntax:- DESCRIBE <table name>;
Post a Comment
Find more ----»

Create Json code from MySQL database with php

Create Json code  from MySQL database with php   -- -- Database: `test` -- -- -------------------------------------------------------- -- -- Table structure for table `page` -- CREATE TABLE IF NOT EXISTS `page` (   `page_id` int(11) NOT NULL,   `page_title` text NOT NULL,   `page_url` text NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; -- -- Dumping data for table `page` -- INSERT INTO `page` (`page_id`, `page_title`, `page_url`) VALUES (1, 'JSON - Dynamic Dependent Dropdown List using Jquery and Ajax', 'json-dynamic-dependent-dropdown-list-using-jquery-and-ajax'), (2, 'Live Table Data Edit Delete using Tabledit Plugin in PHP', 'live-table-data-edit-delete-using-tabledit-plugin-in-php'), (3, 'Create Treeview with Bootstrap Treeview Ajax JQuery in PHP\r\n', 'create-treeview-with-bootstrap-treeview-ajax-jquery-in-php'), (4, 'Bootstrap Multiselect Dropdown with Checkboxes using Jquery in PH...
Post a Comment
Find more ----»

Php prime number program with use of class

Php prime number  program with use of class <?php class find_p_number { # Function to check single number is Prime or not static function isPrime ( $ number ) { # Start temporary number from 2 (1 is not a prime number) $ i = 2 ; # 1 is not a prime number if ( $ number == 1 ) return false ; # 2 is the only even prime number if ( $ number == 2 ) return true ; # Check numbers other than 1 and 2 while ( $ i <= sqrt ( $ number ) ) { if ( $ number % $ i == 0 ) return false ;   $ i ++ ; } # If the execution has come to this point, means it is a prime Number :) return true ; } # Function to check Prime Numbers between two given numbers static function betweenTwoNumbers ( $ num1 , $ num2 ) { $ prime_numbers = array ( ) ; # Check Prime Numbers between two given numbers for ( $ num1 ; $ num1 < $ num2 ; $ num1 +...
Post a Comment
Find more ----»