2110 solutions found
Page 37 of 106votes
I'm setting up a database using phpMyAdmin. I have two tables (`foo` and `bar`), **indexed on their primary keys**. I am trying to create a relational table...
votes
How can I generate a create table script for an existing table in phpmyadmin?
votes
For homebrew mysql installs, where's my.cnf? Does it install one?
votes
How can I install the [MySQLdb][1] module for Python using pip? [1]: http://mysql-python.sourceforge.net/MySQLdb.html
votes
**Migration error on Laravel 5.4 with `php artisan make:auth`** > [Illuminate\Database\QueryException]...
votes
Is the database query faster if I insert multiple rows at once: like INSERT.... UNION INSERT.... UNION (I need to...
votes
I am implementing the following model for storing user related data in my table - I have 2 columns - `uid` (primary key) and a `meta` column which stores other...
votes
At what point does a MySQL database start to lose performance? - Does physical database size matter? - Do number of records matter? - Is any performa...
votes
I can read the *MySQL* documentation and it's pretty clear. But, how does one decide which character set to use? On what data does collation have an effect?...
votes
I'm rewriting a project to use Node.js. I'd like to keep using MySQL as the DB (even though I don't mind rewriting the schema). I'm looking for...
votes
Is there a nice way in MySQL to replicate the SQL Server function `ROW_NUMBER()`? For example: SELECT col1, col2, ROW_NUMBER() OVE...
votes
For the various popular database systems, how do you list all the columns in a table?
votes
Given an array of ids `$galleries = array(1,2,5)` I want to have a SQL query that uses the values of the array in its WHERE clause like: <!-- language: la...
votes
In our place we're split between using mysqli and PDO for stuff like prepared statements and transaction support. Some projects use one, some the other. The...
votes
This is how my connection is set: `Connection conn = DriverManager.getConnection(url + dbName + "?useUnicode=true&characterEncoding=utf-8", use...
votes
I'm running a server at my office to process some files and report the results to a remote MySQL server. The files processing takes some time and the pro...
votes
I would like to know the command to perform a mysqldump of a database without the prompt for the password. REASON: I would like to run a cron job, which tak...
votes
I'm going to run `SHA256` on a password + salt, but I don't know how long to make my `VARCHAR` when setting up the MySQL database. What is a good length...
votes
Is there any way to later output the name of the database that is currently selected?
votes
I have two tables, both looking like id name value =================== 1 Joe 22 2 Derk 30 I need to copy the value of `va...