Is there an editor that allows changes to data in MySQL?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Re: Is there an editor that allows changes to data in MySQL?

Postby OrcaSoul » 08. June 2014 01:33

Nobbie wrote:
OrcaSoul wrote:The ideal form would allow me to enter the product name, and it would use that to pull just the record for that product, and allow me to enter text in any field, then save it into the database, replacing the existing record.


I still dont understand, what you are messing aroung - of course phpmyadmin provides this functionality as well. Instead of browsing thru all your records, click the "Search" button in the top menu, you will receive a form, which shows ALL fields of your choosen table, you may specify any values, any special functionts, whatever you want for each field and finally hit "Submit" and phpmyadmin will show you all records, which matches your criterias. YOu may then even use grid edit / inline edit or hit "edit" to enter data in an appropriate form.

You dont have to write your own code, phpmyadmin is a very sophisticated tool and you really can do everything with this tool, what you are looking for. It is the "swiss army knife" of MySQL.
Nobbie wrote:
OrcaSoul wrote:The result is, searching for the name isn't the fastest way to go - and yes, I can sort the list, but it's still a nuisance when dealing with many bowls.


Because you are searching "manually" (this is indeed a bad idea). Why dont you simply search with MySQL (Select.... Where bowlname = "...." or similar)? MySQL provides not only Metacharacters for Search, it also supports regular expressions.

You may also define an index for the column which holds the names, which makes the search very fast. For columns of type TEXT you may also define a "FULLTEXT" Index, which is a special MySQL Feature.


OK, let me put it this way - at my age, 71, and with my eyesight not the best due to being very nearsighted - I find a cluttered screen like phpMyAdmin hard to read, mostly because of the small font and the confusion of so many things to look at - which can be distracting.

But it is mostly just a matter of my choice. Since I am the only one who will use this, that is my prerogative. You can disagree with how I do this, but don't argue that I am doing it wrong...

Thing is, I prefer a single subject form to do this kind of work - I always have.

I start the script, and enter the name of the bowl:
    Edit a bowl record
    Enter Name of bowl to edit

    BubingaCopper06-001

    Submit

This takes me to the form:

    Edit bowl in database
    Bowl Code:BubingaCopper06-001
    Species Seq:Bubinga06-001
    Source Wood:Bubinga05:031
    Notes:Bubinga05:031
    Product ID Code:Really nice bowl!
    Heading:9-1/2” Bubinga BowlEdged with Copper Patina accent
    Details:Bubinga is a richly dark hardwood of high figure that comes from Africa. Favored for valued furniture - the wood adds a touch of elegance to table tops - bookcases – and turned objects. The patina effect on copper leaf is a technique learned from David Marks - a Master of the craft.
    Image File:BowlPhotos/Thumbs/BubingaCopper06-001tmb.jpg
    Bowl Status:In stock
    VenderID:1
    Price Asked:$125
    Sold for:$
    Proceeds:$
    Current Venue:A/NT Gallery
    Submit

Say I sold the bowl, I want to add the sales price $125 and how much I made $82.66, and remove A/NT Gallery as the Current Venue, plus change the Bowl Status field to Sold!.

Then I hit Submit and the update is entered.

For my way of working, this is the best methodology...for anyone else, they can decide themselves.
OrcaSoul
 
Posts: 57
Joined: 24. August 2009 23:51

Re: Is there an editor that allows changes to data in MySQL?

Postby Nobbie » 08. June 2014 12:21

OrcaSoul wrote:OK, let me put it this way - at my age, 71, and with my eyesight not the best due to being very nearsighted - I find a cluttered screen like phpMyAdmin hard to read, mostly because of the small font and the confusion of so many things to look at - which can be distracting.


Ok, I am not 71, but anyway, I am 55 and have to use glasses since childhood. So if you cannot see the letters on the screen:

a) use a better glass
b) use a bigger font
c) use a bigger monitor

And, of course, a powerfull tool like phpmyadmin provides a lot of options. Again, you will need your time to learn how to work with such a tool. A british colleague of me used to say "a fool with a tool remains a fool" (sorry, i apologize for this), I dont want to insult you, but you will understand, what i mean. A good tool does not automatically mean a good result - you have to learn how to use it.

In my mind, phpmyadmin is not so hard to learn. For example, I am working on music (note sheets) and have to use a software for that (known products are Sibelius, Finale and so on, especially I use "Capella") and each of these note editors are very complex and really very hard to learn. It took me years(!) to learn all the options and to produce really good looking scores in a short time. Compared to that, phpmyadmin is very easy to learn, but anyway, you have to learn.

OrcaSoul wrote:But it is mostly just a matter of my choice.


Of course, but I only wanted to show you, that is NOT a question of phpmyadmin, but a question of your ability, how to work with phpmyadmin. I am a german and we have a well known saying and I will say it German (you will find translators in the WWW, if you dont understand it on your own): "Jeder ist seines Glückes Schmied". And finally, that is all what is left to say.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: Is there an editor that allows changes to data in MySQL?

Postby OrcaSoul » 08. June 2014 20:59

Nobbie wrote:So if you cannot see the letters on the screen:

a) use a better glass
b) use a bigger font
c) use a bigger monitor


Or...make or find something that works better for you.

Nobbie wrote:And, of course, a powerfull tool like phpmyadmin provides a lot of options. Again, you will need your time to learn how to work with such a tool. A british colleague of me used to say "a fool with a tool remains a fool" (sorry, i apologize for this), I dont want to insult you, but you will understand, what i mean. A good tool does not automatically mean a good result - you have to learn how to use it.


You are assuming that I NEED all of those options. I don't.

I have no need or interest in becoming a database expert. All I need is a working system that I can modify to meet my needs.

Nobbie wrote:In my mind, phpmyadmin is not so hard to learn. For example, I am working on music (note sheets) and have to use a software for that (known products are Sibelius, Finale and so on, especially I use "Capella") and each of these note editors are very complex and really very hard to learn. It took me years(!) to learn all the options and to produce really good looking scores in a short time. Compared to that, phpmyadmin is very easy to learn, but anyway, you have to learn.

OrcaSoul wrote:But it is mostly just a matter of my choice.


Of course, but I only wanted to show you, that is NOT a question of phpmyadmin, but a question of your ability, how to work with phpmyadmin.


Not really - it's more a matter of do I need all that capability?

Again - I have no need or interest in becoming a database expert. All I need is a working system that I can modify to meet my needs.

OrcaSoul wrote:I am a german and we have a well known saying and I will say it German (you will find translators in the WWW, if you dont understand it on your own): "Jeder ist seines Glückes Schmied". And finally, that is all what is left to say.


We in America have our own saying: "Get off that high horse"...which basically means that you seem to have just a touch of superiority complex, thinking that anyone who isn't following your advise is somehow a lesser being than you - no insult intended, just making a point.
OrcaSoul
 
Posts: 57
Joined: 24. August 2009 23:51

Re: Is there an editor that allows changes to data in MySQL?

Postby Nobbie » 08. June 2014 21:38

OrcaSoul wrote:We in America have our own saying: "Get off that high horse


Thats the same in German "komm von deinem hohen Pferd herunter". But you are missing the basic point, that i spend a lot of time for your problems, i definately gave you lot of options and hints, but you werent interested. And everyting in your language. All hints werent good enough, or you simply did not believe, or it was cluttered, or slow, too small fonts, or cumbersome, or too blabla here and too blabla there - whatever.

You are what we call a "Besserwisserischer Schlaumichel" and I finally i dont understand, why i ever gave you any help. I still cannot find even only one "Thank you".

To make it short: *plonk*

P.S.: Even if you think so (as you know everything, and everything better than anyone else), working with phpmyadmin only means working with phpmyadmin - you neither need to be an SQL expert, nor does it make you an expert. It is only a MySQL Editor - exactly that, what you asked for (see your subject above). Why did you ask, if you are not interested? Anyway, you dont need to answer, i dont read it anymore.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: Is there an editor that allows changes to data in MySQL?

Postby OrcaSoul » 09. June 2014 00:04

Nobbie wrote:I still cannot find even only one "Thank you".


I count two - look on the first page.
OrcaSoul
 
Posts: 57
Joined: 24. August 2009 23:51

Re: Is there an editor that allows changes to data in MySQL?

Postby Altrea » 09. June 2014 09:22

I make it short:

An available MySQL GUI needs to be very generic to fit the needs of a very flexible database system.
That is what all the GUIs (phpMyAdmin, MySQL Workbench, etc) do.
It cannot fit every peoples specific needs in just one form.

If you want to have a specific GUI for your very specific database, you have to write yur own one.

P.S.: If you both are drifting to a personal area of communication, i will close this thread here. This is not of value for a community support board. Please stay on topic.

P.P.S.: The community edition of MySQL Workbench is free to use
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Is there an editor that allows changes to data in MySQL?

Postby OrcaSoul » 09. June 2014 16:27

Altrea wrote:If you want to have a specific GUI for your very specific database, you have to write yur own one.


Agreed.

Thank you.
OrcaSoul
 
Posts: 57
Joined: 24. August 2009 23:51

Previous

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 134 guests