问题:
How to Seperate data = 0 from data not = 0, then sort data not = 0 ASC, and data = 0 at the last.
CREATE TABLE `fruit` (
`item` varchar(30) COLLATE utf8_unicode_ci NOT NU...
问题:
I want to check if some of IDs of a table not exists in another table
Here is full schema and MySQL query I have http://sqlfiddle.com/#!9/f5705b/1
Query I am using is...
问题:
Is it possible with this information to reliably tell if the first column of the table is an auto increment column?
The available information is as follows :
database h...
问题:
Here is a scenario where we wanna retrieve the specific GroupId no. Eg., 6 having only 3 users say UserId's with 2, 1, 3 with that specific Group
This is the query I trie...
问题:
Question:
I have some code which scrapes https://au.pcpartpicker.com/products/cpu/overall-list/# it gets the text inside each set of brackets and adds them to MySQL datab...
问题:
I apologize if this question has been asked in a similar way before. I am rather new to SQL and am having a very difficult time finding the solution to my problem. Very con...
问题:
I do have a table where changes are always inserted. For this purposes, a version number is increased on each insert but one version is always set manually to be the active...
问题:
I'm trying to write a query in relation to an educational system that returns number values based on the below types of inspections done on specific schools in November, on...
问题:
I am trying to export my table data to csv but I need to change column value using comparing php array or function.
I am trying while loop but it takes a lot time and mem...
问题:
I'm making a login script with a simple manage session feature like Facebook
As a start I have created a table called "users_sessions"
This is the code :
$database-&g...
问题:
I tried to post on postman using vscode and mysql
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right...
问题:
I'm trying to add a new column to an existing table. Expected to be UNKNOWN instead all rows get the value of null. Please help. Here's my code.
Grade.kt
package com.ex...
问题:
I have a column called username, i want the user to be able to insert text in japanese, roman, arabic, korean, and everything that is possible, including special chars [htt...
问题:
We are migrating our application from MySQL 5.5 to 5.7. As the default value 0000-00-00 is not allowed anymore for date fields in MySQL 5.7 in strict mode, I would like to...