answersLogoWhite

0

In a relational database management system (RDBMS), the command for creating a new table is "CREATE TABLE". This is the standard in most SQL programs.

User Avatar

Wiki User

11y ago

What else can I help you with?

Continue Learning about Basic Math

To add a record to a table?

add new


Is plus a noun?

It can be, when used to mean a benefit: This new law is a plus for us. Ordinarily it serves as a conjunction.


What does BEDS CODE stand for?

Basic Educational Data System its used by the new york state ed dep


Color is the fundamental color of a PowerPoint slide?

You could say white, as that is the background color used at the start of a new show.


How do you insert data to a database using a PHP form?

You will need a table first, this can be created via your Database - PHPMyAdmin,So, the first step would be to go to your Control Panel for your website, down to PHPMyAdmin and then to the database you are going to be creating the table inOnce there, you should see an option at the bottom of your page, not in the left hand menu. 'Create new table on database NAMEOFDATABASE'Name the table, Remember, names of tables shouldn't have spaces, use underscores if you need a space. You will also need to input the amount of fields.Once the fields are correctly named and whatnot, you can start thinking about inputting data into the table.Go to your page editor for a php file you should have created. You should know a little about PHP if you're wanting to input items with PHP, so, let's get to Inputting.Inputting data in PHP - MySQLSay you've created a registration form, you have all the fields filled out correctly for the person to Register their details, now you need a way for your website to remember that they are now a member right?The table you should have created in your database is a users table, with fields for the Username, Password (which remember, should be set to MD5 in it's function setting), the gender of the Registering user and their Email address. (4 fields altogether then.)Once you have created variables, query checks for the items that need it and MD5'd the passwords, a query is needed to input the details.e.gmysql_query("INSERT INTO `users` VALUES('$name','$pass','$gender','$email')") or die("Errored due to:".mysql_error());This will Input the values into the table you created with the details of the registering person.Notice that any form element in an HTML page will automatically be available to your PHP scripts.

Related Questions

What is the difference between select into and createview command?

The SELECT INTO command creates a new table with data from an existing table whereas the CREATE VIEW command creates a view i.e., a virtual table from an existing table.


Define an entire new range as a data table?

data table command


What is MySQL insert command?

The INSERT command in MySQL allows you to enter a new row of data to a table in your database.


What is append command in dbase?

"append" command is used to append new records to a dbf file. You can "append blank" or you can "append from" another existing database file. Conditions can be specified while appending, eg; append from <filename> for <condition> (or) append while <condition>. Append can also be done from non dbf files, such as delimited text files.


Query used to add fields to existing tables?

The query can be called an Append query. New columns can be added to existing tables by using the ALTER TABLE command in SQL. ex: ALTER TABLE tbl_employee ADD emp_address VARCHAR(100); The above command adds a column emp_address to an existing table tbl_employee


Does a new table exist after joins in sql?

no. a new table does not exist after a join command. All that is doing is temporarily pulling the data from the tables. If this command was one that you would want to do often, you can create a VIEW, which is a virtual table. It is an object that pulls data from one or more tables based on your search criteria.


Can you add new columns to a database after creating the structure?

Columns are added to a table, not a database (which is a collection of tables). Adding a column to a table is achieved by using the Alter Table SQL command.


What is a file command used to create or start a new file?

The 'touch' command creates a new empty file in Unix.


What is used to drag a table to a new location?

table move handle


Used to drag a table to a new location?

table move handle


What command is used to copy information to a new computer?

Loadstate


What command is used to copy the information to a new computer?

loadstate