anzoone
Jan 24 2007, 06:28 AM
| | Hello all, i ve recently come across NavCat (GUI tool) for MySQL. I have not bought a copy yet, just played around with the demo. Has any one used it beore, if so please let me know if its worth buying. I already have PhpMyadmin, Just wanna know if NavCat is better than PhpMyAdmin in usibility and functionality.
Regards |
Reply
yordan
Jan 24 2007, 06:17 PM
I didn't use it. However, I have a question for you : How do you like it (from the demo) compared to phpmyadmin ? Is it nicer or does it have more usful functionnalities than phpmyadmin ? If yes, do you think it's worth to buy it ? Regards Yordan P.S : concerning the topic title, what is "musql" ? Maybe a mistyping for "mysql" ? 
Reply
anzoone
Jan 25 2007, 02:40 AM
Yes Yordan, it MySQL ...soryy..just a typing error. And about NAVCAT, It seems more user friendly than PhpMyAdmin..But when it comes to buying it i needed an opinion of some one who has used its fully functional version so i ll have a better understaning . The demo, as you would know does not show you every thing. Regards.
Reply
ethergeek
Mar 9 2007, 08:35 PM
I've used Navicat before...though to be honest the tools that MySQL AB provides (MySQL Administrator, MySQL Query) are superb. I've never found a task I couldn't manage with one of those 2 tools.
Reply
Mark420
Mar 10 2007, 01:29 AM
I must agree with you there..Ive tried a few packages also but always seem to come back to the default of MySql query browser and MySQL Admin - again I can say Ive nothing that they cant do when working together.
Reply
bchua
Apr 16 2007, 08:42 AM
navicat is surely better compared to MySQL standard Query Browser
Reply
iGuest
Sep 26 2007, 05:35 PM
Even the trial version of Navcat seems to give you decent intuitive, graphical, multi-table query building capabilities, something phpmyadmim does not offer and I could not figure out with mysql query browser. With mysql query browser, I kept dropping the join table onto the button but instead of joining, it would replace the table with the other one in the main text display. Adding tables, dragging and dropping columns on each other to create relational queries may be possible with mysql query browser, but it was not very intuitive to me if so. -Aurelio
Reply
iGuest
Mar 15 2008, 10:34 AM
Replying to bchuaI agree...I find the GA MySQL query tool is kind of quarky with long statements sometimes...And is sort of a pain to move in and out of...While the NavCat tool feels more like Terratrax a tool I use for MS SQL management. I haven't bought NavCat...Still using the tial, but so far I love it...Though there are still some features on the MySQL query tool that kick ass over the NavCat tool ;-) I will probably buy NavCat though eventually. -reply by Dustin
Reply
iGuest
Aug 21 2008, 11:18 PM
sqlyog
Navcat For MySQL
I found that SQL is the best tool for managing all MySQL databases, and the price is pretty cheap. The GUI interface designer is relatively new, but they are progressing quickly on it. Also.. The company fixes bug really fast. I was using the database compare tool once, and it was constantly crashing. They had the fix into a beta version and available for download in 2 days! -reply by patrick
Reply
Recent Queries:--
"navcat" - 109.14 hr back. (1)
-
000webhost mysql query browser - 148.12 hr back. (1)
-
navicat reading initial communication packet - 148.28 hr back. (1)
-
mysql client navcat download - 148.34 hr back. (1)
-
navcat for my sql download - 192.08 hr back. (1)
-
navcat for my sql - 191.55 hr back. (2)
-
mysql bulk insert xml - 196.10 hr back. (1)
-
download navcat - 16.99 hr back. (3)
-
1and1 mysql replication - 200.68 hr back. (1)
-
navcat download - 307.30 hr back. (1)
-
mysql administrator versus navicat - 341.68 hr back. (1)
-
access 1and1 mysql using navicat - 367.84 hr back. (1)
-
1and1 navicat 8 - 389.89 hr back. (1)
-
navcat - 1.56 hr back. (276)
Similar Topics
Keywords : navcat, mysql
- Mysql Overhead
(2)
Mysql Multiple Tables
(1) It is good practice to use multiple tables to sort out big amounts of data. But once you do that it
becomes increasingly hard to cross reference the tables. Mysql has a little beautiful command
structure that they have added. You can select multiple tables within one sql query. Example of a
basic sql query CODE $sql = "SELECT * FROM table WHERE row=1"; If you noticed
that I selected all of the rows in the table. Normally you will try to not select the entire table
from the database unless you absolutely want all of the table. I would recommend against....
Any Website Provide Free Host Mysql Host?
(4) any website provide free host mysql host? i need it because i am using 000webhost.com now but it
only provide 2 mysql database... can i know where or how can i get more databases regards....
Mysql On Computer
XD (9) I posted PHP on computer? , but for some reason it doesn't show :/. Anyways I am wondering if
there is MYSQL on my computer, meaning can i make a data base on my computer? that way i make what i
want and upload it when i get hosted =)....
Mysql Database Entry By Excel Sheets
(2) Hello .. I would like to ask if i can use use Microsoft excel files in order to make entries to
mysql database. Thanks....
Mysql Database Management
(1) Hi i am new, I have a problem in understanding the query decomposition in D-DB. Can anyone help me
to understand the first question of the exercise 25.21 of Elmasri-Navath 4th edition? Consider the
following relations: BOOKS (Book#, Primary_author, Topic, Total_stock, $price) BOOKSTORE
(Store#, City, State, Zip, Inventory_value) STOCK (Store#, Book#, Qty) Consider a distributed
database for a bookstore chain called National Books with 3 sites called EAST, MIDDLE, and WEST.
Consider that BOOKS are fragmented by $price amounts into: B1:BOOK1:up to $20.....
Mysql And User File_priv
(0) HI, I've hit the grain while trying to import file to mysql database - I need to enable file
permissions of the database user but this seems not possible with most of the hosting providers.
The problem is to set file_priv of the database user to "Y" . This is done in the "user" table of
the maintanance database named "mysql". cPanel doesn't allow this. Via the cPanel you can only
allow privileges on table querries but you cannot grant host file privileges to the database user -
which makes querries like: "LOAD DATA INFILE 'filename' INTO TABLE tablen....
I Have An Error With My Mysql Connection
mysql connection error (7) ok so here's my web page... http://lacrossems.t35.org/ it only lags cause its trying to
connect to the my sql server...i followed this guide
http://forum.ragezone.com/showthread.php?t=387249 and when i edit my config.php to my host and
login info i always get the error cannot connect to the database here is my config.php if you can
help me CODE <?php $host['naam'] =
'CENSORED'; // my host $host['gebruikersnaam'] =
'righto'; // my database username $host['wach....
Mysql Backup With Another Address?
(4) I just got my site hacked!! (don't worry because it is not on astahost) Actually it is a
wordpress blog. So I backed up my MySQL Databases with cpanel. Now when I get my hosting approved
here at astahost, can I restore those backups? Is the change of the site address going to interfere
with this? Is there anyway I can edit those databases to work with my new address? Please help me
out here!....
Sun Bought Mysql
(6) SUN bought the swedish company MYSQL for much money, around 2million each worker got in the company,
they did it to come in to the database market, is it a good reson to buy it?....
Mysql Problem
Linking tables (1) Hello guys, I'm making a PHP/MySQL site for a friend of mine who plays an online game where you
can create towns, add buildings to them and upgrade them to a newer level. I've offered to make
him a small site where he can input his data into a database and keep track of his towns, buildings
and levels. I'll show you my database design and then explain what i want to do. Table: towns
field 1: TownID (primary key, auto-increment) field 2: TownName field 3: TownType field 4: Town
Description Table: buildings field 1: BuildingID (primary key, auto-incremen....
Mysql - So Hard
Come in here if you think MySQL is soo hard! (14) Doesn't anybody think MySQL is so hard to code? I mean think about it, you need loads of
databases just for one little script and you have to type things in like ;Host-Username:
(blahblah) ;Host-Password: (blahblah) ;Host-DatabaseName: (blahblah) Ok, that MySQL code was
random, and it is alot harder than that. If you have expierenced it being hard, you are free to
post right in here, mate.....
Mysql Script Help
help me lol, (3) ok im a real noob to this myswql stuff i know what its for but can any1 write me a script for it for
user sigh up and like a myspace type of profile with a forms peferbly Wii FC code Games. Also can
some1 explain how to add the forms if it doset bother u guys too much TY....
Not Understanding Mysql
(4) Im not understanding MySql stuff can someone help me when u got to the MySql site and all that other
stuff is this like a log of your web stuff or does it help u desigen your website just wanted to
know what it does and how do u use this thing.....
Apache Php With Mysql On Windows [solved]
(9) I have problems running PHP MySQL function in a windows set web environment. PhP scripts are
executed but if I try to use mysql connect and other like functions I get a blank window (while
using the browser). The command line client is working...I've added the path to libmysql.dll
and the extension=php_mysql.dll in the php.ini.....
Subqueries In Mysql
Using subqueries in MySQL. Very helpful. (1) This method is very useful. I always use this when simple queries of linking two tables is not
enough. This method is putting a query inside a query. Example: SELECT * FROM table1 LEFT JOIN
(SELECT * FROM table2 WHERE field1='id') AS subtable or joining multiple queries SELECT *
FROM (SELECT * FROM table1 WHERE userid='001') AS subtable1 LEFT JOIN (SELECT * FROM table2
WHERE field1='id') AS subtable2 You can join more than two queries depending on the output
you want. If someone already posted this topic here I'm sorry I don't know.....
Mysql Query Question
MySQL Select query problem (3) Hii Guyz, I am having this little problem creating a query in MySQL. Problem description: Table:
mytable Table Structure: IssueId | ToolName | Status 01 | Tool1 | Open 02 | Tool1 | Closed 03 |
Tool2 | Closed 04 | Tool3 | Open Now, I want to get the results in the following form: ToolName |
Count(Open) | Count(Closed) For the above input, result will be: Tool1 | 1 | 1 Tool2 | 0 | 1 Tool3
| 1 | 0 There should be NO duplicate toolName in output. Thnaks, Manu.....
Oracle Vs. Mysql Vs. Postgresql
POLL!! Choses you preferred db s/w! (9) Hey Everyone!, Please choose your preferred database s/w! Regards, Avell....
Login System Using A Mysql Db
How do i do this? (5) Hi guys, ive got a registration system that looks something like the one below: Firstname:
Lastname: Then i have inset.php, which looks like the following: $con =
mysql_connect("localhost","autobot","abc123"); if (!$con) { die('Could not connect:
' . mysql_error()); }mysql_select_db("my_db", $con);$sql="INSERT INTO person
(username, password) VALUES ('$_POST ','$_POST ')";if
(!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record
added";mysql_close....
Problems With Php Saving Data Into Mysql
HELP! I can't get my php documents to work with the mySQL (6) i have a server that says it allows php and mysql and in the control panel i can access mysqladmin
and phpmyadmin but i cant get the php to save data into the mysql, i am trying to make a text-based
MMOG so i need to save my users/passwords into a database(i thought) and it won't do it, can
anyone help me....
Mysql And Php
When trying to install Joomla (15) I don't know if this is the correct forum, but here is my question: I'm trying to test
Joomla and some forums in my computer, I have already installed MySQL with the GUI tools, Apache,
and PHP with the MySQL and MySQLi extensions, but when I'm trying to install Joomla I get this
error: Required Settings Check: ------------------------------------- PHP version >= 4.1.0
Yes - zlib compression support Available - XML support Available - MySQL support
Unavailable configuration.php Writeable Session save path Unwriteable Not ....
Permission Problem With Mysql Database Creation
Please Help! (8) I seem to have a problem with accessing my database with proper permissions. I have set the my
database correctly giving my db username all priviliges yet i seem to be unable to even log on with
this username with a denied access error. Any ideas on resolving this?....
Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database
(4) Hello to all of you beautifull people out there, I am new to MySQL, i just wanted to know if its a
good practice to directly store images and other binary files in a MySQL database. Any one with
help? Thanks....
MySQL, Multiple Tables
(24) Ok, I'm coding a project which is a leap than what I'd normally do. Before, I've always
learned ONE table... put EVERYTHING in one database table. I'm making a profile system so there
needs to be at least two tables: 1 for users, 1 for content. My problem is, how do I link the two
together? I could probably figure this out faster if someone explained and posted sample SQL code
that shows how the two are linked together. Thanks!! F....
MySQL Output Database Question
(18) I am new to MySql and have just created a database after using a script. My problem is not the
script, but what it says about putting it into the output file. I cant figure out the right terms
to put it in, I keep getting errors. I try using; SELECT*FROM 'database name' WHERE
'location' but it isnt working. I'm lost with this stuff, I really am. Can someone
please help me out?....
How To Connect MySQL With Flash?
Help me connect my flash Work with MySql (8) I know Flash and mysql but could not figure out if I could ever connect these? I want to have a
dynamic content in my flash object that could be retrieved from the database directly without myself
needing to update it again and again. How can I achieve this ? Do I have to install any additional
controls or connectors to do that ? If yes any one tell me....
Mirror My MySQL Database To Another Mysql Server
(4) Hi..I want to ask if its possible to automatically mirror my mysql databases into another mysql
server?or create a small php script to do this? The reason is because, we all know that database is
very improtant if we have dynamic website. I have my forum hosted and i want to automatically
mirror this or backup into another mysql server(free). Like in freesql.org. So that im not afraid
that i forgot to backup my database..also i have one central backup database. Thanks for the
help..Im looking forward for this posibility.....
Recover Tables From A MySQL .frm File
(8) I have a couple of .frm files with no corresponding data or index files. Is it possible to recover
the table structure (field names, types, sizes, rows,col, etc) from these files? The table type is
innodb....
MySQL Realtime Replication
how to replicate mysql in realtime (4) i dont know if this might be useful to ppl here, but this is a very good knowledge for serious
siteadmins. while i was digging for mysql backup techniques, i've found that mysql is able to
do realtime replication. the idea is that there are master server and slave server. both are having
the same version of mysql installed. the data flows; Master >copy> Slave ( in realtime!)
you'll never have to manually copy the database file of wasting your time to manually use the
mysqldump command. here are the links; http://dev.mysql.com/doc/mysql/en/Replication_HOW....
MySQL - Trouble With Bulk Insert Statements
(3) I'm trying to insert about 500 rows into mysql, but I keep getting errors. If I copy and paste
too many (about 50) insert statements at a time I get errors sometimes. I sometimes even get errors
but then the row is skipped so I don't know there was an error (I'm using linux and SSH).
What's the best way to get my insert statements to put the data in MySQL? Is there anyway that I
can have it tell me if there where any errors all the statements are executed? Thanks for your
help.....
Looking for navcat, mysql
|
*RANDOM STUFF*
*SIMILAR VIDEOS*
Searching Video's for navcat, mysql
|
advertisement
|
|
