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

Error in creating view in mysql. while query runs correctly when independently run

This mysql query runs just fine independently. But when I use this query to create a view then Error Code: 1064 message appears in sql yog. Please identify the reason of this error. CREATE VIEW `databaseName`.`viewName`…
A.M
  • 63
  • 11
0
votes
5 answers

Is .sql file different for MySQL and SQL?

I have a .sql file and I want to load it into MySQL database. I don't know from which database (MySQL or MS-SQL) it was created. Now, I am trying to import that file into MySQL database. It is showing errors while importing and executing that…
Amit
  • 33,847
  • 91
  • 226
  • 299
0
votes
1 answer

Preventing WAN access to a Database

How do I prevent WAN access to a particular database in SQLyog? I am able to grant full access to particular DB's, but not able to prevent them. I have a Web APP that runs on an internal server and accesses MySQL on the same server. I have created…
user3099756
  • 87
  • 1
  • 1
  • 6
0
votes
2 answers

Failed to Run any "Model/Controller in Browser using YII and gii ?

I am newbie in Php using YII and Gii when iam trying to open any model and controller file in browser i am getting error the console of error and code is: CODE:
user3233280
  • 279
  • 2
  • 7
  • 21
0
votes
1 answer

How to use SQLyogTunnel_ciom.php

I am working with mysql credentials where I always get an error : access denied for root@user I have ssh details so I used heidisql and sqlyog to connect to database, It worked. Now I have to write code for this database using php. mysqli_connect…
techrahul87
  • 107
  • 2
  • 11
0
votes
0 answers

How to get longtext to default to empty string

I am using mysql 5.1.36 and SQLyog. I have a longtext field in my table. However, it defaults to 'null' meaning that when I get the data it actually returns the word 'null'. How can I alter the table to instead of defaulting to null, it is just…
Lee Loftiss
  • 3,035
  • 7
  • 45
  • 73
0
votes
2 answers

SQL joins confusion

what is problem in this join??? The console says Error Code: 1051 Unknown table 'invlabtes' SELECT invlabtes.*, invgatepass.BuiltySupp FROM invlabtes FULL JOIN invgatepass ON(invlabtes.GatePassNO=invgatepass.InwardNo AND…
A.M
  • 63
  • 11
0
votes
3 answers

Multiple SQL counts into single result set

Howsit everyone I am trying to do something i think is impossible on MYSQL. We have a very large database where we pull production reports from for our products created. At the moment we run multiple queries to get these results and then transfer…
Stroes
  • 351
  • 2
  • 5
  • 23
0
votes
1 answer

Sqlyog error 1452

I'm having problems with the foreign keys. I have a table DETAILS that contains general details with the NAME being the primary key and another table SYMTOMS with two columns NAME and SYM. I have tried to refernece DETAILS to SYMPTOMS through NAME…
user2701073
  • 1
  • 1
0
votes
1 answer

How to query and group every continuous number series in MySQL?

I have this freight.or_nos table which contains series of receipt numbers. I want to list all the or's being issued excluding the status='Cancelled' making the series broken in groups. For example I have this receipt stab 125001-125050, and 125020…
eggshot
  • 190
  • 6
0
votes
1 answer

How to setup a cron job in SQLyog

I want to create a scheduled job in SQLyog (or suggest me if any) that will run a SQL query every 30 minutes. I want to run the query - UPDATE `db`.`table` SET sessiontime = CEILING(sessiontime/6)*6 WHERE id>1000 Please help me to figure out…
W3Xperts
  • 1
  • 1
0
votes
2 answers

Error in Delete SQL syntax

ok guys i need your help im having trouble in mysql syntax i have a table of CREATE TABLE tblemployee( `employeeID` int(5) Primary key not null, `employeefname` varchar(15), `employeelname` varchar(15), ); CREATE TABLE tbltimpunch( `employeeID`…
daniloJR
  • 37
  • 1
  • 8
0
votes
1 answer

how do i get the last inserted column in sqlyog database without using top or last function?

I have a table named tbltimpunch that has the following columns: employeeID (not primary key/not auto inc) dateoftime (time of day) timein (the time input by the employee) timeout (the time of clockout) It can be created with the following…
daniloJR
  • 37
  • 1
  • 8
0
votes
2 answers

Output blob from mysql

I'm having a wierd problem with PHP/MySQL. I have uploaded into a BLOB a word document. Its successfuly and if (say using SQLYog) I open and save the BLOB as a file it will open perfectly in Open Writer. However the minute I try to output the data…
user1924004
  • 1
  • 2
0
votes
2 answers

SQL SELECT QUERY

i have 3 tables: users: uid int(11) - userid(primary key, auto_increment) name varchar(255) pass varchar(64) created int(11) projects: pid int(11) ..... name varchar(150) description varchar(255) created int(11) users_projects: uid int(11) -…
emcee22
  • 1,851
  • 6
  • 23
  • 32
1 2 3
…
18 19