Recent questions tagged mysql

1 answer 5 views

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

asked Jun 12 by avibootz

1 answer 7 views

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

asked Jun 3 by avibootz

1 answer 5 views

How to find duplicate values in MySQL table using SQL

asked May 31 by avibootz

1 answer 6 views

How to change MySql column position without losing data in SQL

asked May 31 by avibootz

1 answer 29 views

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

asked Nov 2, 2016 by avibootz

1 answer 13 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 8 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 9 views

How to return rows in random order in MySQL with SQL

asked Sep 19, 2016 by avibootz

1 answer 9 views

How to order by two columns in SQL and MySQL

asked Sep 18, 2016 by avibootz

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

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

2 answers 17 views

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

asked Sep 11, 2016 by avibootz

1 answer 15 views

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

asked Jan 7, 2016 by avibootz

1 answer 24 views

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

asked Jan 7, 2016 by avibootz

3 answers 36 views

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

asked Oct 14, 2015 by avibootz

1 answer 19 views

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

asked Oct 13, 2015 by avibootz

3 answers 24 views

How to use SQL ROUND() Function in MySQL

asked Oct 12, 2015 by avibootz

2 answers 29 views

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

asked Oct 11, 2015 by avibootz

2 answers 16 views

How to use SQL CHAR_LENGTH() Function in MySQL

asked Oct 10, 2015 by avibootz

2 answers 18 views

How to use SQL LENGTH() Function in MySQL

asked Oct 10, 2015 by avibootz

4 answers 19 views

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

asked Oct 9, 2015 by avibootz

1 answer 24 views

How to use SQL LCASE() function in MySQL

asked Oct 8, 2015 by avibootz

1 answer 22 views

How to use SQL UCASE() function in MySQL

asked Oct 7, 2015 by avibootz

1 answer 18 views

How to use SQL HAVING Clause in MySQL

asked Oct 6, 2015 by avibootz

1 answer 19 views

How to use SQL GROUP BY statement in MySQL

asked Oct 5, 2015 by avibootz

1 answer 27 views

How to use SQL SUM() Function in MySQL

asked Oct 4, 2015 by avibootz

2 answers 21 views

How to use SQL MIN() Function in MySQL

asked Oct 3, 2015 by avibootz

2 answers 78 views

How to use SQL MAX() Function in MySQL

asked Oct 2, 2015 by avibootz

1 answer 14 views

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

asked Oct 1, 2015 by avibootz

1 answer 14 views

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

asked Sep 30, 2015 by avibootz

2 answers 20 views

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

asked Sep 29, 2015 by avibootz

3 answers 25 views

How to use SQL COUNT() Function in MySQL

asked Sep 29, 2015 by avibootz

2 answers 25 views

How to use SQL AVG() Function in MySQL

asked Sep 28, 2015 by avibootz

1 answer 19 views

What are the MySQL Data Types?

asked Sep 27, 2015 by avibootz

1 answer 21 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 24 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 16 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 26 views

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

asked Aug 18, 2015 by avibootz

1 answer 191 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 83 views

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

asked Jul 7, 2015 by avibootz

1 answer 22 views

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

asked Jul 7, 2015 by avibootz

1 answer 23 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 30 views

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

asked May 27, 2015 by avibootz

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

2 answers 32 views

How to run SQL query in MySQL database with PHP Data Objects (PDO) in PHP

asked May 21, 2015 by avibootz

2 answers 22 views

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

asked May 21, 2015 by avibootz

1 answer 32 views

How to write SQL SELECT from 3 tables in SQL for MySQL in PHP

asked Apr 27, 2015 by avibootz

2 answers 181 views

How to go through mysql result twice, read records again from the beginning in PHP

asked Nov 1, 2014 by avibootz

1 answer 49 views

How to Solve MySQL Warning: mysql_query(): 5 is not a valid MySQL-Link resource

asked Oct 17, 2014 by avibootz

1 answer 33 views

How to show all tables from MySQL Dadabase in PHP

asked Oct 16, 2014 by avibootz

Most popular tags