I have a MySQL query which should count the amount of replies to your comments with relations to other columns. I try to "relate" two columns together but can't figure out how to create a correct query. The table somewhat…
I'm trying to get the totals of a table grouped by names that are similar. Here is my test mysql: CREATE TABLE IF NOT EXISTS aa ( clicks INT NOT NULL, locn varchar (30) NOT NULL ) CHARACTER SET utf8…
I am struggling with a mysql problem. I have two exact same queries, just the item_id at the end is different, but they return different execution plans when I execute them with analyze/explain. This results in a huge difference of…
I'm executing SQL against a MySQL database and trying to write commands to delete all rows in a table. When I run "DELETE FROM MyTable" I get the error 1175 because a safety feature is turned on by default that…
Class.forName("com.mysql.cj.jdbc.Driver"); Connection connection = DriverManager.getConnection( "jdbc:mysql://127.0.0.1:3306/wp_dashort", "dashort", "gt9wkk6r1TPnkgrY"); PreparedStatement ps = null; ps = connection.prepareStatement(mark_complete); System.out.println("dateset"); dateof = dateof + " 00:00"; // ps.setString(1, dateof); connection.createStatement(); ResultSet rs = ps.executeQuery(); Sheet sheet = workbook.createSheet("Security_Completions"); org.apache.poi.ss.usermodel.Row rowhead = sheet.createRow((short) 0); System.out.println("Sheet…
Hi I've deployed single MySQL db instance in Azure via the YAML file in Azure Kubernetes service. I can get into the container via CLI when I'm inside my cluster. I would like to connect with db instance via external…
I want to delete some rows from MySQL db using checkboxes from my ejs view to routes with node.js and React app. I can delete one row, but how can i pass and array of parameters? This is my router…
I am new to SpringBoot and Postman and just started learning Java I was following a tutorial, but I keep getting the following error when I try to POST using POSTMAN after running my files on SpringBoot: I have double…
I found 85 duplicated names in my base with SELECT Name, COUNT(*) FROM Tab GROUP BY Name HAVING COUNT(*) > 1 ORDER BY 2 DESC, 1; with the result set: Name COUNT(*) a 28 b 12 c 10 d 8…
I have a table with articles like this: Table: artPerBrand Colums: ID (auto increment), BrandID, ArtCat, ArtNrShort, ArtNrLong, Active I want to insert new articles (using a python script) but only if the same ArtNrLong does not already exist. I…