Problem: Article: There are a few main aspects of your table that you'll want to know before creating one: Title Your title will go directly after the "create table" command, and must follow the same rules as your database's name (e.g., no spaces). Column Heading You can determine column headings by typing different names into a set of parentheses (see the next step's example). Cell Length When determining cell length, you'll use either "VARCHAR" (variable characters, meaning that you can type in between one and the VARCHAR's limit number of characters) or "CHAR" (requires no more and no less than the specified number of characters; for example, CHAR(1) requires one character, CHAR(3) requires three characters, and so on). Date If you want to add a date to your chart, you'll use the "DATE" command to indicate that the column's contents will be formatted as a date. The date should be entered in YYYY-MM-DD format. Before you can input data for your chart, you'll need to create the chart's structure by typing in the following and then pressing Enter: create table name (column1 varchar(20), column2 varchar(30), column3 char(1), column4 date); For example, to create a table called "Pets" with two VARCHAR columns, a CHAR column, and a date column, you might write the following: create table Pets (Name varchar(20), Breed varchar(30), Sex char(1), DOB date); Using the "insert" command, you can enter your database's information line-by-line: insert into name values ('column1 value', 'column2 value', 'column3 value', 'column4 value'); For the "Pets" table example used previously, your line might look like this: insert into Pets values ('Fido', 'Husky', 'M', '2017-04-12'); You can enter the word NULL for a column's contents if the column is blank. If your database is relatively small, you can insert the rest of the data line-by-line by using the "insert" code. If you elect to do this, skip the next step. If you have a database which requires more lines of information than are practical to insert by hand, you can reference a text file that contains the data by using the following code: load data local infile '/path/name.txt' into table name lines terminated by '
'; For the "Pets" example, you would write something like the following: load data local infile 'C:/Users/name/Desktop/pets.txt' into table Pets lines terminated by '
'; On a Mac computer, you'll need to use the "lines terminated by" command with '
' instead of '
'. Enter the show databases; command, then select your database by typing in select * from name; where "name" is the database's name. For example, if using the "Pet Records" database, you'd enter the following: show databases; select * from Pet_Records;
Summary: Understand the different table commands. Create the table outline. Add a line to your table. Insert the rest of your data if possible. Upload a text file if needed. View your table.

Problem: Article: LinkedIn displays how often your profile appears in search, and what people are looking for when they find you. By adding more details about what you are doing, you can directly see how many more people are finding you online. The more contacts you add, the more people will see your updates. They tend not to be commented on like a Facebook post, but they are widely read. Use the same caveats as in any social media posting. The most important posts you can make to spread your personal brand are to LinkedIn groups that consist of professionals like yourself. They are most likely to be interested in what you post, and take action (should you want them to). " Influencers can have followers and their posts can be featured on LinkedIn Today. Influencers also can write mini blog posts that include images, which also boosts your readership. . There are ways to show LinkedIn that you are an influencer. You can tie your personal blog to LinkedIn so LinkedIn knows your readership carries over to LinkedIn. If you want to try to become an Influence, you can email to influencers@linkedin.com. Another good method is to hit someone who works at LinkedIn with a LinkedIn message.
Summary: Appear on Google and other searches. Don't add people you don't know, but continue to build out your contacts. Post updates to your LinkedIn contacts periodically. Contribute to the right LinkedIn groups. Know that the most visibility you can get is if LinkedIn designates you as an "Influencer. LinkedIn's criteria for becoming an influence has been changing, and is currently officially closed.

Problem: Article: This is a freeware tool designed to help speed up typing, and can be used to create keyboard phrase replacement shortcuts. You can download Auspex for free from here. You will need to extract the file by right-clicking on it and selecting "Extract Here". It will immediately be minimized to your System Tray. This will open the Auspex window. This will start the shortcut creation process. It's crucial that you don't type a phrase that you use for other things, as the shortcut will get replaced any time it is used. A common trick is to use HTML-style tags as the phrase. For example, if you are creating a shortcut for (), you could type &rage; into the "Replace" field. The & and ; ensure that you won't replace a real word by accident. Click the "OK" button when finished. Space, Tab , or Enter to make the emoticon appear. These are the default trigger keys. You can change them using the "Triggered by" menu in Auspex when the shortcut is selected.
Summary:
Download Auspex. Run Auspex. Right-click on the Auspex icon and select "Show". Click "File" "New from Wizard". In the "Step Two" field, enter the phrase that you want to act as the shortcut. In the large field at the bottom of the window, type or paste the emoticon. Type your shortcut and press .