SELECT * from ip2loc.netacuity as IP where MBRCONTAINS(IP.ip_poly,ST_POINTFROMWKB(POINT(2925896821,0))) [SQL] SELECT * from ip2loc.netacuity as IP where MBRCO
I have 3 tables, Property managers, Addresses and Units. I'm trying to get all the rows using the aggregate function COUNT, but it only returns 1 row. I want to
I know this question may seem like a simple one and might have been asked before but what makes this tricky is how do I work out the total days for a payroll. N
I have a 'diary' type blog in which I want to highlight all the posts made around the current day and month, regardless of the year. You could say they need to
I have two tables: Table "products" ID Name Price Quantity 1 Product A 10 10 2 Product B 20 10 Table "promotions" ID Product ID Type Price Quantity 1 1 disco
I'm trying to replace an expensive where in ... query with a CTE. I've done this previously in other sql dialects, but can't get the syntax right for MariaDB/My
I am working on an independent JDBC/Springboot project and I am having a lot of trouble actually posting any data from postman into MySQL. I have tried looking
Standard disclaimer--I am brand new to coding and I have never used a MySQL database before. I also do not know PHP (I know that many of the answers on this sit
I have a delay table (as below) where a SKU is identified by the combination of mmodel and srno and the snapdate.. A SKU present on a specific snapdate indicate
Hello i have this problem today and i partially solved it using the method described by Fabricio Valencia: IMPORTANT: do NOT delete ibdata1 file. You could dest
Let's call this table service_status: +---------+----------+-------------+------------+ |service_id| output | created_at | updated_at | +---------+--------
I have this node.js app where you can post comments on teachers profiles. teacher.ejs <!-- Form --> <div class=""> <form id="commentsForm"
I am working on a mysql (8) db which is too big for the 2TB linux partition size so I have moved the mysql instance onto a 16TB nvme raid under windows 10. All
I have a table with the columns company_id, shipment_id and trip_id. I am asked to find out which companies have less than 4 shipments on a single trip. The que
I have a 'locations' table as follows: Using an API, if I send a valid record, the table will start normally with index 1. If I send something that won't be ac
I am having some problems I can't figure out. I have a database "DatabaseA" on mysql 5.7 (server A), which I would like to migrate to "DatabaseA" on myql 8.0 (s
I have a database user with access to 2 schemas, oldDb and newDb and I want to select everything from oldDb.users table and insert them into newDb.users using L
So i have a problem where i want to see how many rows there are in my database, after i've made an update. Im trying to use "GetMaxRows" but it always returns 0
delimiter // create procedure payFees(in deviceid int, in fee int) begin declare pbalance int default null; declare ptype varchar(2) default ""; dec
I am trying to change my website into multisite on my staging server. When I add define('MULTISITE', true); in wp-config.php on my local machine setup, it works