Question and answer
describe how you would create a new database using your software.
Please note that you can not create a database directly through cPanel->PhpMyAdmin due to the lack of user privileges. 1. You can easily create a new database from your cPanel->MySQL Databases. Navigate to the Create New Database box. [ Enter the database name in the New Database text field and click on the Create Database button. 2. The database name will be preceded by the cPanel username.
For example, if your cPanel user name is user and you want to have a database named test, the actual database name will be user_test. You will get a confirmation message. 3. Navigate to your cPanel->PhpMyAdmin tool and open the newly create database. It is empty and there are no tables. 4. Enter the table name and the number of fields. Click on the Go button to create the table. On the next screen you should enter the fields' names and the corresponding properties. a. Type - Here you should pick the type of the data, which will be stored in the corresponding field. More details about the possible choices can be found in the official MySQL Data Types documentation. b. Length/Values - Here you should enter the length of the field. If the field type is "enum" or "set", enter the values using the following format: 'a','b','c'... c. Collation - Pick the data collation for each of the fields. d. Attributes - The possible attributes' choices are: BINARY - the collation for the field will be binary, for example utf8_bin; UNSIGNED - the field numeric values will be positive or 0; UNSIGNED ZEROFILL - the field numeric values will be positive or 0 and leading zeros will be added to a number; ON UPDATE CURRENT_TIMESTAMP - the value for a data type field has the current timestamp as its default value, and is automatically updated; e. Null- Here you define whether the field value can be NULL. More about the NULL value can be found in the corresponding MySQL documentation. f. Default - This property allows you to set the default value for the field. g. ]
Expert answered|nexie10|Points 115|
Question
Asked 6/12/2013 5:51:25 PM
0 Answers/Comments
Ask a question
Not a good answer? Get an answer now. (Free)
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
0 questions answered
Popular Conversations
What is the equation of the line described below written in ...
Weegy: The line passing through point (4, -1) and perpendicular to the line whose equation is 2x - y - 7 = 0 in slope ...
7/28/2014 12:38:02 PM| 7 Answers
beliefs of buddhism
Weegy: Read more: Buddhism: Basic Beliefs and Practices | Infoplease.com ]
7/28/2014 4:39:59 AM| 5 Answers
Find the product. (-7p)^3
Weegy: -21p User: Find the product. (n^3)^2 · (n^5)^4 Weegy: your question? User: Find the ...
7/28/2014 7:09:27 AM| 3 Answers
What is the solution set of the following equation? -8x + x + 15 = ...
Weegy: Answer is definitely c. B = (R - Ax)/x User: The slope of a line is -1/3. Find the slope of a line that is ...
7/28/2014 1:05:49 PM| 3 Answers
Exerts control over all parts of the body (Points : 4) Nervous ...
Weegy: 1. Peripheral nervous system registers information and controls movements outside the central nervous system. ...
7/28/2014 3:41:02 PM| 3 Answers
Solve for x. 8 – 3x = 20 User: Juan buys 4 shirts on sale for $15 ...
Weegy: 4 tshirts 4 x $15.00 = $60.00 $78.00 - $60.00 = $18.00 6 pairs of socks is $18.00 $18.00 / 6 = $3.00 each ...
7/28/2014 7:55:02 AM| 2 Answers
Weegy Stuff
S
R
L
1
1
P
C
1
P
1
1
L
P
C
P
C
1
P
C
L
P
C
1
P
C
Points 2328 [Total 21328]| Ratings 1| Comments 2318| Invitations 0|Offline
S
L
P
C
P
C
1
L
P
C
L
P
C
P
C
P
C
Points 2163 [Total 17292]| Ratings 0| Comments 2163| Invitations 0|Offline
S
L
P
C
L
P
C
P
C
L
P
C
P
C
Points 1996 [Total 14551]| Ratings 1| Comments 1986| Invitations 0|Offline
S
L
1
Points 1570 [Total 3753]| Ratings 2| Comments 1550| Invitations 0|Online
S
L
1
1
1
1
L
1
Points 1347 [Total 7524]| Ratings 2| Comments 1327| Invitations 0|Offline
S
1
L
Points 1123 [Total 3259]| Ratings 7| Comments 1053| Invitations 0|Offline
S
1
L
1
L
P
P
L
Points 948 [Total 10556]| Ratings 0| Comments 948| Invitations 0|Offline
S
1
L
Points 834 [Total 4510]| Ratings 2| Comments 814| Invitations 0|Offline
S
P
C
L
P
L
1
Points 798 [Total 5852]| Ratings 4| Comments 758| Invitations 0|Offline
S
R
R
Points 160 [Total 348]| Ratings 1| Comments 140| Invitations 1|Offline
Home | Contact | Archive | Blog | About | Terms | Privacy | Social | ©2014 Purple Inc.