Any Tool Where You Can Visually Trace Query Joins?
Talking with a colleague, we wondered if there exists a tool where you can build a query and see all the tables it joins visually but soem sort of line or graph.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
MySql Query Checker Tool
I want to test my web site for the query load checking. Basically mine is a dynamic site where there is lots of traffic. I want to check my query with multiple requests at same time to see how it is affecting my server and how mysqld service is behaving? I have rectified all the things for my query however still some time my mysql service reaches 99% load under high traffic which leads to server crash. So if I can check my query with heavy traffic, then only I ll be able to find actual problem.
Joins Query
I have a page whereby I list all events and flyers for each event. Because each event can have more than one flyer it's obviously a many-to-many relationship, so I have introduced a new table called event_flyers which has the following fields; event_id, flyer_id. How *should* the query look? SELECT * FROM calendar, flyers LEFT JOIN calendar_flyers ON calendar_flyers.flyer_id = flyers.id WHERE calendar_flyers.calendar_id = calendar_id
Relational Query And JOINs
I'm trying to set up a simple invoicing system, and am having trouble figuring out the right query to retrieve data from three tables... The important fields in the tables are: Customers: CustomerID, Name, Address etc etc Orders: OrderID, CustomerID, PaidSoFar OrderRows: OrderID, ProductID, RowTotal I need to make a list looking something like this:
Trace Sql's
Sql Server has a program that we can configure to trace the sql's executing. Is there any program that does the same thing for mysql
Track And Trace
I work for a 5 man company selling track and trace service over the internet. I'm the only full time software guy. We are growing, and I can see soon we are going to start hitting BIG problems, we aren't make any money yet. This doesn't help as I think we need a real MYSQL + Internet guru guy. So my option was this hoping to get some simple answers I can use to before It get out of hand. We have one server running our software and we just bought another. So can it be setup that both servers have there own database, and update each others database. This means if something happens to one server this other can take over the other. I was thinking to make it customer based with server to logon to.
Design / Query Confusion - Joins?
Sorry for the long post here. I'm trying to give enough info. to explain my situation, and am novice enough to not know how much someone might need to know to help. I'm very new to SQL, I've read through the Sitepoint "Build Your Own Database Driven Website" book, and though I did follow it, I didn't build the joke database, I just converted it to the specific task I want to do to organize some stuff for my department at work. Basically what I am doing is tracking design drawings; Job name and number, clients, architects, when drawings leave and return for approvals, to the shop and field, etc... Getting all the information that our detailers might need, in one place. Where I'm running into problems, is designing the database with some thought on how we set up our job numbers and attempting to keep the tables fairly small by creating tables for each year. A typical job number would be something like: B06-064 (B is first initial of the Project Manager - 06 for the year - and 064 for the 64th job that year) 04_jobs, 05_jobs, and 06_jobs all have the same columns: CREATE TABLE 04_jobs ( job_year YEAR(2) NOT NULL DEFAULT ཀ', id SMALLINT(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT, job_name VARCHAR(255), pm_id TINYINT(3), client_id SMALLINT(4), arch_id SMALLINT(4), finished SET(Ɔ', Ƈ') NOT NULL DEFAULT Ɔ', PRIMARY KEY ( job_year, id) ); The job_year seems a bit redundant since the tables are named by year- I was thinking the problem with my select query had to do with the duplicate PKs (id) across tables - this may be a good indication of how little I understand everything - I just added this column and changed the PK this morning. When I run a query such as: SELECT * FROM 04_jobs, 05_jobs; I get rows joined together - each job in each tabled joined on rows. not what I was expecting. - getting a row for each job - as if the query were on a single table. When I run a query such as: SELECT * FROM 04_jobs, 05_jobs WHERE pm_id="1"; I get an error that the clause is ambiguous. I guess where I'm most confused is not knowing if its: 1. a design flaw 2. a query flaw (everything I've read so far on JOIN seems directed at joining rows - which isn't what I want) 3. Something that is easily handled with a PHP loop (I'm new to PHP too). I'm doing everything on a command line for now, I haven't written any php for this area of the project.
To Re-write Complex Query With JOINS
I have a problem with one of the JOIN query here. Below is a brief description of the problem. tablename : test RecordId EffectiveDateothertableidvalue -------- ------------- ------------ ----- 12004-01-10110 22004-01-20120 32004-01-20270 42004-01-10280 52004-01-15110 62004-01-25310 Output : RecordId EffectiveDateothertableidvalue -------- ------------- ------------ ----- 22004-01-20120 32004-01-20270 62004-01-25310 Now I want to use a single SQL query to find a result where there exist one record for each unique "othertableid" where the record selected for the "othertableid" should be the recent one with regard to "EffectiveDate". That is from the above records, I want to select Records with "RecordId" = 2 and 3 because they are the recent one for "othertableid" = 1 and 2 respectively. Please be sure that I want to retrive all fields including "RecordId". The result should not depend on any other fields but "EffectiveDate" only. I am using MySQL 4.0.12 and it does not support "SUBQUERIES" which is now given support in latest MySQL edition. But I have read in the manual of MySQL that any "SUBQUERY" SQL statement can be written with proper "JOINS".
How To Keep Trace Of The Versions From A Table
From the Code that is been written below i need to keep trace of the versions that are been read from the file(test1.lst) each time it is been changed.Does anyone know as to how i can store it in diff tables(version_0701151004 version0701151100,version_0701161000 ....versionYYMMDDHHMM) each time when this query is been called? n how to keep trace of the date and time ? or maybe is there any other method where i can store diff versions in diff files ? would be gratefull for any advice --DROP TABLE stocklist_values; CREATE TABLE stocklist_values( SAG_FREIGABE INT(1) NOT NULL, SAG_SNR VARCHAR(50) NOT NULL, SAG_NAME VARCHAR(40), GSM_RELEASE_VON VARCHAR(20)); LOAD DATA INFILE '/home/user945/database/test1.txt' INTO TABLE stocklist_values FIELDS TERMINATED BY '&'
Mysql Crash - Trace The Log
Yesterday,mysql process disappear sliently. After I check the err-log,no clues found. But the PID file still exising.I think the mysql terminate by some reason.But I still not found why. The error-log mysqld.log wouldn't provide any valueable msg.It just contains the shutdown & start up log. Any idea?
How To Trace Mysql Server
Is there any tool for mysql server to trace and identify the slow query(ie the query which takes more time to run) like sql profiler in sql server. I want to identify the query in VB and optimize that. If there is any way to identify the slow query.
Report Writing Query Problem (joins Again...)
Hola database type folks, I have been trying to get this right for sometime but now must admit defeat I have 3 tables artists -> holds details on the artists card_gallery -> hold details of card available related to artists via artist_name scart -> shopping basket related to card_gallery via card_image_id I am writing a reporting facility that allows the administrator to view all the artists in a table along with their number of cards online and cards sold figures. Currently I have something like select card_gallery.artist_name as cg_an, count(card_gallery.artist_name) as cg_ca, count(scart.card_image_id) as s_ci, from card_gallery left join scart on card_gallery.card_gallery_id=scart.card_image_id group by card_gallery.artist_name but that doesnt give the correct number of cards sold. Cards sold are registered in the scart table by setting the processed field to 1 Ideally I would like to be able to view all the artists on one table with the number of cards online and the number sold even if it's 0
Unable To Do Joins With MySQL Query Browser
I downloaded the Query Browser for Windows. I try to join two tables as described in the manual, drag over the JOIN tables tab but nothing happens. The query remains as is.
Trace SQL Queries Date/times
I have a web application connected to mySQL 4.1 database. I would like to know the date/time for the queries executed on mySQL DB when any operations performed from the UI. Is there any mechanism to trace the information related to any query updates happening on the DB when operations are performed from the UI.
Ability To Trace SQL Events In MySQL?
I am coming from the MS SQL world and always found the ability to trace what SQL events were hitting my database to be powerful. Does this exist in MySQL and if so where is it or is it an add-on?
Natural Joins And Joins With USING
I was wondering if there is a way to make MySQL 5.0.15 ( final release ) able to use natural joins and joins, using old code that worked with 5.0.11 and earlier. Since I am new to starting mysql and modifying it, more information the better.
ERD Tool?
I need a good ERD tool for reverse engineering a few databases. It must be able to properly reverse engineer the foreign keys and create the entity relationships for InnoDB tables. (The fabforce product does not, for example, or at least I can't figure out how to make it do so) Free is preferable, but commerical/licensed products are okay too.
Migration Tool Kit
I'm new to MySQL and cannot get a connection to my database at my ISP. My ISP is lowesthosting.com they use an Apache Server. I've tried to connect using the dns # 207.44.216.56. I've also tried using my FTP address and I cannot get a connection. I get a message in the details that it will not recognize my password. I know I'm doing something wrong but can't figure out what?
Looking For Encryption Tool
I have a prospect that needs to collect sensitive personal data via the web for mortgage applications. A certificate & SSL seems to protect the data from the browser to the server, but I need some way to encrypt the data for storage in mysql and (possibly) into a flat file for retrieval by the prospect. I have not been able to find a simple solution for this compatible with BSD and Apache.
Stand Alone SQL Tool?
i have been using SQLyog 2.5.1 for my sql administration during development. i went back onto their site to see if there were any updates and realised that they were on 3.5 and you had to register the software! (2.5.1 was freeware).
Migration Tool
I'm new to using the Migration Tool and don't know where to look for help, so I posted here rather than the Migration Tool forum. What I am trying to do is get data from a high-traffic Oracle server over to a local MySQL so I can dissect and analyze the data with large amounts of data (with temporary query space too big for MS Access). In the migration tool is there a way to do the following: On the Oracle Server: - Select ACCOUNT_ID, CALL_DATE, CALL_TIME, CALL_RESULT from DATA_REPOSITORY.ACCOUNT_CALLS where CALL_DATE >= TO_DATE('07/01/2007','MM/DD/YYYY') and CALL_DATE <= TO_DATE('07/31/2007','MM/DD/YYYY') On the MySQL Server I want to migrate it into a local schema/table called LOCAL_PROD.CALLS_200707. The major things that I want to do here is only select the 4 fields I need out of the data repository, and I only want to do a month at a time since there is usually ~27 million records per month with data going back all the way to 2005 and I want it split up for faster querying and right now I don't care for anything before the last couple of months. Is this possible using the Migration Tool? I can connect to the Oracle DB and local MySQL fine. However, when I try to mess with the SQL statements under the Advanced options and Apply Changes, it looks like everything is going fine. However, the WHERE statement will go away during the Bulk Transfer and the process will still try to take the entire contents of DATA_REPOSITORY.ACCOUNT_CALLS and create a DATA_REPOSITORY schema on the local server and try to put the entire contents in a table of the same name. I'm open to other suggestions if the Migration Tool is not made for that kind of functionality.
MySQL GUI Tool
I just downloaded mysql but i would like to use a tool that would let me create/drop/alter tables , delete, add files etc. Which tool do you think is the BEST one for this?
Migration Tool Kit
I'm trying to get the migration tool kit working. (i'm a programmer.) I don't understand the target source part. I found this link: http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-targetdb.html I can connect to a sql server. i'm trying to migrate my sql db to a local mysql db. However, i don't have a username or password. (I do have localhost started. I run IIS without usernames or passwords.) is there a prior step i have to take that sets up a user and password so the sql migration tool kit can run?
Migration Tool
I am using the Migration Toolkit In the script it generates, it has a drop command that drops the tables whenever I transfer any new ones over. Anyone know how to change the settings
Php Admin Tool
I recently upgraded from phpmyadmin 2.5.0 to 2.6.3-pl1. I cannot find the functionality to 'load text files into tables'.
Report Tool
Is there any MySQL reporting tool that is open source and doesn't require programming knowledge? I need a front end for MySQL that will allow a user to input a couple parameters and will produce a report, including graphs. I haven't been able to find an adequate open source solution for this.
Graphical Tool
I'm building my first MySQL database and come into trooble when trying to create constraint integrity. I'm trying to get it work by hand (notepad) but thing that it would be better to create the tables using a graphical tool, but I can't find any for MySQL.Please help by giving me URL's for graphical tools (if possible free) that manage constraint integrity.
Graphical Tool
I'm building my first MySQL database and come into trooble when trying to create constraint integrity.I'm trying to get it work by hand (notepad) but thing that it would be better to create the tables using a graphical tool, but I can't find any for MySQL.Please help by giving me URL's for graphical tools (if possible free) that manage constraint integrity.
Database Design Tool
is there any software to draw a database design with his relationship for mysql?
Mysql Optimization Tool
Is there any tools that you can just run on your server that will automatically optimize your mysql database? Like to speed it up,clean it etc.
Where Can I Find 'crash-me' Tool
I remember I could find and use 'crash-me' tool on the mysql.com site. It was very nice to compare mysql with other database products, although not neatly arranged with too many details. Now when I go to the place (http://dev.mysql.com/tech-resources/crash-me.php), it says: Note: The crash-me table is normally generated from DBMSs started with default parameters. If this is not the case, the fact is noted in the comment row. I can I access and use the tool to compare the features of each databases?
Good DB Modeling Tool
I'm wondering which tool you guys recommend for creating a database model. This will be used for MySQL and possibly SQL Server 2000/2005. Also, I'd like to have the capability to reverse engineer my diagram to create the appropriate SQL code. Price isn't much of an issue if such software must be purchased.
Regarding Mysql Front End Tool
could someone please suggest me any mysql front end gui tool which covers features of MySql 5.0.3 beta including stored procedures, views and especially triggers.
Stored Procedure Tool
I'm using mySQL 5 and i'm trying to create some stored procedures. Does anyone know what do I have to do, to make "MySQL Query Browser" works like if i was using the mySQL console ? Cause, when i try to run this code at the "MySQL Query Browser" or another mySQL query tool: DELIMITER | DROP PROCEDURE IF EXISTS sp_declareG| CREATE PROCEDURE sp_declare (P INT) BEGIN DECLARE x INT; DECLARE y INT DEFAULT 10; SET x = P*y; SELECT x; END| DELIMITER ; I get several errors. BUT, if i paste this inside the mySQL console it works FINE ! What do i have to do to make "MySQL Query Browser" works just like the console ?
Case Tool For Mysql?
the version of erwin i have does not support mysql. is there a gpl-type case tool for mysql?
Problem With MysqlAdministrator' Tool
when I first time to login database via 'mysqlAdministrotr' with user 'root', it does not work. Then when I close it, the error message comes out like this 'Exception EAccessviolation in module libmysqladmin.dll at 000013d8 access violation at address 00AC13D8 in module 'libmysqladmin.dll'. Read'.
MySQL Diag Tool For XP
I have MySQL v5 installed on my XP PC. MySQL is used by another program on the same PC. Currently this other program, which I create scripts with in its' native scripting language and run within the program, is coming back with an error that says Error: Table is Read Only. I have used the MySQL GUI admin tool to look at the database that this program uses to see if I can see anything wrong, but it all looks OK. Is there a tool I can use to try and write/access the tables within this programs MySQL database so I can try and identify the offending table and maybe fix the problem.
MySQL Migration Tool
how trustworthy and capable is the Migration Tool? If it says everything went smoothly does it mean that everything went smoothly? Just a little example, Access stores dates on the background in US format although it displays it to me normally in EU/Dutch format (day-month-year). This I could easily check to see if it migrated things well because I'm aware of this issue with Access. But are there any pitfalls I should look out for with this migration tool? Not sure if others have experience with it.
MySQL Monitoring Tool
I have an application thats running 24/7 but every night its loosing connection to the database. When I restart the app in the morning it works fine again. I want to monitor the DB and the server for 24 hours to see what is causing the application to loose connection at night. The provider of the app said that the DB could be tying up too many resources and its loosing connectivity.
Database Design Tool
Is there a good (free) database design tool for windows and MySQL? I have been using DBDesigner but it seems to ignore foreign key constraints when I generate an SQL create script.
MySQL GUI Client Tool
I am looking for a gui-based open source client tool for mysql. Does anybody have any suggestion besides those listed in the first few posts in the beginning of the forum?
MySQL Administrator Tool
I'd like to use MySQL Administrator application remotely from home. Possible? Will I have to open up port 3306? If so, is that safe?
Mass Update Tool
we have so many mass upload tools, load from the file, load from other database built in. How about mass update tools? Say I have a table have 3000 products in it. I want to update the price of these 3000 products with a new table (or excel sheet) of new price by matching the product code (key).Is there a tool for that?
Tool To Produce A Shema
Is there a tool that can compare db1 with db2 and just output the SQL to make db1 look like db2?Would appreciate if that was possible in phpmyadmin either directly or with an extension if those exist.
Is There A Tool That Can Analyze Queries To Help Better Indexing?
I've heard of a tool for MS SQL Server that analyzes your queries and can tell you how to better index your tables. Is there a tool doing this for MySQL? Another tool question - do you know of any tools that can take your queries and trace all the tables it uses?
MySQL DB Designing And Programming Tool
Are there any software for MySQL developers that you could recommend? I`ve been using MSSQL and its Server Management Studio makes my life easier. I can easily make diagrams during planning and creating DB structure, programming SP, Functions, Triggers... and many more in one place. I`ve downloaded DB Designer but it seems to be good only for creating a diagrams. Of course I can generate the code for my diagram and then paste it to phpMyAdmin but... I`m looking rather for one (complex) tool which could make my work more efficient. Is there any?
How To Break In Command-line Tool?
When there are too many results returned from a select query, how can I stop the unfinished displaying of the result? If I press Ctrl-C, the command window will be closed. I just wanna go back to the prompt.
Recommend A Good Reporting Tool?
I am generating multiple mysql databases on embedded data acquisition units. The databases are not complex with only a couple joins. The data will be accessible two ways. 1.) Users will be able to download(mysqdump) a snapshot of the mysql data from an individual DAQ device onto a flash drive or their laptop's hard drive. 2.) Users will access a central server via LAN or WAN(internet) running mysql that will have data updated from the individual DAQ's in real time. I need to provide the ability to produce reports from mysql dumps on a users laptop and produce similar reports from a connection to a mysql server. Is there a tool that provides a client app that can use a pre-made template, read a CSV file to produce a report and also use that same or similar template to produce live reports from a sql connection. I would prefer the reports be html pages, though pdfs would do... I would prefer open source but that isn't a hard requirement.
|
TRACKER
