422 solutions found in database
Page 19 of 22votes
I want to copy a live production database into my local development database. Is there a way to do this without locking the production database? I'm cur...
votes
We offer a platform for video- and audio-clips, photos and vector-grafics. We started with MySQL as the database backend and recently included [MongoDB][1] for...
votes
Is there a MySQL command to locate the `my.cnf` configuration file, similar to how PHP's `phpinfo()` locates its `php.ini`?
votes
How can I see the list of the stored procedures or stored functions in mysql command line like `SHOW TABLES;` or `SHOW DATABASES;` commands.
votes
I've got a very large MySQL table with about 150,000 rows of data. Currently, when I try and run SELECT * FROM table WHERE id = '1'; the c...
votes
I'm just getting started learning [SQLite][1]. It would be nice to be able to see the details for a table, like MySQL's `DESCRIBE [table]`. `PRAGMA tabl...
votes
I am running this query on MySQL SELECT ID FROM ( SELECT ID, msisdn FROM ( SELECT * FROM TT2 ) ); and it...
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'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 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
when i got upgraded my ubuntu from 15.10 to 16.04 i have this erro in my yii2 project SQLSTATE[42000]: Syntax error or access violation: 1055 Expres...
votes
I'm trying to import an sql file of around 300MB to MySql via command line in Ubuntu. I used source /var/www/myfile.sql; Right now it's displ...
votes
I am trying out some code on Ubuntu. I'm trying to run the following code <!-- language: lang-c++ --> #include <cstdlib> #includ...
votes
I just installed MySQL on Ubuntu and the root user can't log in :) How can I recover or find out my password? Using blank for password does not work.