Jupyter is an online notebook. You can run python, markup, bash commands, generate visualizations, and much more in the notebook and display the output as well within the same page.
American Standard Code for Information Interchange (ASCII) is a character encoding system in computers and other electronic systems using text. With the introduction of unicode, the use of ASCII has been declining over the years. Today, unicode is the most widely used character encoding system.
Extended ASCII Table
|\l (lowercase L)||list all databases|
|\d+||show all tables with descriptions|
|\d+ table||show table definition or view definition with column descriptions|
Altering a table
Renaming a table
To match the end-of-line in notepad++, click on Search > Find or ctrl + F. Make sure you click on regular expressions at the bottom of the window. Then type in the following command.
The number of online programs are on the rise. These programs often require students to take exams in proctored venues. Students often get limited help from their institutions in finding a proctor so if you are doing this for the first time, it can be frustrating. Proctoring is not free. It can cost anything from $40 to $100 per exam. There is a good chance that you will be required to pay that cost.
Selecting a database:
mysql> USE database;
mysql> SHOW DATABASES;
Listing tables in a db:
mysql> SHOW TABLES;
Describing the format of a table:
mysql> DESCRIBE table;
Creating a database:
mysql> CREATE DATABASE db_name;
Creating a table:
mysql> CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE)); Ex: mysql> CREATE TABLE pet (name VARCHAR(20), sex CHAR(1), birth DATE);
HTML5 offers many new input types which were not available in previous versions. Smart phones and tablets have limited screen real estate and the interfaces need to be sensitive to touch which requires more space than a mouse pointer. These interfaces require users to switch between keyboards to input characters. HTML5 forms allow web designers to make their sites more user-friendly by offering preselected keyboard such as a date picker for date field, @ and . symbols in the keyboard for emails, and numeric keyboard for numbers.
Microsoft Windows offer many simple keyboard shortcuts. If you use computer as much as I do, you would find that these commands are easy to remember and simplify life a little bit. The symbol + in the table means that you have to press those keys together. win is the windows button just to the right of ctrl with Microsoft Windows logo. The keys are typed in CAPS to increase readability e.g. one and the letter can be confusing is lowercase but not when L is written in uppercase. The commands are NOT case sensitive.