Notice: Payments for answers will end 4/10/2017. Click for more info.
You have new items in your feed. Click to view.
Question and answer
Q: describe how you would create a new database using your software.
A: 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
Get an answer
New answers
Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment
Log in or sign up first.
26,657,168 questions answered
Popular Conversations
What is 3x3 11x2 26x 30 divided by x 5?
Weegy: 3X3 = 9 11X2 = 22 26X30 = 780
2/20/2018 7:03:35 PM| 9 Answers
Which country was first to Settle in the Louisiana area?
Weegy: The first country to settle in the Louisiana area was France.
2/22/2018 10:08:51 PM| 3 Answers
Solve this equation: 2s + s + 12 = 132. A. s = 120 B. s = –30 C. s = ...
Weegy: 2s + s + 12 = 132 User: 2s + s + 12 = 132. Weegy: 2s + s + 12 = 132 User: . Solve the inequality: 12p + 7 > ...
2/24/2018 3:39:46 AM| 3 Answers
Solve for x. 4x + 3 < 9
2/18/2018 11:19:06 AM| 3 Answers
Simplify and solve this equation for q: 3q + 5 + 2q – 5 = 65. ...
Weegy: 3q + 5 + 2q - 5 = 65 User: Solve the following inequality: 38 4 B. x 28 Weegy: 38 User: Use an ...
2/19/2018 12:26:32 AM| 3 Answers
What is equilibrium?
Weegy: Equilibrium is the state in which market supply and demand balance each other and, as a result, prices become ...
2/21/2018 9:09:11 PM| 3 Answers
Write 10 5/12 as an equivalent improper fraction.
Weegy: 10 5/12 in improper fraction form is 125/12. User: Subtract: 8 – 4 1/2
2/15/2018 12:27:39 AM| 2 Answers
In the decimal number .675, the 7 holds what place value? A. ...
Weegy: In the decimal number .675, the 7 holds - Hundredths place. User: Find the value of 8.3 × 24.2 × 0.03. ...
2/22/2018 2:04:24 PM| 2 Answers
Find the difference between the product of 21.33 and 2.04 and the sum ...
Weegy: (21.33 * 2.04) - (1.115 + 3.18 + 22.0613 + 12.2384) User: Which is another way to check the sum of 52 + 23 + ...
2/22/2018 8:00:08 PM| 2 Answers
Which country was first to Explore Louisiana? France Spain England
Weegy: France was the first country to explore Louisiana.
2/22/2018 10:05:40 PM| 2 Answers
Weegy Stuff
S
L
Points 404 [Total 407] Ratings 13 Comments 244 Invitations 3 Offline
S
P
L
P
P
Points 91 [Total 284] Ratings 0 Comments 91 Invitations 0 Offline
S
Points 89 [Total 89] Ratings 0 Comments 19 Invitations 7 Offline
S
1
L
L
P
R
P
L
P
P
R
Points 73 [Total 12684] Ratings 0 Comments 63 Invitations 1 Offline
S
P
Points 41 [Total 85] Ratings 1 Comments 31 Invitations 0 Offline
S
P
Points 17 [Total 34] Ratings 0 Comments 17 Invitations 0 Offline
S
Points 11 [Total 11] Ratings 1 Comments 1 Invitations 0 Online
S
Points 10 [Total 10] Ratings 0 Comments 0 Invitations 1 Offline
S
Points 10 [Total 11] Ratings 1 Comments 0 Invitations 0 Offline
S
Points 10 [Total 10] Ratings 1 Comments 0 Invitations 0 Offline
* Excludes moderators and previous
winners (Include)
Home | Contact | Blog | About | Terms | Privacy | © Purple Inc.