Related Posts:
Managing the Database
Creating Users
To create users above and beyond the default privileged
root user, issue the grant command. The grant command
uses this syntax:
GRANT PRIVILEGES ON DATABASE.OBJECTS TO'USER'@'HOST' IDENTIFIED BY 'PASSWORD… Read More
Advantages of MySQL and PHP
Certain technologies play together better than others. PHP, a simple and powerful scripting language, and MySQL, a solid and reliable database server, make a perfect marriage between two modern technologies for building da… Read More
Why MySQL Database?
MySQL has its own client interface, allowing you to move data
around and change database configuration. Note that you must use a password to
log in. Assigning database users allows you to
limit access to server tables … Read More- Backing Up and Restoring Data MySQL
Even the best maintained databases occasionally develop
problems. Hardware failures, in particular, can really throw a monkey wrench
into your web pages. Now that you're using a database, just backing up the files
(HTM… Read More
why need For a relational database?
A database or database management system that stores
information in tables—rows and columns of data—and conducts searches by using
data in specified columns of one table to find additional data in another table.
In a rela… Read More- MySQL with php
The basic steps of performing a query, whether using the mysql
command-line tool or PHP, are the same:Connect to the database.Select the database to use.Build a SELECT statement.Perform the query.Display the results.
Wh… Read More
Relational Databases-MySQL
MySQL is a relational database.
An important feature of relational systems is that a single database can be
spread across several tables as opposed to our flat-file phone book example.
Related data is stored in separat… Read More
Database Backups using mysqldump
The MySQL server, and mysql, the MySQL client, a MySQL installation comes
with many useful utility programs. We have seen mysqladmin, which is
responsible for the control and retrieval of information about an operati… Read More
Advantages of Using PHP with MySQL
Advantages of Using PHP with MySQL
There are several factors that make using PHP and MySQL
together a natural choice:
PHP and MySQL work well
together
PHP and MySQL have been developed with each other in … Read More
Web and Database Port Listing
Table A-1. HTTP/1.1 Methods and
Field Definitions Web and Database Port Listing
Port
Server
66
Oracle SQL*Net
80
Hyper Text Transfer
Protocol (HTTP)
81
HTTP Proxy,
Alternativ… Read More
Create the months table With MySQL
Create the months table as follows:
CREATE TABLE months (
month_id INT NOT NULL AUTO_INCREMENT,
month VARCHAR (20),
days INT,
PRIMARY KEY (month_id));
To add the months to the new table, s… Read More
Adding New User Privileges to MySQL
You can add users two di erent ways: by using GRANT statements or by manipulating theMySQL grant tables directly. The preferred method is to use GRANT statements, becausethey are more concise and less error-prone.
The exam… Read More
top Database management system-PHP
PHP Support for Multiple Databases
If you have been playing with PHP for a while, you have most
likely noticed its excellent support for connecting to MySQL databases. Most of
the PHP books on the market describ… Read More
Advanced SQL
Many of the features shown in this chapter are specific to MySQL's version of SQL. For example, MySQL's functions are useful tools for working with strings, dates and times, and math. Also, we'll show some w… Read More
Basic MySQL
Basic MySQL
Create or Drop a Database
Starting with something simple, you can use the CREATE command to create a new database. The syntax is
CREATE DATABASE IF NOT EXISTS [yourDBName];
When you create a database wit… Read More