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
142
votes
5 answers

How to change the default charset of a MySQL table?

There is a MySQL table which has this definition taken from SQLYog Enterprise : Table Create Table ----------------- …
pheromix
  • 18,213
  • 29
  • 88
  • 158
19
votes
2 answers

Operation not allowed when innodb_forced_recovery > 0 [SqlYog]

I have created a table using SQLyog. When i insert values into it, it pops up following error message: Operation not allowed when innodb_forced_recovery > 0. My table consist only four columns including one primary key. Following is my create and…
RK.
  • 973
  • 5
  • 19
  • 45
18
votes
4 answers

How to run script from within Mysql workbench?

I have a SQL script to distribute to others to run from a MySQL IDE, not from a MySQL command prompt. I want the user to load the script into a window of workbench (or another IDE like sqlyog) and just run the script, which inserts records based on…
draca
  • 1,319
  • 5
  • 16
  • 32
10
votes
3 answers

How to migrate SQLYog server connections to another machine

I am changing my work computer, and need to move my sqlYog saved connections to the new machine. I do not remember the passwords, is there a way to move it? Windows 7 machines.
Mindwin Remember Monica
  • 1,469
  • 2
  • 20
  • 35
10
votes
6 answers

How to import mysql dump to SQLyog

I have few sql dump files like the tables taken from other db. Now i want to update the tables into my server using the sqlyog. So can anyone help me out in importing .sql files into the SQLyog ??? Thank u in advance
Php Geek
  • 1,107
  • 1
  • 15
  • 36
9
votes
3 answers

MySQLWorkbench forward engineering error

I'm working on a model in MySql Workbench 8.0, when I click on forward engineering and try to generate the script of my model I get Executing SQL script in server ERROR: Error 1064: You have an error in your SQL syntax; check the manual that…
Sebastian Luna
  • 476
  • 1
  • 7
  • 18
7
votes
2 answers

How to select optimal batch size in JDBC?

I have a CSV file with 50000 entries which I want to import in SQL using batch in JDBC. What should be the optimal batch size for it?
Shivam Agrawal
  • 85
  • 1
  • 1
  • 6
7
votes
3 answers

Select the SECOND LAST record in each group

There is a table Remark that contains data as shown below: SerialNo | RemarkNo | Desp ============================================= 10 | 1 | rainy 10 | 2 | sunny 11 | 1 | sunny …
Kim Stacks
  • 10,202
  • 35
  • 151
  • 282
6
votes
4 answers

Insert into, select and where statement combined

How to insert record from Table A to Table B based on the conditions in Table C. Table A: ID Name DateFrom DateTo 1 Alex 22-7-2015 26-7-2015 2 Alice 21-8-2015 25-8-2015 Table C: ID Quarter DateFrom DateTo 1 Quater 1 1-7-2015 …
Lee Lee
  • 63
  • 3
6
votes
11 answers

Error No. 2003. Can't connect to mysql server

I has had two days searching and exploring solutions regarding the error 2003. Can't connect to mysql server on 'Server name'. The firewall is off and I had added the port 3306, the one that mysql uses. Any recommendation?
Sterling Diaz
  • 3,789
  • 2
  • 31
  • 35
5
votes
5 answers

Generate ERD from SQLyog

is there a way for me to generate an Entity Relationship Diagram (ERD) from SQLyog? or if not, from PHPmyAdmin of XAMPP? thanks!
Brandon Young
  • 523
  • 2
  • 8
  • 19
5
votes
1 answer

Error: 1449, "The user specified as a definer ('root'@'localhost') does not exist"

I get the above error when I try to retrieve data or insert data via my app to my database. The proc code is as follows CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_createUser`( IN p_name VARCHAR(20), IN p_username VARCHAR(20), IN…
Oreo
  • 181
  • 1
  • 2
  • 12
5
votes
3 answers

Getting Error while deleting mysql.general_log table

5, getting error while executing below query, delete from mysql.general_log Error getting after executing above query, Error Code: 1556 You can't use locks with log tables. can somebody please help me to resolve above error.
Vikrant More
  • 5,182
  • 23
  • 58
  • 90
5
votes
2 answers

Rearrange column order in Sqlyog

Is it possible to rearrange a table's column order in SQL yog?
ripper234
  • 222,824
  • 274
  • 634
  • 905
4
votes
3 answers

Foreign key as Primary key

I designed tables like this: table1: students --------------------- PK id name number ... --------------------- table2: students_score --------------------- PK FK student_id math_score english_score ... --------------------- Question 1 If some…
Sanghyun Lee
  • 21,644
  • 19
  • 100
  • 126
1
2 3
…
18 19