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
-1
votes
2 answers

MySQL: Non-english characters messes up our SELECT queries

Have a problem doing select queries on our MySql database. This query is working fine: SELECT name FROM products WHERE brand = 'nike' This one doesn't: SELECT name FROM products WHERE brand = 'tøj' There are 1,000+ products with brand = 'tøj', so…
Louisa
  • 552
  • 1
  • 9
  • 22
-1
votes
1 answer

MySQl - Import Multiple .sql Tables

How do i import backup of individual tables (.sql files). I want to use a Db name,ip (mysql machine ip), user, pwd to import all .sql files. My MySQL is on a windows machine
Oggu
  • 323
  • 1
  • 6
  • 18
-1
votes
1 answer

Not inserting correct characters in SQLyog DB from C#

I have a local DB in SQLyog and WindowsFormApplication which is connected to that database. I am from Serbia, so I want to insert and our special characters (š, ć, đ, č, Š, Ć, Đ, Č). I have set DB collation to be UTF-8. But, this seems not to work.…
Marko Kirac
  • 1
-1
votes
2 answers

How to increase the max load file size in VB.NET?

I have a console to load the sample.txt file into Table in database but it's failed when the sample.txt file size is more the 4000kb. How to incerase the limit? I think the default limit is 4096kb. When I run the SQL query in MYSQL its successful…
alkapunzi
  • 1
  • 2
-1
votes
1 answer

incorrect date value dd/MM/yyyy hh:mm:ss tt even datetimepicker formatted as dd/MM/yyyy only

i use datetimepicker to save date only but when i save it to the database, it always have time with it. I custom format datetimepicker to date only dd/MM/yyyy but still gets the error it has time with it. BTW, Date column datatype is Date here's my…
user5567987
  • 167
  • 1
  • 12
-1
votes
2 answers

how to keep checkbox checked even after page refresh

I have one checkbox on my form working with the database for active(1) and inactive(0) users to access via admin panel. All is working fine but the problem is its not keeping the record for the checboxes when the checkbox is checked or unchecked…
H45H
  • 1,019
  • 10
  • 28
-1
votes
1 answer

Error 2007 - SQLyog

Good Morning, I am trying to connect to a Mysql Data base using SqlYog, I have created a new connection and I have entered all the necessary informations (login,password & port). But when I click “ok”, I get this error message (Error 2007 : Protocol…
Mohamed
  • 89
  • 1
  • 4
-1
votes
4 answers

Error 1064 when trying to create a table

Here is the code: create table `team`.`User`( `UserID` bigint NOT NULL AUTO_INCREMENT , `Username` text(30) NOT NULL , `Email` text(30) NOT NULL , PRIMARY KEY (`UserID`) ) Engine= [default] comment='' row_format=Default And the…
Henry Henrinson
  • 5,203
  • 7
  • 44
  • 76
-2
votes
2 answers

MySQL managers. What are advantages and shortcomings of the SQLyog and EMS SQl Manager

I need to find most useful MySQL manager. And I found SQLyog and EMS SQL like most popular. Maybe I'm not right. So, please, advise me something.
Frankie Drake
  • 1,338
  • 9
  • 24
  • 40
-2
votes
1 answer

using string in an IN clause

UPDATE assets a SET a.labor_c_start_dt = '2017-01-01', a.labor_c_end_dt = '2017-12-31' WHERE a.asset = IN(asset1,asset2,asset3) I'm trying to get it to check for the asset name match it and then adjust the following fields. but for some…
Seth Pritchard
  • 77
  • 7
-2
votes
2 answers

how to use datetimepicker on Delphi 7

How to use TDateTimePicker with time format (hour:minute:second)? I tried this code: Sql.text:= ('select * from namatabel where namafield between '+quotedstr(formatdatetime('yyyy/mm/dd', datetimepicker1.date))+' and…
Wirah Arya Mardjani
  • 3
  • 1
  • 4
-2
votes
1 answer

Getting 500 Internal Server Error when trying to run PHP application of yii in Browser?

I am newbie in Php as this question has already been asked several times.... I have import php project in netbeans and db as well in sqlyog but when i am trying to run that app i am getting error in browser Here is the error : Internal Server…
user3233280
  • 279
  • 2
  • 7
  • 21
-3
votes
2 answers

I want to put 'given' and 'surname' column together into 'fullname' in SQL, how would i go about in doing so. tnx

I currently have them separated but would prefer to have both together in one column.
Mnb
  • 3
  • 1
-3
votes
1 answer

Stored Procedure For Deletion in SQLyog

DELIMITER $$ DROP PROCEDURE IF EXISTS `payroll`.`usp_DeleteDesignation`$$ CREATE PROCEDURE `payroll`.`usp_DeleteDesignation` ( IN DesgID int(11) ) /*LANGUAGE SQL | [NOT] DETERMINISTIC | { CONTAINS SQL | NO SQL | READS SQL DATA |…
user1779087
  • 11
  • 1
  • 1
-4
votes
1 answer

SQL query to find out Display employee name as well as their age and experience in years

SQL query to find out Display employee name as well as their age and experience in years. SELECT ENAME, CONVERT(VARCHAR(3),DATEDIFF(MONTH, DOJ, GETDATE())/12) +' years '+ CONVERT(VARCHAR(2),DATEDIFF(MONTH, DOJ, GETDATE()) % 12)+ '…
user123456
  • 143
  • 1
  • 2
  • 13
1 2 3
…
18
19