2108 solutions found
Page 49 of 106votes
What's the difference between `INNER JOIN`, `LEFT JOIN`, `RIGHT JOIN` and `FULL JOIN` in ***MySQL***?
votes
How do I connect to a MySQL database using a python program?
votes
I want to do a *[full outer join][1]* in MySQL. Is this possible? Is a *full outer join* supported by MySQL? [1]: https://en.wikipedia.org/wiki/Join_(SQL)#...
votes
I accidentally enabled **ONLY_FULL_GROUP_BY** mode like this: SET sql_mode = 'ONLY_FULL_GROUP_BY'; How do I disable it?
votes
This should be dead simple, but I *cannot* get it to work for the life of me. I'm just trying to connect remotely to my MySQL server. - Connecting as:...
votes
I'm working on a projects which involves a lot of database writes, I'd say (*70% inserts and 30% reads*). This ratio would also include updates which I...
votes
Why doesn't a **TRUNCATE** on `mygroup` work? Even though I have `ON DELETE CASCADE SET` I get: >ERROR 1701 (42000): Cannot truncate a table referenc...
votes
How do I copy or clone or duplicate the data, structure, and indices of a MySQL table to a new one? This is what I've found so far. This will copy the...
votes
Is it possible to temporarily disable constraints in MySQL? I have two Django models, each with a foreign key to the other one. Deleting instances of a model...
votes
I have a table `story_category` in my database with corrupt entries. The next query returns the corrupt entries: SELECT * FROM story_category...
votes
How can I get the size of a MySQL database? Suppose the target database is called "v3".
votes
I am using Ubuntu and I want to search for a specific Directory called "sdk". All that I know is, that "sdk" Directory is located somewhe...
votes
I am on UBUNTU. JDK version currently installed is: java version "1.7.0_51" Java(TM) SE Runtime Environment (build 1.7.0_51-b13) Java...
votes
The error message: Building native extensions. This could take a while... ERROR: Error installing rails: ERROR: Failed to build gem native...
votes
I am using: gpg --gen-key Is there a better way to create a PGP key? What does this program want? A fully slammed server? > Not enough random b...
votes
I have the following error while trying to connect SQL Server: ```none [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1416F086:SSL routines:...
votes
I have accounts in **GitHub** and **GitLab**. I generated and added an RSA key to my account in **GitLab**, but now I need to work with **GitHub** on a second p...
votes
I am attempting to connect to mySQL through a NodeJS file, but I receive the following error: { Error: ER_ACCESS_DENIED_ERROR: Access denied for user 'r...
votes
I am getting error on ubuntu 16.04 > "ERROR: Couldn't connect to Docker daemon - you might need to run > `docker- machine start default`....
votes
I have just reinstalled latest tensorflow on ubuntu: $ sudo pip install --upgrade https://storage.googleapis.com/tensorflow/linux/cpu/tensorflow-0.7.1-cp...