answersLogoWhite

0

You can return mathematic results in your queries by doing the following:

SELECT (3-2) result

This will return a fieldname called result with the number 1 as the answer.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

Print sql query in magento commerce?

If you want to execute database queries anywhere in Magento this link will help you http://web-funda.blogspot.com/2009/06/write-mysql-database-query-in-magento.html


How do you run a MySQL query involving many fields in PHP?

A mysql query can be run with the mysql_query(); function. Unfortunately, php allows you to run a maximum of one query each time. A possibility is to write all your queries to an array();, and then have them applied in a foreach(); loop.


Can write query within the query?

Yes, you can have a query inside a query. That is known as a sub-query.


How do you retrieve an image from a database using PHP?

It depends what Database you are using. I personally use MySQL so will explain how you would do it using MySQL. You would have to create the MySQL database. I would store the image URL rather than the actual image. Then call it using PHP and a MySQL query. For Example: $sql = "SELECT * FROM Images WHERE Img_Name = 'img1'"; $query = mysql_query($sql); $array = mysql_fetch_array(query); then you would call it into HTML like so:


Are query results saved after the query is executed?

The results are not saved, but the query can be. If the query has been saved, then it can be run at any time to retrieve the data. So it is not necessary to save the data itself. You can write queries that will select data and write it to a new table, in which case the results are being saved.


Where can one find tutorials on writing queries?

Tutorials on writing queries can be found in a number of places depending on what type of query you would like to write. For example, if you would like to write a query letter to a literary agent, you can find excellent advice at Absolute Write. You can also visit your local library and purchase books on how to write query letters.


What are expenses such as heat light and salary called?

Salary is not an expense. -Please re-write so it makes a logical query.


How do you work on mysql workbench?

To work with MySQL Workbench, first, download and install the software from the MySQL website. Once installed, you can create a new connection to your MySQL server by entering the necessary credentials. Use the SQL Editor to write and execute queries, manage databases, and design schemas visually. Additionally, you can utilize built-in tools for data modeling, server administration, and performance tuning.


How can you export data from MySQL to PDF using PHP?

If you know FPDF or simlar library which helps to make a PDF file, using PHP,you will be able to write to a PDF file out of data read from mysql tables.


What is query expression in net?

Query expressions are a declarative query syntax .Query expressions allows a programer to write queries in a high-level language.It is similar to Transact-SQL or XQuery. By using query expression ,complex data source operations like filtering, ordering, and grouping operations on data sources can be perform easily with less code.


How do you write a response to a query letter at work?

One should be polite in their response to a query letter at work. One should be clear and simple with their response and reply as quickly as possible.


How do you write a letter to the party of rejected material return?

How do you write a rejection letter after return to party