Stack Overflow
Stack Overflow

Questions tagged [sqlyog]

SQLyog MySQL GUI is a MySQL manager and admin tool, combining the features from MySQL Administrator, phpMyAdmin and other GUI tools.

SQLyog MySQL GUI is a commercially available (closed-source) MySQL manager and admin tool, combining features from MySQL Administrator, phpMyAdmin and other GUI tools. It's produced and sold by Webyog.

272 questions
2
votes
2 answers

Error No. 2058 Plugin authentication_windows_client could not be loaded: The specified module could not be found

MySQL has a plugin that allows user authentication against current user’s Windows credentials. The plugin is ‘authentication_windows.dll’. I get the following error message from SQLyog: Error No. 2058 Plugin authentication_windows_client could…
Muhammad Siddique
  • 960
  • 1
  • 14
  • 31
2
votes
2 answers

How to query for formatted data in MySql

How can I query for improperly formatted data in MYSQL? For example, if I have the following data in my table: 1.John Doe 2.john doe 3.JOHN DOE 4.joHn DoE. I'm looking for a query that would return rows 2, 3, and 4.
user3346575
  • 37
  • 5
2
votes
2 answers

How can I access database mysql on the server staging?

Mysql gui tools that I use to connect to my database is sql yog I connect use data from env laravel If I connect with data from env localhost, it works If I connect with data from staging server, it does not works My env localhost like this…
moses toh
  • 12,344
  • 71
  • 243
  • 443
2
votes
1 answer

php loop is skipping or missing some results of mysql query

php loop is skipping or missing some results of mysql query, the same query is bringing 181 results in PhpMyAdmin and even in sqlYOG where as the loop is bringing only 175 $queryos = "SELECT * FROM OSCSBranch AS a LEFT JOIN (SELECT ItemCode AS…
Yasar Khalid
  • 71
  • 2
  • 10
2
votes
2 answers

Cant connect to MySQL server on localhost(0).Error No.2003

I am not able to connect to my SQLYog now. I am learning database queries.I could not view my databases.Initially, I downloaded SQLYOg Community 64, installed it and while 'connect to MySQL Host'. Then the following error has come.. Before that,…
Deepak Keynes
  • 2,291
  • 5
  • 27
  • 56
2
votes
3 answers

How to store string containing different language (like Chinese, hindi etc) in MySql 5.0

I am making use of mysql 5.0. Is there a way to store a string containing different language other than english? I tried to store the language Kannada but its storing it as "?????". i even tried changing encoding to utf-8, dosent work. (sqlyog)
Rookie
  • 23
  • 1
  • 3
2
votes
2 answers

Can anyone help me when my left join statement? I think the mySQL Engine is broken

Currently I am trying to output thru query the list of Start_Periods in a table called Payslip. This is just a simple query that I am testing out before turning it into something complex. But at this very simple level, there seems to be something…
Akira Hora
  • 458
  • 1
  • 6
  • 18
2
votes
1 answer

Error Code: 1005 - Can't create table (errno: 150)

I apologize for asking question related to this topic, I know this topic has been discussed on few other posts and its kind of a duplicate but the posts I been through did not help me in fixing my issue. I have the following SQL code to add two…
Nia
  • 151
  • 1
  • 12
2
votes
1 answer

Execute multiple select queries in MySQL - SQLyog

I am trying to execute two select queries like this in SQLyog SELECT * FROM `admin` SELECT * FROM `student` I got this error Then I tried adding semicolumn (;) at the end of first query SELECT * FROM `admin`; SELECT * FROM `student` I am…
mr. super cool
  • 196
  • 1
  • 12
2
votes
0 answers

Access mysql data through SSH tunnel using C#

I have MySQL database at cloud which can be accessed using SSH tunnel. however i am using c# to connect to the database. i also installed SQL connector for visual studio as well. Here are the steps i followed. Installed SQLYog for SSH client.…
shujaat siddiqui
  • 1,527
  • 1
  • 20
  • 41
2
votes
0 answers

how to fill dropdown from database with r shiny?

I have created the dropdown in shiny package . I am not able to populate it with the column in my database tables. ui.r library(shiny) shinyUI(fluidPage( h2("DATA ANIMATION"), sidebarLayout( sidebarPanel( uiOutput("names") …
aakash T.C.
  • 33
  • 5
2
votes
1 answer

deleting rows in sqlyog having null values

I have a table which dosen't have any key(foreign key and...). Some of table fields have null value. when I use the command: DELETE FROM `woe300websnt` WHERE (Arg1=NULL AND Rel=NULL AND Arg2=NULL); the query is run successfully but when I use…
BlueGirl
  • 491
  • 2
  • 9
  • 29
2
votes
1 answer

Where in the relevant specification is it documented that some comments in a SQL script are, in fact, to be executed as valid SQL (by MySQL)?

While browsing a SQL dump generated by the program SQLYog for a MySQL 5.6.16 database, I noticed that every stored procedure CREATE statement was surrounded by comment characters (/* */). However, the stored procedures were created when the SQL…
Dan Nissenbaum
  • 13,558
  • 21
  • 105
  • 181
2
votes
1 answer

Pass null value to stored procedure in Mysql

I am creating a stored procedure in Mysql. How can I pass value that will accept null? I know that in SQL Server 2008 R2, I do like this @name varchar(10) = null but how can I do this in Mysql? DELIMITER $$ CREATE PROCEDURE…
Abhishek
  • 319
  • 8
  • 23
2
votes
2 answers

Insert data into two tables in one php script

Method for inserting data into two tables: We do transfer the 2nd table in our Database. I made a separate connection for two tables. table name is transaction_held_record The columns that I need to fill-in…
Neri
  • 47
  • 1
  • 6
1 2
3
…
18 19