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
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.
Questions asked by the same visitor
Data entry is the process of getting information into a database. True False
Weegy: Information or facts that have been assembled. (More)
Question
Updated 6/12/2013 3:15:51 PM
1 Answer/Comment
Data entry is the process of getting information into a database. Answer is True.
Added 6/12/2013 3:15:53 PM
Software is giving instructions so that text is displayed on the monitor. This software is an example of _____. application software programming language system software programming software
Weegy: Software is giving instructions so that text is displayed on the monitor. This software is an example of _____. answer:application software programming language source:en.wikipedia.org/wiki/Programming_language? (More)
Question
Expert Answered
Asked 6/12/2013 6:31:19 PM
0 Answers/Comments
Software is giving instructions so that text is displayed on the monitor. This software is an example of what?
Weegy: An LCD monitor running at its native resolution usually displays text better than a CRT monitor. [ LCD monitors can technically support lower resolutions than their native resolution, but text won't look as sharp and the image might be small, centered on the screen, edged with black, or look stretched. For more information, see Change your screen resolution. ] (More)
Question
Expert Answered
Asked 6/12/2013 6:30:11 PM
0 Answers/Comments
21,082,106 questions answered
Popular Conversations
What is the middle term of the product of (x - 4)(x - 3)? User: ...
Weegy: b.(p + 2)(p + 16) to check: p*p + (2p + 16p) + (2 * 16) = p^2 + 18p + 32 so the answer is b.(p + 2)(p + 16) ...
5/26/2015 1:22:27 PM| 3 Answers
Give the next two numbers in this pattern: 0, 0.75, 1.5, 2.25, ... ...
Weegy: 0.6/0.75 = 0.8 User: Find the direct variation equation which passes through (0, 0) and (4, 1). A. y = 4x ...
5/26/2015 12:36:07 AM| 2 Answers
Factor a 2 bc + ab 2 c + abc 2. User: Factor x 4 y 2 + x 3 y 3 ...
Weegy: (a)5k^2(1 - 7k) is the answer. 5k^2(1 - 7k) = 5k^2 - 35k^3 User: Factor -4d 3 + 28d 2 - 4d. Weegy: -4d^3 + ...
5/26/2015 9:26:33 AM| 2 Answers
Evaluate f-2g for f = 4 and g = 32. 2 8 User: Write 6,000,370 in ...
Weegy: y*9 User: (b2)3 Weegy: the bond order of b2 is 1, one bond order = 1/2 (#e- in bonding MO's - #e- in ...
5/26/2015 10:14:55 AM| 2 Answers
What is the solution set of the given equation? 4y - 6y + 9y = -2
Weegy: 4y - 6y + 9y = -2 -2y + 9y = -2 7y = -2 y = -2/7 User: Solve for x. 5x - 6 = 4x + 8 Weegy: ...
5/26/2015 12:20:50 PM| 2 Answers
If x is "the number," which of the following equations could be used ...
Weegy: -2 User: Three multiplied by the sum of 4 and a number is the same as 18 more than the number. Find the ...
5/26/2015 12:35:21 PM| 2 Answers
A major characteristic of monopolistic competition is that prices ...
Weegy: A. higher than in perfect competition. User: A minimum price, set by the government, that must be paid for a ...
5/26/2015 12:56:40 PM| 2 Answers
(2x – 1)(x + 7) = 0
Weegy: (2x + 1)(x + 7) = 0; 2x + 1 = 0; 2x = -1; x = -1/2; x + 7 = 0; x = -7; x = -1/2 or x = -7 User: x^2 ...
5/26/2015 4:37:35 PM| 2 Answers
Weegy Stuff
S
Points 742 [Total 750]| Ratings 1| Comments 732| Invitations 0|Offline
S
L
Points 706 [Total 1236]| Ratings 2| Comments 686| Invitations 0|Offline
S
1
Points 560 [Total 952]| Ratings 3| Comments 530| Invitations 0|Online
S
L
P
Points 426 [Total 2903]| Ratings 1| Comments 416| Invitations 0|Online
S
P
C
L
P
L
1
P
P
1
P
1
Points 248 [Total 8994]| Ratings 0| Comments 248| Invitations 0|Offline
S
Points 147 [Total 167]| Ratings 0| Comments 147| Invitations 0|Offline
S
1
L
L
Points 84 [Total 8267]| Ratings 0| Comments 84| Invitations 0|Offline
S
L
Points 56 [Total 3810]| Ratings 2| Comments 36| Invitations 0|Offline
S
L
1
R
Points 52 [Total 1339]| Ratings 0| Comments 52| Invitations 0|Offline
S
Points 20 [Total 20]| Ratings 2| Comments 0| Invitations 0|Offline
Home | Contact | Blog | About | Terms | Privacy | Social | ©2015 Purple Inc.