TechTutorials - Free Computer Tutorials  







MySQL






Tutorials (20)

Total Tutorials: 6548  |  Added today: 0 Tutorials updated: 01/16/2018



Sort Tutorials By:


Accessing MySQL Database
 
n my last post, I introduced you to MySQL database Inbtroduction to MySQL. Today we will be going a bit deep in MySQL. I will be discussing accessing MySQL database.
There are three main ways in which you can interact with MySQL: using a command line, via a web interface such as phpMyAdmin, and through a programming language like PHP. We will be focusing on using the command line, you can read my other post on How to Create MySQL Database to learn how to use phpMyAdmin.

Added: 12/11/2014, Hits: 715, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Backing up and Restoring your MySQL Database
 
This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.
Added: 06/05/2004, Hits: 1,382, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Connecting To MySQL Database The OOP Way InPHP
 
With the introduction of PHP5, there is a great
improvements in OOP and it also introduces many new libraries to seamlessly work with database in an OOP way. These libraries provide you with improved performance, sometimes improved security features, and of course a whole lot of methods to interact with new features provided by the database server. In this tutorial, I will be discussing connecting to MySQL database the OOP way in PHP.

Added: 09/15/2014, Hits: 969, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Creating MySQL Database and User
 
In this tutorial I will be showing how to create MySQL databases and add user to the database created. Am going to show you two ways of creating a MySQL database in this tutorial; Creating MySQL database using PhpMyAdmin and using cPanel.
Added: 01/09/2014, Hits: 930, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Database Relationships
 
We will be looking at database relationships today. MySQL is called a relational database management system because its tables store not only data, but the relationships among the data.
Added: 01/12/2015, Hits: 482, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

How To Create A Simple PHP/MySQL Search
 
Today I will be showing you how to create a simple PHP/MySQL search for your website. Recently I was working on a project I have to include a within search feature. The search engine is just to search the website database. So I decided to make a
tutorial of it for you guys.

Added: 10/28/2014, Hits: 1,180, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Installing MySql on Vista
 
A step by step tutorial that will make installing and configuring MySql on Windows Vista very easy.

Added: 10/03/2008, Hits: 1,685, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Introduction to MySQL
 
With well over ten million installations, MySQL is probably the most popular database management system for web servers. Developed in the mid-1990s, itís now a mature technology that powers many of todayís most-visited Internet destinations. One reason for its success must be the fact that, like PHP, itís free to use. But itís also extremely powerful and exceptionally fast-it can run on even the most basic of hardware, and it hardly puts a dent in system resources. MySQL is also highly scalable, which means that it can grow with your website.
Added: 12/09/2014, Hits: 671, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

MySQL Data Types
 
We will be looking at some MySQL data types.
Added: 12/15/2014, Hits: 556, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

MySQL FAQs - Server Daemon mysqld Administration
 
A collection of 12 FAQs on MySQL server mysqld administration. Clear answers are provided with tutorial exercises on starting and shuting down the server; turning on server log files; viewing binary log files; running server on different port numbers.
Added: 03/22/2007, Hits: 1,202, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

MySQL FAQs - SQL SELECT Query Statements with GROUP BY
 
A collection of 20 FAQs on MySQL SELECT query statements and basic features. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views; sorting and counting query outputs; grouping outputs and applying group functions.
Added: 09/09/2006, Hits: 1,164, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements
 
A collection of 17 FAQs on Oracle SQL DML statements. Clear answers are provided with tutorial exercises on inserting and updating data rows; inserting and updating with subqueries; deleting data rows.
Added: 09/23/2008, Hits: 1,023, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

MySQL Indexes
 
For sometime now we have been looking at MySQL database. Today we will continue to dig deep in MySQL database, but we will be discussing MySQL Indexes.
Indexes allows a MySQL database to be searched more quickly and faster. Although a MySQL database can still be searched without an index but as the database begin to grow large there will be a need for an index which will be used to identify each rows in a table and hence makes searching the table a very smooth and fast one.

Added: 12/17/2014, Hits: 544, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Photo Album In PHP/MySQL
 
In today tutorial, I will be showing how to create a photo album in PHP/MySQL.
Added: 10/09/2014, Hits: 816, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

PHP Script Tips - Working with MySQL Database
 
A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.
Added: 03/02/2007, Hits: 1,269, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Querying MySQL Database
 
So far weíve created a MySQL database and tables, populated them with data, and added indexes to make them fast to search. Now itís time to look at how these searches are performed, and the various commands and qualifiers available. We will be looking at querying MySQL database.
Added: 12/22/2014, Hits: 569, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Retrieving Data in MySQL
 
In this tutorial, you'll learn how to use the SELECT statement to retrieve one or more columns of data from a table.
Added: 01/02/2006, Hits: 1,109, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Setting up a Local Server
 
As a web designer and developer you must have a way of testing your web applications, which you can do through a web server. The need for a local server is increasing as many developer want to test their application s without having to upload to a live server.
Added: 01/09/2014, Hits: 1,178, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

Sorting Retrieved Data
 
The retrieved data is not displayed in a mere random order. If unsorted, data is typically displayed in the order in which it appears in the underlying tables. This could be the order in which the data was added to the tables initially. However, if data was subsequently updated or deleted, the order is affected by how MySQL reuses reclaimed storage space. The end result is that you cannot (and should not) rely on the sort order if you do not explicitly control it.
Added: 01/03/2006, Hits: 1,028, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating

SQL Tutorials by Herong
 
This free book is an excellent tutorial book for beginners. It is a collection of notes and sample codes written by the author while he was learning SQL himself. Topics include CREATE, cursor, data type, DATE, DBD, DBI, DELETE, deadlock, export, FETCH, HAVING, import, INDEX, INSERT, isolation, GROUP BY, language, load data, lock, mSQL, MySQL, online, ORDER BY, Perl, query, RDBMS, SELECT, SQL, SQL-92, TIME, stored procedure, TIMESTAMP, transaction, UPDATE, WHERE, Windows, XML.
Added: 01/27/2006, Hits: 1,442, Rating: 0, Votes: 0
Add To Favorites  |  Add Rating
Items Per Page:







7 Seconds Resources, Inc.




IT Showcase