Doubt in MySQL ...
What are the possible problems that can occur when doing a foreign key in different databases?
Considering this type of foreign key and a View that looks for information from another database, which one is most useful?...
I wanted to know if it is possible to reorder the table entries in mysql, overwriting the deleted entries, and without breaking the other tables.
If it is possible, which command would you use and give me some examples.
For example:
In table...
Good morning.
I'm doing a sales web app, and I want to return the sales ID to insert into the intermediate product_product table (multiple products in 1 sale). I tried it that way, but obviously I could not:
<?php
$connect = mysqli_conn...
I have a database and an html code that finally managed to make a connection but the code is a bit messy because it mixes html with java and mysql ... Here's an example:
<%@page import="java.io.*,java.sql.*" %>
<%
Class.forNa...
SELECT dataVen, Sum(valorTotal) as valorTotal FROM cad_cr2 Group by MONTH(dataVen)
The above query returns the following values:
Iwishitwerethatway,groupedbymonth:
I've done a lot of research and try, but without success.
I try to connect to MySQL with the code below. I do not use Hibernate, or anything.
It's just to connect to the bank and run a simple SQL clause. I get the error below.
I've seen some questions with answers here, but I confess I did not under...
I can do the data insertion but I have no idea how to do data selection on a HTML using $.get JSON .
php code
public function Inserir($tabela,$sql){
ksort($sql);
$Campos_nome= implode('', '', arr...
I'm doing a query and I'm transforming the data no formato brazilian and then I want to use the data_vencimento original in order by but it does not work
code:
SELECT *,DATE_FORMAT(data_vencimento,'%d/%m/%Y') as data_ve...
I wanted when the user was to register, if he informs an email or registration already existent in the bank of that a message and it is forbidden to register in the system, in the code below it continues registering the user even with the ema...