Rename a MySQL table

Tyler Tyler (285)
0
Updated: February 18th, 2015

Renaming a MySQL table is very simple, but sometimes the syntax is hard to remember.

Posted in these interests:

webdev
PRIMARY
58 guides
mysql
9 guides

Rename a MySQL table

webdevmysql
Tyler Tyler (285)
0
Updated: February 18th, 2015
Tyler
1
 

Posted in these interests:

webdev
PRIMARY
58 guides
mysql
9 guides
webdev
PRIMARY
58 guides
mysql
9 guides
PRIMARY
Calling all writers!

We’re hiring. Write for Howchoo

1
 
In these interests
webdev
PRIMARY
58 guides
mysql
9 guides
webdev
PRIMARY
58 guides
mysql
9 guides
PRIMARY

In the MySQL prompt type: use database_name

Now type: RENAME TABLE old_table_name TO new_table_name;

In the MySQL prompt type: use database_name

In the MySQL prompt type: use database_name

Select the database

Now type: RENAME TABLE old_table_name TO new_table_name;

Now type: RENAME TABLE old_table_name TO new_table_name;

Rename the table

Calling all writers!

We’re hiring. Write for Howchoo

Tyler's profile pictureTyler
Joined in 2015
Software Engineer and creator of howchoo.
Tyler's profile picture
Share this guide!
RedditEmailText
Related to this guide:
MySQL vs PostgreSQLMySQL vs PostgreSQL
Comparing performance, syntax, replication, and features.
Gilad's profile picture GiladView
In these interests: postgresqlwebdevmysql
How to export clean HTML from Google DocsHow to export clean HTML from Google Docs
By default, the HTML exported from Google Docs includes tons of classes, styles, and is generally messy. This short guide will teach you how to export clean HTML devoid of classes and inline styles.
Zach's profile picture ZachView
In these interests: googledocswebdevcode
Filtering Google Analytics language spamFiltering Google Analytics language spam
Google Analytics spam is nothing new. But now spammers have realized that, since language appears in the initial Google Analytics dashboard view, spoofing the language code reaches eyeballs.
Zach's profile picture ZachView
In these interests: webdev
MySQL vs PostgreSQLMySQL vs PostgreSQL
Comparing performance, syntax, replication, and features.
Gilad's profile picture GiladView
In these interests: postgresqlwebdevmysql
Gilad's profile pictureViewpostgresqlwebdevmysql
How to export clean HTML from Google DocsHow to export clean HTML from Google Docs
By default, the HTML exported from Google Docs includes tons of classes, styles, and is generally messy. This short guide will teach you how to export clean HTML devoid of classes and inline styles.
Zach's profile picture ZachView
In these interests: googledocswebdevcode
Zach's profile pictureViewgoogledocswebdevcode
Filtering Google Analytics language spamFiltering Google Analytics language spam
Google Analytics spam is nothing new. But now spammers have realized that, since language appears in the initial Google Analytics dashboard view, spoofing the language code reaches eyeballs.
Zach's profile picture ZachView
In these interests: webdev
Zach's profile pictureViewwebdev
People also read:
Converting XML files to JSON is a good practice for providing easy manipulation and preparing service responses. You can accomplish this efficiently with just three lines of code.
Part of being a web developer is testing things that will inevitably break in insane and unexpected ways in Internet Explorer.
As a developer, I’ve customized my bash prompt to always show the current git branch if I’m in an initialized git repository. This is convenient, but it can make for a very long bash prompt.
This guide will show you how to set up a LAMP environment in macOS and OS X.
I’ll spoil it – “printenv” is your friend. This guide will show a few examples of how to use it.
Surprisingly, normal YouTube embeds are not automatically sized to the browser window as it is resized.
I started programming in PHP, so by default I would use apache even when I just wanted to test basic HTML files. As I was learning Python, I discovered a great HTTP request handler.
As a web developer, I stare at Chrome’s developer tools — particularly the Elements and Console tabs — all day long. As a result, all light and no dark makes Zach’s eyes dull and tired.
You can echo the current MODX resource’s full page URL without the use of a snippet call.
Converting XML files to JSON is a good practice for providing easy manipulation and preparing service responses. You can accomplish this efficiently with just three lines of code.
Part of being a web developer is testing things that will inevitably break in insane and unexpected ways in Internet Explorer.
As a developer, I’ve customized my bash prompt to always show the current git branch if I’m in an initialized git repository. This is convenient, but it can make for a very long bash prompt.
This guide will show you how to set up a LAMP environment in macOS and OS X.
I’ll spoil it – “printenv” is your friend. This guide will show a few examples of how to use it.
How to Convert XML to JSON in PHP
How to Run Internet Explorer on Mac (For Free)
Adjust the Length of Your Bash Prompt on the Fly
How to Set Up a LAMP server in macOS
How to Print Environment Variables in Linux/Unix
Surprisingly, normal YouTube embeds are not automatically sized to the browser window as it is resized.
I started programming in PHP, so by default I would use apache even when I just wanted to test basic HTML files. As I was learning Python, I discovered a great HTTP request handler.
As a web developer, I stare at Chrome’s developer tools — particularly the Elements and Console tabs — all day long. As a result, all light and no dark makes Zach’s eyes dull and tired.
You can echo the current MODX resource’s full page URL without the use of a snippet call.
GitHub Pull Requests: How and Why to Use Pull Requests
Make YouTube Video Embeds Responsive Using Pure HTML and CSS
Using Python’s simple HTTP server
Tell Chrome Developer Tools to Use a Dark Theme
How to Print the Current Page URL in MODX
Posted in these interests:
webdevwebdev
webdev
PRIMARY
All things web development.
webdevwebdev
webdev
PRIMARY
All things web development.
PRIMARY
ExploreExplore
Discuss this guide:
We’re hiring!
Are you a passionate writer? We want to hear from you!
We’re hiring!
Are you a passionate writer? We want to hear from you!
View openings

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Donate

Always show file extensions in Mac OSX

Theo Theo (2)
Total time: 1 minute 
Updated: February 18th, 2015

As a website designer, I work with a lot of files — and a lot of file types. Nothing’s worse than wasting time trying to fix a problem caused by an overseen missing file extension.

Posted in these interests:

osx
PRIMARY
47 guides
mac
81 guides
apple
51 guides
webdesign
18 guides
finder
3 guides

Always show file extensions in Mac OSX

Theo Theo (2)
Total time: 1 minute 
Updated: February 18th, 2015

As a website designer, I work with a lot of files — and a lot of file types. Nothing’s worse than wasting time trying to fix a problem caused by an overseen missing file extension.

Posted in these interests:

osx
PRIMARY
47 guides
mac
81 guides
apple
51 guides
webdesign
18 guides
finder
3 guides

Always show file extensions in Mac OSX

Theo Theo (2)
Total time: 1 minute 
Updated: February 18th, 2015

As a website designer, I work with a lot of files — and a lot of file types. Nothing’s worse than wasting time trying to fix a problem caused by an overseen missing file extension.

Posted in these interests:

osx
PRIMARY
47 guides
mac
81 guides
apple
51 guides
webdesign
18 guides
finder
3 guides

Always show file extensions in Mac OSX

Theo Theo (2)
Total time: 1 minute 
Updated: February 18th, 2015

As a website designer, I work with a lot of files — and a lot of file types. Nothing’s worse than wasting time trying to fix a problem caused by an overseen missing file extension.

Posted in these interests:

osx
PRIMARY
47 guides
mac
81 guides
apple
51 guides
webdesign
18 guides
finder
3 guides

Always show file extensions in Mac OSX

osxmacapplewebdesignfinder
Theo Theo (2)
Total time: 1 minute 
Updated: February 18th, 2015
Theo
 

Posted in these interests:

osx
PRIMARY
47 guides
mac
81 guides
apple
51 guides
webdesign
18 guides
finder
3 guides
osx
PRIMARY
47 guides
mac
81 guides
apple
51 guides
webdesign
18 guides
finder
3 guides
PRIMARY
Calling all writers!

We’re hiring. Write for Howchoo

 
In these interests
osx
PRIMARY
47 guides
mac
81 guides
apple
51 guides
webdesign
18 guides
finder
3 guides
osx
PRIMARY
47 guides
mac
81 guides
apple
51 guides
webdesign
18 guides
finder
3 guides
PRIMARY

Open a Finder window

Go to Finder > Preferences

Select “Show all filename extensions”

Calling all writers!

We’re hiring. Write for Howchoo

Theo's profile pictureTheo
Joined in 2015
Theo's profile picture
Share this guide!
RedditEmailText
Related to this guide:
How to enable the dashboard in OS X El CapitanHow to enable the dashboard in OS X El Capitan
As someone who uses OS X dashboard widgets often, I was dismayed to find out that Apple has hidden it by default. Thankfully, it’s easy to reenable the dashboard in El Capitan. Here’s how to do it.
Zach's profile picture ZachView
In these interests: osxmacelcapitan
How to delete an application on Mac OS XHow to delete an application on Mac OS X
There are a few different methods for deleting an application based on how you installed it.
Tyler's profile picture TylerView
In these interests: osxmac
How to Delete an Application Downloaded from the Mac App StoreHow to Delete an Application Downloaded from the Mac App Store
This guide will teach you how to quickly delete an application from your Mac that was downloaded from the Mac App Store. This method uses Launchpad.
Tyler's profile picture TylerView
In these interests: osxmac
How to enable the dashboard in OS X El CapitanHow to enable the dashboard in OS X El Capitan
As someone who uses OS X dashboard widgets often, I was dismayed to find out that Apple has hidden it by default. Thankfully, it’s easy to reenable the dashboard in El Capitan. Here’s how to do it.
Zach's profile picture ZachView
In these interests: osxmacelcapitan
Zach's profile pictureViewosxmacelcapitan
How to delete an application on Mac OS XHow to delete an application on Mac OS X
There are a few different methods for deleting an application based on how you installed it.
Tyler's profile picture TylerView
In these interests: osxmac
Tyler's profile pictureViewosxmac
How to Delete an Application Downloaded from the Mac App StoreHow to Delete an Application Downloaded from the Mac App Store
This guide will teach you how to quickly delete an application from your Mac that was downloaded from the Mac App Store. This method uses Launchpad.
Tyler's profile picture TylerView
In these interests: osxmac
Tyler's profile pictureViewosxmac
People also read:
Many applications use multiple windows, and there is a handy keyboard shortcut to help you switch quickly between them.
There are plenty of websites that will automatically convert a video into a gif. Some of these sites even have a few options to customize the gif you create.
This guide shows you how to change the HipChat notification sound in both Mac and Windows. Presently, the notification sound cannot be changed through either native application.
Flushing your dns is a very useful troubleshooting step and is necessary for some network changes to take effect.
Flushing your dns is a very useful troubleshooting step and is necessary for some network changes to take effect.
This guide was written for OS X 10.9. For an updated version of this guide click here. There are plenty of reasons you will want to encrypt files on your personal computer.
This shortcut takes your cursor directly to the searchbox after opening Mail.app. This works in all current versions of OSX.
This short guide shows you how to disable the additional Mac menubars/toolbars and docks that were added in OS X Mavericks.
You can set up your Apple computer so that when you double-click the menu bar it minimizes the application. This is a huge time saver and is OS X does not do this by default.
I have tons of photos and this was seriously slowing my computer down. It took a bit of hunting to figure out how to do this since the option is apparently not in iTunes.
Many applications use multiple windows, and there is a handy keyboard shortcut to help you switch quickly between them.
There are plenty of websites that will automatically convert a video into a gif. Some of these sites even have a few options to customize the gif you create.
This guide shows you how to change the HipChat notification sound in both Mac and Windows. Presently, the notification sound cannot be changed through either native application.
Flushing your dns is a very useful troubleshooting step and is necessary for some network changes to take effect.
Flushing your dns is a very useful troubleshooting step and is necessary for some network changes to take effect.
How to switch between the windows of an application on OS X
How to turn a video into a gif on a Mac
How to change the HipChat notification sound
How to flush dns on Mac OS 10.7 or 10.8
How to flush DNS on Mac OS X Yosemite
This guide was written for OS X 10.9. For an updated version of this guide click here. There are plenty of reasons you will want to encrypt files on your personal computer.
This shortcut takes your cursor directly to the searchbox after opening Mail.app. This works in all current versions of OSX.
This short guide shows you how to disable the additional Mac menubars/toolbars and docks that were added in OS X Mavericks.
You can set up your Apple computer so that when you double-click the menu bar it minimizes the application. This is a huge time saver and is OS X does not do this by default.
I have tons of photos and this was seriously slowing my computer down. It took a bit of hunting to figure out how to do this since the option is apparently not in iTunes.
How to encrypt files on Mac OS X 10.9
Mac Mail Search Box Shortcut
Remove Multiple Menu Bars and Docks in macOS/OS X
Double-Click the Menu Bar to Minimize an Application in macOS
How to Stop iPhoto From Opening When You Connect Your iPhone or iPad
Posted in these interests:
osxosx
osx
PRIMARY
OS X is a series of Unix-based operating systems developed by Apple, Inc. The first public beta, called Kodiak, appeared in 2000.
appleapple
Apple Computers is an American computer and consumer electronics company founded by Steve Jobs and Steve Wozniak.
osxosx
osx
PRIMARY
OS X is a series of Unix-based operating systems developed by Apple, Inc. The first public beta, called Kodiak, appeared in 2000.
PRIMARY
ExploreExplore
appleapple
Apple Computers is an American computer and consumer electronics company founded by Steve Jobs and Steve Wozniak.
ExploreExploreExplore
Discuss this guide:
We’re hiring!
Are you a passionate writer? We want to hear from you!
We’re hiring!
Are you a passionate writer? We want to hear from you!
View openings

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Donate

Running this command should print out something like this: CentOS release 6.3 (Final)

Running this command should print out something like this: CentOS release 6.3 (Final)

Running this command should print out something like this: CentOS release 6.3 (Final)

How to find your linux distribution and version

How to find your linux distribution and versionHow to find your linux distribution and version
Tyler Tyler (285)
Total time: 1 minute 
Updated: February 18th, 2015

If you’re logged into a machine, you may want to know exactly which version of linux you are using.

Here’s everything you’ll need to complete this guide:

Linux×1

How to find your linux distribution and version

webdevsysadmin
Tyler Tyler (285)
Total time: 1 minute 
Updated: February 18th, 2015
Tyler
1
 
1

Here’s everything you’ll need to complete this guide:

Linux×1
Linux×1
Calling all writers!

We’re hiring. Write for Howchoo

1
 
1
In these interests
webdev
PRIMARY
58 guides
sysadmin
12 guides
webdev
PRIMARY
58 guides
sysadmin
12 guides
PRIMARY

Running this command should print out something like this: CentOS release 6.3 (Final)

Running this command should print out something like this: CentOS release 6.3 (Final)

Running this command should print out something like this: CentOS release 6.3 (Final)

cat /etc/*release

Calling all writers!

We’re hiring. Write for Howchoo

Tyler's profile pictureTyler
Joined in 2015
Software Engineer and creator of howchoo.
Tyler's profile picture
Share this guide!
RedditEmailTextPinterest
Related to this guide:
MySQL vs PostgreSQLMySQL vs PostgreSQL
Comparing performance, syntax, replication, and features.
Gilad's profile picture GiladView
In these interests: postgresqlwebdevmysql
How to export clean HTML from Google DocsHow to export clean HTML from Google Docs
By default, the HTML exported from Google Docs includes tons of classes, styles, and is generally messy. This short guide will teach you how to export clean HTML devoid of classes and inline styles.
Zach's profile picture ZachView
In these interests: googledocswebdevcode
Filtering Google Analytics language spamFiltering Google Analytics language spam
Google Analytics spam is nothing new. But now spammers have realized that, since language appears in the initial Google Analytics dashboard view, spoofing the language code reaches eyeballs.
Zach's profile picture ZachView
In these interests: webdev
MySQL vs PostgreSQLMySQL vs PostgreSQL
Comparing performance, syntax, replication, and features.
Gilad's profile picture GiladView
In these interests: postgresqlwebdevmysql
Gilad's profile pictureViewpostgresqlwebdevmysql
How to export clean HTML from Google DocsHow to export clean HTML from Google Docs
By default, the HTML exported from Google Docs includes tons of classes, styles, and is generally messy. This short guide will teach you how to export clean HTML devoid of classes and inline styles.
Zach's profile picture ZachView
In these interests: googledocswebdevcode
Zach's profile pictureViewgoogledocswebdevcode
Filtering Google Analytics language spamFiltering Google Analytics language spam
Google Analytics spam is nothing new. But now spammers have realized that, since language appears in the initial Google Analytics dashboard view, spoofing the language code reaches eyeballs.
Zach's profile picture ZachView
In these interests: webdev
Zach's profile pictureViewwebdev
People also read:
Converting XML files to JSON is a good practice for providing easy manipulation and preparing service responses. You can accomplish this efficiently with just three lines of code.
Part of being a web developer is testing things that will inevitably break in insane and unexpected ways in Internet Explorer.
As a developer, I’ve customized my bash prompt to always show the current git branch if I’m in an initialized git repository. This is convenient, but it can make for a very long bash prompt.
This guide will show you how to set up a LAMP environment in macOS and OS X.
I’ll spoil it – “printenv” is your friend. This guide will show a few examples of how to use it.
Surprisingly, normal YouTube embeds are not automatically sized to the browser window as it is resized.
I started programming in PHP, so by default I would use apache even when I just wanted to test basic HTML files. As I was learning Python, I discovered a great HTTP request handler.
As a web developer, I stare at Chrome’s developer tools — particularly the Elements and Console tabs — all day long. As a result, all light and no dark makes Zach’s eyes dull and tired.
You can echo the current MODX resource’s full page URL without the use of a snippet call.
Converting XML files to JSON is a good practice for providing easy manipulation and preparing service responses. You can accomplish this efficiently with just three lines of code.
Part of being a web developer is testing things that will inevitably break in insane and unexpected ways in Internet Explorer.
As a developer, I’ve customized my bash prompt to always show the current git branch if I’m in an initialized git repository. This is convenient, but it can make for a very long bash prompt.
This guide will show you how to set up a LAMP environment in macOS and OS X.
I’ll spoil it – “printenv” is your friend. This guide will show a few examples of how to use it.
How to Convert XML to JSON in PHP
How to Run Internet Explorer on Mac (For Free)
Adjust the Length of Your Bash Prompt on the Fly
How to Set Up a LAMP server in macOS
How to Print Environment Variables in Linux/Unix
Surprisingly, normal YouTube embeds are not automatically sized to the browser window as it is resized.
I started programming in PHP, so by default I would use apache even when I just wanted to test basic HTML files. As I was learning Python, I discovered a great HTTP request handler.
As a web developer, I stare at Chrome’s developer tools — particularly the Elements and Console tabs — all day long. As a result, all light and no dark makes Zach’s eyes dull and tired.
You can echo the current MODX resource’s full page URL without the use of a snippet call.
GitHub Pull Requests: How and Why to Use Pull Requests
Make YouTube Video Embeds Responsive Using Pure HTML and CSS
Using Python’s simple HTTP server
Tell Chrome Developer Tools to Use a Dark Theme
How to Print the Current Page URL in MODX
Posted in these interests:
webdevwebdev
webdev
PRIMARY
All things web development.
webdevwebdev
webdev
PRIMARY
All things web development.
PRIMARY
ExploreExplore
Discuss this guide:
We’re hiring!
Are you a passionate writer? We want to hear from you!
We’re hiring!
Are you a passionate writer? We want to hear from you!
View openings

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Donate
Tyler's profile pictureTyler
Joined in 2015
Software Engineer and creator of howchoo.
Related to this guide:
MySQL vs PostgreSQLMySQL vs PostgreSQL
Comparing performance, syntax, replication, and features.
Gilad's profile picture GiladView
In these interests: postgresqlwebdevmysql
How to export clean HTML from Google DocsHow to export clean HTML from Google Docs
By default, the HTML exported from Google Docs includes tons of classes, styles, and is generally messy. This short guide will teach you how to export clean HTML devoid of classes and inline styles.
Zach's profile picture ZachView
In these interests: googledocswebdevcode
Filtering Google Analytics language spamFiltering Google Analytics language spam
Google Analytics spam is nothing new. But now spammers have realized that, since language appears in the initial Google Analytics dashboard view, spoofing the language code reaches eyeballs.
Zach's profile picture ZachView
In these interests: webdev
People also read:
Converting XML files to JSON is a good practice for providing easy manipulation and preparing service responses. You can accomplish this efficiently with just three lines of code.
Part of being a web developer is testing things that will inevitably break in insane and unexpected ways in Internet Explorer.
As a developer, I’ve customized my bash prompt to always show the current git branch if I’m in an initialized git repository. This is convenient, but it can make for a very long bash prompt.
This guide will show you how to set up a LAMP environment in macOS and OS X.
I’ll spoil it – “printenv” is your friend. This guide will show a few examples of how to use it.
Surprisingly, normal YouTube embeds are not automatically sized to the browser window as it is resized.
Posted in these interests:
webdevwebdev
webdev
PRIMARY
All things web development.
Discuss this guide:
We’re hiring!
Are you a passionate writer or editor? We want to hear from you!
We’re hiring!
Are you a passionate writer or editor? We want to hear from you!

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Tyler's profile pictureTyler
Joined in 2015
Software Engineer and creator of howchoo.
Share this guide!
Related to this guide:
SVG Optimization: How (and Why) to Optimize SVGsSVG Optimization: How (and Why) to Optimize SVGs
SVGs are great; making them smaller makes them even greater. This guide will show you how to optimize SVGs.
Zach's profile picture ZachView
In these interests: svgwebdesignwebdev
Use Chrome Developer Tools to Check Whether Resources Are Loading over SSLUse Chrome Developer Tools to Check Whether Resources Are Loading over SSL
In the wake of Google’s announcement that it will start giving a ranking boost to full-SSL sites, many companies are converting their sites to be full-https.
Zach's profile picture ZachView
In these interests: chromewebdesignwebdev
Make your lightbox display over an embedded YouTube video in IE8Make your lightbox display over an embedded YouTube video in IE8
In Internet Explorer 8, embedded YouTube videos are treated as the absolute top element, regardless of z-index.
2paclives's profile picture 2paclivesView
In these interests: webdesign
People also read:
Most people don’t know that you can look up past “snapshots” of almost any website. Archive.org is a 501(c)(3) nonprofit organization that was formed to build an expansive Internet library.
Internet Explorer 8 may display a border regardless of your CSS attempts. This guide details how to remove it once and for all.
Text shadows are a beautiful and subtle effect for your web site. CSS3 text shadows are currently support on all versions of Chrome, Safari, Firefox 3.5+, and IE 10+.
Learn how to center text in CSS.
If you’re the administrator of a Facebook Page for your business (or whatever), you can still comment as yourself.
When building a website, it’s a good idea to open external links (e.g. http://google.com) in a new window so that users aren’t directed away from your site.
If you’d like your visitors to be able to open a phone application straight from your website you can follow this quick guide.
Posted in these interests:
Discuss this guide:
We’re hiring!
Are you a passionate writer or editor? We want to hear from you!
We’re hiring!
Are you a passionate writer or editor? We want to hear from you!

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Tyler's profile pictureTyler
Joined in 2015
Software Engineer and creator of howchoo.
Share this guide!
Related to this guide:
MySQL vs PostgreSQLMySQL vs PostgreSQL
Comparing performance, syntax, replication, and features.
Gilad's profile picture GiladView
In these interests: postgresqlwebdevmysql
How to export clean HTML from Google DocsHow to export clean HTML from Google Docs
By default, the HTML exported from Google Docs includes tons of classes, styles, and is generally messy. This short guide will teach you how to export clean HTML devoid of classes and inline styles.
Zach's profile picture ZachView
In these interests: googledocswebdevcode
Filtering Google Analytics language spamFiltering Google Analytics language spam
Google Analytics spam is nothing new. But now spammers have realized that, since language appears in the initial Google Analytics dashboard view, spoofing the language code reaches eyeballs.
Zach's profile picture ZachView
In these interests: webdev
People also read:
Converting XML files to JSON is a good practice for providing easy manipulation and preparing service responses. You can accomplish this efficiently with just three lines of code.
Part of being a web developer is testing things that will inevitably break in insane and unexpected ways in Internet Explorer.
As a developer, I’ve customized my bash prompt to always show the current git branch if I’m in an initialized git repository. This is convenient, but it can make for a very long bash prompt.
This guide will show you how to set up a LAMP environment in macOS and OS X.
I’ll spoil it – “printenv” is your friend. This guide will show a few examples of how to use it.
Surprisingly, normal YouTube embeds are not automatically sized to the browser window as it is resized.
Posted in these interests:
webdevwebdev
webdev
PRIMARY
All things web development.
Discuss this guide:
We’re hiring!
Are you a passionate writer or editor? We want to hear from you!
We’re hiring!
Are you a passionate writer or editor? We want to hear from you!

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

How to open a link in a new window (HTML)

How to open a link in a new window (HTML)How to open a link in a new window (HTML)
Zach Zach (233)
Total time: 1 minute 
Updated: February 18th, 2015

When building a website, it’s a good idea to open external links (e.g. http://google.com) in a new window so that users aren’t directed away from your site.

Posted in these interests:

webdesign
PRIMARY
18 guides
html
4 guides

How to open a link in a new window (HTML)

How to open a link in a new window (HTML)How to open a link in a new window (HTML)
Zach Zach (233)
Total time: 1 minute 
Updated: February 18th, 2015

When building a website, it’s a good idea to open external links (e.g. http://google.com) in a new window so that users aren’t directed away from your site.

Posted in these interests:

webdesign
PRIMARY
18 guides
html
4 guides

How to open a link in a new window (HTML)

How to open a link in a new window (HTML)How to open a link in a new window (HTML)
Zach Zach (233)
Total time: 1 minute 
Updated: February 18th, 2015

When building a website, it’s a good idea to open external links (e.g. http://google.com) in a new window so that users aren’t directed away from your site.

Posted in these interests:

webdesign
PRIMARY
18 guides
html
4 guides

How to open a link in a new window (HTML)

How to open a link in a new window (HTML)How to open a link in a new window (HTML)
Zach Zach (233)
Total time: 1 minute 
Updated: February 18th, 2015

When building a website, it’s a good idea to open external links (e.g. http://google.com) in a new window so that users aren’t directed away from your site.

Posted in these interests:

webdesign
PRIMARY
18 guides
html
4 guides

How to open a link in a new window (HTML)

webdesignhtml
Zach Zach (233)
Total time: 1 minute 
Updated: February 18th, 2015
Zach
 

Posted in these interests:

webdesign
PRIMARY
18 guides
html
4 guides
webdesign
PRIMARY
18 guides
html
4 guides
PRIMARY
Calling all writers!

We’re hiring. Write for Howchoo

 
In these interests
webdesign
PRIMARY
18 guides
html
4 guides
webdesign
PRIMARY
18 guides
html
4 guides
PRIMARY

Add the target=”_blank” attribute to the a href tag.

Opens Google in a new window

Add the target=”_blank” attribute to the a href tag.

Opens Google in a new window

Add the target=”_blank” attribute to the a href tag.

Opens Google in a new window

Use the following code:

Calling all writers!

We’re hiring. Write for Howchoo

Zach's profile pictureZach
Joined in 2015
Web developer, designer, tinkerer, and beer enthusiast living in Tampa, Florida.
Zach's profile picturehowchoo
Share this guide!
RedditEmailTextPinterest
Related to this guide:
SVG Optimization: How (and Why) to Optimize SVGsSVG Optimization: How (and Why) to Optimize SVGs
SVGs are great; making them smaller makes them even greater. This guide will show you how to optimize SVGs.
Zach's profile picture ZachView
In these interests: svgwebdesignwebdev
Use Chrome Developer Tools to Check Whether Resources Are Loading over SSLUse Chrome Developer Tools to Check Whether Resources Are Loading over SSL
In the wake of Google’s announcement that it will start giving a ranking boost to full-SSL sites, many companies are converting their sites to be full-https.
Zach's profile picture ZachView
In these interests: chromewebdesignwebdev
Make your lightbox display over an embedded YouTube video in IE8Make your lightbox display over an embedded YouTube video in IE8
In Internet Explorer 8, embedded YouTube videos are treated as the absolute top element, regardless of z-index.
2paclives's profile picture 2paclivesView
In these interests: webdesign
SVG Optimization: How (and Why) to Optimize SVGsSVG Optimization: How (and Why) to Optimize SVGs
SVGs are great; making them smaller makes them even greater. This guide will show you how to optimize SVGs.
Zach's profile picture ZachView
In these interests: svgwebdesignwebdev
Zach's profile pictureViewsvgwebdesignwebdev
Use Chrome Developer Tools to Check Whether Resources Are Loading over SSLUse Chrome Developer Tools to Check Whether Resources Are Loading over SSL
In the wake of Google’s announcement that it will start giving a ranking boost to full-SSL sites, many companies are converting their sites to be full-https.
Zach's profile picture ZachView
In these interests: chromewebdesignwebdev
Zach's profile pictureViewchromewebdesignwebdev
Make your lightbox display over an embedded YouTube video in IE8Make your lightbox display over an embedded YouTube video in IE8
In Internet Explorer 8, embedded YouTube videos are treated as the absolute top element, regardless of z-index.
2paclives's profile picture 2paclivesView
In these interests: webdesign
2paclives's profile pictureViewwebdesign
People also read:
Most people don’t know that you can look up past “snapshots” of almost any website. Archive.org is a 501(c)(3) nonprofit organization that was formed to build an expansive Internet library.
Internet Explorer 8 may display a border regardless of your CSS attempts. This guide details how to remove it once and for all.
Text shadows are a beautiful and subtle effect for your web site. CSS3 text shadows are currently support on all versions of Chrome, Safari, Firefox 3.5+, and IE 10+.
Learn how to center text in CSS.
If you’re the administrator of a Facebook Page for your business (or whatever), you can still comment as yourself.
If you’d like your visitors to be able to open a phone application straight from your website you can follow this quick guide.
Using CSS, you can display beautiful background images that span the entirety of the user’s window — regardless of their resolution. Here’s how to do it.
If you have a log file that gets written to frequently, you will want to add it to logrotate so it doesn’t consume all of your disk space.
iPhone on Book of Fonts
Really love that font you found in a book or website? Learn how to tell what it is.
Surprisingly, normal YouTube embeds are not automatically sized to the browser window as it is resized.
Most people don’t know that you can look up past “snapshots” of almost any website. Archive.org is a 501(c)(3) nonprofit organization that was formed to build an expansive Internet library.
Internet Explorer 8 may display a border regardless of your CSS attempts. This guide details how to remove it once and for all.
Text shadows are a beautiful and subtle effect for your web site. CSS3 text shadows are currently support on all versions of Chrome, Safari, Firefox 3.5+, and IE 10+.
Learn how to center text in CSS.
If you’re the administrator of a Facebook Page for your business (or whatever), you can still comment as yourself.
Time Travel the Internet: View Any Website from (Almost) Any Year
How to remove an iFrame border in IE8
CSS Text Shadows: How to Add a Text Shadow Using CSS3
Center align text using CSS
How to Comment on Your Facebook Page as Yourself
If you’d like your visitors to be able to open a phone application straight from your website you can follow this quick guide.
Using CSS, you can display beautiful background images that span the entirety of the user’s window — regardless of their resolution. Here’s how to do it.
If you have a log file that gets written to frequently, you will want to add it to logrotate so it doesn’t consume all of your disk space.
iPhone on Book of Fonts
Really love that font you found in a book or website? Learn how to tell what it is.
Surprisingly, normal YouTube embeds are not automatically sized to the browser window as it is resized.
How to open the telephone app using an HTML link
How to create a full-page (cover) background image using CSS
How to add a file to logrotate on Linux
iPhone on Book of Fonts
iPhone on Book of FontsHow to Find Out What Font is Being Used
Make YouTube Video Embeds Responsive Using Pure HTML and CSS
Posted in these interests:
htmlhtml
Hypertext Markup Language (HTML) is a standardized coding language that is interpreted by web browsers to display graphics as well as color, font, and hyperlink effects.
PRIMARY
Explore
htmlhtml
Hypertext Markup Language (HTML) is a standardized coding language that is interpreted by web browsers to display graphics as well as color, font, and hyperlink effects.
Explore
Discuss this guide:
We’re hiring!
Are you a passionate writer? We want to hear from you!
We’re hiring!
Are you a passionate writer? We want to hear from you!
View openings

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Donate
Calling all writers!

We’re hiring. Write for Howchoo

Tyler's profile pictureTyler
Joined in 2015
Software Engineer and creator of howchoo.
Related to this guide:
Git: Move Your Latest Commits to Another BranchGit: Move Your Latest Commits to Another Branch
Sometimes we start writing code without managing our branches in advance. Then we make commits in master (or some other base branch) when we intended to carve off a new feature branch.
Tyler's profile picture TylerView
In these interests: git
GitHub Package Registry: Manage Packages Alongside Your Source CodeGitHub Package Registry: Manage Packages Alongside Your Source Code
Publishing software packages is already pretty easy, so what does GitHub’s Package Registry offer that we don’t already have?
Tyler's profile picture TylerView
In these interests: newsgithubgit
Git: Handling Merge Conflicts Using "Ours" and "Theirs"Git: Handling Merge Conflicts Using "Ours" and "Theirs"
Nothing is certain, except death and taxes and merge conflicts. -Benjamin Franklin
Tyler's profile picture TylerView
In these interests: git
People also read:
Cleaning up unused tags is an important part of Git housekeeping. This guide will show you how to delete tags from both local and remote Git repositories.
Git is an open-source version control system (VCS). In order to use Git to track changes in your code from the command line, you’ll need to download, install and configure it on your computer.
Tab completion, or auto-completion, is essential if you’re using Git on the command line. Tab completion is a nice feature of many shells that allows you to complete a word by hitting tab.
I’ve wanted to start blogging again after a few years off. I was thrilled to find that I can blog using markdown in Vim and publish using git.
When you’re using git routinely, it’s helpful to know which branch you’re currently on without having to type git status or git branch.
This short guide will show you how to list all remote branches in Git.
There are some fundamental git commands that you will use frequently that are hard to work into a “how-to” guide. Here are some basic git commands and how to use them. These are in no specific order.
Hub overview Hub is a command-line tool that wraps git and provides extra functionality that makes working with GitHub easier.
Make your object readable in console.
Create GitHub personal access tokens for the command line
Posted in these interests:
gitgit
git
PRIMARY
webdevwebdev
All things web development.
Discuss this guide:
We’re hiring!
Are you a passionate writer? We want to hear from you!
We’re hiring!
Are you a passionate writer? We want to hear from you!

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

How to disable the Macbook trackpad when a wireless mouse is present

How to disable the Macbook trackpad when a wireless mouse is presentHow to disable the Macbook trackpad when a wireless mouse is present
Zach Zach (233)
Total time: 1 minute 
Updated: February 18th, 2015

I like using a wireless mouse at my desk but sometimes I accidentally hit the trackpad.

Here’s everything you’ll need to complete this guide:

Wireless Mouse×1
Mac OS X×1

How to disable the Macbook trackpad when a wireless mouse is present

osxmacappletrackpadmouse
Zach Zach (233)
Total time: 1 minute 
Updated: February 18th, 2015
Zach
1
 
2

Here’s everything you’ll need to complete this guide:

Wireless Mouse×1
Mac OS X×1
Wireless Mouse×1
Mac OS X×1
Calling all writers!

We’re hiring. Write for Howchoo

1
 
2
In these interests
osx
PRIMARY
47 guides
mac
81 guides
apple
51 guides
trackpad
1 guide
mouse
1 guide
osx
PRIMARY
47 guides
mac
81 guides
apple
51 guides
trackpad
1 guide
mouse
1 guide
PRIMARY
Open Universal AccessOpen Universal Access

Open Spotlight (in the top-right corner of your screen) and type “Universal Access”.

Open Universal AccessOpen Universal Access

Open Spotlight (in the top-right corner of your screen) and type “Universal Access”.

Open Universal Access

Select the “Mouse & Trackpad” tab and then click the “Trackpad Options” button.

Check the box for “Ignore built-in trackpad when mouse or wireless trackpoint is present”. Click Done.

Calling all writers!

We’re hiring. Write for Howchoo

Zach's profile pictureZach
Joined in 2015
Web developer, designer, tinkerer, and beer enthusiast living in Tampa, Florida.
Zach's profile picturehowchoo
Share this guide!
RedditEmailTextPinterest
Related to this guide:
How to enable the dashboard in OS X El CapitanHow to enable the dashboard in OS X El Capitan
As someone who uses OS X dashboard widgets often, I was dismayed to find out that Apple has hidden it by default. Thankfully, it’s easy to reenable the dashboard in El Capitan. Here’s how to do it.
Zach's profile picture ZachView
In these interests: osxmacelcapitan
How to delete an application on Mac OS XHow to delete an application on Mac OS X
There are a few different methods for deleting an application based on how you installed it.
Tyler's profile picture TylerView
In these interests: osxmac
How to Delete an Application Downloaded from the Mac App StoreHow to Delete an Application Downloaded from the Mac App Store
This guide will teach you how to quickly delete an application from your Mac that was downloaded from the Mac App Store. This method uses Launchpad.
Tyler's profile picture TylerView
In these interests: osxmac
How to enable the dashboard in OS X El CapitanHow to enable the dashboard in OS X El Capitan
As someone who uses OS X dashboard widgets often, I was dismayed to find out that Apple has hidden it by default. Thankfully, it’s easy to reenable the dashboard in El Capitan. Here’s how to do it.
Zach's profile picture ZachView
In these interests: osxmacelcapitan
Zach's profile pictureViewosxmacelcapitan
How to delete an application on Mac OS XHow to delete an application on Mac OS X
There are a few different methods for deleting an application based on how you installed it.
Tyler's profile picture TylerView
In these interests: osxmac
Tyler's profile pictureViewosxmac
How to Delete an Application Downloaded from the Mac App StoreHow to Delete an Application Downloaded from the Mac App Store
This guide will teach you how to quickly delete an application from your Mac that was downloaded from the Mac App Store. This method uses Launchpad.
Tyler's profile picture TylerView
In these interests: osxmac
Tyler's profile pictureViewosxmac
People also read:
Many applications use multiple windows, and there is a handy keyboard shortcut to help you switch quickly between them.
There are plenty of websites that will automatically convert a video into a gif. Some of these sites even have a few options to customize the gif you create.
This guide shows you how to change the HipChat notification sound in both Mac and Windows. Presently, the notification sound cannot be changed through either native application.
Flushing your dns is a very useful troubleshooting step and is necessary for some network changes to take effect.
Flushing your dns is a very useful troubleshooting step and is necessary for some network changes to take effect.
This guide was written for OS X 10.9. For an updated version of this guide click here. There are plenty of reasons you will want to encrypt files on your personal computer.
This shortcut takes your cursor directly to the searchbox after opening Mail.app. This works in all current versions of OSX.
This short guide shows you how to disable the additional Mac menubars/toolbars and docks that were added in OS X Mavericks.
As a website designer, I work with a lot of files — and a lot of file types. Nothing’s worse than wasting time trying to fix a problem caused by an overseen missing file extension.
You can set up your Apple computer so that when you double-click the menu bar it minimizes the application. This is a huge time saver and is OS X does not do this by default.
Many applications use multiple windows, and there is a handy keyboard shortcut to help you switch quickly between them.
There are plenty of websites that will automatically convert a video into a gif. Some of these sites even have a few options to customize the gif you create.
This guide shows you how to change the HipChat notification sound in both Mac and Windows. Presently, the notification sound cannot be changed through either native application.
Flushing your dns is a very useful troubleshooting step and is necessary for some network changes to take effect.
Flushing your dns is a very useful troubleshooting step and is necessary for some network changes to take effect.
How to switch between the windows of an application on OS X
How to turn a video into a gif on a Mac
How to change the HipChat notification sound
How to flush dns on Mac OS 10.7 or 10.8
How to flush DNS on Mac OS X Yosemite
This guide was written for OS X 10.9. For an updated version of this guide click here. There are plenty of reasons you will want to encrypt files on your personal computer.
This shortcut takes your cursor directly to the searchbox after opening Mail.app. This works in all current versions of OSX.
This short guide shows you how to disable the additional Mac menubars/toolbars and docks that were added in OS X Mavericks.
As a website designer, I work with a lot of files — and a lot of file types. Nothing’s worse than wasting time trying to fix a problem caused by an overseen missing file extension.
You can set up your Apple computer so that when you double-click the menu bar it minimizes the application. This is a huge time saver and is OS X does not do this by default.
How to encrypt files on Mac OS X 10.9
Mac Mail Search Box Shortcut
Remove Multiple Menu Bars and Docks in macOS/OS X
Always show file extensions in Mac OSX
Double-Click the Menu Bar to Minimize an Application in macOS
Posted in these interests:
osxosx
osx
PRIMARY
OS X is a series of Unix-based operating systems developed by Apple, Inc. The first public beta, called Kodiak, appeared in 2000.
appleapple
Apple Computers is an American computer and consumer electronics company founded by Steve Jobs and Steve Wozniak.
osxosx
osx
PRIMARY
OS X is a series of Unix-based operating systems developed by Apple, Inc. The first public beta, called Kodiak, appeared in 2000.
PRIMARY
ExploreExplore
appleapple
Apple Computers is an American computer and consumer electronics company founded by Steve Jobs and Steve Wozniak.
ExploreExploreExplore
Discuss this guide:
We’re hiring!
Are you a passionate writer? We want to hear from you!
We’re hiring!
Are you a passionate writer? We want to hear from you!
View openings

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.

Donate

How to replace the air filter housing on a 2001 Toyota 4runner

How to replace the air filter housing on a 2001 Toyota 4runnerHow to replace the air filter housing on a 2001 Toyota 4runner
Tyler Tyler (285)
Total time: 60 minutes 
Updated: February 18th, 2015

This guide will likely work on 4runners within a few years of 2001. All you have to do is make sure the part you buy is the correct part.

Here’s everything you’ll need to complete this guide:

Dorman 258-512 Air Filter Box×1
Disconnect all hoses from the air filter housingDisconnect all hoses from the air filter housing

There is a large hose connected to the rear air filter housing. There is a single screw that you can loosen to disconnect the hose. Also connected is a smaller hose in the right hand side of the housing which should be able to be removed simply by pulling it away from the housing.

Disconnect the airflow sensorDisconnect the airflow sensor

To disconnect the airflow sensor simply squeeze the fitting like you see in the image and pull the wires away from the sensor. You will then need to remove the 2 screws holding the sensor to the housing. Set the 2 screws and the sensor off to the side for now.

Remove the water tubeRemove the water tube

There is a white, plastic tube used for adding water. This is easy to remove and will be necessary for the next few steps. This image shows the bolt you will need to remove in the next step. To remove this plastic tube simply loosen it at the top and pull it straight up.

Remove the bolts securing the air filter housingRemove the bolts securing the air filter housing

There are three bolts that secure the air filter housing to the vehicle. Two of them will require either an extension for your ratchet.

Remove the housing from the vehicleRemove the housing from the vehicle

At this point, should be able to remove the housing by first pulling the housing towards the center of the vehicle detaching it from the left wall. Then once it is detached, pull straight up.

Secure the new housing in its placeSecure the new housing in its place

Go ahead and bolt the new housing in it’s place. You can then go ahead and re-attach the hoses and fasten them them in place.

Connect the airflow sensor and put the water tube back in its placeConnect the airflow sensor and put the water tube back in its place

Screw the airflow sensor back in place, and reattach the wires. Then slide the water tube back in its place and secure it at the top.

Insert the air filter and double check your workInsert the air filter and double check your work

Insert a new air filter into the housing. Make sure everything is fastened tightly, all hoses are connected and the airflow sensor is back in it’s place. Once you’ve done this you’re finished!

We’re hiring!
Are you a passionate writer? We want to hear from you!

Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.