MySQL

MySQL 3.6 Reference Manual
http://dev.mysql.com/doc/refman/5.6/en/index.html

used in batch mode: you place your queries in a file beforehand, then tell mysql to execute the contents of the file.

>SELECT USER();
root@localhost

> SHOW DATABASES;
http://dev.mysql.com/doc/refman/5.6/en/database-use.htm

> USE world;

> SHOW TABLES;

> DESCRIBE table_in_world;

> SELECT COUNT(*) FROM table_name;

> SELECT DATABASE();

==============================

http://dev.mysql.com/doc/refman/5.6/en/creating-database.html

==============================

String Types (BLOB or TEXT)
http://www.tutorialspoint.com/mysql/mysql-data-types.htm

https://wiki.python.org/moin/TkInter

https://wiki.python.org/moin/GuiProgramming
Python has a huge number of GUI frameworks (or toolkits) available for it, from TkInter (traditionally bundled with Python, using Tk

25.1. tkinter — Python interface to Tcl/Tk
https://docs.python.org/3.3/library/tkinter.html

SyntaxError: multiple statements found while compiling a single statement

When you see multiple statements are being declared, that means you’re seeing a script, which will be executed later. But in the interactive interpreter, you can’t do more than one statement at a time.
http://stackoverflow.com/questions/21226808/syntaxerror-multiple-statements-found-while-compiling-a-single-statement

finding tables with no PRIMARY KEY
https://www.simple-talk.com/sql/t-sql-programming/exploring-your-database-schema-with-sql

How to add a column
http://www.tech-recipes.com/rx/378/add-a-column-to-an-existing-mysql-table

===================

mysql> create table dictionary
(word_ID int(6) NOT NULL AUTO_INCREMENT,
word text NOT NULL,
category text NOT NULL,
concept int(1),
authority text,
notes text,
PRIMARY KEY (word_ID));

———————————————-

http://dev.mysql.com/doc/refman/5.1/en/alter-table-examples.html

CREATE TABLE t2 LIKE dictionary;

ALTER TABLE t2 MODIFY category text NOT NULL;

INSERT INTO t2 SELECT * FROM dictionary;

DROP TABLE dictionary;

ALTER TABLE t2 RENAME dictionary;

====================================

create table first3000
-> (id int(5) not null auto_increment,
-> word text not null,
-> category text not null,
-> for_db text,
-> concept int(1),
-> primary key (id));

=======================

http://www.w3resource.com/sql/aggregate-functions/sum-function.php

Limits on Table Size
http://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html

Keywords and reserved words
https://dev.mysql.com/doc/refman/5.6/en/keywords.html
references

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s