2108 solutions found
Page 47 of 106votes
I have a column containing urls (id, url): http://www.example.com/articles/updates/43 http://www.example.com/articles/updates/866 http://www.ex...
votes
What command returns the current version of a MySQL database?
votes
What is the size of column of `int(11)` in mysql in bytes? And Maximum value that can be stored in this columns?
votes
I want to execute a text file containing SQL queries, in MySQL. I tried to run `source /Desktop/test.sql` and received the error: > mysql> . \home\...
votes
How can I trace MySQL queries on my Linux server as they happen? For example I'd love to set up some sort of listener, then request a web page and view a...
votes
I installed [LAMP][1] on [Ubuntu 12.04 LTS][2] (Precise Pangolin) and then set root password on [phpMyAdmin][3]. I forgot the password and now I am una...
votes
How do I see if my database has any indexes on it? How about for a specific table?
votes
I have a table with ~500k rows; varchar(255) UTF8 column `filename` contains a file name; I'm trying to strip out various strange characters out of the f...
votes
I'm setting up a new server and keep running into this problem. When I try to log into the MySQL database with the root user, I get the error: > ER...
votes
Here is the script to create my tables: CREATE TABLE clients ( client_i INT(11), PRIMARY KEY (client_id) ); CREATE TABLE proje...
votes
How to declare a variable in mysql, so that my second query can use it? I would like to write something like: SET start = 1; SET finish = 10;...
votes
When I open XAMPP and click the start MySQL button, it gives me an error. I had started it just before, but now it isn't working. > 12:19:12 PM [mysq...
votes
I try to connect MySQL database with Java using connector 8.0.11. Everything seems to be OK, but I get this exception: Exception in thread "main&q...
votes
How do I drop all tables from a MySQL database, ignoring any foreign key constraints?
votes
I am using MySQL in localhost as a "query tool" for performing statistics in R, that is, everytime I run a R script, I create a new database (A), crea...
votes
Consider: ./mysqladmin -u root -p** '_redacted_' Output (including typing the password): > Enter password: > > mysqladmin: co...
votes
Is it possible to create a temporary (session only) table from a select statement without using a create table statement and specifying each column type? I know...
votes
By default, `mysqldump` takes the backup of an entire database. I need to backup a single table in MySQL. Is it possible? How do I restore it?
votes
I am learning MySQL and tried using a `LOAD DATA` clause. When I used it as below: ```mysql LOAD DATA INFILE "text.txt" INTO table mytable; ```...
votes
How can I best write a query that selects 10 rows randomly from a total of 600k?