 |
|
 |
Home »
MySQL »
General Guides
::
ReportRelated Tutorials
 |
|
|
|
MySQL / General Guides Database tables are used to store and retrieve data. Different languages and character sets need to be stored and retrieved differently. As such, MySQL needs to accommodate different character sets (different alphabets and characters) as well as different ways to sort and retrieve data. Site: www.brainbell.com
|
||
|
|
|
|
|
|
MySQL / General Guides In this tutorial, you will learn how to: Select data from a database; Filter data using Where clause; Sort data by Order; Use wildcards for smart search; Use aggregate functions; Insert data into a database; Update data in a database; Delete data from a database; Create, update and delete tables. Site: www.itechcollege.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 Use the command line mysqldump utility to dump all database contents to an external file. This utility should ideally be run before regular backups occur so the dumped file will be backed up properly. The command line mysqlhotcopy utility can be used to copy all data from a database (this one is not supported by all database engines). You can also use MySQL to dump all data to an external file using BACKUP TABLE or SELECT INTO OUTFILE. Both statements take the name of a system file to be created, and that file must not already exist or an error will be generated. Data can be restored using RESTORE TABLE. Site: www.brainbell.com
|
||
|
|
|
|
|
|
MySQL / Replication and Backup If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. 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. Site: www.codebeach.com
|
||
|
|
|
|
|
 MySQL / General Guides A collection of 16 FAQs on MySQL SELECT statements with JOIN and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EXISTS, and FROM clauses; using UNION operations. Site: dev.fyicenter.com
|
||
|
|
|
|
|
 MySQL / General Guides 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. Site: dev.fyicenter.com
|
||
|
|
|
|
|
|
MySQL / General Guides MySQL retrieval operations work with sets of rows known as result sets. The rows returned are all the rows that match a SQL statement zero or more of them. Using simple SELECT statements, there is no way to get the first row, the next row, or the previous 10 rows, for example. Nor is there an easy way to process all rows, one at a time (as opposed to all of them in a batch). Cursors are used primarily by interactive applications in which users need to scroll up and down through screens of data, browsing or making changes. Site: www.brainbell.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 / General Guides You can insert data to the tables directly from mysql> prompt or by loading a file containing the data. The values will be tab separated one line represent one record. |
||
|
|
|
|
|
|
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 / 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. |
||
|
|
|
|
|
|
MySQL / General Guides It's more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. This section describes the basic principles of entering commands, using several queries you can try out to familiarize yourself with how mysql works. Site: dev.mysql.com
|
||
|
|
|
|
|
 MySQL / General Guides This tutorial will show you how to get records in your table in database to show on your PHP files. This SQL statement has many options. Site: www.phpsimple.net
|
||
|
|
|
|
|
|
MySQL / General Guides The basis of security for your MySQL server is this: Users should have appropriate access to the data they need, no more and no less. In other words, users should not have too much access to too much data. Site: www.brainbell.com
|
||
|
|
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
|
|