Cannot connect to arvixe database in my SQL Server Management Studio – Plesk
I have to access my arvixe.com database in my SQL Server Management Studio 2014. Can Anybody guide me? Screenshot attached. What was the problem with it
Converting Twitter4J Date to SQL Date – Twitter API
I have this date format coming from Twitter API: Wed Oct 11 17:30:20 CEST 2017 In Java SQL I need this date format: 2017-10-11 17:30:20 How can i convert the date format to make it possible to insert into database?…
At what point should I create a separate table (mysql)? – CPanel
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…
SQL request error – Artificial Intelligence
Good evening everyone, I'm working on a assignment and can't figure out the following, I have two tables: CREATE TABLE Rental ( rental_id DECIMAL(12) PRIMARY KEY, customer_id DECIMAL(12), movie_id DECIMAL(12), delivery_status VARCHAR(64), return_status VARCHAR(64)); and CREATE TABLE Movie ( movie_id…
How to add sequential numbers to an empty SQL table – CPanel
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…
Table Join with limit and performance increase – SEO
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…
Database import error syntax – SEO
I have tried to import my sql database into Phpmyadmin because I'm moving to another hosting. I'm having a similar kind of error when trying to add another database. I don't know where the problem is. Could it be because…
Install wordpress with a pre-defined theme – CPanel
I am wondering if anybody has an idea about how to make this possible. 1: User chose a website design from a gallery in my website. 2: Then, I create a hosting for my user and Install wordpress, but with…
How to get the relevent table data using JOIN Query – Photoshop
course{ course_id, course_name, } subject{ subject_id, subject_name, course_id } student{ email, course_id, } This is my code , It display all the subjects belongs to the course $_GET['email_address']=$_SESSION['email_address']; $sql="(SELECT c.course_name course_name,su.subject_name subject_name from subject su LEFT JOIN course c ON…
Select max value for which condition x is fulfilled in SQL Server 2012 – SEO
I'm trying to build a flexible attribution model for site traffic. I've started out by making a last-click model, where a conversion is attributed to a channel of traffic based on the last visit a visitor made prior to converting.…