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

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
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 learn maven
I want to learn maven  Hi, I have to work on the maven based projects in my company. So, I want to learn it in 5-6 days. How to start learning Maven? Can I learn Maven in 5-6 days. Thanks
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 to learn maven
I want to learn maven  Hi, I have to work on the maven based projects in my company. So, I want to learn it in 5-6 days. How to start learning Maven? Can I learn Maven in 5-6 days. Thanks   Hi, First of all I would
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
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 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
Mysql Alter Multiple Columns
Mysql Alter Multiple Columns       Mysql Alter Multiple Columns is used to modify the table definition and rename the columns name in a table. Understand with ExampleADS
Mysql Multiplication Columns
Mysql Multiplication Columns       Mysql Multiplication Columns is used to provide... an example from 'Mysql Multiplication Columns'.To understand the example we
Mysql Multiplication Columns
Mysql Multiplication Columns       Mysql Multiplication Columns is used to provide the column... '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 table and add multiple columns to the specified table. Understand
i want to learn data science
i want to learn data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: i want... can learn the topic "i want to learn data science". Also tell me
i want to learn machine learning
i want to learn machine learning  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: i want... so that I can learn the topic "i want to learn machine learning"
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
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
I want to learn Hadoop from scratch
I want to learn Hadoop from scratch  Hi, I want to learn Hadoop from.... I have 2 years of experience in Java, JDBC and Web application development. I... for companies. Now I want to learn Hadoop including all the technologies of it. How
I want to learn Hadoop from scratch
I want to learn Hadoop from scratch  Hi, I want to learn Hadoop from.... I have 2 years of experience in Java, JDBC and Web application development. I... for companies. Now I want to learn Hadoop including all the technologies of it. How
i want to create dynamic calendar in java
i want to create dynamic calendar in java  i want code and explanation
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 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
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
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
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
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
i want to display where i entered values to same page
i want to display where i entered values to same page  hi friends !! i have a values from jsp page .and i want to store that values into DB at the same time i want to show immediatlly on same jsp page with tabular format
i want to display where i entered values to same page
i want to display where i entered values to same page  hi friends !! i have a values from jsp page .and i want to store that values into DB at the same time i want to show immediatlly on same jsp page with tabular format
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
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 (adsbygoogle = window.adsbygoogle || []).push
i want to remove specific node in xml file
i want to remove specific node in xml file   <A> <B>hi <C>by <A> <B>hellow <C>how r u ? i want to delet node which is == hellow using java program please help me . tanks in advance
I want complete tutorial on advanced java
I want complete tutorial on advanced java  I am studying advanced java like servlets, JSP's RMI EJB's JDBC & all stuff like this i want some tutorial file so that i can download it & read can anyone help me?   
i want to create an icon on my desktop... with this i want to open my web application
i want to create an icon on my desktop... with this i want to open my web application  i want to create an icon on my desktop... with this i want to open my web application(automatically run my server... )how
I want code below mention programe
I want code below mention programe  Create a web application using any technology that accepts a keyword and displays 10 relevant tweets from Twitter in real-time for that keyword
I want design samples for JSP project
I want design samples for JSP project  Sir, I world Like to do a project in jsp techonology. But i have no idea of selecting the project, especially if i selected any project i have no idea that is how to build ie how to design
I am from .net background, I want to learn SOA.
I am from .net background, I want to learn SOA.  Hi I am from .net background, I want to learn SOA. Could it possible for me to learn SOA, I suppose SOA includes Java. I dont have knowledge of java. Please help Thanks  
I want example of Control Statement in Java
I want example of Control Statement in Java  Hi, I want answer of control statements in java with example? Thanks   Hi, Control statement in Java is used to control the flow of execution of program. Here
I want to learn hibernate step-by-step.
I want to learn hibernate step-by-step.  Hello, I am very new to programming world and I am looking forward to learn Hibernate, but I would like to start from start and learn it step by step. Can you please help me.. I would
i want to know how a slide will hide
i want to know how a slide will hide  when im click on the button then im getting a slide, but when im click on the another button this slide will be hide.. and here im using logic iterate to getting the values from action class
i want to know how a slide will hide
i want to know how a slide will hide  when im click on the button then im getting a slide, but when im click on the another button this slide will be hide.. and here im using logic iterate to getting the values from action class
i want to save image on server folder. and i want to save URL of this folder and name of image in database
i want to save image on server folder. and i want to save URL of this folder and name of image in database  hi i want to save image on server folder. and i want to save URL of this folder and name of image in database.on click
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
What classes should I take if I want to become a data scientist?
What classes should I take if I want to become a data scientist?  Hi... for the tutorials to learn: What classes should I take if I want to become a data... learn the topic "What classes should I take if I want to become a data
I want to learn Machine Learning, where should I start?
I want to learn Machine Learning, where should I start?  Hi, I am... for the tutorials to learn: I want to learn Machine Learning, where should I start? Try... "I want to learn Machine Learning, where should I start?". Also tell me

Ads