Recent questions tagged mysql

1 answer 5 views

How to find non-ASCII characters in MySQL with SQL

asked Mar 19 by avibootz

1 answer 18 views

How to select records from the last 24 hours in MySQL using SQL

asked Nov 10, 2018 by avibootz

1 answer 17 views

How to get only the first N characters of a field in MySQL with SQL

asked Sep 11, 2018 by avibootz

1 answer 16 views

How to match a whole word in MySQL with SQL

asked Sep 11, 2018 by avibootz

1 answer 12 views

How to remove rows with duplicate value in MySQL field in SQL

asked Jul 6, 2018 by avibootz

1 answer 13 views

How to count duplicate value in MySQL row field with SQL

asked Jul 6, 2018 by avibootz

1 answer 71 views

How to get last Insert id when using on duplicate key update with PDO MySQL SQL and PHP

asked Jun 12, 2018 by avibootz

1 answer 18 views

How to fetch one column from MySQL table into array using PDO and PHP

asked Jun 3, 2018 by avibootz

1 answer 10 views

How to find duplicate values in MySQL table using SQL

asked May 31, 2018 by avibootz

1 answer 16 views

How to change MySql column position without losing data in SQL

asked May 31, 2018 by avibootz

1 answer 32 views

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

asked Nov 2, 2016 by avibootz

1 answer 17 views

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

asked Oct 2, 2016 by avibootz

1 answer 17 views

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

asked Oct 2, 2016 by avibootz

1 answer 15 views

How to return rows in random order in MySQL with SQL

asked Sep 19, 2016 by avibootz

1 answer 15 views

How to order by two columns in SQL and MySQL

asked Sep 18, 2016 by avibootz

1 answer 25 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

1 answer 12 views

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

asked Sep 11, 2016 by avibootz

2 answers 24 views

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

asked Sep 11, 2016 by avibootz

1 answer 21 views

How to open a new connection to MySQL database with MySQLi object-oriented in PHP

asked Jan 7, 2016 by avibootz

1 answer 27 views

How to open a new connection to MySQL with MySQLi object-oriented in PHP

asked Jan 7, 2016 by avibootz

3 answers 45 views

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

asked Oct 14, 2015 by avibootz

1 answer 26 views

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

asked Oct 13, 2015 by avibootz

3 answers 32 views

How to use SQL ROUND() Function in MySQL

asked Oct 12, 2015 by avibootz

2 answers 34 views

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

asked Oct 11, 2015 by avibootz

2 answers 23 views

How to use SQL CHAR_LENGTH() Function in MySQL

asked Oct 10, 2015 by avibootz

2 answers 32 views

How to use SQL LENGTH() Function in MySQL

asked Oct 10, 2015 by avibootz

4 answers 24 views

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

asked Oct 9, 2015 by avibootz

1 answer 31 views

How to use SQL LCASE() function in MySQL

asked Oct 8, 2015 by avibootz

1 answer 29 views

How to use SQL UCASE() function in MySQL

asked Oct 7, 2015 by avibootz

1 answer 26 views

How to use SQL HAVING Clause in MySQL

asked Oct 6, 2015 by avibootz

1 answer 25 views

How to use SQL GROUP BY statement in MySQL

asked Oct 5, 2015 by avibootz

1 answer 35 views

How to use SQL SUM() Function in MySQL

asked Oct 4, 2015 by avibootz

2 answers 30 views

How to use SQL MIN() Function in MySQL

asked Oct 3, 2015 by avibootz

2 answers 87 views

How to use SQL MAX() Function in MySQL

asked Oct 2, 2015 by avibootz

1 answer 18 views

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

asked Oct 1, 2015 by avibootz

1 answer 21 views

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

asked Sep 30, 2015 by avibootz

2 answers 26 views

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

asked Sep 29, 2015 by avibootz

3 answers 32 views

How to use SQL COUNT() Function in MySQL

asked Sep 29, 2015 by avibootz

2 answers 34 views

How to use SQL AVG() Function in MySQL

asked Sep 28, 2015 by avibootz

1 answer 25 views

What are the MySQL Data Types?

asked Sep 27, 2015 by avibootz

1 answer 27 views

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

asked Sep 26, 2015 by avibootz

1 answer 29 views

How to get all the records except the missing unknown data in a column with SQL in MySQL

asked Sep 26, 2015 by avibootz

1 answer 22 views

How to return next row on MySQL with PHP Data Objects (PDO) for increased security in PHP

asked Sep 25, 2015 by avibootz

1 answer 30 views

How to use SQL DELETE in MySQL database with PHP Data Objects (PDO) in PHP

asked Aug 18, 2015 by avibootz

1 answer 199 views

How to use ajax to update MySQL and web page without refresh with PHP, jQuery and JavaScript

asked Jul 14, 2015 by avibootz

1 answer 87 views

How to print MySQL table with PHP Data Objects (PDO) in PHP

asked Jul 7, 2015 by avibootz

1 answer 27 views

How to use SQL UPDATE in MySQL database with PHP Data Objects (PDO) in PHP

asked Jul 7, 2015 by avibootz

1 answer 27 views

How to INSERT INTO a date ( NOW() ) with SQL in MySQL database with PHP Data Objects (PDO) in PHP

asked May 27, 2015 by avibootz

1 answer 51 views

How to INSERT INTO MySQL database with PHP Data Objects (PDO) in PHP

asked May 27, 2015 by avibootz

1 answer 27 views

How to get the number of rows from SQL query on MySQL with PHP Data Objects (PDO) in PHP

asked May 24, 2015 by avibootz

Most popular tags