Add A Column MySql Terminal Command
If you're working with a MySQL database, you may find that you need to add a new column to a table. Fortunately, adding a column to a MySQL table is a straightforward process that we will do using the MySQL terminal command. Here's how:
Read More
Create A New Table With Column MySql Terminal Command
To create a new table with columns use this command. CREATE TABLE [table] ([column] VARCHAR(120), [another-column] DATETIME);
Read More
List All Indexes On A Table MySql Terminal
To see all indexes on a table enter this code. show index from [table];
Read More
Show Table Structure MySql Terminal Commands
To show the table structure in terminal use this code. describe [table];
Read More
Show Tables MySql Terminal Commands
If you want to see the tables in the database use this command. show tables;
Read More
Determine What Database Is In Use MySql Terminal Commands
If you want to know what database that you are in you can use this terminal command. select database();
Read More
Select A Database Terminal Command
You can select a database to work with by entering the following command in terminal. use [database];
Read More
Create A New Database Terminal Commands
If you want to create a new database in terminal enter the following command. create database [database];
Read More
Access a Database MySQL Terminal Command
If you're a developer working with databases, you're probably familiar with MySQL - an open-source relational database management system. While there are many ways to access a MySQL database, one of the most straightforward methods is through the MySQL te
Read More
Show all databases in MySql Terminal Command
In order to show all databases in your terminal enter the following code. show databases;
Read More
Access MySql Terminal Commands
In order to access your the mysql part in your terminal you will enter something like this. Access monitor: mysql -u [username] -p; (will prompt for password)
Read More
Disable PHP On A Directory With Htaccess
If you need to disable php on a directory with htaccess here is your script. Open up your text editor and paste this code in it.
Read More
Find Track Down That Filthy Spammer AND BLOCK THEM!
What Your Will Learn Here How to get a list of scripts that are emailing on your server. Get the IP address of the spammer Block the IP address
Read More
EXIM CHEAT SHEET
The following EXIM Cheat Sheet will help you manage your EXIM 4 server. To complete these steps, it is helpful if you already are familiar with SMTP, MTA, and UNIX shell prompt. If you are having any issues with email delivery, please check out my post on
Read More
How To Enable Javascript In Your Firefox Browser
Have you visited a domain website that seems to be broken with no style or design? When visiting a web page which appears to be broken down into basic text links you may find that your JavaScript is disabled in Firefox. No problem!
Read More