Search Results

Search found 19 results on 1 pages for 'sqlyog'.

Page 1/1 | 1 

• "please select equal number of source and reference" on sqlyog

  - by ripper234

  I am trying to add a foreign key constraint via sqlyog, and getting this error, although I am only select one source and one reference columns please select equal number of source and reference Does anyone knows what it means in this case? Note that I do have an equal number of source and reference columns...

  Read the article

• SQLyog alternative

  - by JohnM2

  Do you know any app similar to SQLyog (sql gui admin tool)? Especially, I am looking for opinion from users who had used SQLyog and found "something better".

  Read the article

• Where i have to get free mysql(sqlyog) enterprise edition.

  - by Ayyappan.Anbalagan

  Where i have to get free mysql(sqlyog) enterprise edition. regards A.ayyappan

  Read the article

• how to delete in Mysql

  - by Ian Moss

  i want to delete a element in mysql. the problem is that my connection not succesfully open and they give me error unable to connect even same connectionstring work elsewhere in current project. well when my code open the connection they work fine. but a small function try to delete a row in Mysql. i am confused what is goes wrong because :- same…

  Read the article

• Seeking a GUI auto-format feature for T-SQL

  - by dvanaria

  Is there a freely available GUI tool that will allow interaction with Microsoft SQL Server (via T-SQL) that provides an auto-format feature? I constantly find myself writing queries in SQL Query Analyzer (Microsoft’s standard GUI tool for T-SQL) and cutting/pasting the whole thing into SQLyog (a GUI tool for MySQL), where I can press F12 and have…

  Read the article

• Wrong intrepretation of some columns in ireport

  - by Purushotham

  Hi, I got a strange problem. I am using iReport 3.7.1 tool to create some reports. The Query Editor has one query. It shows all the data types of the fields in that query exactly same as the data types shown when I execute it using SQLYOG editor. The problem is here: One field data type is mismatched. I don't know the reason. SQLYOG says it is…

  Read the article

• Error code 1005 (errno: 121) upon create table while restoring MySQL database from a dump

  - by Jonathan

  I have a linux prod machine and a Win7 64bit dev machine. My workflow includes dumping the production MySQL database on the linux machine and restoring it in my local MySQL database on the windows machine (using SQLyog). This worked fine for a long time. Following some trouble, I formatted and reinstalled my windows dev machine. Since then I'm…

  Read the article

• Error code 1005 (errno: 121) upon create table while restoring MySQL database from a dump

  - by Jonathan

  I have a linux prod machine and a Win7 64bit dev machine. My workflow includes dumping the production MySQL database on the linux machine and restoring it in my local MySQL database on the windows machine (using SQLyog). This worked fine for a long time. Following some trouble, I formatted and reinstalled my windows dev machine. Since then I'm…

  Read the article

• Best SQL database gui tool for linux?

  - by jim

  Specifically I'm looking for a native linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential. Thanks!

  Read the article

• Fatal error encountered during command execution

  - by RICH KID SMART KID

  when i execute our error in sqlyog he work fine but in code when i execute i have error that "Fatal error encountered during command execution" what is means of it.

  Read the article

• Db2 sql dump tools

  - by adisembiring

  I am searching for tools to dump db2 tables (like sqlyog or MySQL browser in MySQL). Can you suggest me some? Thanks

  Read the article

• Best SQL database gui tool for linux?

  - by jim

  Specifically I'm looking for a native linux program that is similar in functionality to Navicat or SQLYog. I.e. I need something good at editing data. Free would be best, but not essential. Thanks!

  Read the article

• Downloading Database dump from server

  - by Ctroy

  I have a mysql database on a server that is around 4 gb in size and I couldn't get it downloaded to my local machine. I tried getting a dump on the server, but the dump is not getting created probably because of the big size. Is there any way, I could get the dump downloaded on my local machine? I can syncing using Sqlyog but I know it will…

  Read the article

• Ditch cPanel / WHM in favour of manual seup

  - by BWRic

  We currently use cPanel / WHM on a reseller account but are looking at getting a dedicated server. My first thought was to duplicate this set up on the dedicated box to allow us to quickly create new accounts. I'll be a managed server so they'll have set up the LAMP stack. I'm curious if I actually need cPanel and WHM. We don't use many of…

  Read the article

• PHP - MySQL - Select runs indefinitely

  - by John

  I have three tables listings: id, pid, beds, baths, etc, etc, etc, db locations: id, pid, zip, lat, lon, etc, etc, etc, db images id, pid, height, width, raw, etc, etc, db id, pid & db are indexed. db just references the mls provider a particular item came from. in images the raw column holds raw image data there are about 15k rows…

  Read the article

• Can't connect to MySQL database hosted in CloudBees

  - by user3692698

  I have a free CloudBees account and created a free ClearDB database using their wizards. My trouble is when I use their connection information (whether I try to connect from my Java app, or an outside tool - SQLyog to be exact) I take the error: Access denied for user 'b51dbc5757d79f'@'%' to database 'mywiki. The username provided by…

  Read the article

• You have an error in your SQL syntax; check the manual that corresponds to your MySQL

  - by LuisEValencia

  I am trying to run a mysql query to find all occurences of a text. I have a syntax error but dont know where or how to fix it I am using sqlyog to execute this script DECLARE @url VARCHAR(255) SET @url = '1720' SELECT 'select * from ' + RTRIM(tbl.name) + ' where ' + RTRIM(col.name) + ' like %' + RTRIM(@url) + '%' FROM…

  Read the article

• Syncing magento database froms development to production

  - by ringerce

  I use git for version control. I have a development, staging and production environment. When I finish in development I push to staging for review by the client. When approved, I push changes from staging to production. That works fine as long as there is no database changes. What happens if I install modules via Magento connect on…

  Read the article

• Can not delete row from MySQL

  - by Drew

  Howdy all, I've got a table, which won't delete a row. Specifically, when I try to delete any row with a GEO_SHAPE_ID over 150000000 it simply does not disappear from the DB. I have tried: SQLyog to erase it. DELETE FROM TABLE WHERE GEO_SHAPE_ID = 150000042 (0 rows affected). UNLOCK TABLES then 2. As far as I am aware, bigint…

  Read the article

1