Time type column field data update in mysql
SQL |
https://codedump.io/share/JUGPFnf3MPsL
|
I have a time type column in database and i want to update current stored value.
I wrote this query but data is not changed.
UPDATE testing SET timev...
5 years ago
MySQL Database in XAMPP is stopped
SQL |
https://codedump.io/share/6k8w20ZjLe3w
|
I'm running Xampp on Linux(Ubuntu 14.04) and while everything was working fine until an hour back right after I shut it down it suddenly starts throwi...
5 years ago
Access SQL Calculation in SELECT make not null
SQL |
https://codedump.io/share/oGuTJkztWvlo
|
I have a query that filters results for products which have had orders sent after an user-input date, and calculates what the quantity becomes if the ...
5 years ago
SQL Foreign Key command won't execute
SQL |
https://codedump.io/share/m4AD5hH9sB4E
|
when trying to execute a SQL statement that will assign foreign keys to my database I receive an error, am I missing something simple?
CREATE TABLE `...
5 years ago
Sorting a column with numbers, strings and nils
SQL |
https://codedump.io/share/3PmcUYXG9Ug
|
I have a column that includes numbers (as strings), strings and nils.
I would like to order all numbers by numerical values, then strings alphabetical...
5 years ago
PostgreSQL one to many pivot with crosstab
SQL |
https://codedump.io/share/sG59ohogWcpi
|
I am trying to build a one to many query in PostgreSQL that looks at a customer table, a transaction table and the result is a table showing which pro...
5 years ago
Getting grand totals with grouping sets
SQL |
https://codedump.io/share/R2LETFhdRjIh
|
I am migrating SQL SERVER 2005 to SQL SERVER 2014 and came across this problem. I have a "search engine" STORED PROCEDURE that builds report queries o...
5 years ago
Show last update date
SQL |
https://codedump.io/share/sJwqkr6VQaVG
|
I am new in this forum and also new in SQL my question is
I have an Excel sheet link to database with "From Microsoft query" I have 3 tables link tog...
5 years ago
SQL SELECT LIKE (Insensitive casing)
SQL |
https://codedump.io/share/dfTlKWGF3uH1
|
I am trying to execute the sql query:
select * from table where column like '%value%';
But the data is saved as 'Value' ( V is capital ).
When I e...
5 years ago