MYSQL Trigger

Mungkin saya adalah salah satu orang yang ketinggalan info soal MYSQL, terlebih lagi soal MYSQL TRIGGER…apa itu??

Memang sudah 3 tahun ini saya tidak bermain-main dengan fungsi MYSQL yang advance, biasanya pake query-query standar saja, jadi maklum jika MYSQL TRIGGER sampe sekarang belum ngerti :D

MYSQL TRIGGER, mungkin kalo di ORACLE disebut STORE PROCEDURE.
Perintah TRIGGER adalah suatu PROCEDURE di MYSQL yang berfungsi secara otomatis menjalankan query tertentu. Trigger akan berjalan ketika “pemicu” nya dipanggil.

Sebagai contoh, Server akan mengupdate secara otomatis pada tabel B jika  “row” di tabel A di hapus..

di sesi berikutnya akan saya sajikan bagaimana contoh Mysql Triggernya…

 

Viral Marketing 101 – tidak menggunakan ini bisa membunuh bisnis Anda!

Kreativitas.

Ini adalah salah satu kebajikan sebuah situs harus memiliki untuk memimpin perlombaan dalam persaingan kejam dalam pasar bisnis berbasis internet. Dengan banyak kompetisi dan persaingan terjadi, setiap metode pemasaran harus digunakan dan dimanfaatkan.

Tidak masalah jika Anda memiliki produk pembunuh atau website yang dirancang besar, jika orang tidak tahu kau ada, tidak masalah, dan tidak berencana untuk melakukan sesuatu yang besar. Terburuk dari semua, bisnis Anda hanya dapat membunuh.

Meskipun ada banyak metode dan sistem yang digunakan oleh banyak situs e-commerce hari ini, ada beberapa yang dapat membantu Anda dengan dorongan ekstra di peringkat popularitas. Satu disebut viral marketing.

Sementara istilah Viral mudah virus, kata yang sangat banyak ditakuti oleh semua pemilik komputer, bukan apa tampaknya. Tidak benar-benar menggunakan komputer untuk bisnis mereka untuk menyebar, bagaimanapun, dapat membunuh Anda. Setiap orang lelah dengan semua pop-up iklan dan spyware.

Umum Informasi tentang Viral Marketing

Viral Marketing juga dikenal iklan jika virus adalah teknik pemasaran yang digunakan untuk meningkatkan kesadaran masyarakat dari produk atau perusahaan untuk membangun. Mereka menggunakan berbagai bentuk media untuk menjangkau publik tanpa benar-benar mempromosikan produk untuk masuk ke bentuk lain berarti adiktif yang bisa membuat seseorang ketagihan dan dipaksa atau sangat bagus untuk menangani produk atau periklanan bersama dengan perusahaannya.

Singkatnya, perusahaan perjalanan pada gagasan bahwa jika orang-orang seperti isi media mereka akan menyebarkannya ke teman-teman dan keluarga. Sponsor media tertentu, seperti flash game keren, video lucu, cerita lucu dan semacamnya, Anda dapat melanjutkan dengan logo perusahaan atau merek atau deskripsi produk atau konten lainnya untuk membantu mempromosikan perusahaan atau produk.

Viral marketing telah menjadi alat populer iklan dan pemasaran, biaya yang relatif rendah. Untuk mencegah ditandai sebagai spam mail, viral marketing menghitung pada keinginan dari satu orang untuk lulus pada produk. Jika seseorang melihat nama orang yang mereka kenal sebagai pengirim, tidak menghalangi dan terbuka.

Banyak perusahaan menawarkan insentif seperti diskon dan rabat ketika mereka membantu dalam menyebarkan viral marketing mereka. Mereka didasarkan pada jumlah penerima pemasaran viral adalah orang dalam menentukan jumlah atau jumlah rangsangan yang dapat dikaitkan.

Menggunakan viral marketing untuk keuntungan Anda

Keuntungan utama dan terpenting pemasaran viral adalah bahwa Anda memiliki banyak publisitas dan kesadaran publik tentang situs Anda dan mendapatkan bisnis Anda. Anda bisa arus lalu lintas yang pelanggan potensial untuk menghasilkan. Dengan sedikit kecerdikan dan imajinasi, ditambah beberapa insentif atau hadiah, Anda dapat mencapai sejumlah besar orang dan mengumumkan keberadaan Anda.

Kebanyakan setiap situs dan perusahaan yang menyadari efektivitas Viral Marketing dan Periklanan. Jangan menggunakannya akan membunuh bisnis Anda. Bersama dengan sistem lain dan metode dalam mempromosikan situs Anda sebagai optimasi mesin pencari dan pemasaran seperti virus dapat dengan mudah bergerak dalam permainan rating.

Viral marketing bisa menjadi cara licik untuk membiarkan orang tahu tentang Anda dan perusahaan Anda. Anda bisa menyampaikan iklan Anda. Mereka juga biaya yang sangat rendah, yang tidak bisa berinvestasi dalam bisnis bunuh diri. Segala yang Anda butuhkan adalah ide bagus, permainan adiktif yang baik, sebuah cerita lucu masih banyak ide di luar sana. Buat gosip atau buzz, banyak film yang dipromosikan dengan menggunakan skandal dan gosip untuk membuat moiré populer. Ingat film “The Blair Witch Project”?

Banyak perusahaan besar telah mencoba viral marketing dan memiliki banyak keberhasilan dengan itu. Sebuah contoh klasik adalah Microsoft Hotmail. Mereka adalah perusahaan besar pertama yang dikenal menggunakan sistem dan telah melakukan keajaiban bagi mereka.

Sekarang giliran Anda untuk menggunakan pemasaran viral bekerja keajaiban bagi Anda. Bertindak sekarang dan menuai keuntungan Viral Marketing akan memberikan Anda dan penjualan Anda.

5 Hal Penting Dalam Web Design

5 Aturan Penting dalam Website Design

Ketika datang ke website Anda, perhatian ekstra untuk setiap detail kecil untuk memastikan bahwa melakukan optimal untuk melayani tujuannya. Berikut adalah tujuh aturan penting praktis untuk mengamati untuk memastikan bahwa website Anda berkinerja baik.

1) Jangan menggunakan halaman splash

Splash halaman adalah halaman pertama yang Anda lihat ketika Anda tiba pada sebuah situs web. Mereka biasanya memiliki gambar yang sangat indah dengan kata-kata seperti “selamat datang” atau “klik di sini untuk masuk.” Pada kenyataannya, mereka hanya bahwa – vas cantik tanpa tujuan yang nyata. Biarkan pengunjung Anda alasan untuk klik pada tombol “back”! Beri mereka nilai situs Anda di depan tanpa halaman pembuka.

2) Jangan menggunakan iklan banner berlebihan

Bahkan orang-orang cerdas paling bersih telah melatih diri untuk mengabaikan banner iklan sehingga Anda akan membuang real situs berharga. Sebaliknya, menyediakan lebih banyak konten berharga dan link afiliasi menenun relevan ke konten Anda, dan biarkan pengunjung anda merasa bahwa mereka inginkan, bukan membeli didorong untuk membeli.

3) Memiliki navigasi sederhana dan jelas

Anda membutuhkan menu navigasi yang sederhana dan sangat mudah untuk menawarkan, sehingga bahkan seorang anak muda akan tahu bagaimana menggunakannya. Tinggal jauh dari menu berbasis Flash yang rumit atau multi-tier menu dropdown. Jika pengunjung Anda tidak tahu bagaimana bernavigasi, mereka akan meninggalkan situs Anda.

4) Memiliki indikasi yang jelas di mana pengguna

Ketika pengunjung sangat asyik browsing situs Anda, Anda akan ingin memastikan mereka tahu bagian mana dari situs mereka saat ini. Dengan begitu mereka akan dapat dengan mudah menemukan informasi yang relevan atau menavigasi ke bagian situs. Jangan membingungkan pengunjung Anda karena kebingungan berarti “meninggalkan kapal”!

5) Hindari menggunakan audio di situs Anda

Jika pengunjung Anda pergi tinggal lama di situs Anda, membaca konten Anda, Anda akan ingin memastikan mereka tidak terganggu oleh beberapa perulangan audio pada dan di website Anda. Jika Anda bersikeras menambahkan audio, pastikan mereka memiliki kontrol atas itu – volume atau mute kontrol akan bekerja dengan baik.

The best thing about blogs, they just keep going

The best thing about blogs, they just keep going

Now that you’ve added your blog, we need to make sure that you own this blog.

Create a new post on your blog. Copy and paste the randomly generated sentence shown above exactly as it is given anywhere in your new post. Publish the new post so that it is viewable at your blog’s URL.

Once this sentence is on your blog, come back to your PPP account and press the claim blog button. You can remove the post after you have successfully claimed the blog.

How to Escape From Copyscape

Instructors who search for plagiarism and cheating may feel like crime scene investigators searching for justice. Apparently, this search has gone on for centuries as …

Creators of original works have legal copyright protection which gives them the exclusive right to use and publish their original material. Copyright infringement has …

If you are an educator, the sad fact is that you have likely encountered student plagiarism. Whether it is due to ignorance or deliberate theft, the digital age has …

Click the banner that you want to use. This brings you to a new page titled “Defend Your Site with a Banner.” A large text field below displays the HTML code needed to display the banner.

If you subscribe to Copyscape’s Copysentry service to protect your Blogspot blog from plagiarism, adding a Copyscape banner to your blog helps you notify your readers that you are monitoring the Web for duplicate content and will protect your intellectual property if necessary. Copyscape has a large selection of banners for you to choose from, ensuring that you can select one that fits well with the design of your blog.

Log into your Blogspot.com account in a new browser window or tab, and select the “Design” link on the main menu next to your blog’s title.

It’s possible for even the best writers to accidentally plagiarize. This is because once we read specific wording, we are more likely to recall our thoughts in that …

This article was created by a professional writer and edited by experienced copy editors, both qualified members of the Demand Media Studios community. All articles go through an editorial process that includes subject matter guidelines, plagiarism review, fact-checking, and other steps in an effort to provide reliable information.

Learn about plagiarism checkers. All writers should use some sort of plagiarism checker before submitting articles so they don’t run the risk of being deleted from writing sites that also check your work. These article checkers are also a good way to make sure your articles are not being stolen from you and placed on other websites too. Some article checking sites are free and others charge a fee.

When accessing an account in a system or website, a user can authenticate himself by entering his user name and password. Automatic or automated user authentication …

Writing a good research paper is a tough challenge, but breaking it down into smaller pieces helps a lot.

If you have ever yelled a retort to a broadcast journalist’s report or tossed a newspaper article aside in disgust, you have rendered a reaction to the media. And …

Few university students, past or present, can say that they have not witnessed some form of academic dishonesty. Plagiarism, or presenting someone else’s ideas or …

Plagiarism is a real threat to academia. Students resort to plagiarizing text for many reasons, not the least of which is easy access to different papers on the …

With so much available on the Internet, it is easy for students to use other people’s content in their own research paper or other work without paraphrasing it or …

{!= ads[i].line2 !} {!= ads[i].line3 !}

With the advent of the Internet, intellectual property became harder to manage. More and more, sites such as Wikipedia were scrambling to weed out plagiarism, which …

Plagiarism is a serious offense that can result in academic probation or even expulsion. Occasionally, even a good student can plagiarize if she forgets to reference …

Find a plagiarized paper using Plagiarismchecker website. Paste the text to be checked into the text field given on the Web page. Click “Search” to find duplicated entries in the text.

How to Become a Better Web Content Writer

Web content requires a style of writing like none other. Writing content for the Web is all about the keywords and using the proper keyword density.

Writing is a major way of communicating thoughts, feelings and information. As a blogger or freelance writer, it works to your benefit to perfect your craft. There …

Even if you have a naturally beautiful singing voice, there are always things you can do to help you sing better. Whether you are a soloist, or you sing with a choir …

This article was created by a professional writer and edited by experienced copy editors, both qualified members of the Demand Media Studios community. All articles go through an editorial process that includes subject matter guidelines, plagiarism review, fact-checking, and other steps in an effort to provide reliable information.

Your resume is a marketing tool to showcase your writing experience. Many companies will ask to see your writing samples and a resume in response to an advertisement …

First, do a little research to determine if freelance web content writing is a good fit for you. The forums at wahm.com and warriorforum.com are full of information from people who write and/or use affiliate marketing to earn a living.

Lucy Friend is a professional writer specializing in career and workplace articles. She has worked as a recruiting/retention consultant and also owned a cleaning business for eight years. Friend studied computer science at Ursinus College.

Technical writers write the highly technical white papers, engineering and medical reports needed by professionals in other fields. The technical writer has to have a …

A Web Marketing Specialists salary will vary depending upon his experience, employment status and location. A Web or Internet Marketing Specialist gets sales and …

List your skills. This could include experience with certain word processing software, content management systems, and blogging platforms. If you have knowledge of HTML or search engine optimizations, these can prove to be great assets. Let potential employers know about them.

If you are currently applying for writing jobs online, you will need a resume. Content companies are now requiring writers to submit resumes to separate the skilled …

Becoming a web content writer is a great way to work from home on your own schedule. In order to break into the field, you’ll need a resume. It may seem impossible to come up with anything to put on a web content writing resume when you’ve never done it for anyone else, but it can be done.

Bloggers, copy writers and search engine optimization marketers all rely on one skill to produce content for the Internet — speed. The slowest of the bunch loses credibility among targeted readers, who in turn are referred to another blogger, copy writer or SEO marketer for their Internet content. It’s tough as nails on the World Wide Web as a content writer, and speed is both your best friend and worst enemy.

Exercises to Improve Writing Speed. Writing anything more complex than a grocery list often requires painstaking thought. If a lot of thinking is required, the …

Good writing technique is important for developing a novel that will sell. The best novels have almost seamless writing, allowing the reader to become completely …

Close with an invitation for the recipient to contact you. Provide your contact information and indicate that you are looking forward to hearing from the person. End with “Sincerely, .”

Tips on Writing an Effective Cover Letter. No matter how qualified you are for a job, an employer probably couldn’t get past a negative impression if you showed up …

How to Write SEO Articles for the Web

{!= ads[i].line2 !} {!= ads[i].line3 !}

Re-edit your work. Make sure you look over your work as much as possible. If you are working for someone, you do not want to appear to be sloppy in your spelling and grammar.

Article spinning, the art of distributing many copies of a single article to dozens of websites, can be a great way to attract visitors to your website. But search …

{!= ads[i].line2 !} {!= ads[i].line3 !}

Determine your primary keyword and secondary keywords. Use approximately two to five percent of your ideal keywords throughout the article to increase your page rank. Use the keywords naturally, and use them only once for every 100 words you write.

Search engine optimization (SEO) leads to more traffic to your website. The more SEO content that you have on your site, the higher that your ranking will be on …

Seek clients through online and offline methods, using the strategies you detailed in your business plan. Make sure you highlight the benefits of using SEO and walk clients through your pricing and plans.

Create a well-designed website. Most SEO companies will require you to list one on the application. You can outsource this or create one yourself using free tools such as WordPress. Your site needs to be tailored to promoting businesses using Internet methods. It will also be useful for pulling in potential clients after you’re approved as a reseller.

Becoming a freelance writer is challenging, no matter what type of writing you decide to do. However, for newcomers, getting into SEO writing can be a great …

SEO (search engine optimization) is a method used by website owners and builders to ensure that a website gets the highest rank possible in search engine databases …

Holding a marketing degree or having experience in the marketing field allows you the opportunity to work in a variety of different jobs. If you are drawn to the …

Learning how search engine robots work is key in optimizing your page. Read the resources below to learn more about individual spiders.

Since the commercialization of the Internet, page one (1) listing has been the prize! If your website is not SEO (search engine optimization) friendly, you can be …

Creating a website for your business is only the first step in making an online presence. To be successful, you need to make sure that people can find your website …

Select the right keywords. Keywords should be specific and not general phrases. For example, if you are selling handbags, Italian leather handbags would be a better keyword phrase to use than simply handbags.

Headlines or headings are read by search engines and used to determine what your page is about. Here’s how to write a good heading or headline.

You or your company can have the best-looking website in the world, but if no one sees it, your efforts are totally for naught. Most often, people with an interest in …

Understand “black hat” SEO. This is the dark side of SEO. It involves deceptive measures to trick both customers and search engine robots. Methods like “cloaking” and …

IWeb is Apple’s entry into the website publishing market. An element of the iLife software package, it is designed for ease of use, and allows users to create a …

Search engine optimization (SEO) leads to more traffic to your website. The more SEO content that you have on your site, the higher that your ranking will be on …

Search Engine Optimization (SEO) is the process of creating Web content that ranks as high as possible for a particular keyword or set of keywords. Since most …

Legit Ways to Make Money Online With Free Startup

Making money online can be a difficult process if you don’t know where to look. Chances are, you won’t get rich with any of these tactics, but you can end up making a …

The common saying “It takes money to make money” doesn’t always apply. There are several ways to start a business with little to no start-up costs. Online e-commerce …

Fun Free Ways to Make Money Online. Thanks to computers and the Internet, it is now possible to make money online from your home without spending a dime of your own money.

Place a donate button on your blog. Some bloggers hold regular fund-raising drives and some have managed to blog full-time because of the donations from their readers.

This article was created by a professional writer and edited by experienced copy editors, both qualified members of the Demand Media Studios community. All articles go through an editorial process that includes subject matter guidelines, plagiarism review, fact-checking, and other steps in an effort to provide reliable information.

Getting sponsored by a business is another way to make money blogging. In most cases sponsorship happens by businesses approaching blogs that cover a demographic they are interested in.

With the cost of every expense from transportation to groceries going up, its no wonder we are all looking for ways to make extra money. Here’s how to make extra …

Although an economic recession seems like a caution sign to entrepreneurs, some of today’s most stable and successful businesses can trace their roots to a recession …

These contacts will also prove invaluable if you start a side business or launch a new career during or after the recession.

Helium is the best paid website there is. At first you start off slow but once you build your writers rep you make money off your articles daily.

Want to make money online with no financial investment? There are plenty of legitimate money making opportunities. Here are some scam-free ways to earn money online.

Most offers you get through email or Internet ads that claim you can make money at home with no special experience or skills are scams that require large up-front …

Find a company that would benefit from your envelope stuffing service. Non Profit organizations with boards usually have to send out very large personalized packages to their members on a monthly basis. Grant writers with a high customer base with little employees are also a good business to contact. Grant writer usually have allot of snail mail and virtual mail to get out that has to be perfect. For either types of companies they will usually only think about hiring when they are extremely busy and if you prove yourself to be cost effective they will usually keep you on. Accountants may also hire out for such service during the busy seasons.

Do not pay for a set up package or get caught up in schemes sending out mail to get others to buy a package to send out mail. This is not a real work at home job and is not going to make you money.

It is best to use the companies supplies and not your own. Your charge should be based on how much time it should take you to get the job done if you worked straight through.

Internet marketing refers to the various methods used to advertise goods and services on the World Wide Web. These methods include viral marketing, Web 2.0, article …

Investing in the stock market is risky, especially if you’re looking for instant riches, but there are big returns if you are careful and educate yourself. There are …

How to Design a Website

Preview your site in a variety of browsers and on a variety of computers, to determine that your creation looks the way it should in different environments.

Everyone has a Web site these days (you do, don’t you?). Some are for fun, while others are pure business. If you’re planning a new site, you have to know its …

This article was created by a professional writer and edited by experienced copy editors, both qualified members of the Demand Media Studios community. All articles go through an editorial process that includes subject matter guidelines, plagiarism review, fact-checking, and other steps in an effort to provide reliable information.

How to Make a Business Portfolio. Part of the series: Business Plans. A business portfolio is a gathering or combination of business experiences, products and services …

Ever dream of working from home on your own time and by your own terms? Doing Web design work is a profitable career that’s in high demand. As an even better …

A portfolio displays the sampling of work done by an artist, designer or illustrator. Having a great portfolio is very important for jump starting a career and …

Applications That Create Web Archive Files. Web applications differ in size as a result of the database associated with them. Since the inception of customized …

There are many Web design applications available to create Web pages. In some of them, you don’t have to know HTML to create a page.

Use the application’s tutorials and help files to familiarize yourself with how the program works. For standard text editors, use an HTML reference guide.

Learn what’s involved in designing a successful website. This entails researching what’s out there, seeing what the big companies are doing and comparing different sites in quality and easiness of use. Aside from design and layout, you will also need to manage information change, maintenance and navigability of the site.

Web design is a much sought-after skill. After all, businesses need high quality websites to attract clients and individuals often want a website to show off family …

If you want to take the leap to start their own fashion design business, you will need to educate yourself not just on fashion, but on marketing, product design and …

JavaScript is a computer scripting language used primarily to grant programmable access to objects featured in other software applications. It is mostly used in …

Deborah Lee Soltesz is a web developer who has been creating web sites, promotional materials and information products for over 20 years. Soltesz has a Bachelor of Science in computer science and engineering, and has worked in earth and space science research for over a decade writing for scientific and general audiences.

PHP is a powerful server-side scripting language in use on millions of websites. According to builtwith.com, as of May 2010, more than 2.8 million websites were using …

Graphic design has been growing steadily for the past few years. The web has become a major way of communicating with people as well as clients.

Web designers and developers are the computer programmers that create and maintain websites on the Internet. Unlike many other careers, there’s no officially required …

The “Truth” anti-smoking campaign is a nationwide campaign that aims to inform people about the dangers of smoking. The “Truth” campaign is dedicated to its cause of …

{!= ads[i].line2 !} {!= ads[i].line3 !}

Macromedia dreamweaver allows web developers to hide the HTML code while they design the website, making it easy for those who do not use HTML.

If you want to design your own landscape and would like the convenience of being able to play around with it on your computer, you might want to try using a landscape …