Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • 22:48

    pasenor on ci-windows

    debug (compare)

  • 22:42

    pasenor on ci-windows

    downgrade click (compare)

  • 21:20

    pasenor on req-file

    (compare)

  • 21:20

    pasenor on sqlcomplete2

    (compare)

  • 21:20

    pasenor on pin-max-req-versions

    (compare)

  • 21:20

    pasenor on pyoxidizer

    (compare)

  • 21:20

    pasenor on fix-socket-connection

    (compare)

  • 20:07

    pasenor on ci-windows

    debug (compare)

  • 20:05

    pasenor on ci-windows

    debug (compare)

  • 20:02

    pasenor on ci-windows

    debug (compare)

  • 19:59

    pasenor on ci-windows

    debug (compare)

  • 19:44

    pasenor on ci-windows

    try to fix temp files problem fail build on pytest failure (compare)

  • 19:35

    pasenor on ci-windows

    requirements for windows (compare)

  • 19:33

    pasenor on ci-windows

    requirements for windows (compare)

  • 19:32

    pasenor on ci-windows

    requirements for windows (compare)

  • 19:26

    pasenor on ci-windows

    pytest call (compare)

  • 18:46

    pasenor on ci-windows

    Windows CI (compare)

  • 13:10
    pasenor edited #950
  • 13:09
    pasenor assigned #950
  • 13:04

    pasenor on master

    Add shortcut to login-path para… Change shortcut to -g to avoid … Update changelog and AUTHORS and 2 more (compare)

Daniel Guldberg Aaes
@notaduck
do any of you know if it is possible to use vim over vi as an external editor?
incker
@incker
image.png
Hello, do anyone know faster way to select first variant than arrow down?
Oh, yes, it is Tab! thank you (found by myself)
Martyn T. Keigher
@MartynKeigher
Hey all!! Been playing with this tool now for a little bit, and its awesome!! Just have one question though... Is there any work being done to make JSON a style\type of output formatting?? I have ran through all the available formats, and while one of them is close (I think CSV?)...would really love it if JSON was available. Any insight that anyone can share on that?? - Thanks.
Martyn T. Keigher
@MartynKeigher
Update: I have my SQL output formatted as JSON, using SELECT JSON_OBJECT('id',id,'name',NAME) AS 'JSON' FROM `table` WHERE `id` = 3;. My formatting is set to 'plain', and this is close to what I am after, but is there anyway to TRIM the header from the output? All I want is the result. Maybe a new format type called 'minimal'?
BayMRX
@BayMRX
image.png
Does anyone know about this?
this is mycli, and it's normal in mysql
颜虎
@luojianet
hello
image.png
谁能帮我看下这个问题
aytrack
@aytrack
Hi, when I execute multiple statements in the current mycli after a certain statement in the middle fails, the subsequent statement will not continue to execute, how should I set it to continue to execute the following sql when there is a failed statement
Prajjwal Datir
@PrajjwalDatir
image.png
Hello, I'm newbie in SQL.
So my question is when I do
CREATE database 'something';
in MariaDB it works
but when I do it in mycli it shows
(1044, "Access denied for user ''@'localhost' to database 'something'")
What do I do?
Prajjwal Datir
@PrajjwalDatir
image.png
ACe
@alienhunter3010
Goodmorning. I'm new on gitter and on mycli too
I'm trying to customize stuff and I think it will be really cool to add colors to prompt (like escape codes?) so mycli and powerline could work together! What do you mean?
zhurongpeng
@zhurongpeng
image.png

select id, name from users in (156955, 156956, 156957, 156958, 156959, 156960, 156961, 156962, 156963, 156964, 156955, 156956, 156957, 156958, 156959, 156960, 156961, 156962, 15
6963, 156964, 156955, 156956, 156957, 156958, 156959, 156960, 156961, 156962, 156963, 156964);

When I copy, there is an extra space. How do I solve this problem

156963 becomes 15 6369
What do i do? Can this be done by configuration
ACe
@alienhunter3010
No, this depends from the terminal. I think you solve with multiline enabled (F3). Remember to close query with ;
zhurongpeng
@zhurongpeng
I've tried it, and whether It's enabled or disabled, the result is the same
ACe
@alienhunter3010
You need to explicite break the query line by line on the right place
zhurongpeng
@zhurongpeng
Yes, now I also do so, I think there should be a solution, but I don't know
Ganesh Chandrasekaran
@gchandra_twitter

hi mycli users.. I'm facing an issue.. hope someone has an answer.
When I try to connect to MySQL 8 which has SSL on.. I get this error.

(3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.')

Any trick to bypass the ssl and connect to it. Its a remote server where I dont get to control or access to certificate.

anchithAcharya
@anchithAcharya
Hey, does anyone have an idea on how to clear the screen in mycli?
ACe
@alienhunter3010
Ctrl+L - it works outside too :D
anchithAcharya
@anchithAcharya
Damn, didn't know that. Thanks a lot!
Logan Weaver
@LoganW_gitlab
image.png
Hey all, had a quick question. On an older install I was able to have a full query autocomplete. I can't seem to get that on a new install. Anybody know how to turn that on again?
ACe
@alienhunter3010
It works for me, it uses the history, I think. So maybe you need to launch more queries, before it will be useful
Logan Weaver
@LoganW_gitlab
I wound up figuring it out. I had installed it using apt-get which for some reason on Ubuntu 18 only has version 1.8 of mycli. I installed it using PIP instead and voila I got version 1.16 and have my full query autocomplete back. Thanks for the help though!
ACe
@alienhunter3010
I'm using mycli from July 2020, and I installed it directly from pip. Good that you solve it ;)
Alex Yelluas
@hiphamster
Hello fellow mycli users! Is it possible to add aliases / custom commands into mycli?
Logan Weaver
@LoganW_gitlab
Depends on what you mean, you can favorite queries that will get set to a custom name that you can run by doing \f query_name. Here's the the docs: https://www.mycli.net/favorites hopefully that's somewhat what you were looking for?
Alex Yelluas
@hiphamster
@LoganW_gitlab Thanks, this is quite useful
Bill Maca
@bmaca
Hey folks does anyone happen to know how I can shut off the interactive mode in mycli
i want everything to go to stdot instead it drops me into the interactive mode
Bill Maca
@bmaca
@channel
I found it
no pager
nopager
Suryaobulareddy2932
@Suryaobulareddy2932
Hi
I'm new to mysql database
I would like to know anyone using mysql with timeseries data?
Ahmad Y. Alrawi
@ahmad1995
Hello guys , so im trying to connecto to my local mariadb server and this error triggers everytime
mycli -S/var/lib/mysql/mysql.sock -P 3306 -u root -p0000
Traceback (most recent call last):
File "/usr/bin/mycli", line 9, in <module>
load_entry_point('mycli==1.22.2', 'console_scripts', 'mycli')()
File "/usr/lib/python2.7/site-packages/pkg_resources/init.py", line 489, in load_entry_point
return get_distribution(dist).load_entry_point(group, name)
File "/usr/lib/python2.7/site-packages/pkg_resources/init.py", line 2852, in load_entry_point
return ep.load()
File "/usr/lib/python2.7/site-packages/pkg_resources/init.py", line 2443, in load
return self.resolve()
File "/usr/lib/python2.7/site-packages/pkg_resources/init.py", line 2449, in resolve
module = import(self.module_name, fromlist=['name'], level=0)
File "/usr/lib/python2.7/site-packages/mycli-1.22.2-py2.7.egg/mycli/main.py", line 441
f"Connecting to socket {socket}, owned by user {socket_owner}")
is it a python issue or is it the socket
seabass
@seabass:chat.weho.st
[m]
@ahmad1995: I'm not an database expert by any stretch of the imagination, but by all means post the error message here and I shall take a look at it!