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

Advertisements

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 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 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 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 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 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

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

syntax for create a table
syntax for create a table syntax for create a table

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

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
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

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.

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

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

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

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

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 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 to insert one table to anothere table
how to insert one table to anothere table i have insert the record one table then i retrve the value of that table i insert one value at a time

how to use stringtokenizer on table? and display in table format.
how to use stringtokenizer on table? and display in table format. table is retrieved from mysql database and each row contains data like(java,c,c++,.net

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

Creating a Hash Table
table. What is the hash table and how to create that? Hash Table holds... Creating a Hash Table : Java Util ... for several values. Hash Table is created using an algorithm (hashing function

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 take a backup of a table in sql
how to take a backup of a table in sql how to take a backup of a table in sql? SQL BackUp Table example

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

Java to create table in jsp file that include other jsp file
Java to create table in jsp file that include other jsp file String jspContent = "table" += "tr" += "td" += "jsp:include page='fileSource'" //this line is not working properly... += "/td" += "/tr>" += "/table" Please refer

create a table in access2007 from gui application using textfields and combox
create a table in access2007 from gui application using textfields and combox I want to create a table in ms access 2007 from gui application in which when i click create button the table should get created based on textfield

JDBC Drop Table Example
JDBC Drop Table Example: In this tutorial we will learn how drop Table from Database. This tutorial first create database "testjdbc" if not exist and create a table "user" under "

how to create using jsp
how to create using jsp code 1: <%@ page language="java...; <title>Create New Student</title> </head> <body> <form name="create" method="post" action="<

Ads