Skip to main content

MYSQL Interview Questions

By
How can swap same feilds data using Mysql ?
Table Name Color


ID | Color

--------------------
1 Black
2 Whilte
3 Whilte
4 Black


We can swap feilds data using following query.

update `test` as i , test as c set i.color='black',c.color = 'white' where i.color='white' and c.color='black'

What is MYSQL ?
MySQL is an open source relational database management system (RDBMS) which uses Structured Query Language (SQL). MYSQL is the most popular language that is available for both Linux and Windows operating system.
Labels:

Comments

Post a Comment

Popular posts from this blog

Flex Interview Questions

By
1) What is Flex? Flex is used to devleop Rich Internet Application (RIA) You can both desktop & web based applicaiton.It is markup language and object-oriented languages its many syntax match with flash action script. Flex Developers use typically five distinct phases to develoep Rich Internet Application. Design Configure Build Deploy Secure 2) How do i get Page URL and Query String ? We can use mx.core.Application.application.url (mx.core)package to work with current page URL. & query string. 3) Describe flex component file types ? There are following file types we can use in flex. extension .mxml - a component implemented as an MXML file. extension .as - a component implemented as an ActionScript class. extension .swc - a SWC file contains components in a packge. 4) Difference between target & currentTarget ? target : This property is set by the dispatchEvent() method. You cannot change this to a different object. currentTarget : This property is set by component instan...
3 comments
Read more

Ethereum Programming Language

By
Solidity: The Programming Language of Ethereum Blockchain technology has revolutionized various industries by introducing decentralized and secure applications. Ethereum, one of the leading blockchain platforms, has gained immense popularity due to its ability to support smart contracts, which enable the execution of self-executing code with predefined rules. To write these smart contracts, developers use Solidity, a high-level, contract-oriented programming language specifically designed for Ethereum. In this article, we will explore Solidity in detail, including its features, syntax, use cases, advantages, and challenges. 1. Introduction to Solidity Solidity was introduced by Gavin Wood in 2014 and is the primary language for developing smart contracts on the Ethereum platform. It is a statically-typed language that supports inheritance, libraries, and complex user-defined types. Solidity code is compiled into bytecode, which can be executed on the Ethereum Virtual Machine (EVM), mak...
Post a Comment
Read more

How to Format My Source Code For Blogger ?

By
How to format my source code for blogger, blog, Blogging, weblog & website ? Now you can format you source code for blogger, blog, Blogging, weblog & website using online source code formatter. This application build in javascript. This source code beautifier or formatter provide for your blogger, Blog and websites a good code indentation. You can can format your source code with alternative background using <pre> tag. It does not add unnecessary tags in formatted source code excpet <pre> and <code> so just try onto your source code for blog or blogging & website posts . This is absolutly free online line source code formatter tool for your blogger & website. http://codeformatter.blogspot.com/ See example.. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE> New Document </TITLE> <META NAME="Generator" CONTENT=""> <META NAME="A...
2 comments
Read more