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
0
votes
0 answers

adding another to column and fill it with values

I have a full working table. it already has data. I need to put another column that will serve as a serial code of each row that was created. the format of the serial code would be user-1, user-2, etc. how do I do that?
nathanie0221
  • 3
  • 1
  • 5
0
votes
1 answer

Mysql custom function

Can someone explain why this isn't working? I've tried it in phpMyAdmin and an amended version in SQLYog CREATE FUNCTION `manageDate`(a VARCHAR(200),b DATETIME) RETURNS DATETIME BEGIN DECLARE datevar DATETIME; IF (a REGEXP…
user1018244
  • 113
  • 6
0
votes
1 answer

why the output error, I do not understand

create table qbey ( idqbey int primary key auto_increment, bey int, users int, foreign key (users) references persons(idusers) on delete cascade on update cascade, foreign key (bey) references bey(idbey) on delete cascade on update…
Nasiba Sharipova
  • 13
  • 3
0
votes
1 answer

Warning Code : 1264 Out of range value for column for datetime column value

Here's my query: UPDATE lynn_mis_goodsales SET accepteddate = '2011-02-30 13:24:50' WHERE created LIKE '0000-00-00 00:00:00' The column value is datetime, and the error given is: Warning Code : 1264 Out of range value for column…
learner23
  • 75
  • 2
  • 4
  • 11
0
votes
1 answer

workbench is necessary for the creating local database form the script file

i downloaded Mysql server for win64-bit machine from http://dev.mysql.com/downloads/mirror.php?id=409022 this link. Then i installed the server.After completing the installation i ll not find workbench. Is workbench is necessary to create local…
Vinoth
  • 753
  • 3
  • 12
  • 23
0
votes
2 answers

Create Table fails in sqlyog

CREATE TABLE inventory ( id INT IDENTITY(1,1) PRIMARY KEY, product VARCHAR(50) UNIQUE, quantity INT, price DECIMAL(18,2) ); error is Error Code : 1064 You have an error in your SQL syntax; check the manual that…
user1528105
  • 1
  • 1
0
votes
1 answer

Mysql Stored Procedure SQLYog issue

I have setup my site in a way that I develop on localhost and then just updates it and all is good to go then but, there is a problem with the Stored Procedures. When I create a stored procedure on localhost and then using sqlyog copy that to live…
Junaid
  • 2,084
  • 1
  • 20
  • 30
0
votes
1 answer

SQLyog (webyog) change table access for root

We are more than 1 user working on SQLyog (webyog), we all use root to login, recently it has been brought to my attention that some confidential data has been leaked from 1 of the tables that I work on. I have been instructed to have a look into…
user1354195
  • 3
  • 1
-1
votes
1 answer

Database connectivity in ASP.NET

I want to connect my database that I have created in SQLyog (version 9.2.02) to Visual Studio 2010 using C#. I am working on an Online Reservation project, and I am not finding the appropriate steps to do it. How to proceed?
user1240912
  • 29
  • 1
  • 2
-1
votes
1 answer

Cant login to Sql WorkBench as I forgot my root password

I have forgotten my root@localhost password for MySQL and because of this, I am unable to connect to the database. How do I change it?. I tried the Alter method in which we have to set a new password in a txt file and then run. I tried that but it's…
Arnab Das
  • 31
  • 7
-1
votes
1 answer

How to add check constraint in 'SQLyog community edition - Mysql GUI'?

There is no check constraint tab in SQLyog community edition - Mysql GUI.
Arhana
  • 41
  • 6
-1
votes
1 answer

Max(date) with inner join and where clause

I have 2 tables, user and order. Both name and group in user table form a unique combination, so note that here we have total of 5 unique combination in the entries. For each unique combination, i would like to find their latest respective status,…
Santa
  • 47
  • 14
-1
votes
1 answer

Error Code: 1060 Duplicate column name 'fsu_id' in the attached mysql view

I am receiving Error Code: 1060 Duplicate column name 'fsu_id' in the attached view that I am trying to create even the field names are pre-fixed. I am creating the view using tool called SQLyog. The tables bkd and rcs are actually views I have…
Malcolmf
  • 75
  • 8
-1
votes
1 answer

Sqlyog - multiple SQL queries

I have set of SQL select queries to execute and share the consolidated results in excel sheet, I'm using sqlyog to do this. Every time I execute results are in multiple tables. Can I get the results in a single table? Select * from a.table; Select…
user9606172
  • 1
  • 1
-1
votes
1 answer

Are there any MySQL tools available for modifying Stored Procedures using GUI (not manually by writing code)?

I want to know that is there MYSQL Tool available in which we can modify the existing Stored Procedures by using GUI. I do not want to write code manually in the Stored Procedure.
Mudassar
  • 3
  • 1
1 2 3
…
18 19