Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

MySQL

MySQL is a Relational Database Management System. It was first released in 1995 and is most commonly used with the PHP programming language. MySQL is open source and 100% free to use.

500 Questions

JSP and Servlets

MySQL

How do you retrieve table data from mysql to jsp?

Asked by Wiki User

<%@ page import ="java.sql.*" %>

<%@ page import ="javax.sql.*" %>

<%@ page import ="java.io.*" %>

<%@ page language="java" import="java.util.*,java.text.SimpleDateFormat;" pageEncoding="ISO-8859-1"%>

<html>

Calendar currentDate = Calendar.getInstance();

SimpleDateFormat formatter= new SimpleDateFormat("dd/MM/yyyy");

String dateNow = formatter.format(currentDate.getTime());

String nam=(String)request.getAttribute("uname");

String pwd=(String)request.getAttribute("pwd");

request.setAttribute("date",dateNow);

request.setAttribute("nam",nam);

request.setAttribute("pwd",pwd);

System.out.print(nam);

String full_name=request.getParameter("fname");

String cn=request.getParameter("name");

String deg=request.getParameter("designation");

String ema=request.getParameter("email");

String mobile=request.getParameter("mob_no");

String serial=request.getParameter("ser_no");

String department=request.getParameter("deptt_name");

String off_add=request.getParameter("office_address");

String st_name=request.getParameter("state_name");

String spin=request.getParameter("pin");

String phn_no=request.getParameter("phone_no");

String svar1=request.getParameter("srvip");

String svar2=request.getParameter("srvloc");

String svar3=request.getParameter("destport");

String svar4=request.getParameter("descrsrv");

String placen=request.getParameter("place");

String vdate=request.getParameter("date");

String rname=request.getParameter("r_name");

String rdesg=request.getParameter("r_designation");

String remail=request.getParameter("r_email");

String rphone=request.getParameter("r_phone");

String cname=request.getParameter("c_name");

String cdesg=request.getParameter("c_designation");

String cemail=request.getParameter("c_email");

String cphone=request.getParameter("c_phone");

String issby=request.getParameter("captchatext");

Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost/vpn","root","test123");

Statement st= con.createStatement();

int i=st.executeUpdate("insert into vpn_registration(cname,name,designation,email,mobile,serial_no,name_dept,off_add,state,pincode,off_phone,place,rname,rdesign,rmail,rmob,c_name,cdesign,cmail,cmob,issuedby) values ('"+cn+"','"+full_name+"','"+deg+"','"+ema+"','"+mobile+"','"+serial+"','"+department+"','"+off_add+"','"+st_name+"','"+spin+"','"+phn_no+"','"+placen+"','"+rname+"','"+rdesg+"','"+remail+"','"+rphone+"','"+cname+"','"+cdesg+"','"+cemail+"','"+cphone+"','"+issby+"')");

Statement st1= con.createStatement();

int y=st1.executeUpdate("insert into server_details(registration_no,serip,serloc,destport,desc_service) values ('"+svar1+"','"+svar2+"','"+svar3+"','"+svar4+"')");

st.close();

con.close();

<head>

<title>ONLINE VPN REGISTRATION FORM</title>

<style>

a, A:link, a:visited, a:active

{color: #0000aa; text-decoration: none; font-family: Tahoma, Verdana; font-size: 11px}

A:hover

{color: #ff0000; text-decoration: none; font-family: Tahoma, Verdana; font-size: 11px}

p, tr, td, ul, li

{color: #000000; font-family: Tahoma, Verdana; font-size: 11px}

.header1, h1

{color: #ffffff; background: #4682B4; font-weight: bold; font-family: Tahoma, Verdana; font-size: 13px; margin: 0px; padding-left: 2px; height: 21px}

.ctrl

{font-family: Tahoma, Verdana, sans-serif; font-size: 12px; width: 100%;}

.btnform

{border: 0px; font-family: tahoma, verdana; font-size: 12px; background-color: #DBEAF5; width: 100%; height:18px; text-align: center; cursor: hand;}

.btn

{background-color: #DBEAF5; padding: 0px;}

textarea, select,input

{font: 9px Verdana, arial, helvetica, sans-serif; background-color: #DBEAF5;}

</style>

function addRow(tableID) {

var table = document.getElementById(tableID);

var rowCount = table.rows.length;

if(rowCount>6)

{

alert("Cannot add more than 6 rows.");

return false;

}

document.getElementById("rowlength").value=rowCount;

var row = table.insertRow(rowCount);

var counts=rowCount-1;

var cell0 = row.insertCell(0);

var chk = document.createElement("input");

chk.type = "checkbox";

chk.name="chk"+counts+"";

cell0.appendChild(chk);

var cell1 = row.insertCell(1);

var srvip = document.createElement("input");

srvip.name="srvip"+counts+"";

srvip.id="srvip"+counts+"";

srvip.className='ctrl';

srvip.type = "text";

//srvip.onClick="hello()";

cell1.appendChild(srvip);

var cell2 = row.insertCell(2);

var srvloc = document.createElement("input");

srvloc.type = "text";

srvloc.className='ctrl';

srvloc.name="srvloc"+counts+"";

cell2.appendChild(srvloc);

var cell3 = row.insertCell(3);

var destport = document.createElement("input");

destport.type = "text";

destport.className='ctrl';

destport.name="destport"+counts+"";

destport.id="destport"+counts+"";

cell3.appendChild(destport);

var cell4 = row.insertCell(4);

var descrsrv = document.createElement("input");

descrsrv.type = "text";

descrsrv.className='ctrl';

descrsrv.name="descrsrv"+counts+"";

cell4.appendChild(descrsrv);

}

</SCRIPT>

function clearFields()

{

document.cmaForm.reset();

}

</script>

function deleteRow(tableID) {

try {

var table = document.getElementById(tableID);

var rowCount = table.rows.length;

for(var i=0; i<rowCount; i++) {

var row = table.rows[i];

var chkbox = row.cells[0].childNodes[0];

if(null != chkbox && true == chkbox.checked) {

if(rowCount <= 2) {

alert("Cannot delete all the rows.");

break;

}

table.deleteRow(i);

rowCount--;

i--;

}

}catch(e) {

alert(e);

}

</SCRIPT>

function setid()

{

var x=document.cmaForm.rowlength.value;

//alert(x);

document.cmaForm.id=x;

return true;

}

</script>

</head>

<tr>

</tr>

</table>

<tr>

<td class="header1" nowrap>NIC VPN Services<img src="img/line9.gif" width="10" height="1" border="0"></td>

</tr>

<tr>

<td colspan="7" align="center"><font size="2">National Infomatics Centre <br> Department of Information Technology<br>Ministry of Communications and Information Technology

<br> Government of India</font></td>

</tr>

<td colspan="7" align="center"><font size="2" color="white"><b>VPN Registration Form</b></font></td>

</tr>

<td colspan="7"><b>Note:</b>  Fields marked<font size="2" color="red"> * </font>are mandatory.

</td>

</tr>

<logic:present name="fail">

</logic:present>

<td colspan="7" align="center"><b>SECTION I : SUBSCRIBER INFORMATION</b></td>

</tr>

<td colspan="7"> 1.1 Personal Details:</td>

</tr>

<td colspan="1" width="5%"> Common Name:</td>

<td colspan="5" width="50%"><input type="text" name="name" value="<%= request.getParameter("uname")%>" readonly="readonly"class="ctrl"></td>

</tr>

<td width="15%"> Designation:<font size="2" color="red">* </font></td>

<td colspan="1" width="5%"> E-mail Address:<font size="2" color="red">* </font></td>

</tr>

<td width="15%"> Mobile:<font size="2" color="red">* </font></td>

<td colspan="1" width="5%"> DC Serial No.:</td>

<td colspan="5" width="50%"><input type="text" name="ser_no" value="<%= request.getParameter("pwd")%>" readonly="readonly"class="ctrl" size="10"></td>

</tr>

<td colspan="7"> 1.2 Official Address:</td>

</tr>

<td> Name of the Department:<font size="2" color="red">* </font></td>

</tr>

<td > Office Address:<font size="2" color="red">* </font></td>

</tr>

<td width="15%"> State:</td>

</tr>

<td width="15%" > Office Telephone:</td>

</tr>

<td colspan="7"> 1.3 List of Server to access through VPN:<font size="2" color="red">* </font></td>

</tr>

<TR>

<TD width="150">IP Address of the Server</TD>

<TD width="196">Location of the Server</TD>

<TD width="167">Destination Port</TD>

<TD width="162">Website/URL of Servers</TD>

</TR>

<TR>

<TD>

</TD>

</TR>

</TABLE>

</td>

</tr>

</tr>

<td colspan="7" align="center"><font size="2"><u>DECLARATION</u></font></td>

</tr>

<td colspan="7">I hereby declare that<br>     1. The information provided is correct.<br>

     2. Is responsible for the safety of the Digital Certificate, PIN, Username and Password issued for accessing VPN Service.<br>

     3. I undertake to surrender the VPN account and Digital certificate on transfer / leaving the division.<br>

     4. The certificate and VPN account are issued will be used only for accessing the NIC VPN Service as per the list provided in 1.3.<br>

     5. Will not indulge in any activity and no attempt will be made to gain unauthorized access to other NIC Websites and facilities.<br>

     6. I am responsible for the content/ data uploaded in the servers through VPN connection.<br>

 I have read the terms and conditions of NIC VPN Services and will comply with. If at a later stage any information is found to be incorrect or non-compliance with the terms and conditions will result in the cancellation of the DC issued by NIC for NIC VPN service.</td>

</tr>

<td width="15%"> Place:<font size="2" color="red">* </font></td>

</tr>

<td colspan="7" align="center"><b>SECTION II : RECOMMENDATION</b></td>

</tr>

<td colspan="7"> This is to certify that the person as identified in SECTION-I has provided correct information and is authorized on behalf of the organization to update and access servers listed in 1.3.<br>

 I shall intimate NIC VPN Division to deactivate the account when the person is transferred / relived from responsibility for which the VPN account and digital certificate is issued.

</td>

</tr>

<td colspan="7"> 2.1 Verification by Recommending/Reporting/Head of Office</td>

</tr>

<td colspan="1" width="5%"> Designation:<font size="2" color="red">* </font></td>

</tr>

<td width="15%"> E-mail Address:<font size="2" color="red">* </font></td>

<td colspan="1" width="5%"> Contact No.:<font size="2" color="red">* </font></td>

</tr>

<td colspan="7" align="center"><b>SECTION III : Verification by NIC-Coordinator</b></td>

</tr>

<td colspan="7" align="left" ><a href="http://webservices.nic.in/webcoord.aspx" target="blank"> <u>  Please refer the authorised NIC Web Co-ordinator</a></u></td>

</tr>

<td colspan="7"> User Category: Free / Paid<br>

 If free enclose the copy of the approval.<br>

 If paid, then confirm the period for which payment is made: From:.................To:.................<br>

 Project No. ......................................................................................................................<br>

 The web sites mentioned at 1.3 (a) in SECTION-I am correct. The subscriber is the authorized person to update this web site and require VPN Services. Permission may give for the same.<br>

 I shall intimate NIC VPN division to deactivate the account when the person is transferred / relived from responsibility for which the VPN account and digital certificate is issued.

</td>

</tr>

<td colspan="1" width="5%"> Designation:<font size="2" color="red">* </font></td>

</tr>

<td width="15%"> E-mail Address:<font size="2" color="red">* </font></td>

<td colspan="1" width="5%"> Contact No.:<font size="2" color="red">* </font></td>

</tr>

<td width="15%"> Enter the Letters:<font size="2" color="red">* </font></td>

</tr>

</table></td></tr></table>

</td>

</tr>

<tr>

<tr>

</tr>

</table>

</td>

</tr>

</table>

</form>

<td align="center"><font face="Tahoma">For any query please contact VPN Support:</font><font color="blue" face="Tahoma">vpnsupport[at]nic[dot]in</font>

<br>

<font face="Tahoma">Contact No:</font> <font color="blue" face="Tahoma">+91-11-24305391 / 99</font></td>

</tr>

<logic:present name="fail">

${fail}

</logic:present>

</table>

</body>

</html>

MySQL

What is connection in database?

Asked by Wiki User

Connection is the process of linking your website or web application to the mysql database. So it cannot be a data within the database. The login & password or Signup details can be part of the database but not the connection.

Software and Applications (non-game)

Business Plans

MySQL

What role do decision support system play in the business environment?

Asked by Wiki User

Typical roles decision support systems (DSS) play in business modeling are around advocating a certain thought around decision making use of the underlying data. For example : identifying from the underlying data who are the most profitable customers, what products are selling well in a certain market etc ...for organizations DSS could help in cost management as well (where is money getting spent for what) .. it could help in defining marketing strategy, it could help is supply chain management and pretty much in the whole ecosystem of the organization.

Database Programming

Microsoft Access

MySQL

What are the advantages of an SQL database as compared to a MS Access database?

Asked by Wiki User

There are many differences between Oracle and Access. First, you need to know that Oracle and Access are both relational database engines. Oracle is sold by Oracle Corporation and Access is sold by Microsoft. The biggest differences between the two are the size and number of users each supports. Oracle is a scalable enterprise database engine that supports from one to many (tens to hundreds of thousands) of simultaneous users. Access on the other hand is most commonly used as a single-user database but since the release of Access 97, can be augmented with Visual Basic code and can easily support 100+ simultaneous users (Top limit of 200 users). Oracle can support very large databases (Tens of Terabytes in size or larger), while Access is designed for much smaller databases in the 1 to 2 gigabyte size range. Oracle has a wide range of support features that can be used to monitor and tune database performance - Access is much more limited in its performance tuning capabilities. Microsoft's SQL Server rdbms is a direct competitor with Oracle and has a great many more similarities with Oracle. There are numerous incompatibilities between Access/Jet SQL and Oracle SQL, including, but not limited to the following:

1. The date delimiter is "#" in Access and " ' " (single quote) in Oracle and SqlServer.

2. In CHAR Datatype, Oracle returns trailing spaces. Access does not return trailing spaces in String data type. In Oracle, use VarChar2 Datatype.

3. Jet allows use of the "Join" keyword. Oracle uses "(+)" following the joined field(s). Join is not a recognized word in Oracle.

4. IIF() is allowed in Jet but in Oracle, you must use the DECODE function. See Oracle documentation.

5. The following functions in Jet must be translated in Oracle.

Mid(fld, 2, 2) - Substr(fld, 2, 2)

Left(2) - Substr(fld, 1, 2)

Right(n) - Substr( fld, Instr(...),n)

Len() - LENGTH()

Year(Fld) = 1997 - to_char(Fld, 'yyyy') = '1997'

Month(Fld) = 6 - to_char(fld, 'mm') = '06'

Trim(Fld) - LTrim() or RTrim()

6. Generally, you need to use "to_date('01/23/1978', 'mm/dd/yyyy')" to format a date for comparison in Oracle SQL whereas in Jet Sql you could simply use "#01/23/1978#".

7. "RENAME" is a reserved word in Oracle and is therefore an illegal field or table name, but not in Jet.

8. If a memory variable is used in a SQL statement, and the variable is a string with trailing spaces, Jet will trim the value before comparing to the database field. Oracle will not! Therefore, the following will work in Jet but not Oracle, assuming the Oracle field in VARCHAR[2].

Sql = " ... where fldname = 'abc ' ...."

9. Oracle SQL will not find uppercase data in the database if the value in the SQL statement is lowercase. Assume that the LastName field contains the value 'SMITH' in the Oracle table Policy. Access will make a find on the following SQL and Oracle will not (Like character would be "*" for Access.

select * from Policy where LastName Like 'smith%'

10. Conversion of Memo (Jet) fields to Oracle can be a problem. The only data type in Oracle that is analogous to the Memo in Jet is the Long. Although it can hold up to 2gb of string data, you cannot append more than approximately 5,000 characters to the existing Long field because you exceed the length of the maximum string length in an Oracle SQL Statement.

Additionally, you cannot use such expressions, as the following, usable in Jet, in Oracle. They result in the error, "Invalid use of Long Datatype."

select distinct LONGFLD

Length(LONGFLD)

It seems impossible to use a query to determine rows where there is data in the Long field since a Long field that has '' in it is not Null.

Oracle 8 has Append and Get Chunk commands, but the documentation in the Oracle 7.2 Book does not mention these functions, nor are there any examples of how to update a Long field that exceeds 5,000+ characters.

11. Use of the following sql can be extremely slow in Oracle.

select * from table where policy in

(select policy2 from table2 where .....)

Try using the Oracle Minus operator instead. It uses indexes where the "in (select...)" does not. See the Oracle documentation for usage of the Minus.

12. It is normal, when using Jet, to fill the recordsource property of a data control at design time, even if you are going to fill it with a specific SQL sometime after Form_Load. This is done in order to use the Grid Designer when a data control is bound to a Grid or Combo, etc. However, when the form loads, all such data controls are refreshed. If you have the table name as the data control recordsource, which would be normal for designer use, and assuming that dbSQLPassThrough is being used, the entire table is returned to the client machine and refreshed into the grid, even if the grid is not visible, i.e., on a different tab. In Jet, this will not be the case if "UseExactRow" property is not set and therefore will not take an inordinate amount of time, but in Oracle it could be disastorous!

An easy way to deal with this is to set the recordsource to "" in the Form_Load event, especially if you are connected to Oracle. Later on, your code will set the recordsource to the specific SQL as required. Note that this must be done in the Form_Load because the Grid will be refreshed by the time the Activate Event is fired.

13. Be aware that, when using dbSQLPassThrough, the entire recordset, specified by the SQL, is returned to the client machine, and is therefore readonly. At this point the recordset belongs to the client, and Oracle is out of the picture. In praticality, there is no difference between a Snapshot and Dynaset in passthrough mode.

14. Use of apostrophes (') in names and abbreviations are a problem in SQL. In Access, it may be circumvented by use of the double quote (") to encapsulate string data in the SQL statement instead of the apostrophe, thus allowing the use of the (') in the string. In Oracle, you can use two single quotes ('') to denote an apostrophe. The string below is valid in Oracle Sql.

... Set Lastname = 'O''Toole',...

15. In Access, an empty string ("") is not Null. Oracle's default parameter for Null is set to '' (double single quotes or empty string). In other words, Oracle, by default, treats an empty string field as Null. Therefore, the following code which works in Access, does not work in Oracle.

...Where RTrim(Fld) <> ''.....

In Oracle, change the SQL to:

... Where Fld is not null....

Also, the following sql will not work if a field is Null.

... Where THSTATE <> 'Z'...

Even though the field is null, and therefore <> 'Z', the row containing the Null field will not be returned. In order to get the row, you must enhance the SQL as:

...where (THSTATE <> 'Z' or THSTATE is Null)...

WHATEVER YOU THINK NULL IS, IT ISN'T!

16. When using dbSQLPassThrough with DAO, the RecordsAffected Property will always return -1, and there is apparently no way to determine whether any records were affected by an action sql or not.

17. When printing an error message from ODBC, if you print Error, as in the errors object, you will print "ODBC Call Failed", which is useless. Instead, print Errors(0).Description (or both) and you will get the true error description returned from the ODBC data source.

18. If you are having trouble with a bound data control returning less than the correct number of row, i.e., returns 100 rows when it should have returned 200 or more, set the DefaultCursorType to 1 (ODBC Cursor). For some reason this is not always required, but it will solve the problem of truncated recordsets in a data control connected to Oracle.

19. Access allows an Order By clause at the end of a query that uses a Union, but if you try this in Oracle, it will not work because Oracle ignores the column names in the result set from the Union. Not to worry! You can Order By column positions from the select statement. In other words, if Policy is returning in column 3 of the result set, and you want to order by Policy, then use "Order By 3..."

Database Programming

Companies

MySQL

Oracle Database

What are the benefits of using ER diagrams?

Asked by Wiki User

ER diagrame shows the relationship among entities.

Microsoft Access

MySQL

How can you create table using datasheet view?

Asked by Wiki User

When you open Access, Select NEW. The New tab provides several ways that you can create a new database including "TABLE View" which then looks like a datasheet

Computers

Computer Programming

MySQL

Similarities Between

Similarities between computer language and programming language?

Asked by Wiki User

They run things using Yahoo+ code. For mor info contact me via my IM .... kaybee_0@yahoo

Libraries and Library History

Computer Science

MySQL

You want UML diagrams for library management system?

Asked by Wiki User

An Online Public Access Catalog (OPAC) is e-Library website which is part of Integrated Library System(ILS), also known as a Library Management System (LMS), and managed by a library or group of libraries.

Patrons of the library can search library catalog online to locate various resources - books, periodicals, audio and visual materials, or other items under control of the library. Patrons may reserve or renew item, provide feedback, and manage their account.

See example of UML diagram in the link.

Java Programming

MySQL

Oracle Database

What are Java applets used for in programming?

Asked by Wiki User

Java Applets: Their Uses in Programming - AchieversIT

Java Applets were once a popular technology for web-based interactivity and dynamic content. However, their usage has declined in recent years due to security concerns and the emergence of alternative web technologies like HTML5 and JavaScript. Nonetheless, Java Applets have historically been used in programming for various purposes:

Interactive Web Content:

Java Applets were initially designed to enhance web pages with interactive and dynamic features. They allowed developers to embed interactive games, animations, calculators, and other interactive elements directly within web browsers.

Data Visualization:

Applets were used to create interactive data visualizations, such as charts, graphs, and diagrams, that could be displayed within web pages. This was especially useful for presenting complex data in a user-friendly manner.

Educational Tools:

Java Applets were employed in the development of educational websites and e-learning platforms. They allowed educators to create interactive simulations, quizzes, and tutorials for online learning.

Online Games:

Java Applets were popular for developing web-based games. They provided a platform-independent way to deliver games to users through web browsers.

Scientific and Engineering Applications:

In scientific and engineering fields, Java Applets were used to create simulations and modeling tools. Researchers and students could interact with these simulations to better understand complex phenomena.

Business Applications:

Some businesses used Java Applets for web-based applications, such as data entry forms, calculators, and product configurators, to engage users and facilitate online transactions.

Real-Time Collaboration:

Applets supported real-time collaboration features in web applications. Users could collaborate on documents, drawings, and other content within a web-based environment.

Embedded Systems Configuration:

In certain cases, Java Applets were used for configuring and controlling embedded systems, such as network devices and industrial machinery, via web interfaces.

It's important to note that while Java Applets offered advantages in terms of cross-platform compatibility and rich interactivity, they also had drawbacks, particularly in terms of security vulnerabilities and the need for browser plugins. As a result, their use has decreased, and modern web development has largely shifted toward technologies like HTML5, JavaScript, and CSS for creating dynamic and interactive web content.

At AchieversIT, we provide comprehensive Java training that covers a wide range of Java technologies and programming concepts, including Java Applet development, to equip students with a solid foundation in Java programming.

Computer Programming

MySQL

Which computer programming languages are the standard?

Asked by Shanesmith89

The older languages are still the standards by which modern programming languages are measured. Fortran, COBOL, Lisp, and C/C++ are all used as baselines to evaluate newer languages. Of course, the "new kids" are being used as standards more and more often. Java, Ruby, Perl, Python, and other more modern languages are being used to measure how "good" a new language is.

C Programming

MySQL

Oracle Database

How three pass compiler works?

Asked by Wiki User

C Programming

C++ Programming

MySQL

What drug helps to lose weight the fastest?

Asked by Wiki User

Eating a healthy, varied diet that is high in fruits and vegetables — including soluble fiber, vitamin D, and probiotics — is the best plan for losing weight from your waistline. Avoiding refined carbohydrates, sugar, and processed foods whenever possible will help you cut calories and get rid of fat more quickly.reduce

How quickly will you lose weight? The volunteers reduced their waist sizes by an average of 1 inch for every 4lb (1.81kg) they lost. So if you lose 1lb (0.45kg) a week you could hope to your waistline by an inch after four weeks. If you are interested to know the amazing secret tips which helps me lose weight fast then click on the link in my bio

Computer Programming

Database Programming

MySQL

Describe the 3 levels of government?

Asked by Wiki User

depending on what country you live in, here in Canada we have municipal, provincial and then federal.

Electronics Engineering

Database Programming

MySQL

Oracle Database

What is the dbm?

Asked by Wiki User

it is the power ratio in decibels

No, it isn't. dB on its own is a ratio.

But when dB has a suffix, the figure is an absolute measurement, not a ratio.

For instance, dBm is a measurement of power compared to 1mW.

0dBm means zero difference between 1mW and the measured figure. In other words the measured figure is also 1mW.

3dBm is 3dB greater than 1mW. -3dB is 3dB less than 1mW. etc.

Another suffix is W. 0dBW being 1 watt.

There are many more suffixes, some of which are used in only a few specialised cases.

Computer Programming

Computer History

C Programming

MySQL

Is SQL a high level language?

Asked by Wiki User

Yes, SQL is a high level language, since it allow us to get result without much going into Assembly level instructions, by using interpreter to change our statements/queries into machine level instructions!.

Database Design

MySQL

Oracle Database

What does the expression 1 5 evaluate to?

Asked by Wiki User

Jobs & Education

Rain and Flooding

Volcanoes

MySQL

Briefly explain the three form of moral dimension?

Asked by Wiki User

Electronics Engineering

MySQL

Is primary key required if you have a candidate key?

Asked by Wiki User

MySQL

Oracle Database

How do you represent key constraints in ER diagram?

Asked by Amrj555

MySQL

What is granularity in sql database?

Asked by Wiki User

lowest level of data

Marketing Advertising and Sales

Visual Basic Programming

MySQL

Synopsis for employee management system?

Asked by Wiki User

synopsis of employee details

MySQL

What is data manipulating language?

Asked by Wiki User

DML is a subset of SQL (Structured Query Language) that is used to insert, delete and revise records (or 'tuples') in a relational database. The precise definition of DML varies considerably with the database system with which it is associated.