 |
|
 |
Home »
MySQL »
General Guides
::
ReportRelated Tutorials
 |
|
|
 MySQL / General Guides In this lesson, you'll learn how to connect and log into SQL Server, how to issue SQL Server statements, and how to obtain information about databases and tables. |
||
|
|
|
|
|
 MySQL / General Guides Most users concentrate on MySQL's databases and tables - after all, that's where most of the action takes place - and they don't usually look deeper to understand how it handles access privileges, passwords, and security. This approach is usually more than adequate for most development activities - unless you happen to be a database administrator whose job involves setting up and securing the databases against unauthorized usage or malicious mischief. Site: www.dmxzone.com
|
||
|
|
|
|
|
 MySQL / Optimization Suppose you need to calculate constantly-changing information based on constantly-updated information in one or more tables. Are you stuck doing everything in multiple expensive queries? By no means. How careful denormalization and query construction can lower your database load and simplify your code. Site: www.onlamp.com
|
||
|
|
|
|
|
 MySQL / General Guides An introduction to using mysql, from creating databases to modifying tables to creating and deleting rows. |
||
|
|
|
|
|
|
MySQL / General Guides In this tutorial, we cover the following topics:A short introduction to relational databases and relational modeling, A quick start guide to the winestore database and its full entity-relationship model, The MySQL command interpreter and the basic features of MySQL, Using SQL to create and modify databases, tables, and indexes, Using SQL to insert, delete, and update data, The SQL SELECT statement for querying, with examples of simple and advanced queries, Functions and operators in SQL and MySQL, Advanced features, including managing indexes and keys, tuning the MySQL DBMS, security, and the limitations of MySQL. Site: www.brainbell.com
|
||
|
|
|
|
|
|
MySQL / Optimization MySQL logo Just like you need to defrag and check your file system, it's important to do the same thing with MySQL tables. If you don't, you might end up with slow and corrupted database tables. Follow this easy tutorial to set up an automatic optimization for your db. Site: www.999tutorials.com
|
||
|
|
|
|
|
 MySQL / General Guides What is SQL? SQL stands for Structured Query Language and is the lingua franca in the database world. SQL is a standard that is used by all database vendors and programmers to define, extract and access the information that is stored in databases. Site: www.chauy.com
|
||
|
|
|
|
|
|
MySQL / General Guides This tutorial, I hope you will have the basic understandings of how to, create a table to store data in, how to insert data into your tables, how to delete data from your tables and how to update data in your tables. These are three very principal tasks when using MySQL, such as, adding a new user, deleting a user, and edit an existing user (in theory). Site: tutorialcode.com
|
||
|
|
|
|
|
 MySQL / Replication and Backup MySQL includes several ways to backup your important data. In this article learn how to backup our databases using the mysqldump utility that comes with MySQL. Site: www.devarticles.com
|
||
|
|
|
|
|
 MySQL / General Guides Basic steps on how to setup a mysql database. Includes creating a tables, adding tables, and exporting a database. Site: www.phpsimple.net
|
||
|
|
|
|
|
 MySQL / Replication and Backup This article describes how you can back up MySQL databases without interrupting the MySQL service. Site: www.howtoforge.com
|
||
|
|
|
|
|
 MySQL / General Guides How to efficiently select related data from two databases simultaneously using a single MySQL query. Site: www.nucleocide.net
|
||
|
|
|
|
|
|
MySQL / General Guides MySQL supports several storage engines that act as handlers for different table types. MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables: Site: dev.mysql.com
|
||
|
|
|
|
|
 MySQL / Replication and Backup If you happen to have data stored in a MySQL database, it is good for you to learn how to backup and restore the database. Site: www.kirupa.com
|
||
|
|
|
|
|
|
MySQL / General Guides This second installment covers an introduction to databases, logging on to MySQL, defining SQL, inserting data in a table, and modifying stored data. |
||
|
|
Site Search
Categories
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPageAdvertisement
|
|