MySQL Installation
After installing MySQL, go to MySQL directory on your pc, open the file my.ini and change the data directory where you’ll store all your data in the future. By default, it’ll define your pc’s Documents directory as shown below. datadir=”C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/” However you can point it to Data directory under MySQL dir.
Saturday March 21st from 9:00pm to 11:00pm PST
247Apps Scheduled Maintenance We will be making some improvements to our servers to provide greater reliability and performance for our customers. From 9:00pm to 11:00pm PST, Saturday March 21st, we will be conducting some hardware upgrades to our servers. Services for software Elementor, Rental Plugins, Custom Calculation customers will be affected. While you may continue to work in open applications, you may experience an interruption to web services during the maintenance period. We apologize for any inconvenience this disruption may cause and thank you…
Applying mathematics directly to database table
When your company decides to reduce the prices of all products to 5% during this difficult economic time, what will you do to adjust the product prices in your database. Here is what I will show you. If you perform the query directly to production database, first, I would recommend you duplicate the product table in case you enter an incorrect query. I always do this when I run query to change data in database. Then write you query UPDATE tbl_products SET price = price –…
Concatenate 2 or more fields from a database table
If you want to get a result of firstname and lastname together as a single field, you will use CONCAT_WS(separator string, field1, field2,…) function. Here’s I will show you how. For example, a table name Manager has 4 fields and some records as shown below. id firstname lastname email_address 1 Linda Doe linda@mynetworksolutions.com 2 Didi Menita didi@yahoo.com 3 Jane Doe jane@adobe.com 4 Elisa Bethoni bethoni@microsft.com You will use the following query statement to produce the expected result as shown below. SELECT id, CONCAT_WS(‘ ‘,firstname,lastname) AS…
Mathematical Functions in MySQL
Name Description ABS() Return the absolute value ACOS() Return the arc cosine ASIN() Return the arc sine ATAN2(), ATAN() Return the arc tangent of the two arguments ATAN() Return the arc tangent CEIL() Return the smallest integer value not less than the argument CEILING() Return the smallest integer value not less than the argument CONV() Convert numbers between different number bases COS() Return the cosine COT() Return the cotangent CRC32()(v4.1.0) Compute a cyclic redundancy check value DEGREES() Convert radians to degrees EXP() Raise to the…