MySql Function for Date Time Input Terminal Commands

For date time input use this function. NOW()

Read More

Insert A Record MySql Terminal Command

To insert a record use this command in terminal. Customize the values. INSERT INTO [table] ([column], [column]) VALUES ('[value]', [value]');

Read More

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