I would like to know if it is possible to rename a whole database of MySQL
I have the Database Register with the people table
I would like to rename CAD_CRS
Is it possible?
My problem is that I have a subquery that works perfectly, but for this I have to insert the id I want in the variables.
In the @mediaKM_mes variable I select the tbl table by car id;
in the @km variable I select the table tblCar by the car i...
It is giving an error when I try to connect to the SQL SERVER database with SQLALCHEMY
from sqlalchemy import create_engine, engine
import pandas as pd
engine = create_engine('mssql+pyodbc://User:password@server:1433/Bases_testes?drive=SQL+Ser...
I have a table with a lot of information and an empty one.
I need to make an INSERT on this empty table with just one information from the other table, but SELECT must be random.
I'm using the following line in VBA:
db.Execute "INSERT IN...
I have already checked and engine and is like InnoDB, in code tbm I did not find error, I had already done the command in another table before then I'm a little lost about the cause, follows the codes of the tables:
In Columns:
SUM(CASE WHEN cqd.queuetime < AVG(cqd.queuetime) THEN 1 ELSE 0 END) as 'Qtde < Média' e
SUM(CASE WHEN cqd.queuetime > AVG(cqd.queuetime) THEN 1 ELSE 0 END) as 'Qtde > Média',
returns the following error in SQL SERVER...
Good afternoon.
I have a simple query in SQL
Select * from Tabela Order By Campo
Where this field is a string, and this string has data such as "xyz001" , "xyz002" , "xyz0011" , so "xyz0011" is displayed first as...
I'm not very experienced with SQL language, how could I make a query work this way:
SELECT *,
( SELECT marca.* FROM marca WHERE marca.id = produtos.id ) AS nome_marca
FROM produtos WHERE id = 5
What I want to return is all * of table...
I am making an elastix bind report and I have a problem here in the output.
Theoretically, if I do not touch Where , the result would have to be the same.
select distinct
(case left( devices.id ,2)
when '10' then 'SAC'
when '40' then 'SA...
I need to change the parameters nls of Oracle, putting the characteristics of the image below:
I've tested a lot of tips, but it always says I have insufficient privileges.
These are my settings:
NLS_LANGUAGE AMERICAN
NLS...