Questions tagged as 'mysql'

Tagged questions
1
answer

checkbox filled with database data in php

I have this code that creates the calendar and checkboxes: <?php # PHP Calendar (version 2.3), written by Keith Devens function generate_calendar($year, $month, $days = array(), $day_name_length = 3, $month_href = NULL, $first_day = 0,...
asked by 26.03.2018 / 11:47
1
answer

Transaction in different banks

In a certain part of the system I need to do transaction control, but this operation involves tables that are in different databases. I made a test by inserting two tables into different banks and at the end of them doing a rollback , a...
asked by 13.02.2018 / 13:56
1
answer

Write and Use images in database (Delphi and MySQL)

Hello, I would like to know how to write images (.jpg, .png, .bmp, etc) in the MySQL database using Delphi XE6. I would like to use TDBImage, if possible, to show the images already recorded in the database. Where it stores the image in MySQL is...
asked by 13.02.2018 / 17:54
1
answer

How to solve mysql_query error? [duplicate]

I installed a login and registration system in a hosting, I adjusted the database and connected with the system, I even created a user to test the login. However when I log in he has these errors: Warning: mysqli_query() expects at least 2 p...
asked by 09.02.2018 / 07:17
1
answer

How to insert ON DELETE and ON UPDATE

I have a MySQL database structure ready, but ALTER TABLE of FOREIGN KEY's has not specified settings for ON DELETE and ON UPDATE . How do I enter these settings now, with the tables and keys already created?   ...
asked by 31.03.2018 / 14:08
1
answer

FETCH_CLASS does not display parent class values

I'm using FETCH_CLASS to map classes, but when for example one class inherits another, FETCH_CLASS does not find the attributes of the parent class and ends up creating new attributes class UsuarioVO { private $id; private $nome;...
asked by 31.03.2018 / 04:11
1
answer

Removing Duplicates from Two SQL Columns

So the situation is as follows, I have a table and I have three fields in it, so I need to compare the a = b ) and find out if there is anyone else. What's the problem, I'm new in the middle of the sql and I'm not sure if I did it right, I t...
asked by 01.02.2018 / 13:43
1
answer

Software to create relationship and MySQL DB structure

I am with a project in mind and would like to map the data and create the relationship of the tables, even if only visually before developing the pages, could you indicate me a software (I think the concept is mer) preferably free me help to vis...
asked by 24.02.2018 / 00:07
1
answer

How to list DB query

Good evening! How do I list a query in the database? I have a bank where you store Singers and their songs ... I would like to list spotify style, listing numerically according to the amount of content in the bank.     
asked by 18.02.2018 / 00:10
1
answer

SQL account how to do sum and subtraction

I'm starting to learn SQL need to make an account, I have a select for a report where I need to make an account to show another value in the fields of that report and formula can not appear on it. Query: SELECT application_name,...
asked by 23.03.2018 / 12:31