Edit Values In Table Through GUI
I wonder which GUI tool I can use if I want to edit some values in a table? I can't find it in Query Browser. Do I really need to execute SQL to make a simple change to a field?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Edit A Table
Can anyone offer insight as how to edit or remove rows and or columns in a table? I am just starting to learn MySQL. Please forgive me if this is questions is rather simple.
Edit A Field In A Table
I got a table with thousand records. There's one record that has one field whose value I want to edit. So basically I want to edit one field in my DB. I see the update command.... and each record has a unique PK of course so I have what I need to "zero-in" on the record.
Edit Content Of A Table
In mysqlcc it was pretty straight forward how to edit the actual data that was being held in a table. Now i'm struggling just to figure out where to read the actual data that is being held. If i have a table that has had data written to it, I want to be able to go in and change that data how can i do that?
Edit Table Data Greyed Out?
Is there some reason why the Edit Table Data option is greyed out when I right click on a table name? Is there something else I need to do to get this set up correctly?
Can't Edit Table Data With MySQL Administrator
I'm just getting started with MYSQL. I can create a simple database and add some records to it. I can view the tables with MySQL Administrator. However, "Edit Table Data" is greyed out. What is the magic incantation to enable this feature?
INSERTing Into A Table, With Values From Another Table
I'm programming a shopping cart application, where the products are categorized into different lines. I have a table that defines the different product lines, and now want to populate the product table. However, the text file with the products in it, which I will use to populate the products table, uses the line NAME for each product, when I wish to use the line ID instead. To get the line ID, I would need to get the value from the line table. My question is: is it possible to populate the products table with data from the products text file, as well as a column from the lines table? That is, the INSERT (or LOAD DATA) statement will insert column values from the text file, but the line id from the lines table instead of the line name found in the file (WHERE line name = line name in the lines table). I'm still not sure whether to use an INSERT, and write PHP code to go through the text file, or to use LOAD DATA for this task, because I don't know which statement would support what I'm looking for.
Insert Table Values From Another Table
I have two tables: Users and metadata Users: id userid username Metadata: id userid value I would like to extract a list of the userid's from the users table and enter them into the metadata table, with an additional value. Example: I want to take all of the userid's from the User table and insert them into the Metadata table, and make the value="one" for each entry into the Metadata table.
Update One Table Value With Values From Another Table
I am trying to update one table value with values from another table, and I cannot get it to work. What am I doing wrong? This is my SQL-command: UPDATE tabel1 SET tabel1.name=tabel2.name WHERE tabel1.ID=tabel2.ID
Inserting Values From 1 Table Into Another Table
I have 2 tables: A and B Table A contains fields u, x and y Table B contains fields u and z Table A has all possible variations of u. Table B has some of the varaiations of u in it. My problem is that I'm trying to insert the z-values from Table B into Table A's y field and link them up based on the u-values. I'm running into problems like truncating at row 0. I've tried the following queries: update TableA set y =(select TableB.z from TableB where TableA.u=TableB.u) update TableA,TableB set TableA.y =(select TableB.z from TableB where TableA.u=TableB.u)
Add Values To Table
I have a table tblMailingList. It has 3 columns; Name, EmailAdd, AutoID. I am using mysql> INSERT INTO pet -> VALUES ('name1','u@me.com'); but I am unsure as to what to do for the AutoID field. If I use the example given, the error message says that the number of fields is different. How do I get this info into my table?
INSERT Values From One Table To Another
In table A i have a.id and name and in table B, i have b.id, a.id(FK) and owns. Table A -------------- a.id | name | -------------- 12 | James | 13 | Paul | 14 | Tom | 15 | Andy | Table B -------------- b.id | a.id | owns | -------------------- 1 | 12 | Car | 2 | 12 | Bike | 3 | 13 | PC | Now what i want is to add two new names to table A which will be Tom and Andy and have the same data in table B for Tom and Andy with just different b.id (PK). How can i insert this new data in table B using insert?
Update A Table With Values In Another
I have the following table tableA column_a column_x column_y column_z tableB column_x column_y column_z How do I update the rows of tableA that match rows of tableB (all rows of tableB are unique) What I want to acheive is a check against tableA.column_x with tableB.column_x, if they match, then update the row in tableA.column_y with the value of tableB.column_y and tableA.column_z with tableB.column_z
Update Table Values
I have a csv.txt file with contacts and their information in it. Then I also have a table in mysql with the same contacts and their various information. I need to merge these to so that if a field value in the database is NULL the value that is in the csv.txt file is inserted into the database field. I have been looking at the mySQL site on how to do this but have not been able to produce a working solution. Below is a more detailed example of what I am looking for. Code:
Returning Values That Are In One Table, But Not In Another
I'm looking for a query to return values which occur in one table, but not in the other. Say we have two tables (table_1, table_2) each with a column titled "appointments". I want a list of results for appointments which are in table_1, but not in table_2 I have tried the following, but all I get is a huge list of duplicate appointments which occur in both tables: SELECT table_1.appointments FROM table_1, table_2 WHERE table_1.appointments<>table_2.appointments; I've also tried 'NOT IN' for this but the result was just the same.
Editing Values In A Table
I just moved from SQL Server to MySQL and in the Enterprise Manager in SQL Server I could query the entire table and then modify the values with the table without writing an UPDATE statement. I cannot do that in one of my tables because the EDIT at the bottom is greyed out. There are other tables where I can make a modification to any value I want within the table.
Edit Two Row
Is it possible to edit same fields on two row that i do not have to use two queries? mysql_query("UPDATE items SET howmany=howmany-1 WHERE uid='".$_SESSION['uid']."' AND type='plant' AND name='".$plant_name1."'"); mysql_query("UPDATE items SET howmany=howmany-1 WHERE uid='".$_SESSION['uid']."' AND type='plant' AND name='".$plant_name2."'"); name - howmany - type - userid plant1 - 7 -------- plant -- 1 plant2 - 3 -------- plant -- 1 car ---- 1 -------- toy ---- 1 plant3 - 15 ------- plant -- 1
Inserting Values Into A Mapping Table
I am using a mapping table with two primary keys (ID1, ID2). When I try to insert data into this table I get the following error: Quote: Violation of PRIMARY KEY constraint 'PK_myTable'. Cannot insert duplicate key in object 'dbo.myTable'. The statement has been terminated. I am able however to insert values if I do it directly into my table. Here is an excerpt of my comm = New SqlCommand( _ "INSERT INTO myTable (ID1, ID2) " & _ "VALUES (@ID1, @ID2)", conn) ' Add command parameters comm.Parameters.Add("@ID1", System.Data.SqlDbType.Int) comm.Parameters("@ID1").Value = ID1List.SelectedItem.Value comm.Parameters.Add("@ID2", System.Data.SqlDbType.Int) comm.Parameters("@ID2").Value = ID2List.SelectedItem.Value
Generating A Table With Missing Values In SQL
I have the following table: +------+------+------+-----------+ |ID |GROUP |CODE |ANSWER | +------+------+------+-----------+ |1 |1 |001 |01-01-2003 | |2 |1 |002 |Yes | |3 |1 |003 |NA | |4 |1 |004 |297797 | |5 |1 |005 |0 | |6 |2 |002 |Yes | |7 |2 |004 |297852 | |8 |2 |005 |1 | +------+------+------+-----------+ This means that code 001 and 003 of group 2 are missing. Result of the query should be: +-------+-----------+-----------+-----------+-----------+--------+ |GROUP |ANSWER1 |ANSWER2 |ANSWER3 |ANSWER4 |ANSWER5 | +-------+-----------+-----------+-----------+-----------+--------+ |1 |01-01-2003 |Yes |NA |297797 |0 | |2 |NULL |Yes |NULL |297852 |1 | +-------+-----------+-----------+-----------+-----------+--------+ The missing values should be replaced by a NULL value in my resultset. Is this possible? I don't have any clue how my query should look like, can anyone help me and show me a solution?
Eliminating Double Values From A Table
I need to consolidate data from many adress databases, which i allready sucessfully put into one table1. As Newbie i am reviing the Manuals and tutorials, but in 2 days i learned a lot about the powerfull command, but not how to solve the following question: Is there a straight forward method to copy data from one table1 into the other table2, but not those rowse, which have same value in Fieldx. All my Update and INSERT SELECT experiments somehow created more then less data in the target table.
Update Query Where Values Will Come From Other Table
I'm creating an update query which the value will come from another table. I have here my current query which unfortunately makes the system hangs. Probably because of the query itself is not properly coded. update boxes b inner join messages m on b.ctnnumber = m.ctnno set b.consigneerecv = m.CName, b.consigneerecvdate = m.DateRcv, b.phrecventered = "Y", b.PhilStatus = "delivered", b.prevreleasestatus = b.releasestatus, b.releasestatus = "delivered", b.PhilStatusDate = m.smsrecvdate, b.phdelprice = "0.00", b.phdelamt = "0.00", b.recvrelation = m.Relation, b.APRecventered = m.smsRecvDate where b.consigneerecv = '' or b.consigneerecv = 'NA' or b.consigneerecv is null; I'm thinking revising it so that it will not cause the system to hang but I don't know how. Guys please help me with this one. I also have this another idea which probably will not work. My idea was something like this: Update table1 set table1.column1 = (select table2.column1 where table2.column1 = table1.column1), table1.column2 = (select table2.column2 where table2.column1 = table1.column1), .....
Insert Values Only If They Do Not Already Exist In Table
I want to insert some values from one table (A) into another table (b). However there are some values in table A which exist two times in table A. I only want to insert values one time. So If a certain field value also exist in some other row (same fieldname) then I don't want to insert it twice. It doesn't matter which of the two rows will be inserted. Can this be done with MySQL? Maybe with some Control Flow Functions?
Updating A Table To Increment Values
Question, if I want to update all values in a certain column to increment by one, what statement could I use? In quasi-MySQL, this is my pseudocode: UPDATE table SET fields=[previous_val+1] where [previous_val]>[my_val] Or do I HAVE to run a SELECT query, increment the value, and THEN Update it? I was just thinking there'd be an easier way.
Accepting Values As NULL When Not In Another Table
Is it possible to perform a SELECT query on multiple tables and simply accept one of the values as NULL if not in another table rather than the whole query failing? For instance, if "rec_id" exists in "table_1" for certain but it is uncertain if it exists in "table_2", is it possible to return the query with a variable assignment stating whether "rec_id" was or wasn't found in "table_2"? I am hoping I can do this without a LEFT OUTER JOIN as the query is fairly complex and involves five different tables. Whenever results are fetched I simply need to know if rec_id is or isn't in table_2 if it is found in table_1. As there are frequently over 10,000 result rows returned it wouldn't be sound to put this into a seperate loop that queries with each rec_id to see if it is in table_2. I have tried "SELECT table_1.rec_id, table_2.rec_id FROM table_1, table_2 WHERE table_2.rec_id=table_1.rec_id OR table_2.rec_id IS NULL" but this returns no records.
An Enum Field Using Values From Another Table
The first table, called genus, contains several fields, the important one in genus is name, and there are others about the individual plant types. The second table 'plants' needs one field for the genus name, so that I can link tables on this. If there a way to make a foreign key from the genus table into an enum field on the second? My idea is that then, with phpmyadmin or similar I can just select the genus name from a list when entering new plant data.
Renumber Mysql Table Values
There are 100000 rows in a table, I need to renumber them from 1,3,6,8,11,14,21,55,888,1000,9999...99999 to 1,2,3,4,5,6,7,8,9,10,11,12,13,14... etc I also need to update an associated table, so its going to need to lock the tables, find the lowest available index in table1, then update table1 index, and then update table2 to use the same index as well, then unlock tables What would be the procedure to do that?
How To Edit Bdb_max_lock Value
I'm running MySQL 5.0.19 on Windows Server 2003. How do I edit the bdb_max_lock value? I'm using the MySQL Administrator, but can't find a way to edit it through that.
How To Edit A .MYD File
I need to know how to edit a mysql .MYD file.Are there any editors available for editing the file or are there any other means to edit that file.
Can't Edit New Records
I can not edit new records that were entered after I migrated the access tables to mysql I can edit the new records in the mysql table using the mysql query browser I can edit existing records using the access 2000 fe db that were impoted to the mysql db during the migration process I get a write conflict message box "This record has been changed by another user since you started editing it." The save record option is grayed out and my only choice is to drop changes or copy to clip board.
Database Edit App
Im looking for any kind of application that lets me edit a database, without having to go through myPHPadmin? For instance, maybe a way to do something with an excel sheet and then the app uploads it. Basically, I have an address book php application running on my website, and I'd like to add a lot of entries at once, without having to do it one at a time through the app itself. I figured out somewhat how to add certain parts through phpmyadmin, however, adding an entire entry means sending information to different tables in the database and I don't know how to format everything for each table. For instance, the Name of the contact is one table, the addresss information is another, and the groups (family, friends, etc) it belongs to is yet another. So is there any program that could help me do that? or...yeah. Sorry if this is confusing. I just really need to get this done for work, and its totally taking too long and my boss is getting upset.
Edit Sql Locally
i am using ems sql managaer 2005 as it has a good GUI and i can make/change tables fine i just can't find where the tables are located on the local server?? its set up on my local host which is on the xp server that my workstation (xp) is connected to. So basically how can i find these files to upload and is this the standard way to do it? I would very much like to keep my system of having a local and online version.
Edit A Database
I have set up a site for my business based around osCommerce, which comes with MySQL databases already written. I know nothing about SQL, but need to change the format of one of my databases, swapping the order that certain lines occur. Is there a simple way to do this (or possibly a simple way for a simple person to do it
Returning All Unique Values From A Table Field
I wrote a select that works fine but I am looking at it and thinking that the query might require mysql to scan EVERY row before giving me my answer. Lets pretend I have a table with fruits and want to return all the available colors of those fruits that I currently have in the database. Is this an efficient or horribly inefficient statement? "select color from fruits group by color" It seems to return what I want: fruits: ------ blue green yellow ... I am just wondering if it goes through EVERY row and groups them? If I have the table indexed by color am I allright?
Replace Some Username Values With The Users ID In A Different Table
I really can't figure this out. I want to replace some username values with the users ID in a different table. The tables are pictures user (Example FRED) picture (Example pic.gif) users id (Example 5233) user (Example FRED) What I want to do is replace the user column in pictures with the correct id from the users table So in the pictures table, it would no longer be FRED it would be 5233 Is there a query I can run to do this? I'd really appreciate some feedback
INSERT INTO Table (vars) VALUES(vals)
I am trying to use the following command: INSERT INTO sr_main (originator,symreq) VALUES (A.Person,269); Whenever I enter the command above I get the following error: ERROR 1054 (42S22): Unknown column 'A.Person' in 'field list' I am confused because the error refers to my _value_ 'A.Person' as a column!? Do string values need to be surrounded with quote marks of some type? I have already tried the obvious (to me) quote markers, e.g. ", ' The data is accepted if I use this command: INSERT INTO sr_main (originator) VALUES (269); I actually have a lot more fields and values than shown, and ideally would like to use the command type: INSERT INTO tablename (field1,field2,field3) VALUES (1,2,3) Code:
Counting Occurrences Of Values In Table Column.
I have two tables; Table 1; Agent_ID UserID First_Name Last_Name 1ShadShad Mortazavi 2Harry Harry Potter Table 2; Recording_IDAgent_ID Status GSM_File etc 11 000001.gsm 21 0 00002.gsm 32 100003.gsm 41 200004.gsm 51 100005.gsm 61 200006.gsm 72 100007.gsm Status 0 = Red, 1 = Yellow and 2 = Green I would like a query that returns the number of occurrences of Red, Yellow, Green against each agent so the data returned would look something like this; NameREDYellow Green Shad Mortazavi 2 0 2 Harry Potter 0 2 0 I'm using MySQL version 3.23.58 I can do this programmatically in Perl with several query's; but this is CPU intensive. If I could get this in one query I it would save time.
Selecting Unique Values From A Table (NOT DISTINCT!)
Lets say we have a table that has the field photo_id and has values of it many times. For example 245 can exist any number of times (1, 5, 8, e.t.c.). I want to select the values that exist in the table ONLY ONCE. Please note that i dont want to select each value once (using DISTINCT), that would return all the values that exist in the table. For example lets say the table has the following values: 245 563 776 224 563 563 776 776 776 776 The query i want to make should return only the values 245 and 224 as 563 and 776 exist many times in that table.
Can't Edit Text In Phpmyadmin
I need to edit some of the rows in phpMyAdmin (just text). But when I make the change and click "Go", everything seems fine, but no change was actually made! I don't understand what is going on, because this never happened before. I was always able to make changes to the text and it would save, and the change on the site would be seen. PHP version 5.2.4 MySQL version 5.0.27-standard-log
Record Update/Edit
I have a number of tables that are linked together. If a record record is created in the "main" table, atleast one record or more is created in the other tables. My users have requested a edit function and I was wondering which of the below methods would be best. 1. Delete the main record and all record relating to it in all the other tables. Then creating new records for the tables with the new data. OR 2. Check if the the data has changed, and if it has either create a new record if one does not already exist or update if it already exists. Or if data did exist and no longer does delete the record. For simplicity sake the first one was the option I would go with but I am not sure if it would create more headaches in the long run.
How To Edit The Database Manually?
I delete some users from the database related to a script I am working at it. But, after I deleted those (users) the script memberlist shows (blank spaces) insted of clear list of users in the script. For example: ((Before the delete from the database)) the memberlist view like this: 1. User A 2. User B 3. User C 4. User D 5. User F 6. User G ((After the delete from the database )) the memberlist view like this: 1. blank 2. User B 3. blank 4. User D 5. blank 6. blank I know I must delete the users from the script admin itself, but I dosen't know that the blank space will remain the script members list? My Quesation, How I can delete the (blank space) in the member list? and how I can edit the database manually?!
Edit MySQL DB Without Server
I have received a MySQL Database and saved on my HD. Now I want to use & edit with PHP some (basically delete some tables and remode some fields I do not want to use), but I do not want to load the DB to a server first or start any XAMMP.
Trying To Edit A BLOB From SQL Statement
I have a BLOB field containing multiple user options, like below. language=en columns=80 rows=25 I am trying, using SQL to change the 'language=en' line to 'langauge=it' where the user_id=x.
Keep DB Of Users And Allow Them To Edit Certain Tables
I am quite up to date in programming and database queries, but have a relatively simple question that I have no idea about. I would like to allow people to 'sign up' to my web site (for now keeping it simple, say with a basic HTML form) their details should go into a table, say username, email and password (table already created) and then to allow them access to a given table from within another HTML form, such that they would not be able to log into the mysql DB from the command prompt, but they would be able to add, delete or modify rows from within a designed gui (designed by me to make sure they wouldn't delete the whole table or anything). Is this a relatively simple task, or am I asking too much from my first real mySQL project? if its do-able, could anyone direct me to an essay utorial or give me a hint in which direction I should be going with this.
Unable To Edit Users
I have had MySQL up and running fine and today I made a few changes in preparation to replicate the databases on what will be the Master. I now have a problem where when I logon to the Adminstrator GUI appl as root once after re-booting windows I get in OK, however I can no longer view any user information. It does allow me to add a user apparently. However once I log off I can no longer login as root - I get error 1045 with exactly the same login details as have just worked before. If I reboot I can get in again once. Can anyone suggest why I might be seeing this funny situation, or suggest anything I might have changed to cause this. I 'think' I have put everything back as it was.
Edit Existing Data
I have just started to learn MySQL and this question might be silly. I have a MySQL table with user information. I want to edit this table in a website. I need to load existing data in a HTML form and then edit the fields and update them. I searched the net but could not find anything .
Edit This Object Code
Code: $s_groups = $db->selectObjects("db_direct","1 ORDER BY sid"); I have to add "WHERE sid < 10" in this code. I tried $s_groups = $db->selectObjects("db_direct","1 WHERE sid <10 ORDER BY sid"); which didn't help
|
TRACKER
