Quickly Rename a Mysql database

How do I quickly rename a MySQL database (change schema name)?

From phpMyAdmin, select the database you want to select. In the tabs there's one called Operations, go to the rename section. That's all.

It does, as many suggested, create a new database with the new name, dump all tables of the old database into the new database and drop the old database.

Using WhatsApp On Web

How do I use WhatsApp Web?

To provide you with a richer communication experience, WhatsApp is now accessible both on your phone and your computer. WhatsApp Web is a computer based extension of the WhatsApp account on your phone. The messages you send and receive are fully synced between your phone and your computer, and you can see all messages on both devices. Any action you take on the phone will apply to WhatsApp Web and vice versa. At this time, WhatsApp Web is available only for Android, iPhone 8.1+, Windows Phone 8.0 and 8.1, Nokia S60, Nokia S40 EVO, BlackBerry and BlackBerry 10 smartphones.

WhatsApp Web is not another WhatsApp account. When you use WhatsApp on your computer and your phone, you are simply accessing the same account on these two devices.

Minimum requirements to enjoy WhatsApp Web

• You need to have an active WhatsApp account on your phone.
• You need to have a stable internet connection on both your phone and your computer.
• You need to use the latest version of Chrome, Firefox, Opera, Safari or Edge as your web browser on your computer.

To get started with WhatsApp Web

1. Visit web.whatsapp.com on your computer.

2. Open WhatsApp on your phone.

• On Android: in the Chats screen > Menu > WhatsApp Web.
• On Nokia S60 and Windows Phone: go to Menu > WhatsApp Web.
• On iPhone: go to Settings > WhatsApp Web.
• On BlackBerry: go to Chats > Menu > WhatsApp Web.
• On BlackBerry 10: Swipe down from top of the screen > WhatsApp Web.
• On Nokia S40: Swipe up from bottom of screen > WhatsApp Web.
• Scan the QR Code on your computer screen from your phone.

3. Scan the QR Code on your computer screen from your phone.

From your phone, navigate to WhatsApp Web to view your logged in computers or to logout from an active WhatsApp Web session.

Note: To avoid data usage charges on your phone, we recommend that you are always connected to Wi-Fi when using WhatsApp Web.

How to optimize shopping ads: Google Best Practices

A Guide to Shopping Campaign Best Practices

Shopping campaigns give you the chance to feature product images and information directly in your ads. This guide covers how to create high-quality data feeds, structure effective campaigns, set your best bids and simplify the mobile shopping experience.

1. Create high-quality product feeds and keep them fresh

Use relevant titles, descriptions and images to increase CTR but don’t keyword stuff. Read more

Why: When key information comes first in well-designed titles, descriptions and images, your CTR is likely to go up. Forced repetition can also harm your placement.

Keep your feed accurate and up-to-date. Read more

Why: Inaccurate or incomplete feeds will be disapproved by Google because they create a bad experience for users. That means your ads won’t show.

2. Structure your shopping campaigns as you would a storefront

Focus on product lines, profit margins and best sellers. Read more

Why: It will help you budget and bid effectively for your top products.

Promote seasonal items with a separate campaign. Read more

Why: You’re likely to sell more with targeted budgets and marketing messages.

Use multiple campaigns and campaign priorities to promote your flash sales. Read more

Why: You can support and prioritize time-sensitive sales campaigns without restructuring your entire core campaign.

3. Bid based on your goals and your competition

Use benchmark and impression share data to set your best bids. Read more

Why: Some impressions are more valuable than others, so make sure your bids match the value of each.

Bid and budget more when you anticipate peak seasons or shifts in demand. Read more

Why: This will keep your bids competitive at periods of high traffic and opportunity.

4. Make it easy for mobile shoppers

Simplify shopping and checkout. Read more

Why: Mobile users have smaller screens and shorter usage periods.

Don’t forget about mobile tracking. Read more

Why: Shoppers use many devices each day, and mobile can play a big role in conversions.

Bid higher for shopping queries close to your store. Read more

Why: People who do shopping searches near your store are more likely to convert there.

lambda expression in C#

A lambda expression is an anonymous function means no name of method. The => token is called the lambda operator. It is used in lambda expressions to separate the input variables on the left side from the lambda body on the right side.


Example
delegate int del(int i);
static void Main(string[] args)
{
    del myDelegate = x => x * x;
    int my = myDelegate(5); //my = 25
}


Example 2:

        public static void Main()
        {
            Func<int, int> t = x => x + 1;

            Func<int, int> t2 = x => { return x + 1; };

            Func<string, string> t3 = x => { return x; };

            Action<int> example1 =  (int x) => Console.WriteLine("{0}", x);
       
       
            Console.WriteLine(t.Invoke(1));
            example1.Invoke(7);
            Console.ReadLine();
        }
Output : 2
               7

Using hashtags on Instagram

How do I use hashtags?

You can add hashtags in the caption or comments of your post. If you add hashtags to a post that's set to public, the post will be visible on the corresponding hashtag page.

To tag a photo or video with a hashtag:

1. Take or upload a photo or video
2. Choose to add a filter, then type # followed by text or emoji in the Caption field (ex: #flower)
3. If you want to add a hashtag to a post you've already uploaded, edit the caption or include your hashtag in a comment on your photo

After you tag your post with a hashtag, you'll be able to tap the hashtag to see a page that shows all photos and videos people have uploaded with that hashtag.

Things to keep in mind:

• When people with private profiles tag posts, they won't appear publicly on hashtag pages.
• Numbers are allowed in hashtags. However, spaces and special characters, like $ or %, won't work.
• You can only tag your own posts. You can't tag other people's photos/videos.
• You can use up to 30 tags on a post. If you include more than 30 tags on a single photo/video, your comment won't post.
• Older versions of Apple IOS don't support tapping hashtags. Instead, search hashtags by going to  Search & Explore > Search > Tags.

How can I change the phpmyadmin automatic log out time?

In PHPMyAdmin 4 this no longer appears in the config.inc.php file. Instead go to PHPMyAdmin in your browser. Ensure you are at the localhost level to see the Settings link. Then set Settings > Features > Change the value of 'Login cookie validity' > Save

Setting up foreign keys in phpMyAdmin?

In phpmyadmin, you can assign Foreign key simply by its GUI. Click on the table and go to Structure tab. find the Relation View on just bellow of table (shown in below image).

corresponding SQL query automatically generated and executed.