How To Create a Table.
How To Create a Table?
View Answers
December 27, 2010 at 5:27 PM
Hi friends,
If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script:
<?php
include "mysql_connection_config.php";
$sql = "CREATE TABLE user_info("
. " id INTEGER NOT NULL"
. ", name VARCHAR(80) NOT NULL"
. ", address VARCHAR(1024)"
. ", pin INTEGER". ")";
if (mysql_query($sql, $con)) {
print("Table user_info created.\n");
} else {
print("Table creation failed.\n");
}
mysql_close($con);
?>
Remember that mysql_query() returns TRUE/FALSE on CREATE statements. If you run this script, you will get something like this: Table user_info created.
Thanks...
Ads
Related Tutorials/Questions & Answers:
How To Create a Table.
How To Create a Table. How To Create a Table? Hi friends, If you want to create a table, you can run the CREATE TABLE statement..._config.php"; $sql = "CREATE TABLE user_info(" . " id INTEGER NOT NULL" . ", name
How To Create a Table. How To Create a Table? Hi friends, If you want to create a table, you can run the CREATE TABLE statement..._config.php"; $sql = "CREATE TABLE user_info(" . " id INTEGER NOT NULL" . ", name
how to create a table
how to create a table create table tablename (name varchar(10),name.... Use the following query: create table tablename (name varchar(10),address varchar(10)); For more information, visit the following link: Java Create
how to create a table create table tablename (name varchar(10),name.... Use the following query: create table tablename (name varchar(10),address varchar(10)); For more information, visit the following link: Java Create
Advertisements
how to create database and table using jsp
how to create database and table using jsp hi frnds...., i want to create database and table in mysql using jsp.... i have an registration form(name,sex,address,phone and so on ... ) i want to create individual table in mysql
how to create database and table using jsp hi frnds...., i want to create database and table in mysql using jsp.... i have an registration form(name,sex,address,phone and so on ... ) i want to create individual table in mysql
How to read textfile and create SQL server table ?
How to read textfile and create SQL server table ? hi sir, your site... trying to read textfile and create table in sql server but it gives error as null, but in Mysql it works fine and table is created.. May i have your suggestions
How to read textfile and create SQL server table ? hi sir, your site... trying to read textfile and create table in sql server but it gives error as null, but in Mysql it works fine and table is created.. May i have your suggestions
How to Create Multiplication Table from 1 to 10?
How to Create Multiplication Table from 1 to 10? Hi, I want to develop an small application store products. So, i how to create multiplication... table. Thanks Hi, Did you want to create multiplication table 1
How to Create Multiplication Table from 1 to 10? Hi, I want to develop an small application store products. So, i how to create multiplication... table. Thanks Hi, Did you want to create multiplication table 1
how tohow to create a table with primary key and foreign keyhow to create a table with primary key and foreign key
how tohow to create a table with primary key and foreign keyhow to create a table with primary key and foreign key how to create a table using.... CREATE TABLE CUSTOMER (SID integer, FirstName varchar(40), LastName varchar(40
how tohow to create a table with primary key and foreign keyhow to create a table with primary key and foreign key how to create a table using.... CREATE TABLE CUSTOMER (SID integer, FirstName varchar(40), LastName varchar(40
how to create a new table for the already existing user in the website
how to create a new table for the already existing user in the website haiii....i want the code in jsp "how to create a new database for every user that has been already existing in the website?"....plzzzz help me
how to create a new table for the already existing user in the website haiii....i want the code in jsp "how to create a new database for every user that has been already existing in the website?"....plzzzz help me
How do we create new table apart from mapping with existing table ?
How do we create new table apart from mapping with existing table ? Hi, How do we create new table apart from mapping with existing table ? Thanks
How do we create new table apart from mapping with existing table ? Hi, How do we create new table apart from mapping with existing table ? Thanks
Create Table in SWT
Create Table in SWT In this section, you will study how to create a table. SWT provides... to create a table. In the given example, we have create an ArrayList of Tennis players
Create Table in SWT In this section, you will study how to create a table. SWT provides... to create a table. In the given example, we have create an ArrayList of Tennis players
alter table create index mysql
alter table create index mysql Hi, What is the query for altering table and adding index on a table field? Thanks
alter table create index mysql Hi, What is the query for altering table and adding index on a table field? Thanks
Java Table Create
, temp etc should also come in that table............. so plz tel me how...Java Table Create hi........ thanks 4 ur reply......... but i... and then avalues in front of them. Eg: suppose the following is the table
, temp etc should also come in that table............. so plz tel me how...Java Table Create hi........ thanks 4 ur reply......... but i... and then avalues in front of them. Eg: suppose the following is the table
MySQL Create Table
MySQL Create Table Here, you will read the brief description about the MySQL create table. The CREATE TABLE statement is used for creating a table in database.
MySQL Create Table Here, you will read the brief description about the MySQL create table. The CREATE TABLE statement is used for creating a table in database.
alter table create index mysql
alter table create index mysql Hi, What is the query for altering table and adding index on a table field? Thanks Hi, Query is: ALTER TABLE account ADD INDEX (accounttype); Thanks
alter table create index mysql Hi, What is the query for altering table and adding index on a table field? Thanks Hi, Query is: ALTER TABLE account ADD INDEX (accounttype); Thanks
Create Dynamic Table using Hubernate
: How to create seperate table for all users they sign up for my web app. i need... files but i done create and update for a single table. i dono how to automate...Create Dynamic Table using Hubernate Thank's for reading my Post. I
: How to create seperate table for all users they sign up for my web app. i need... files but i done create and update for a single table. i dono how to automate...Create Dynamic Table using Hubernate Thank's for reading my Post. I
create table in mysql of split file created in java
create table in mysql of split file created in java i have created splite file in java. now i want to create table from splited data how to do
create table in mysql of split file created in java i have created splite file in java. now i want to create table from splited data how to do
Mysql Create Table
Mysql Create Table Mysql Create Table is used to create a table in database. Understand with Example The section of Tutorial will help you to create a table in database
Mysql Create Table Mysql Create Table is used to create a table in database. Understand with Example The section of Tutorial will help you to create a table in database
JDBC: Create Table Example
JDBC: Create Table Example In this section, we are going to create table using JDBC and using database MySql. Create Table : Database table is collection... are creating table, named student in the database. For that we create
JDBC: Create Table Example In this section, we are going to create table using JDBC and using database MySql. Create Table : Database table is collection... are creating table, named student in the database. For that we create
how to create session for login
how to create session for login how to create session for login? how to display uploaded resume and images in the profile
how to create session for login how to create session for login? how to display uploaded resume and images in the profile
Php Sql Table
Php Sql Table This example illustrates how to create table in php. In this example we create a table "emp_table" with three fields, "... we fetched all rows and columns by select query. Table: emp_table
Php Sql Table This example illustrates how to create table in php. In this example we create a table "emp_table" with three fields, "... we fetched all rows and columns by select query. Table: emp_table
How alter table in MySQL?
How alter table in MySQL? Hi, I have a table and I want to alter an int field into text field. How to alter the table in MySQL? Thanks Hi, You can use the following query: alter table employees change empid empid
How alter table in MySQL? Hi, I have a table and I want to alter an int field into text field. How to alter the table in MySQL? Thanks Hi, You can use the following query: alter table employees change empid empid
How to update table in Hibernate
How to update table in Hibernate Hi, I have a table in database that has two fields in it. Student Name and ID, can anyone explain me how to update these tables in Hibernate. Thanks. Update table query in Hibernate
How to update table in Hibernate Hi, I have a table in database that has two fields in it. Student Name and ID, can anyone explain me how to update these tables in Hibernate. Thanks. Update table query in Hibernate
how to use stringtokenizer on table? and display in table format.
display result in row format how to use stringtokenizer on table? and display in table format
display result in row format how to use stringtokenizer on table? and display in table format
How to create form in Swings
How to create form in Swings How to create registration, login and question form in Java Swing? Creating different forms in Java Swing - Examples how to create registration form in swing swing login form example
How to create form in Swings How to create registration, login and question form in Java Swing? Creating different forms in Java Swing - Examples how to create registration form in swing swing login form example
How to create a class in java
How to create a class in java I am a beginner in programming and tried to learn how to do programming in Java. Friends please explain how can I create a class in Java
How to create a class in java I am a beginner in programming and tried to learn how to do programming in Java. Friends please explain how can I create a class in Java
how to create web aplli
how to create web aplli how to Create a web application using any technology to display 10 most relevant tweets from Twitter in real-time for the keyword "@cldmgc
how to create web aplli how to Create a web application using any technology to display 10 most relevant tweets from Twitter in real-time for the keyword "@cldmgc
how to create web aplli
how to create web aplli how to Create a web application using any technology to display 10 most relevant tweets from Twitter in real-time for the keyword "@cldmgc
how to create web aplli how to Create a web application using any technology to display 10 most relevant tweets from Twitter in real-time for the keyword "@cldmgc
How to Create Keyboard in JAVA
How to Create Keyboard in JAVA please help me to create On-Screen Keyboard with java and please give me an another idia to make it ..............iam waiting for your help ,think u so much
How to Create Keyboard in JAVA please help me to create On-Screen Keyboard with java and please give me an another idia to make it ..............iam waiting for your help ,think u so much
how to allow table editing
how to allow table editing 1**. hi... l've tried the method isCellEditable(int rowIndex, int colIndex) { return true but it doesn't enabled the user the editing of any cell why????????????? regards
how to allow table editing 1**. hi... l've tried the method isCellEditable(int rowIndex, int colIndex) { return true but it doesn't enabled the user the editing of any cell why????????????? regards
