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…
This is the table schema: CREATE TABLE public.page_by_category ( id integer NOT NULL DEFAULT nextval('page_by_category_id_seq'::regclass), page_id bigint NOT NULL, category_id bigint NOT NULL, weight integer NOT NULL, CONSTRAINT id_pk PRIMARY KEY (id), CONSTRAINT category_id_fkey FOREIGN KEY (category_id) CONSTRAINT page_id_fkey FOREIGN…
I have a problem, I've spent a lot of time on. I have to display the pairs of items (Item1, Item2, How many) that appear on the invoices - and how many pairs have repeated. The table that connects invoices…
I have table in SQL Server as below : +--------------+----------------------------------------------+ | reportName | ShareWith | +--------------+----------------------------------------------+ | IBM SH data | [email protected],[email protected],[email protected] | | Samsung Sr | [email protected],[email protected] | | Xiaomi MFG | | | Apple US st | [email protected],[email protected]…
i have MySQL data which is imported from csv file and have multiple duplicate files on it, I picked all non duplicates using Distinct feature. Now i need to delete all duplicates using SQL command. Note i don't need any…
Deploying to Heroku and having trouble uploading an SQL export from phpMyAdmin SQL Export Settings: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; Create Table CREATE TABLE `posts` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `title`…
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 have many to many relationship like this : Server version: 10.4.17-MariaDB table colors(id,name). table items(id,title....). table item_color(id,items_id,color_id). my query is like this : SELECT items.*,colors.name FROM items,item_color,colors where items.id = item_color.item_id and colors.id = item_color.color_id i use php function…
I am making my first app with Symfony and when i setup my database (doesn't matter if it's postgresql or mysql). I have an error "could not find driver" three time. One in PDOConnection.php line 38. Other in Exception.php line…
I have two tables users and radacct, both table has same column username . table radacct also has a column acctstoptime which is important here. table acctstoptime is actually a datetime column with allow null. table users has more than…