Database Archives - Page 38 of 44

Create a temporary table in a SELECT statement without a separate CREATE TABLE

Is it possible to create a temporary (session only) table from a select statement without using a create table statement and specifying each ...

May 2, 2022
0 Comments

How to retrieve the current version of a MySQL database management system (DBMS)?

What command returns the current version of a MySQL database? 2Best Answer 21 Try this function – SELECT VERSION(); -> '5.7.22-standard' VERSION() Or ...

May 2, 2022
0 Comments

How to run SQL script in MySQL?

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> ...

May 2, 2022
0 Comments

ERROR 1698 (28000): Access denied for user ‘root’@’localhost’

I’m setting up a new server and keep running into this problem. When I try to log into the MySQL database with the ...

May 1, 2022
0 Comments

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am ...

May 1, 2022
0 Comments

Delete with Join in MySQL

Here is the script to create my tables: CREATE TABLE clients ( client_i INT(11), PRIMARY KEY (client_id) ); CREATE TABLE projects ( project_id ...

May 1, 2022
0 Comments

Copying PostgreSQL database to another server

I’m looking to copy a production PostgreSQL database to a development server. What’s the quickest, easiest way to go about doing this? 12 ...

May 1, 2022
0 Comments

Database development mistakes made by application developers [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

May 1, 2022
0 Comments

How to see indexes for a database or table in MySQL?

How do I see if my database has any indexes on it? How about for a specific table? 14 s 14 To see ...

May 1, 2022
0 Comments

How to shrink/purge ibdata1 file in MySQL

I am using MySQL in localhost as a “query tool” for performing statistics in R, that is, everytime I run a R script, ...

May 1, 2022
0 Comments