Low cost ecommerce web development India flash website design
Creating a Database
Those of you who are working on your Web host's MySQL server have probably
already been assigned a database with which to work. Sit tight, we'll get back to
you in a moment. Those of you running a MySQL server that you installed
yourselves will need to create your own database. It's just as easy to create a
database as it is to delete one:
mysql>CREATE DATABASE jokes;
I chose to name the database jokes, because that fits with the example we're using.
Feel free to give the database any name you like, though. Those of you working
on your Web host's MySQL server will probably have no choice in what to name
your database, since it will usually already have been created for you.
Now that we have a database, we need to tell MySQL that we want to use it.
Again, the command isn't too hard to remember:
mysql>USE jokes;
You're now ready to use your database. Since a database is empty until you add
some tables to it, our first order of business will be to create a table that will hold
our jokes.
40
website designer freelance ASP PHP ecommerce web developer
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110