Google | Programming language | computer science | Technology Information

May 2012
M	T	W	T	F	S	S
« Apr
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31

Posts Tagged ‘google’

CREATE, ALTER, and DROP DATABASE

March 10, 2012 |

Author admin

SQL (Structured Query Language) is a language used to access the database. Almost all understand the language of SQL database software. Therefore the software and database SQL commands with one another more or less similar.

The types of commands in the SQL itself is divided into three:

DDL (Data Definition Language)
DML (Data Manipulation Language)
DCL (Data Control Language)

DDL (Data Denifition Language) is a type of SQL command associated with defining objects in a database or the database itself. There are three basic commands in this DDL statement, theCREATE, ALTER, and DROP.

DML (Data Manipulation Language) is a type of SQL command associated with the manipulation of data and records in a database. The basis of the DML commands such as SELECT, INSERT, UPDATE, DELETE, and so forth.

DCL (Data Control Language) is a type of SQL statements that relate to safety or security of a database. DCL is an example of the basic commands GRANT and REVOKE.

Of the many options database software, one of which is often the mainstay of the webmaster isMySQL. Because other than freeware, MySQL is also suitable for people who are just learning the world of the database’s like me.

MySQL command types were divided into three, namely DDL, DML, DCL. We will discuss one by one starting from the DDL. One of the DDL statement that is certain to use the CREATE, ALTER, and DROP DATABASE.

CREATE DATABASE

General form of the CREATE DATABASE:

view plain copy to clipboard print ?

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
[create_specification] … [Create_specification] …
create_specification: create_specification:
[DEFAULT] CHARACTER SET [=] charset_name [DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name | [DEFAULT] COLLATE [=] collation_name

Function CREATE DATABASE statement is to create a new database. This command functions the same as the CREATE SCHEMA statement. Run the MySQL console, type the command SHOW DATABASES to see a list of any existing database in MySQL.

view plain copy to clipboard print ?

SHOW DATABASES; SHOW DATABASES;
+——————–+ + ——————– +
| Database | | Database |
+——————–+ + ——————– +
| information_schema | | Information_schema |
| mysql | | Mysql |
| phpmyadmin | | Phpmyadmin |
| test | | Test |
+——————–+ + ——————– +

It will show all existing databases in MySQL. To create a MySQL database on the console type theCREATE DATABASE database_name;. Suppose we will create a new database with the name of the university.

view plain copy to clipboard print ?

CREATE DATABASE universitas; CREATE DATABASE university;

Use the SHOW DATABASES command to see which database we just created.

view plain copy to clipboard print ?

SHOW DATABASES; SHOW DATABASES;
+——————–+ + ——————– +
| Database | | Database |
+——————–+ + ——————– +
| information_schema | | Information_schema |
| mysql | | Mysql |
| phpmyadmin | | Phpmyadmin |
| test | | Test |
| universitas | | University |
+——————–+ + ——————– +

ALTER DATABASE

Common forms of ALTER DATABASE:

view plain copy to clipboard print ?

ALTER {DATABASE | SCHEMA} [db_name] ALTER {DATABASE | SCHEMA} [db_name]
alter_specification … alter_specification …
alter_specification: alter_specification:
[DEFAULT] CHARACTER SET [=] charset_name [DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name | [DEFAULT] COLLATE [=] collation_name

ALTER DATABASE statement function is to change the characteristic of a database is usually stored in the file db.opt. This command is rarely used. ALTER DATABASE has the same function with the ALTER SCHEMA.

DROP DATABASE

General forms of the DROP DATABASE:

view plain copy to clipboard print ?

DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP {DATABASE | SCHEMA} [IF EXISTS] db_name

DROP DATABASE statement function is to remove the database. One thing to note is, MySQL is not going to confirm the removal of the database if you use this statement. Therefore you must be careful to use this statement because all the records, tables and objects that exist in your database will also be lost with the database to delete. Suppose we will remove the university database that we created earlier.

view plain copy to clipboard print ?

DROP DATABASE universitas; DROP DATABASE university;

Use the SHOW DATABASES command to see a list of databases.

view plain copy to clipboard print ?

SHOW DATABASES; SHOW DATABASES;
+——————–+ + ——————– +
| Database | | Database |
+——————–+ + ——————– +
| information_schema | | Information_schema |
| mysql | | Mysql |
| phpmyadmin | | Phpmyadmin |
| test | | Test |
+——————–+ + ——————– +

OK ..! So first tutorial this time.

Database_name CREATE SCHEMA has the same function with the CREATE DATABASE database_name. Try it! REFERENCES

Posted in ddl script |

Comments Closed

Internet Advertising Methods

April 24, 2011 |

Author admin

People are opting for online marketing techniques that basically 50% of people are familiar with HTML. If you have your own business, you must decide which online marketing technique that works for you. Ask yourself what you will get those expensive marketing techniques online or cheap? Other tubes in “expensive!” immediately, but do not know how inexpensive online marketing technique calls for the striking features as well.This aspect of information and methods of marketing onlinecheap and expensive:The cost:

1. Pop-up. Not only is it uncomfortable expensive, but overall that readers close pop-up house without disturbing even know what they are all about. This is an online marketing technique that you can do without.

Fly ads are types of pop-ups that are upset readers.

2. 1. Pop-up. Not only is it uncomfortable expensive, but overall that readers close pop-up house without disturbing even know what they are all about. This is an online marketing technique that you can do without.

Fly ads are types of pop-ups that are upset readers.

2. Pod molds.

Broadcast is to TV as pod cast on the web. This is a superior technique of online marketing that can in no way restrict your finances. But if you plan to success, podcasting worth it.

3. Paying the search engines.

How does it work? When someone types a keyword relevant to your website, the URL is immediately integrated into the front page of the higher success. Transaction solved for optimizing search engine allows just that. Very expensive, yes, but if we have to do with Google and other search engines Google here, so do not give a second thought.

This is associated with another method of marketing pay-per-click System online.

The economy:

1. Blog.

Take the group and the website of your site. This is an online marketing technique that is common when starting, so you need not fear that this will never lead region. All you have to do is to consider the suggestions for a blog, article, and voila! You do not even need to pay!

2. Public search engines not-so-great.

This is inexpensive and reliable. If you publish your site on a search engine on a small scale, you are more likely to become more efficient. Keep in mind that search engine optimization for small and executives can easily remember your website, so this online marketing technique could be just right for you.

3. Back.

It is not just economic, it is almost free! Let the contents of the text to someone weblink your website and so on back.

Posted in Internet Advertising, internet marketing |

Tags: advertising methods, bl, broadcast, google, internet advertising, marketing techniques, molds, other search engines, own business, pay per click, pod cast, pop ups, second thought, striking features, tubes, ups |

Comments Closed

Internet Marketing Strategies

March 24, 2011 |

Author admin

Your company will benefit from new models of online advertising. But there is no need to spend money just to have some reasonable visibility for the company. There are many ways to grow your business be seen and felt without doing too much with advertising costs.

Leverage your power line – through advertising and web advertising. Here are some simple methods you can use to improve the reputation of your business without taking more than what you can afford. However, these methods require some work and endurance to produce flexible outcomes.

First, you need a web page before they can develop the use of such advertisers on the web at low prices and advertising techniques. So go create one or use a web designer.You will see your items. Will be used in the use of the following models of online advertising.

1. Affiliate Marketing

And ‘the process of selecting a system known as small sites associated with visitors to a web page. Content of the advertisements and links are provided by the companies. You will have to pay a certain amount of profit your sales associates.

2. Connections

One of your goals should be to obtain an excellent location with Google. One way to do this is through links. This could be done through trading links to other companies that are relevant to yours.

3. Newsletter

Sending notifications to your members (those who have authorized for your newsletters) will contribute significantly to the development of a good working relationship with your customers or potential customers. It should be short, fine, regular, written for a general audience.

4. E-mail marketing

As one of the advertisers on the web tools cheaper advertising, continues to be very important to keep customers aware of your articles. Just make sure to avoid spam or early, you should close the activity because of conditions.

5. Articles

If you put quality content in the form of content on the web page with your articles, Google will list your web page. Web page layout that you are getting popular by Google means more visitors for you.

6. Forum

Expand the system via the Internet is to become a member of boards that primarily affects about products or appropriate for your articles. Certainly the trends or solutions presented and request appropriate information will build your status as a member of this forum and to raise awareness of the business through your information. This information is only those that go with your post. Link to your web page may be included in this.

Posted in internet marketing |

Tags: advertising costs, advertising techniques, affiliate marketing, e mail marketing, endurance, google, internet marketing strategies, leverage, notifications, quality content, web advertising, web designer, web pa, web page content, web tools |

Comments Closed

Aggressive Internet Marketing Made Possible

February 24, 2011 |

Author admin

Intense and web advertising misleading advertising and advertising and promotions that real exceed the expectations of every businessman. A business needs fierce advertising and advertising on the Web. Nothing more, nothing less. But to do it cheap? Is it even possible? How can something so competitive, it is convenient?

Fortunately, you can take advantage of Internet advertising and business advertising competitive if you just take a critical look pretty good. Be passionate and caring and know what is happening in the online industry. The following questions will help you determine if your site is selected for promotion and advertising is the invoice.

1. Companies that offer free website design?

Even if you know HTML, it is even more desirable if a professional team for you. Some websites offer advertising and advertising free-style website to ensure that your needs are satisfied with the site. This is a must as advertising and advertising is integrated with the Web style. If the company requires you to pay more than fifty dollars for the Web style, both for the web marketing straight-forward! Look elsewhere!

2. How many keyword phrases your site’s content?

Having too many words or phrases to focus on will make your page ranking drop.Creating smaller web pages with content that only highlights a few key phrases will be used in online advertising, and advertising works best.

3. As search engine is compatible with your website?

Internet advertising and advertising is coined “aggressive” only if it is a search engine to one hundred percent compatible. There are about 10 major online and Google your website is to work with them. Find out if your website advertising and publicity is an expert in SEO.

4. You know your competitors?

Advertising on the Web accessible and competitive advertising propels your company to act on its rivals. Research and evaluation of the rivalry is mandatory to understand your shortcomings and advantages over them. If this feature is excluded from your online advertising and advertising strategy, you get a good deal mediocre.

5. How effective in terms of advertising and advertising monthly?

Usually, you will be asked to pay a monthly fee for advertising and advertising strategy.For advertising and advertising strategy to be effective, it must zero the following: web development, link exchanges, web content, updates and technical support team. Of course, it also includes the standard SEO, competition analysis and keyword density.

Posted in internet marketing |

Tags: advan, advertising on the web, aggressive internet, business advertising, competitive advertising, fifty dollars, free style, google, keyword phrases, misleading advertising, professional team, research and evaluation, web style, website advertising, website internet |

Comments Closed

Programming language | computer science | Technology Information | DDL SCRIPT

Posts Tagged ‘google’

CREATE, ALTER, and DROP DATABASE

CREATE DATABASE

ALTER DATABASE

DROP DATABASE

Internet Advertising Methods

Internet Marketing Strategies

Aggressive Internet Marketing Made Possible