I have made relational database model using MagicDraw tool. Every cashier has their workTime type saved in enumerator: Then I generate DDL code and try to paste it into phpMyAdmin to generate DB but I get many errors. I tried…
Hello I am writing and retrieving data from firebase, after writing some data I need to close the app and reopen to see the data that added. private let ref = Database.database().reference().child("categories") viewDidLoad(){ self.ref.observeSingleEvent(of: .value, with: { (snapshot) in for…
I have a trigger BEFORE INSERT that contains: set new.order_id = concat(new.account_id, '.', lpad(new.id, 4, '0')) Now when I try to insert some data with php like this: $insertorder = ' INSERT INTO orders ( producten ) VALUES ( "'.$conn->real_escape_string($encodedproductenarray).'"…
I need to work on a database with a telegram bot and I write this to manage the db file: class DBfunction: def __init__(self, dbname = 'example.db'): self.debname = dbname self.conn = sqlite3.connect(dbname) self.cur = self.conn.cursor() def search_db(self, telegram_id): telegram_id…
we are working on a datawarehouse project and need to pull data from our customer´s shopify database. We want to analyse inventory stock quantity and stock value, also do market analysis, traffic analysis, top landing pages, conversions, revenues and others.…
I am trying to install Magento 2 on Centos 7 using php 7.4 and MariaDB 10.5.8 . Everything works smooth just the part where I run the Magento 2 install script it throws the error SQLSTATE[HY000] [1045] Access denied for…
I'm using MariaDB and PHPMyAdmin, but my code is all neutral so happy to switch to Postgres or whatever, but this should be straight forward enough. I haven't designed anything yet, just after best approaches. I have 3 database tables…
I'm trying to write a SQL query to update a field in a different database (Hosted on the same server with phpMyAdmin). I just want it to update the most recent row as the query will be run directly after…
I have a database with multiple languages, so i transferred the database between WooCommerce to Magento. It's transferred only English language without other's. How can i solve it?
I have one table for users (userid is the pk) and a second table for items (itemid is the pk) I need to have those two tables into one table, how could I do that in phpmyadmin?