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
4
votes
1 answer

SQL LIMIT by id column

I have the following statement: SELECT s.*, u.`fname`, u.`lname`, aif.`airport` FROM services s INNER JOIN airports_in_flight aif ON s.`id` = aif.`service_id` INNER JOIN users u ON s.`service_provider_id` = u.`id` Lets say for example that…
Gil404
  • 711
  • 1
  • 8
  • 22
4
votes
3 answers

How to use to_char function functionality in MySQL

I have a table tine_by_day and I know how to use TO_CHAR function in oracle, but how to get same output if I use in MySQL? Is there any conversion function in MySQL for TO_CHAR()? I have already tried date_format instead to_char but I'm not getting…
sam140
  • 219
  • 1
  • 5
  • 27
4
votes
2 answers

Select for items meeting both of two criteria in SQL

I have a system that reports the XYZ location of items in a field to a SQL database. I am attempting to filter for false positives (only identifying moving items) by filtering for a known point in time when items pass a point, and at what location…
Uberbot7147
  • 51
  • 7
3
votes
2 answers

How to increment using a SQL variable within an update statement

I am trying to increment a column using an @count variable in SQL. I have tried multiple attempts that I will list below that all result in: Error Code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL…
Kevin Minds
  • 43
  • 5
3
votes
1 answer

What is the proper if clause syntax for a MySQL stored function?

I am brand new to MySQL, so I apologize if some of this is relatively elementary. I'm trying to write a stored function to round a digit to a certain number of significant figures. I have a function which, in theory, should work - I consulted…
oliviaratliff
  • 35
  • 5
3
votes
4 answers

Use Select data in nested Select statement in MySQL

I have a query in MySQL. Full Query SELECT tc.expense AS expense, tc.tour_sub_code, tc.login_id FROM tc_wallet tc WHERE tc.login_id = 'vinod.kumbala' AND tc.expense = 'Daily Allowance' AND tc.delete_flag = 'F' AND…
Ajinkya Karode
  • 177
  • 1
  • 4
  • 18
3
votes
2 answers

Converting string to timestamp format in MySQL

I have a column in my MySQL database which has timestamp data in string format. I want to convert it into timestamp format. Below is the sample data: Date -------------------------------- Fri Dec 14 14:11:43 IST 2018 Fri Dec 14 14:13:20 IST…
goonerboi
  • 309
  • 6
  • 18
3
votes
1 answer

Keyboard shortcut to format statements in Sqlyog?

What is the keyboard shortcut to pretty-format statements in Sqlyog?
ripper234
  • 222,824
  • 274
  • 634
  • 905
3
votes
1 answer

SQLyog Copy Table with geometry field failing with Cannot get geometry object from data you send to the GEOMETRY field

I'm trying to perform a Copy Table(s) To Different Host/Database in mySql using the SQLyog IDE, and am facing the following error upon copying a table that has 2 geometry fields: Cannot get geometry object from data you send to the GEOMETRY…
Veverke
  • 9,208
  • 4
  • 51
  • 95
3
votes
2 answers

How to set "performance_schema on" in mysql?

I want to turn performance_schema ON in mysql to collect statistics. How can I achieve this?
Vikrant More
  • 5,182
  • 23
  • 58
  • 90
3
votes
1 answer

Cannot drop a mysql table

I am getting a weird error. I have a table animals, that I am trying to drop. I cannot drop the table because of a foreign key constraint fails. I know that I must drop the foreign keys before I drop the table. The problem is this table has no…
wesleywmd
  • 605
  • 1
  • 6
  • 20
3
votes
1 answer

How to connect to remote mysql using sqlyoug or heidisql

I have mysql installed in unix box i want to connect that using sqlyog. Usually i can connect through putty as below. login as : root root@IP's password:: xxxxx [root@somealiasname ~] mysql -u root -p Enter password : mysql> How to Connect this…
Azhar
  • 933
  • 1
  • 12
  • 28
3
votes
2 answers

sqlyog export query result as csv

I'm using SQLyog and I was wonder if would be possible to export query result as csv? What I mean let's say I have query like SELECT * FROM wp_comments WHERE comment_post_ID = 902 and I would get back some rows what I would export as csv. Found it!…
fefe
  • 8,755
  • 27
  • 104
  • 180
2
votes
2 answers

MySQL 2003 Error : can't connect to localhost (10061), but PHPMyAdmin works

I'm trying to connect to the MySQL server that came with WAMPServer locally using SQLYog, but it gives me this error: Error No. 2003 Can't connect to MySQL server on 'localhost' (10061) However, phpmyadmin works just fine, and mysql_connect()…
bryc
  • 12,710
  • 6
  • 41
  • 61
2
votes
2 answers

MySQL's wait_timeout incorrect in SQLyog

Following this question, I set the following MySQL parameter in C:\Program Files\MySQL\MySQL Server 5.5\my.ini (the equivalent of Linux's my.cfg): [mysqld] wait_timeout=2147483 After restarting Windows I used SQLyog to see the effect: SHOW SESSION…
Jonathan Livni
  • 101,334
  • 104
  • 266
  • 359
1
2
3
…
18 19