Use the following command for stop a process using port 80 .This example is based on Ubuntu Linux operating system. Commands need to run in terminal sudo netstat -lpn |grep :80 tcp6 0 0 :::80 :::* LISTEN 1185/apache2 sudo kill 1185
Tag: Mysql
Maximum range of varchar in MySQL
Varchar() is a datatype in MySQL. The length of Varchar() is varies from 0 – 65,535. The important feature of this data type is ,it only using the bytes wants to store data,no wastage of memory.
How to ALTER table in SQL
ALTER a table in SQL Use the following commands for add,change,drop table fields in SQL. SQL>AlTER TABLE <Table name> <ADD,DROP,CHANGE> <field name> ALTER TABLE `test` ADD `test INT NOT NULL ALTER TABLE `test` DROP `name` ALTER TABLE `test` CHANGE `name` `student_name` INT( 11 ) NOT NULL
mysql table alter query
We can use the following query for add new field to table. this types of queries are alter queries Syntax :ALTER `<table name>` ADD `<fieldname>` <type> <option> Example: ALTER TABLE `engine4_core_poll_societies` ADD `soc_admin` INT NOT NULL