mysql-command-line-client Questions
7
Solved
I just ran a simple MySQL CREATE TABLE statement that produced the line
"Query OK, 0 rows affected, 1 warning (0.07 sec)."
It didn't actually show me what the warning was, though. How can you...
Sainfoin asked 1/8, 2009 at 2:40
2
Solved
I created an MySql event a few days ago. I don't think it has run. If I do SHOW EVENTS It started on 2015-09-07 00:00:00 and it has an interval of WEEK. Today is 2015-09-14 and it is well after mid...
Ellga asked 14/9, 2015 at 20:1
4
Solved
I have an auto-generated SQL script to run on 5.6.17-157.2.
It worked fine on 5.5.33-1.17.1.
Every SQL statement shows \g at the end. For example
CREATE TABLE articoli
(
ID INT,
titolo LONGTEXT,...
Oliviaolivie asked 21/10, 2014 at 21:0
1
First of all, the doc says below:
mysql> help
...
ego (\G) Send command to mysql server, display result vertically.
...
go (\g) Send command to mysql server.
...
But, ego or go doesn't work aft...
Roxannroxanna asked 14/11, 2023 at 10:14
3
In hive, I can set the prompt to be the currently selected database. Is it possible to do the same in MySQL?
I want to replace mysql with kundoor in the image below.
Poulter asked 15/8, 2017 at 9:55
2
On Linux, my.cnf can be altered such that mysql -u myusername will work on the client side without the -p option. It's safer to use config files to set this up rather than putting the password in a...
Eros asked 12/8, 2019 at 3:58
5
Solved
I am trying to log in to mysql with --defaults-file option on the command line:
$ mysql --defaults-file ~/mycnf.cnf
But I get the following error:
mysql: unknown option '--defaults-file'
But this...
Salol asked 23/5, 2013 at 18:33
3
Solved
I get this annoying error when I try to insert data from db1 to db2 in MaridaDB 10 using mysql CLI. This is while all the columns exist.
INSERT INTO db2.thread (threadid, title, postuserid, datelin...
Evolute asked 4/6, 2013 at 5:49
2
Solved
Here is my question about MySQL.
After I log in to MySQL using:
mysql -u myname -p
...
mysql>
I wanted to know what the username I used to logon. Is there a way to check this? like "whoami...
Arondell asked 23/2, 2015 at 6:17
9
Solved
I would like to know if there's a way for a mysql query to return the username of the user that issues the query.
Is this possible?
Jeanicejeanie asked 13/10, 2013 at 21:5
6
What is the windows command to switch users on MySQL?
I'm having a little problem in using MySQL on windows. I know how to create a new user and giving grants to the new user and all. But I don't k...
Gotcher asked 2/4, 2014 at 12:41
8
I've managed to get into MySQL using the command line terminal, but when I tried to enter some SQL, it said 'no database selected'
how do I select a database? my database name is: photogallery
Wh...
Nonagon asked 13/3, 2011 at 2:36
1
© 2022 - 2025 — McMap. All rights reserved.