When you share a link on Facebook, the service will automatically set the title, and the description for you. If you do not like it, or you want to set this information yourself, this tutorial will help you.
Once your system is updated to OS X Lion, applications will attempt to automatically open from your last session. When you start an application, suddenly the last file you were using is staring you in the face. While many users will find this convenient, other users find this particularly annoying. Here is how to disable this new feature from Lion.
By default, OS X Lion has all new Finder windows open to All My Files. If you don’t utilize this as much as you do other directories such as Documents, your Home directory or a custom folder, you can change the default and make Finder’s new window be more useful to your needs.
Wolfram Alpha is an answer engine that is great for accessing all kinds of information including statistics and data analysis, socioeconomic data, mathematics, science, etc. Did you know that you can also use Wolfram Alpha to generate QR Codes and Bar Codes for your own personal use?
A primary key uniquely identify a row in a table. One or more columns may be identified as the primary key. The values in a single column used as the primary key must be unique (like a person’s social security number). When more than one column is used, the combination of column values must be unique.
MySQL tables are easy to extend with additional columns.
The best laid plans of mice and DBAs oft go awry, so it is sometimes necessary to change the characteristics of a column after it exists and contains data. Beware whenever you make changes to your database — always make a backup first.
The SQL command in this recipe removes a column and the column’s data from an existing MySQL table.
A very cool and powerful capability in MySQL and other databases is the ability to incorporate regular expression syntax when selecting data. The regular expresion support in MySQL is extensive. This recipe reviews regular expression use in MySQL and lists the supported regular expression metacharacters.
To get the PubDate element of an RSS feed to validate, it needs to be in RFC-822 format. MySQL has flexible ways of working with dates and times which make this a simple task.
MySQL provides an easy mechanism for writing the results of a select statement into a text file on the server. Using extended options of the INTO OUTFILE nomenclature, it is possible to create a comma separated value (CSV) which can be imported into a spreadsheet application such as OpenOffice or Excel or any other applciation which accepts data in CSV format.
Sometimes every occurance of a value which may be duplicated multiple times in a result set is not needed. For example, if making a pulldown menu list of options, each option should be seen only once. The DISTINCT keyword in a select statement eliminates duplication in the result set.
1...368369370...528Page 369 of 528
error: Content is protected !!
