creating tables using SQl

how do i create tables using SQl

Page 1 of 1

2 Replies - 1665 Views - Last Post: 29 November 2006 - 01:45 AM Rate Topic: -----

#1 kefa  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 25-October 06

creating tables using SQl

Post icon  Posted 02 November 2006 - 08:30 AM

new user ,but very determned ,how to create tables using SQL ???
Is This A Good Question/Topic? 0
  • +

Replies To: creating tables using SQl

#2 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 247
  • View blog
  • Posts: 13,505
  • Joined: 12-July 02

Re: creating tables using SQl

Posted 02 November 2006 - 08:52 AM

Though the command line, or using a GUI?

command line or programatically:

http://www.w3schools.../sql_create.asp

If by GUI, can you specify the interface?
Was This Post Helpful? 0
  • +
  • -

#3 k0b13r  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 15
  • View blog
  • Posts: 243
  • Joined: 18-July 06

Re: creating tables using SQl

Posted 29 November 2006 - 01:45 AM

I'm not sure about SQL, but in MySQL you can use phpMyadmin, or command line, or script written in Perl/PHP ... your choice :)
In PHP it wil be something like
<?php
mysql_connect("<host>", "<user>", "<password>");
mysql_select_db("your_db");
mysql_query("CREATE TABLE 
name1 data_type1
name2 data_type2");
?>


Welcome to Dream In Code :)

This post has been edited by k0b13r: 29 November 2006 - 01:45 AM

Was This Post Helpful? 0
  • +
  • -
Page 1 of 1