Databases

View:  
Sorted by:  

How to Send an SQL Server to the MySQL Server

After you have an open connection to the MySQL server, you send your SQL statement query. To interact with the database, put your SQL statement into a variable and send it to the MySQL server with the [more…]

How to Send Multiple Queries to the MySQL Server

Sometimes, you want to send two or more queries to the MySQL server at the same time. MySQL allows you to do so, but you need to use a different function to send the queries. You can send multiple queries [more…]

How to Select a MySQL Database

If you don’t select the MySQL database in the connect function, you can select the database by using the mysqli_select_db function. You can also use this function to select a different database at any [more…]

How to Convert mysqli Functions to mysql Functions

You’re probably using PHP 5 or later with the mysqli functions to interact with MySQL 5.0 or 5.1. If you’re using PHP 4, the mysqli functions aren’t available. Instead, you use the mysql functions, even [more…]

How MySQL Works

The MySQL software consists of the MySQL server, several utility programs that assist in the administration of MySQL databases, and some supporting software that the MySQL server needs [more…]

Database Structure and MySQL

MySQL is a Relational Database Management System (RDBMS). Your MySQL server can manage many databases at the same time. In fact, many people might have different databases managed by a single MySQL server [more…]

The Basics of Communicating with MySQL

All your interaction with the database is accomplished by passing messages to the MySQL server. The MySQL server must be able to understand the instructions that you send it. You communicate using [more…]

How to Use the mysql Client

When MySQL is installed, a simple, text-based program called mysql (or sometimes the command line interface or the CLI) is also installed. Programs that communicate with servers are [more…]

Protect Your MySQL Databases

You need to control access to the information in your MySQL database. You need to decide who can see the data and who can change it. If a bad guy gets a list of your customers' private information [more…]

MySQL Administrator Responsibilities

Administering MySQL encompasses the tasks required to ensure that MySQL can perform its data management duties in an efficient and secure manner. You might be responsible for some or all of the administrative [more…]

How to Control Access to Your MySQL Data

You need to control access to the information in your MySQL database. You need to decide who can see the data and who can change it. Imagine what would happen if your competitors could change the information [more…]

MySQL Account Names and Hostnames

Together, the MySQL account name and hostname (the name of the computer that’s authorized to connect to the database) identify a unique account. Two accounts with the same name but different hostnames [more…]

MySQL Passwords

A password is set up for every MySQL account. If no password is provided for the account, the password is blank, which means that no password is required. MySQL doesn’t have any limit for the length of [more…]

MySQL Account Privileges

MySQL uses account privileges to specify who can do what. Anyone using a valid account can connect to the MySQL server, but he or she can do only those things that are allowed by the privileges for the [more…]

The MySQL Security Database

When MySQL is installed, it automatically creates a database called mysql. All the information used to protect your data is stored in this database, including account names, hostnames, passwords, and privileges [more…]

How to Identify What MySQL Accounts Currently Exist

To see your MySQL account information, you can execute an SQL query, using the mysql client. To see what accounts currently exist for your database, you need an account that has the necessary privileges [more…]

How to Add MySQL Accounts

The preferred way to access MySQL from PHP is to set up an account specifically for this purpose with only the privileges that are needed.

If you're using an account given to you by a company IT department [more…]

How to Add and Change MySQL Passwords and Privileges

Passwords in MySQL aren’t set in stone. You can add or change a password for an existing account. Like many procedures, you can add or change passwords with an SQL statement, like this: [more…]

How to Handle MySQL Errors

You use the mysqli functions of the PHP language, such as mysqli_connect and mysqli_query, to interact with the MySQL database. Things will sometimes go wrong when you use the statements. You may make [more…]

5 Ways to Customize Reports with SQL Server Reporting Services

Add a few lines of extra coding in SQL Server 2005 Reporting Services to customize your reports. Try some of these interesting (and cool) tricks to make your reports either stand out or fit into the existing [more…]

How to View a Report with SQL Server Reporting Services

Viewing a report with Microsoft SQL Server 2005 Reporting Services requires that your computer have at least a connection to the server that's running the report server. If you've installed the sample [more…]

How to Create Role Assignments with SQL Server Reporting Services

SQL Server 2005 Reporting Services includes several predefined roles to accommodate various categories of users. You can see the roles defined in SQL Server Management Studio when you expand the Roles [more…]

Microsoft SQL Server 2005 Reporting Services For Dummies Cheat Sheet

Reporting Services 2005, which comes as part of SQL Server 2005, is an intuitive reporting tool that's an extension of the powerful database management system. To develop effective reports, you should [more…]

Using Oracle's Database Upgrade Assistant

For some of you, Oracle 12c may not be the first database that you are implementing. You may have Oracle already installed and running. In that case, you might want to consider [more…]

Oracle Database Statistics

When it comes to statistics within your Oracle database, information is power. That saying translates a lot of different ways but the overall idea is that the more you know about someone or something, [more…]

Listings:1-2526-5051-7576-100more...

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.