Collections - Shopping Go to another website with more information - SuperMemo Go to another website with more information - FAQ - Feedback - Contact us 
Introduction to MySQL
Home > Sciences > Computer Science > Introduction to MySQL
Recent additions
Report a bug The Contributors` Pantheon | Site map Site index
 
 Search
 
Match:
Format:
Sort by:
 
 About
 
Author(s): Piotr Maksimczyk
Other collections by the author:
 
No. of items: 82
Rating: 5.0 (out of 5)
Last updated: Jul 31, 2001
 
 
Privacy policy Go to another website with more information
 

Due to SuperMemo Library being moved to a new server, you can currently order this collection only as a subset of one of the mixes from Super Memory Store that are listed in the Order as part of... section you can find in the left pane of this page (if available). We sincerely apologize for any inconvenience this may cause.
Our entire assortment is being republished incrementally in order of priority as determined by the quality and popularity of individual collections. If you would like to increase the priority of this collection, contact us by writing to: publish (at) super-memory (dot) com with in the subject.

 Description
 
A compact collection that will help you to master how to add, access, and process data stored in a database managed by MySQL (very fast, reliable, and easy to use database management system).
To quickly find items of your interest, the collection is divided into thematic categories such as Strings, Variables, Syntax and more.
Additionally to help you recognize and diversify among variables, escape characters, SQL queries, data, and names of databases, tables and columns, all these types ot texts are marked in various colors.
 
 Sample
 
Q: mysql: In MySQL, the NULL value is always false in comparison to any other value, even [...].
A: NULL

Q: mysql: What command should be used to provide server status information?
A: mysql> SHOW STATUS;

Q: mysql: What will be shown if we use a command:

Q: mysql> SELECT "hello\tmy\tworld\nbye\tmy\tworld";
A: hello   my    world
A: bye     my    world

Q: mysql: What command should be used to create a table named tbl_name in the current database with three columns: first containing character field with fixed length of 15 characters, second containing date and third containing real number value (we assume that tbl_name table does not exist)?
A: mysql> CREATE TABLE tbl_name (first CHAR(15), second DATE, third REAL);

Q: mysql: Say that we have a table named tbl_name with two columns: first containing date and second containing real number value. What command should be used to insert into first the 2000-05-03 date and into second the -1.23 real number?
A: mysql> INSERT INTO tbl_name(first, second) VALUES ('2000-05-03', -1.23);

 
 
  Compatibility
 
To use this material you need the SuperMemo software Go to another website with more information. In the table below can you find what versions of SuperMemo the Introduction to MySQL collection is compatible with

SM6 Go to another website with more information SM7 Go to another website with more information SM8 Go to another website with more information SM98 Go to another website with more information SM99 Go to another website with more information SM2000 Go to another website with more information SM2002 Go to another website with more information Palm SM Go to another website with more information SMCE Go to another website with more information
green check green check green check green check green check green check green check green check green check

 
 Download
 
Download a free sample of all commercial collections available from SuperMemo Library:

Library Digest, (SM2000 format)

 
  Installation HelpDesk
 
The step-by-step procedure with instructions on how to install collections available from SuperMemo Library in:
SuperMemo 6 for DOS
SuperMemo 7 for Windows
SuperMemo 8 for Windows
SuperMemo 98 for Windows
SuperMemo 99 for Windows
SuperMemo 2000 for Windows
SuperMemo for Palm Pilot
SuperMemo for Windows CE
 
 What is SuperMemo?
 
  • SuperMemo makes it possible to learn fast and retain memories for years
  • SuperMemo is based on a breakthrough in scientific research on memory and learning
  • SuperMemo is available as a computer program for Windows
For more information...
 
Send e-mail to a friend
 
Do you have any comments, remarks or suggestions? Contact us
   Back to Top