python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - vitess

How to select data depending on data from the same table with custom field in SELECT?

I have a query to fetch closest airports to the airport: SELECT *, ( 6371 * acos(cos(radians(55.966324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(37.416573)) + sin(radia...
test-img

JamesJGoodwin

mysql

sql

vitess

Votes: 0

Answers: 1

Latest Answer

Error 1052 in mysql indicates that a reference is ambiguous (see https://dev.mysql.com/doc/mysql-errors/5.7/en/server-error-reference.html) Qualify all columns in your expression with the correct alia...
test-img

tinazmu

Which distributed SQL databases put data from different tables with the same tenant in the same node?

I’m designing a SQL data schema with many tables that have a compound primary key of (customer_id, id). The application will frequently need to run JOIN queries to assemble data. However, it should ne...
test-img

Calebmer

sql

cockroachdb

distributed-database

yugabytedb

vitess

Votes: 0

Answers: 2

Latest Answer

there are two aspects in that: security and performance. For security (tenant isolation) you don't need to dedicate nodes if you have Row Level Security. Here is an example on YugabyteDB (distributed ...
test-img

FranckPachot

Posts

Questions

Blogs

Jobs