A friend and I are working on a database that stores information about cPanel hosting accounts, such as what settings, apps, and features each account is using. Most of the fields are boolean, such as whether or not the account…
I am not proficient in MySQL and phpMyAdmin and got this error when trying to import my SQL file to a new installation of WAMP. I was developing a joomla website on my local pc and after completion, decided to…
I have MySQL installed on an Ubuntu machine. When I run use TWEETDATA command it shows me following error ERROR 1049 (42000): Unknown database 'tweetdata' But the database TWEETDATA does exist in the db. Below is the output of show…
So I have two tables in my phpmyadmin like tabel1 and tabel2 in both tables, i want to select id = 2 so I have tried mysql_query('SELECT * FROM tabel1, table2 WHERE id=2'); but not working plz give me some…
Good example will be shopify. Where you have N number of users (in this case each user assume site). And each user will have it's own records in DB. But db schema will be the same (same tables for each…
So I have a dropdown list that should change the information displayed within the section below the form. The switch statement checks which option is selected and then assigns the correct query to run to the variable $query. I'm not…
so I just started to learn using Magento 2 and I'm blocked from the start :/ I looked in many sites before for my problem I found solutions but none of them did solve my problem, I hope you have…
I'm trying to add sequential numbers, from 1 to 200M, to an empty SQL table. The number is too large to make the list with Excel. I'm also using Cpanel which has a low file size limit. Any way to…
Background: I'm writing an in house SEO crawler to check our positions in google. The crawling is working brilliantly, the storage is fine, but Im now having performance issues with displaying the data (currently the storage table have over 11million…
Unfortunately I have a SQL file more than 350 MB. I have to import this file on the server to connect the database with one of my clients website. How I can do this? If it was my PC, then…