Recent questions tagged sql

1 answer 29 views

How to generate 1 letter URLs and INSERT INTO MySQL with PDO in PHP

asked Nov 2, 2016 by avibootz (468,280 points)

1 answer 12 views

How delete all rows that have a field with more than N characters in MySQL with SQL

asked Oct 2, 2016 by avibootz (468,280 points)

1 answer 7 views

How to get the length (count how many characters) of a field in MySQL with SQL

asked Oct 2, 2016 by avibootz (468,280 points)

1 answer 9 views

How to return rows in random order in MySQL with SQL

asked Sep 19, 2016 by avibootz (468,280 points)

1 answer 8 views

How to order by two columns in SQL and MySQL

asked Sep 18, 2016 by avibootz (468,280 points)

1 answer 21 views

How to use SQL INSERT INTO and UPDATE ON DUPLICATE KEY (to avoid duplicate error) in MySQL with PDO in PHP

asked Sep 13, 2016 by avibootz (468,280 points)

1 answer 8 views

How to find all the max values of a field in MySQL table with SQL

asked Sep 11, 2016 by avibootz (468,280 points)

2 answers 16 views

How to find the max value of a field in MySQL table with SQL

asked Sep 11, 2016 by avibootz (468,280 points)

3 answers 34 views

How to format SQL NOW() Function (current system date and time) in MySQL

asked Oct 14, 2015 by avibootz (468,280 points)

1 answer 18 views

How to use SQL NOW() Function (current system date and time) in MySQL

asked Oct 13, 2015 by avibootz (468,280 points)

3 answers 23 views

How to use SQL ROUND() Function in MySQL

asked Oct 12, 2015 by avibootz (468,280 points)

2 answers 29 views

What is the different between SQL LENGTH() and CHAR_LENGTH() Functions in MySQL

asked Oct 11, 2015 by avibootz (468,280 points)

2 answers 16 views

How to use SQL CHAR_LENGTH() Function in MySQL

asked Oct 10, 2015 by avibootz (468,280 points)

2 answers 18 views

How to use SQL LENGTH() Function in MySQL

asked Oct 10, 2015 by avibootz (468,280 points)

4 answers 19 views

How to use SQL MID() and SUBSTRING() functions in MySQL

asked Oct 9, 2015 by avibootz (468,280 points)

1 answer 23 views

How to use SQL LCASE() function in MySQL

asked Oct 8, 2015 by avibootz (468,280 points)

1 answer 21 views

How to use SQL UCASE() function in MySQL

asked Oct 7, 2015 by avibootz (468,280 points)

1 answer 17 views

How to use SQL HAVING Clause in MySQL

asked Oct 6, 2015 by avibootz (468,280 points)

1 answer 19 views

How to use SQL GROUP BY statement in MySQL

asked Oct 5, 2015 by avibootz (468,280 points)

1 answer 27 views

How to use SQL SUM() Function in MySQL

asked Oct 4, 2015 by avibootz (468,280 points)

2 answers 18 views

How to use SQL MIN() Function in MySQL

asked Oct 3, 2015 by avibootz (468,280 points)

2 answers 75 views

How to use SQL MAX() Function in MySQL

asked Oct 2, 2015 by avibootz (468,280 points)

1 answer 14 views

How to get the last value of the selected column in SQL in MySQL

asked Oct 1, 2015 by avibootz (468,280 points)

1 answer 14 views

How to get the first value of the selected column in SQL in MySQL

asked Sep 30, 2015 by avibootz (468,280 points)

2 answers 20 views

How to get the number of records in a table with SQL in MySQL

asked Sep 29, 2015 by avibootz (468,280 points)

3 answers 25 views

How to use SQL COUNT() Function in MySQL

asked Sep 29, 2015 by avibootz (468,280 points)

2 answers 25 views

How to use SQL AVG() Function in MySQL

asked Sep 28, 2015 by avibootz (468,280 points)

1 answer 21 views

How to make calculation on SELECT when we have NULL value in some fields with SQL and MySQL