Remember
Register
Programming & Software Q&A | CollectiveSolver
Questions
Tags
Users
Welcome to collectivesolver - Programming & Software Q&A with code examples. A website with trusted programming answers. All programs are tested and work.
Contact: aviboots(AT)netvision.net.il
Most popular tags
python
java
javascript
c#
c
cpp
php
vb#
typescript
nodejs
html
go
rust
swift
dart
ruby
scala
r
css
bootstrap
groovy
sql
mysql
jquery
lua
bash
f#
kotlin
win32
winapi
reactjs
opengl
c-windows
pascal
sdl2
cobol
nodejs-express
angularjs
glfw
html5
postgresql
dom
android-java
wordpress
glad
bootstrap4
css3
objective-c
visual-studio-code
software
windows
fortran
web-hosting
firefox
bgfx
perl
binary
elixir
opencl
vulkan
ada
phpmyadmin
wpf
direct3d11
erlang
q2a
cpp17
clisp
laravel
netbeans
edge
prototype
ide
dot-net-library
chrome
linux
xampp
download
d
binary-arithmetic
imgui
search-engine
clang
fontawesome5
xdebug
iphone
hardware
apache
webgl
xml
pc
xhtml
browser
programming
Disclosure:
My content contains affiliate links.
Recent questions tagged sql
29,957
questions
39,172
answers
573
users
Recent questions tagged sql
1
answer
21
views
How to replace part of a string in MySQL with SQL
asked
Jul 17
by
avibootz
mysql
sql
1
answer
81
views
How to create SQL SELECT query to find all the words from string in database rows with PHP
asked
Jan 29, 2021
by
avibootz
php
sql
1
answer
76
views
How to create SQL SELECT query to find all the words from array in database rows with PHP
asked
Jan 29, 2021
by
avibootz
php
sql
1
answer
76
views
How to create database with UTF8 character set in MySQL using SQL
asked
Nov 30, 2020
by
avibootz
mysql
sql
1
answer
80
views
How to create database in MySQL using SQL
asked
Nov 29, 2020
by
avibootz
sql
mysql
1
answer
91
views
How to print field (column) from table in MySQL with PHP and SQL
asked
Nov 28, 2020
by
avibootz
mysql
php
sql
1
answer
97
views
How to use order by with multiple columns in MySQL with SQL
asked
Oct 12, 2020
by
avibootz
sql
mysql
1
answer
107
views
How to order by field length in MySQL with SQL
asked
Oct 12, 2020
by
avibootz
sql
mysql
1
answer
104
views
How to remove duplicate rows in MySQL with SQL
asked
Jul 21, 2020
by
avibootz
sql
mysql
1
answer
131
views
How to ignore error when insert duplicate rows in MySql table with SQL
asked
Oct 17, 2019
by
avibootz
sql
mysql
1
answer
90
views
How to get the total rows from a MySQL table with SQL in PHP & PDO
asked
Oct 9, 2019
by
avibootz
sql
mysql
php
2
answers
444
views
How to select a range of rows (N1 to N2) from a MySQL table with SQL
asked
Oct 9, 2019
by
avibootz
sql
mysql
3
answers
219
views
How to select the last N rows from a MySQL table with SQL
asked
Oct 9, 2019
by
avibootz
sql
mysql
2
answers
158
views
How to select the first N rows from a MySQL table with SQL
asked
Oct 9, 2019
by
avibootz
sql
mysql
1
answer
113
views
How to get the total rows from a MySQL table with SQL
asked
Oct 9, 2019
by
avibootz
sql
mysql
1
answer
130
views
How to update table column of every row in MySQL with SQL
asked
Sep 25, 2019
by
avibootz
mysql
sql
2
answers
148
views
How to change the database engine of a MySQL database table to MyISAM or InnoDB in SQL
asked
Sep 24, 2019
by
avibootz
sql
1
answer
109
views
How to get all the columns names from table in MySQL with SQL
asked
Sep 22, 2019
by
avibootz
sql
mysql
1
answer
112
views
How to insert data from one table to another in MySQL with SQL
asked
Sep 22, 2019
by
avibootz
mysql
sql
1
answer
126
views
How to filter select rows by column length in MySQL with SQL
asked
Sep 7, 2019
by
avibootz
sql
mysql
1
answer
161
views
How to order select rows by column length in MySQL with SQL
asked
Sep 7, 2019
by
avibootz
mysql
sql
1
answer
116
views
How to select N random records in MySQL with SQL
asked
Sep 7, 2019
by
avibootz
mysql
sql
2
answers
146
views
How to update MySQL table using SQL
asked
Aug 2, 2019
by
avibootz
mysql
sql
1
answer
130
views
How to find non-ASCII characters in MySQL with SQL
asked
Mar 19, 2019
by
avibootz
sql
mysql
1
answer
123
views
How to select records from the last 24 hours in MySQL using SQL
asked
Nov 10, 2018
by
avibootz
mysql
sql
1
answer
143
views
How to get only the first N characters of a field in MySQL with SQL
asked
Sep 11, 2018
by
avibootz
sql
mysql
1
answer
136
views
How to match a whole word in MySQL with SQL
asked
Sep 11, 2018
by
avibootz
sql
mysql
1
answer
139
views
How to remove rows with duplicate value in MySQL field in SQL
asked
Jul 6, 2018
by
avibootz
sql
mysql
1
answer
144
views
How to count duplicate value in MySQL row field with SQL
asked
Jul 6, 2018
by
avibootz
sql
mysql
1
answer
538
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
php
sql
mysql
1
answer
143
views
How to fetch one column from MySQL table into array using PDO and PHP
asked
Jun 3, 2018
by
avibootz
php
mysql
sql
1
answer
130
views
How to find duplicate values in MySQL table using SQL
asked
May 31, 2018
by
avibootz
mysql
sql
1
answer
143
views
How to change MySql column position without losing data in SQL
asked
May 31, 2018
by
avibootz
mysql
sql
1
answer
158
views
How to generate 1 letter URLs and INSERT INTO MySQL with PDO in PHP
asked
Nov 2, 2016
by
avibootz
php
mysql
sql
1
answer
119
views
How delete all rows that have a field with more than N characters in MySQL with SQL
asked
Oct 2, 2016
by
avibootz
sql
mysql
1
answer
138
views
How to get the length (count how many characters) of a field in MySQL with SQL
asked
Oct 2, 2016
by
avibootz
sql
mysql
1
answer
174
views
How to return rows in random order in MySQL with SQL
asked
Sep 19, 2016
by
avibootz
sql
mysql
1
answer
142
views
How to order by two columns in SQL and MySQL
asked
Sep 18, 2016
by
avibootz
sql
mysql
1
answer
158
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
php
sql
mysql
1
answer
126
views
How to find all the max values of a field in MySQL table with SQL
asked
Sep 11, 2016
by
avibootz
sql
mysql
2
answers
180
views
How to find the max value of a field in MySQL table with SQL
asked
Sep 11, 2016
by
avibootz
sql
mysql
3
answers
229
views
How to format SQL NOW() Function (current system date and time) in MySQL
asked
Oct 14, 2015
by
avibootz
sql
mysql
1
answer
146
views
How to use SQL NOW() Function (current system date and time) in MySQL
asked
Oct 13, 2015
by
avibootz
sql
mysql
3
answers
179
views
How to use SQL ROUND() Function in MySQL
asked
Oct 12, 2015
by
avibootz
sql
mysql
2
answers
190
views
What is the different between SQL LENGTH() and CHAR_LENGTH() Functions in MySQL
asked
Oct 11, 2015
by
avibootz
sql
mysql
2
answers
158
views
How to use SQL CHAR_LENGTH() Function in MySQL
asked
Oct 10, 2015
by
avibootz
sql
mysql
2
answers
154
views
How to use SQL LENGTH() Function in MySQL
asked
Oct 10, 2015
by
avibootz
sql
mysql
4
answers
250
views
How to use SQL MID() and SUBSTRING() functions in MySQL
asked
Oct 9, 2015
by
avibootz
sql
mysql
1
answer
149
views
How to use SQL LCASE() function in MySQL
asked
Oct 8, 2015
by
avibootz
sql
mysql
1
answer
148
views
How to use SQL UCASE() function in MySQL
asked
Oct 7, 2015
by
avibootz
sql
mysql
Page:
1
2
3
next »
...