Recent questions tagged mysql

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)

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 (468,280 points)

1 answer 24 views

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

asked Jan 7, 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 19 views

What are the MySQL Data Types?

asked Sep 27, 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

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

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 (468,280 points)

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 (468,280 points)

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 (468,280 points)

1 answer 188 views

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

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

1 answer 82 views

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

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

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 (468,280 points)

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 (468,280 points)

1 answer 18 views

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

asked May 27, 2015 by avibootz (468,280 points)

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 (468,280 points)

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 (468,280 points)

2 answers 19 views

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

asked May 21, 2015 by avibootz (468,280 points)

1 answer 32 views

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

asked Apr 27, 2015 by avibootz (468,280 points)

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 (468,280 points)

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 (468,280 points)

1 answer 31 views

How to show all tables from MySQL Dadabase in PHP

asked Oct 16, 2014 by avibootz (468,280 points)

1 answer 98 views

How to SELECT random records from a table in MySQL and PHP

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

1 answer 17 views

How to count number of rows in a MySQL database table in PHP

asked Sep 2, 2014 by avibootz (468,280 points)

1 answer 62 views

How to return the AUTO_INCREMENT ID generated from the previous INSERT operation in PHP

asked Jul 26, 2014 by avibootz (468,280 points)

1 answer 21 views

How to create MySQL table in PHP

asked Jul 13, 2014 by avibootz (468,280 points)

Most popular tags

Hostgator - Save 50% Off Your New Optimized WordPress Hosting With Coupon: WDA50