Share on Google+Share on Google+

Revanth Kumar
i want 2 columns to be deleted in mysql
1 Answer(s)      4 years and 11 months ago
Posted in : PHP

i want 2 columns to be deleted in mysql The tables having the columns have no mapping

Ads

View Answers

April 30, 2012 at 4:05 PM


Use the given query:

ALTER TABLE  table_name  DROP   col_name;









Related Tutorials/Questions & Answers:
i want 2 columns to be deleted in mysql
i want 2 columns to be deleted in mysql  i want 2 columns to be deleted in mysql The tables having the columns have no mapping   Use the given query: ALTER TABLE table_name DROP col_name
I want Mini Java Project for Student Admission System. actually i want 2 know how 2 start this...please show me my way.....
I want Mini Java Project for Student Admission System. actually i want 2 know how 2 start this...please show me my way.....  I want Mini Java Project for Student Admission System. actually i want 2 know how 2 start this...please
Advertisements
mysql alter table add multiple columns
mysql alter table add multiple columns  Hi, I have a table in database. I want to add multiple columns into existing table. What is the code for mysql alter table add multiple columns? Thanks   Hi, You can use
Mysql Alter Multiple Columns
Mysql Alter Multiple Columns       Mysql Alter Multiple Columns is used to modify the table... The Tutorial illustrate an example from 'Mysql Alter Multiple Columns'. To grasp
Mysql Multiplication Columns
Mysql Multiplication Columns       Mysql Multiplication Columns is used to provide the column that is the outcome product of all the records in the respective columns of a table
Mysql Multiplication Columns
Mysql Multiplication Columns       Mysql Multiplication Columns is used to provide... 'Mysql Multiplication Columns'.To understand the example we simply create
Mysql Alter Add Multiple Columns
Mysql Alter Add Multiple Columns       Mysql Alter Add Multiple Columns is used to modify... The Tutorial illustrate an example from 'Mysql Alter Add Multiple Columns
i want for statement codding
i want for statement codding  what is the for condition following out put 1 2 2 3 3 3 4 4 4 4 5 5 5 5 5
i want to update values
i want to update values  in my form i have 2 submit buttons one... database and it need to insert automatically in to disabled text boxs and once i press the edit button all text boxs need to enable so that i can edit my details
i want to learn Jquery
i want to learn Jquery  i want to learn jquery can u plz guide me   Yes, you can learn these technologies by yourself. Go through the following links: Ajax Tutorials JSON Tutorials JQuery Tutorials
I want this jsp answers
I want this jsp answers    How can we declare third party classes and interfaces inside our jsp page? How can we declare and definr global variables... for particular jsp pages? If we want to develop any jsp pages using eclipse where we can
I want this jsp answers
I want this jsp answers    How can we declare third party classes and interfaces inside our jsp page? How can we declare and definr global variables... for particular jsp pages? If we want to develop any jsp pages using eclipse where we can
i want code for these programs
i want code for these programs   Advances in operating system Laboratory Work: (The following programs can be executed on any available and suitable platform) Design, develop and execute a program using any
i want to protect mysql database table which user can not view to table and can not copy my table till then us
i want to protect mysql database table which user can not view to table and can not copy my table till then us  i want to protect mysql database... backup of database. if user and programmer want to export and import to table
i want to protect mysql database table which user can not view to table and can not copy my table till then us
i want to protect mysql database table which user can not view to table and can not copy my table till then us  i want to protect mysql database... backup of database. if user and programmer want to export and import to table
all sequences to create jdbc and how can i use jtable to display a single columns or multiple columns
columns or multiple columns  i am 3rd year cs student in ethiopia. i have..."); ResultSetMetaData md = rs.getMetaData(); int columns = md.getColumnCount(); for (int i = 1; i <= columns; i++) { columnNames.addElement( md.getColumnName(i
struts 2 mysql
struts 2 mysql  In the example : http://www.roseindia.net/struts/struts2/struts-2-mysql.shtml how is the username and password(in insertdata.jsp) which is entered by the user is transferred to the { ("INSERT employee VALUES
I want solution for this jsp program..
I want solution for this jsp program..   <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*" %> JSP Page <%! String
plsz i want the coding details of line
plsz i want the coding details of line  package vc.api; import...)Math.ceil((max+min)/2); for (i=0;i<picture.getHeight();i...++) { 2. **if (template.getRGB(j,i)<-8388608) {//black if (random.getRGB(j,i
plsz i want the coding details of line
plsz i want the coding details of line  package vc.api; import...)Math.ceil((max+min)/2); for (i=0;i<picture.getHeight();i...++) { 2. **if (template.getRGB(j,i)<-8388608) {//black if (random.getRGB(j,i
How do I sort by mutiple columns that are in ArrayList using some comparable class
How do I sort by mutiple columns that are in ArrayList using some comparable class  Iam reading a csv file with 20 columns (all string types) in ArrayList after splitting them. I need to find how can I sort muti columns (i.e.
i want to create dynamic calendar in java
i want to create dynamic calendar in java  i want code and explanation
i want display integer number in a string of statement
i want display integer number in a string of statement  i want display integer number in a string of statement
i want to create dynamic calendar in java
i want to create dynamic calendar in java  i want code and explanation
I want to learn Hibernate tutorial quickly
I want to learn Hibernate tutorial quickly  Hello, I want to learn Hibernate tutorial quickly. Is there any way.. I want to learn Hibernate online.. Please help
same thing i want but from db..
same thing i want but from db..  http://www.roseindia.net/tutorial/javascript/dynamicCombo.html same thing i want but from db
I want detail information about switchaction? - Struts
I want detail information about switch action?  What is switch action in Java? I want detail information about SwitchAction
i want print the following out put
i want print the following out put  Hello sir i want the following out put can u provide the program in c# o/p; HELLOLLEH HELLLEH HELEH HEH H
Selecting All Columns or Specific columns
to create database and create a specific columns in MySQL .  CREATE Statement... with the column along the first row. If you want to only select columns, replace... Selecting All Columns or Specific columns  
how i want to create a coding by this question?
how i want to create a coding by this question?  Design and write a class named Person and its two subclasses named Student and Employee. Make... and email address. A student has a matric number and status (year 1, year 2
i want to pass Javascript value to JSP scriptlet..
i want to pass Javascript value to JSP scriptlet..  i am having a problem that, i am having a combo box in the JSP page when i select an item from... now i want to pass this value to JSP scriptlet
Tutorials   
Java Spring Hibernate Struts Training I am Java programmer. Should I learn Java Script or Python? Delete multiple records with pagination by selecting checkboxes How to add one hour in php date? connection in php connection in php connection in php PHP magento how to make previous and next Button Display Data in php session written exam display database results question create a simple form Magento Strings in PHP Zend Framework Installation in xampp? How to prevent adding duplicate items to the shopping cart php problem maximum execution time of 30 seconds exceeded in php Call-time pass-by-reference has been removed in HTTP_POST_VARS is deprecated $_GET[] index is not defined Function mysql_db_query() is deprecated Function mysql_db_query() is deprecated Function split() is deprecated Fatal error: Call to undefined function session_register() in .php file php tag not working Error reporting in PHP Why are MySQL Routines and Views not used with PHP? How to add Click to copy function to my wordpres blog? connection of php to MySQL. loan calculator Datepicker not getting called through include function of php change url string integrate login in php Installation of wamp server Display PHP clock with user input date and time value in div from php, reloading form pre-populate form developing a system using php n mysql Configure apache Tomcat to work with Eclipse and PDT in php How to display a file for 24 hours? LOGIN ERROR LOGIN FAILED", $_SESSION['login fail']='0',}?> I GOT ERROR FOR MY PROJECT PHP Sending emails and insert into trable Tutorial college Student Admission System PLZ HELP ME. i need php code.

Ads

 
Advertisement null

Ads