Guest Posted May 23, 2004 Share Posted May 23, 2004 Hello, Sorry- this is more of a MyPHPAdmin issue than an OSC one, but there are a couple of contributions (I'm particularly referring to the "Random Order Number" one) that require that the database table definitions be altered. In the case of the random order number, you need to change the type of the 'orders_id' field in the 'orders' table and remove the 'auto increment' flag). It's suggested that MyPHPAdmin can be used for this, but I'm at a loss as to how - the nearest functionality I can find is to delete a field or add a new one, but not to alter the attributes of an existing one. Am I missing something blindingly obvious ? Exactly how do you do this with MyPHPAdmin ? ...or any other tool (can you do this from the MySQL command line ?) regards, Rich. Link to comment Share on other sites More sharing options...
AlanR Posted May 23, 2004 Share Posted May 23, 2004 phpMyAdmin You can see the field right? Display the table and click the little pencil icon (change) for the orders_id field. Then you can change from auto increment. Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) Link to comment Share on other sites More sharing options...
Guest Posted May 23, 2004 Share Posted May 23, 2004 No, sorry - you've lost me there... From starting MyPHPAdmin, I click.... Table -> Edit -> <select database> -> <select table> It then asks me if I want to backup the database. I select 'yes' I am then presented with the table's list of fields (6 columns). There's a message at the top of the page telling me that I can delete a field by clicking on its name and there are three boxes at the bottom of the page that I can use to enter a new field. ...but nothing suggesting I can edit a field - no 'pencil' icons in sight ! R. Link to comment Share on other sites More sharing options...
Guest Posted May 23, 2004 Share Posted May 23, 2004 Sorry - I was being imprecise - when I say 'fields', MyPHPAdmin refers to 'columns' regards, Rich. Link to comment Share on other sites More sharing options...
AlanR Posted May 23, 2004 Share Posted May 23, 2004 You can't find something like this? Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) Link to comment Share on other sites More sharing options...
Guest Posted May 23, 2004 Share Posted May 23, 2004 Oh ! No, I don't get any of those icons - just the column of table data. I don't get the tabs at the top either. I can't even find the icons in the MyPHPAdmin source directory Am I doing something stupid ? I'm using version 0.9.2. R. Link to comment Share on other sites More sharing options...
AlanR Posted May 23, 2004 Share Posted May 23, 2004 Am I doing something stupid ? I'm using version 0.9.2. R. I don't know if I'd go that far. :lol: The screenshot came from 2.5.6 You can go snag a later version at http://www.phpmyadmin.net/home_page/ It's not hard to install. If you have trouble post back. Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) Link to comment Share on other sites More sharing options...
Guest Posted May 23, 2004 Share Posted May 23, 2004 STOP !!!!!!!! I've just found out that there is a "MyPHPAdmin" program and there is a "phpMyAdmin" program. For the last 2 years (yes, really !), I've been using the former. I suspect what I really need is the latter. Who thought of these names ? Not at all confusing !!!!!!!! Arrrrrrrrgggg......... Thanks for all your help, by the way. regards, Rich. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.