Question Regarding MySQL Interface Options And MySQL Vs MS Access
First, there are many applications available for interacting with MySQL. One of the things that frustrated me at first was the CLI. I know that it's the foundation and understanding syntax is critical to making it all work in the end, but when dealing with large datasets, I feel that a GUI makes life easier at times.
So, I started out with phpMyAdmin, seems to be 'the' geek-preferred application. I also ran into a few shareware ones here and there as well as Navicat, and I recently learned that there are 2 apps from MySQL.com for administrating the DB and creating queries.
In your experience, what seems to be the best MySQL interface application? At the moment I couldn't say *exactly* what I'm looking for, but more-or-less something that will ease the headache of creating queries and managing users, tables, etc.
Question #2:
I have been hired to be a Web Developer, Network Admin, and Database Administrator all-in-one. We have are a retail company selling peuter goods and have a product line-up of about 100 items. The President wants a robust database to deal with everything. Right now we use MS Excel for our needs. He says it's becoming cumbersome and wants to move on. I suggested MS Access because that's exactly what it's built for, companies that have been running in Excel and want more robust control over what they're doing. But the president keeps hearing this 'MySQL' buzzword and wants a MySQL database. Fine with me, I just know Access better, that's all.
I've been cramming PHP & MySQL down as fast as I can and am starting to feel more familiar with both technologies. At the moment, I feel MySQL to be more of a headache (my fault I'm sure, I just don't know it yet) But For Example:
To properly normalize a DB, I sometimes have to break a table into 3 tables. The first and second are no problem, but the third 'association' table is annoying (at least doing it CLI or phpMyAdmin). See, Access, you just make 2 tables and graphically set associations very easily.
So, from what you know of MySQL, do you think it would be still superior to Access seeing as we want to integrate it into osCommerce eventually and possibly some of their user contributions?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Importing To Mysql From MS Access-csv Options
I am having problem importing an Access 2000 csv into mysql using phpMyAdmin. I have set CSV options: fields terminated by {,} fields enclosed by {,} fields escaped by {don't know what to put here} Lines terminated by {don't know what to put here} Column names {don't know what to put here} the first row of the input file has the field names will someone tell me the correct parameters for this kind of input file?
GUI Interface For MySQL
Ihave been using SQL Server and MS Access in the past. Can any one tell me if My SQL has a graphical interface like MS SQL server and MS Access. Whcih would allow me to visually manipulate database objects and also desighn queries/views visually.
Mysql GUI Interface
is there any GUI for mysql is availabe ??? just like SQL server or ms access .. not even like apart from phpmyadmin but like windows on which we can make database , tables , reocords .... etc .. i guess micro olap have this .. but its not free ..
MySQL Backup Options
I was using mysqldump to perform MySQL backups just fine. However, we recently had to restore the database and it took about 10 hours for 100GB to restore. Now they (managers) want me to find a different method, one that will restore faster. So I tried using MySQL administrator's backup utility but it takes twice as long and is twice as big! I doubt this will speed up the restore. So, my first question is why is it so big and why does it take so long? Is it giving me something that I won't get using mysqldump? And my second question is how can I optimize one of these methods so a restore doesn't take half a day?
Mysql Interface Generator
I wanted to know if there are any program that generates a webpage with the forms to insert data into the db. Example: I have a table with {id, url, desc} The program must generate a page with text fields to enter this information.
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux? I'm trying add a user account and password to the db server but I'm not having any luck from the command prompt.I'm trying to setup the nexus discussion software.
User Interface With MySQL
is there product that provides a developable non-web user interface in the way that Access has one for its database? I've seen many that customize database routines, but what we want to do is create a user interface that includes logic without having to go through Php, Cfm, Net, or any of the web-based technologies.
MySQL Interface Required
I hope this question is appropriate for this group. My server provides a MySQL database. Do I need a third-party interface to add tables and records to it, or is their another way?
Local Interface To MySQL
I need to harvest data from MySQL tables. My experience is with MSSQL and Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't need to manage anything. I just need the data. What kind of interface can I use to query and save data locally? I don't see any MySQL drivers available when I try to setup an ODBC from my desktop. Can I download one somewhere?
MySQL C++ Interface Installation
After I downloaded MySQL C++ package & installed it, I can't compile any sources. System notes "undefine reference 'function' ", is anyone familar with gcc & MySQL C++ development package ?
Options Area Of MySQL Administrator
trying to get Apache/PHP/MySQL setup on a Mac OS X Server version 10.4.9. Those come installed by default, and I also added MySQL Administrator and phpMyAdmin. Everything is working, except for the Options area of MySQL Administrator. Instead of getting the various options, I get a note at the bottom that says: "Could not read configuration file." I'd imagine that some config file somewhere needs editing, but I'm not sure exactly what needs to be done.
Mysql Command Line Options
I am executing the following from the command line. mysql -uroot -t rep_queries_${yearmth} -A <<QUERY_INPUT SELECT count( distinct source_ip) from day_${yearmthday} where query_ip = $numip QUERY_INPUT It returns the heading along with the result (see below). Can I suppress things so that only the result is returned? I need to store the result in a unix variable. +----------------------------+ | count( distinct source_ip) | +----------------------------+ | 41 | +----------------------------+
Check Compiled In Options To Mysql Binary
How do I find out what options were compiled into the binary versions of mysql? Also, is there a way to see what options were compiled when a binary was manually created with configure/make/make install. Is there a query you can do on the daemon?
Backup Options Non Functional - MySQL Admin
I have inherited a small MySQL database, version 5.x. I have installed MySQL Administrator. I would like to try the backup utilities offered in this application, but they are all greyed-out and non-functional. It doesn't matter whether the application is run on the local host or on a client workstation -- the backup features are non-functional.
Dropdown List - Insert Into Mysql. Options
This is something probably simple but confuses me. I simply want to add a dropdown list where, when an option is selected, its value will be inserted into a dbase table. More specifically, assume there is a page where the user sees his order. He will be able to select the order status (pending or delivered). So, for example, if his ordered is delivered, by selecting "delivered" option, "delivered" will be inserted into the 'Status' Table.
Get Access Denied Msg..how Can I "reset" Mysql Access
I downloaded the windows installation last night - mysql-4.0.16-win.zip - unzipped it to c:ms, double clicked on setup.exe and nothing.... nothing happened at all.... Bad download I though, so tried the same thing with the .zip of version 3.25.55 I had - the downlaod that I used once before, before my recent re-format - so I knew that it did work once, but this time, same problem. The setup.exe just doesn't do anything... I really want to learn mySQL, but if I can't even install the thing, it doesn't look good!
Interface
MySQL is just the language that the database is programmed in, in a nutshell is that right? If so, it's not like Microsoft Access where you can create a user interface so the user can input data and apply queries to data etc. These are my assumptions, so my question is: Is there an open source application that applies a user interface to a MySQL database so a user can do these things?
GUI Interface
I have only read the book by DuBois and used samples at the command line. I would like to use this for work. I am avoiding the IT push to use Microsoft Access. I have 10 people in our group who need to share data (now about 50 excell spreadsheets). What I am really looking for is a GUI that can get me most of the way there. I can have my own server behind the firewall in our corporation so I am free to do my own thing. What I have found on the net so far is: Control Center Front SQLyog NAvicat Any feedback on these? Ease of use and reporting are most important attributes.
XA Interface
In 5.0 Manual,I see XA Interface( use SQL[XA START,...],Connector/J ). But, 1. I want know XA Interface in C API. ( using xa_switch_t like other DB ( oracle, infomix, .. ) )I can't find this in Manual. 2. If MySql is not support this, does Mysql have the plan?
GUI Interface
Is there a GUI Interface for MySQL ... that runs on Unix (Solaris, Linux, etc) There was an earlier thread about it - http://forums.devshed.com/showthread.php?t=51564&page=1&pp=15&highlight=GUI but most of these seem to run on Windows only.
Gui Interface
If I wanted to create a switchboard would I be able to use the GUI Interface to do so? I am in the process of learning MYSQL
Server Doesn't Take All Options Out Of My.cnf
------_=_NextPart_001_01C34C58.52CDCBE2 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable My problem is, that all variables except "wait_timeout" are initialized from the my.cnf file, only "wait_timeout" is always set to the standard value... Has anyone the same problem? Does somebody know how to resolve it? =20 Moritz =20 ------_=_NextPart_001_01C34C58.52CDCBE2--
SQL Statement With Options
I want to have a form that searches a database. The form should have a drop down menu that will allow to search different table fields based on the selection. The fields are "lname" and "idnum". So, my drop down menu named "type" should have those two as options. Now next to that I will have a text field called "input" which should will take in the value to search. Now, How do I write a SQL statement that will take the value from the drop down (which will tell what field to search) and the input (the string to search for) and search the table "members" .
Compiling Options
How to check from shell what options mysql was compiled with? I mean Linux version.
Seq. For Options File
In MySQL we have a concept of options-file in which we define multiple options, now since this file can be placed in multiple locations, my doubt is can someone tell me the prefernce or the order in which it searches option-file in Server or local disk. Basically whats the order in which option-file is searched ??
No Security Options
I have just downloded the "MySQL 4.1" and have got the package to install and have run through the various options but I never came to the setup for the initial password and user so when I run the dos window I get "Password"..... ( sits scratching his head looking at the screen ) Is there a fundimental step which I missed ( left all options as is on install ) and is there other programs that I will need to install to work with mysql for setting up websites ?
Group Options
I have a query that looks like this: CODESELECT tags.tag, assets.id FROM tags, assets WHERE tags.id=assets.id
GRANT Options
I am trying to write a piece of SQL code which will allow a user group access to view all fields of a table but only edit certain ones. The only code I can find seems to apply to the record as a whole. Is it possible that I can restrict access to certain fields or will I need to create a new View table of those fields and give them edit access over the view table?
Visual Interface
i tried the gui tools in mySQL.com but Im having some trouble instaling them, eventually ill be successful but I heard there are simpler packages, I just want to see the ER diagram of my databases, for the rest I can handle.
End User Interface
My goal is to set up a database to track our inspection data at our company. Currently, we are using Excel spreadsheets to make inspection reports. I would like to be able to get this information into a database so that a technician can set up the inspection plan before the inspector gets the part (the inspection plan would include the Customer Name, Part No., Revision, Items to inspect, etc.) Then when the inspector receives the part, they can pull up the inspection plan and enter the dimensional values obtained for each attribute on say six or ten parts and print an inspection report. Then this data can be sorted and viewed in different ways. We have three Windows 95 computers and three Windows 98 computers we are currently using on an ethernet network. I am thinking of using MySql, Apache and PHP to set this up. Would there be a simpler way to create an end user interface to MySql other than using PHP and Apache?
User-interface
I have been using MySQL-Front for a couple of years and while it is helped me a great deal it is also pretty buggy for my experience. I am looking for a backup method to see and edit my table data. Can anyone offer a another method - perhaps web based that is free and easy to use?
Best Options For Database Export
In exporting the data from my live db, I am wondering what would be the best dump options to use. My problem is that I am finding the import on my localhost to be slower than expected. Are their recommended options for the export that I could use in order to make the import quicker?
SELECT With More LIMIT Options ? How ?
I have two elements : one with cars and other with boats - in the same table. I want to make one select statement that returns the first 7 cars ( random selected ) and another 3 boats ( random selected ). I am searching from 2 days.
SELECT ... INTO OUTFILE Options
how to use the SELECT ... INTO OUTFILE command to create a csv file of query output. The problem i have is that the resulting file doesnot have column headers. Is there an option that i need to turn on/off to enable the output file have column headers.
Specifying Multiple WHERE Options Within A Group
I'm looking to list the number of Users who have an entry matching "Page View" in the table UserActions. The query I'm using is: SELECT COUNT(*) AS Download_Ruequests FROM (SELECT * FROM UserActions, (SELECT * FROM UserActions WHERE Action LIKE "View%" GROUP BY UserID) AS Users WHERE UserActions.Action = "Request Download" GROUP BY UserActions.UserID) AS Downloads; However, it involves 2 subqueries and I can't help but feel there must be a simpler way... I want to return users who have viewed a page AND requested a download, but each of these actions is in a different row in the table. So I'm effectively saying, show me the User IDs which have this action and another action in a different row.
List Of Full Options In My.cnf
Where is the list of full options in my.cnf? I am looking for the full list of options in my.cnf. Where can a detailed list be found in the documentation?
An MS-windows Front End Interface ?
Is there an MS-Windows front end interface for mySQL ? I'm thinking of an MS-Access sort of approach for basic database configuration and maintenance. Maybe there's a back door way to ODBC myself from MS-access to mysql on a Windows system ? Does Mysql have an ODBC front end I can get in through ? Any pointers to some directions ? I plan to use perl/my-sql for web work. But, it seems like a _lot_ of work to build the databases and populate them via mysql commands. I'd like to be able to work them _locally_ through a basic data maintenance program and then move it to the (web) server when ready.
An MS-windows Front End Interface ?
Is there an MS-Windows front end interface for mySQL ? I'm thinking of an MS-Access sort of approach for basic database configuration and maintenance. Maybe there's a back door way to ODBC myself from MS-access to mysql on a Windows system ? Does Mysql have an ODBC front end I can get in through ? Any pointers to some directions ? I plan to use perl/my-sql for web work. But, it seems like a _lot_ of work to build the databases and populate them via mysql commands. I'd like to be able to work them _locally_ through a basic data maintenance program and then move it to the (web) server when ready.
GUI Interface Rennie Garcia
I have experience using other databases and wanted to find out if there is a high level GUI interface for MYSQL which enables me to create a database. I am using as a backend to a large PHP site and need any easier way of creating tables etc rather than using the command line editor.
Graphical Interface Hangs
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.
Database And Client Interface
I am planning to use MySql for my building my database. I already installed MySQL on my system. I would like to know have two databases. 1. for developement 2. for storing the correct data from the development database. Can i have two databases on the same server, so that I can copy data from one database to another. Also, I am planning to interface matlab with MySQl. i.e., Matlab would be my client program. What drivers or connections do I need to download in order to talk to the database from Matlab.
Export Table To .csv Via Web/PHP Interface
I have a website running Apache 1.3.31, PHP 4.3.0 and MySQL 3.23.45 (yes, I know...). Data from different tables is presented in lists on the webpage. I've been asked to add functionality to download lists as .csv-files. I have failed to find info about how to do this smoothly through a PHP script (not via command line).
Microsoft Word Interface
I am developing an online app that helps many editors review articles, check for errors, add new articles, etc. The editors are used to using Word to help them go through several articles at once. Because of this, I'm hoping to figure out a way to allow several persons access to their content on a MySQL database online via their local install of MS Word. I have been working some with the OBDC mysql provides at http://www.mysql.com/products/connector/odbc/ (ver 3.51) and have been able to connect and retrieve some data. My problem is how do I update the users' articles online after they have finished reviewing them in MS Word?
Conditional Where - 1 Of 2 Options, Order Maters
Very simliar to my Conditional Join thread, I would like to combine two queries that have different WHERE clauses. Basically when looking for an item, it could be in one of two formats: Vendor-Code-Color or Vendor-Color: SELECT s01_Products.id AS products_id , s01_Products.active AS products_active , s01_Attributes.id AS attributes_id , s01_Options.code AS options_code , s01_Options.prompt AS options_prompt FROM s01_Products LEFT OUTER JOIN s01_Attributes ON s01_Products.id = s01_Attributes.product_id LEFT OUTER JOIN s01_Options ON s01_Products.id = s01_Options.product_id WHERE s01_Products.code = 'VV-9303-BLK' ORDER BY s01_Options.code SELECT s01_Products.id AS products_id , s01_Products.active AS products_active , s01_Attributes.id AS attributes_id , s01_Options.code AS options_code , s01_Options.prompt AS options_prompt FROM s01_Products LEFT OUTER JOIN s01_Attributes ON s01_Products.id = s01_Attributes.product_id LEFT OUTER JOIN s01_Options ON s01_Products.id = s01_Options.product_id WHERE s01_Products.code = 'VV-9303' ORDER BY s01_Options.code Is it worth re-writing this query? I only need to look for Vendor-Code if Vendor-Code-Color returns nothing. I don't think that I would gain MUCH by combining the queries because in theory the query would search the table (using an index), and if NULL, search again. I don't see any difference from using two seperate queries except maybe the resources used to send/receive the query? Any ideas? Should I just leave it as is? If I start to add more variations in the WHERE clause would it start to make a noticeable difference in speed?
|
TRACKER
