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 315 days ago|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.
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
All Categories|No Subcategories|
Updated 315 days ago|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 315 days ago|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
All Categories|No Subcategories|Expert Answered
Asked 315 days ago|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
All Categories|No Subcategories|Expert Answered
Asked 315 days ago|6/12/2013 6:30:11 PM
0 Answers/Comments
Home | Contact | Terms | Privacy | Social | ©2013 Purple Inc.
Ad
Popular Conversations
The question below refers to the selection "By the Waters of ...
Weegy: The question below refers to the selection "By the Waters of Babylon." The many lights that John sees in his ...
4/22/2014 8:51:50 AM| 5 Answers
Identify the function of the italicized noun clause. Cousin Jake's ...
Weegy: The function of the noun clause "that he run the mile in less than four minutes" is a NOUN PHRASE COMPLEMENT.
4/22/2014 9:51:58 AM| 4 Answers
Which sentence uses a verb that agrees with its compound subject? ...
Weegy: Which sentence uses a verb that agrees with its compound subject? A. Pumpkins and grapes are grown on vines. ...
4/22/2014 12:24:12 PM| 4 Answers
(x 2 + 4x + 8)(2x - 1)
Weegy: Simplify: 2x - 8 = 2x - 3. As you can see, there are no values of x that make the equation true. Subtracting 2x ...
4/22/2014 7:19:21 AM| 3 Answers
Ethiopians learned Christian traditions from ___________. a. their ...
Weegy: Ethiopians learned Christian traditions from the Hebrews.
4/22/2014 7:36:55 AM| 3 Answers
If x varies inversely with y and x = 4 when y = 9, find x when y = 6. ...
Weegy: (3x-2) squared is 9x^2 - 12x + 4. User: Find the general term for the sequence -3, 1, 5, 9, .... Weegy: -6
4/22/2014 8:28:58 AM| 3 Answers
How many terms are in the expression shown below? x2 - 10xy + 3y + ...
Weegy: There are 5 terms in the expression x2 - 10xy + 3y + y2 - 1. User: Find the value of 21 - 18 ÷ 3 · ...
4/22/2014 1:25:53 PM| 3 Answers
Who is the owner of GTV vodka
Weegy: Birdman, the rapper, is the owner of GTV vodka.
4/22/2014 11:38:15 PM| 3 Answers
Solve for x. x - 8 = -20 -28 -12 12 28
Weegy: 6(x - 2) = 4, 6x - 12 = 4, 6x = 4 + 12, 6x = 16, x = 16/6, or 8/3 in simplest form. User: The sum of ...
4/23/2014 1:27:55 PM| 3 Answers
Which of the following represented loyalty to church before loyalty ...
Weegy: D. User: The Glorious Revolution took place in response to the __________. a. actions of James II c. Articles ...
4/22/2014 4:08:32 AM| 2 Answers
At the incident scene, who handles media inquires? A. Public ...
Weegy: At the incident scene, who handles media inquires? D. Communications Officer User: The Liaison Officer: A. ...
4/22/2014 6:09:11 AM| 2 Answers
Weegy Stuff
S
L
P
C
L
P
C
Points 1834 [Total 7221]| Ratings 0| Comments 1834| Invitations 0|Online
S
L
P
C
P
C
1
L
P
C
Points 1731 [Total 9612]| Ratings 0| Comments 1731| Invitations 0|Offline
S
1
L
C
L
Points 914 [Total 5717]| Ratings 4| Comments 874| Invitations 0|Offline
S
1
L
1
L
P
Points 577 [Total 7254]| Ratings 2| Comments 557| Invitations 0|Online
S
L
Points 480 [Total 2927]| Ratings 2| Comments 450| Invitations 1|Offline
S
L
1
1
1
Points 311 [Total 3577]| Ratings 7| Comments 241| Invitations 0|Online
S
R
Points 267 [Total 379]| Ratings 6| Comments 187| Invitations 2|Offline
S
Points 208 [Total 208]| Ratings 6| Comments 128| Invitations 2|Online
S
Points 170 [Total 586]| Ratings 0| Comments 170| Invitations 0|Offline
S
1
Points 165 [Total 495]| Ratings 4| Comments 125| Invitations 0|Online