presto server started with a mongodb and myql catalogs.
from presto cli, I can query the tables of both sources.
I can even issue a query that combines data from both sources.
In Mongo it is mongodb.test.actors which has name,city,dob fie…
I am designing a site for renting party gear. Basically I am trying to see if an item is available during a certain date range. The user inputs the date in a form and it checks if the item is available during this date range
foreach ($_SES…
I have 2 servers, one running the frontend code (Node.js, express) and the other running MySQL with PHPMyAdmin, both are working standalone and I can confirm the MySQL database is running on 3306 but whenever I try to connect via Node.js (…
Help!! I have two tables that I’m working with:
The first table consists of volumes for all MS-DRGS by payor and facility.
The second table provides information about specific MS-DRGs, referred to as pairs or triplets.
I need a few thing…
Help!! I have two tables that I’m working with:
The first table consists of volumes for all MS-DRGS by payor and facility.
The second table provides information about specific MS-DRGs, referred to as pairs or triplets.
I need a few thing…
I have this query
SELECT 321.74 / 12 * 3, ROUND(321.74 / 12 * 3 + 0.001, 2), ROUND(80.435, 2);
The first result is 80.435 so ROUND to 2 decimal places should return 80.44, instead it returns 80.43, meanwhile if I round 80.435 I get 80.44….
controller
$this->load->model(‘Customer_model’);
$users = $this->Customer_model->recently_registered();
$this->load->view(‘dashboard’, $users);
displaying customer in desc order limit 5
model
…
I want to be able to use an UPDATE statement to be able to set the value of FiscalYear column (an int column not visible in the schema attached) to equal the year the order was placed (orderdate) EXCEP that if the month is in October,Novem…
I have a doubt about real escape string and security from sql injection..
Does have any difference if i put real escape string inside a query? like:
$ano = $_POST[‘ano’];
$SQL->query("DELETE from viewers WHERE ano = ‘".$SQL-&g…
Is it possible to add a column to all the tables that which name ends in a specific substring using Flyway? To give a better context of the problem I am trying to solve I will leave an example below:
In my database I have this two tables s…
Hive version – 3.1.2
SQL connector version – 8.0
Trying to grant permissions like – GRANT all on . to ‘hiveuser’@localhost identified by ‘hivepassword’;
Error – ERROR 1064 (42000): You have an error in your SQL syntax; check the manual tha…
Hive version – 3.1.2
SQL connector version – 8.0
Trying to grant permissions like – GRANT all on . to ‘hiveuser’@localhost identified by ‘hivepassword’;
Error – ERROR 1064 (42000): You have an error in your SQL syntax; check the manual tha…
I have the following table in the MySQL Data
CREATE TABLE `new_table` (
`date1` varchar(20) DEFAULT NULL,
`organisation` varchar(45) DEFAULT NULL,
`proportion` varchar(45) DEFAULT NULL,
`id` int NOT NULL AUTO_INCREMENT,
PRIMARY K…
I have the following table in the MySQL Data
CREATE TABLE `new_table` (
`date1` varchar(20) DEFAULT NULL,
`organisation` varchar(45) DEFAULT NULL,
`proportion` varchar(45) DEFAULT NULL,
`id` int NOT NULL AUTO_INCREMENT,
PRIMARY K…
I have a Table (TableA) with Those Keys –> user_id, content_id, points, content_type, description, created_date
content_id is the unique id of my document, so the every content_id can have 2 records with content_type(1-> like and 2 …
I have a page that I am currently trying to take the details of a form, and enter them into a database as a new row in a table.
However, this does not work and nothing is entered into the table.
One thing I have had to do is access a diffe…
My question title may not appropriate as I am not so much aware of how to call it. I will appreciate it if anyone can edit to fits the query.
I am planning to build a web application where users will subscribe. For instance CRM or Project …
schema diagram my databases
Show the titles of the books that sold the most in February 2021
my query is
SELECT nota, SUM(jumlah) AS total_terjual, judul FROM detail_transaksi INNER JOIN buku ON buku.kode_buku =
detail_transaksi.kode_buku …
Relevant code:
SELECT `startdate`, `problem` INTO tktCompletedDate, problem
FROM servicerequest WHERE (requestID = tktRequestID);
CASE problem
WHEN "Screen is broken" THEN
SET tktProbSpec = ‘installed replacemen…
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘,)’ at line 1
type nameses struct {
Name string
Surname string
}
var name nameses
i…