Automatic Update Of Values In Another Db
I am trying to integrate a CMS and a fourm.
As a solution, whenever there is a change in the users table of the CMS db I want to have it automatically changed (updated) in the forum db as well.
Can anyone recommend a solution?
Please note that the two user tables differ in structure, just some columns match, like password and such.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Automatic Update On Clients?
I'm developing an application wich saves data on an SQL Server Express database, but I'm planning to upgrade to MySql. Only at the server is the program wich add registries, occasionally the clients could add information. Here is the problem: Is there a way on MySql where the information on the clients is updated automatically? something like if a register is added to tell all the clients immediatly, because is crucial for the clients to have the latest data in real-time.
Automatic Procedure On Update?
Is there a way to have the database also Add Column 1, and Column 2 together and put the value into column 3, when a new record is inserted?
How To Update Tables Automatic?
I have a table with all FOREIGN KEYS pointing to tables with PRIMARY KEYS. But when i add data to base table(Primary Key) it should auto update the dereived(Foreign key) table
Automatic Update At 12 Pm In Mysql
For my final project,I must do cafeteria systems with mysql backend database. This is my system. Student will have $10 and will deduct for breakfast,lunch and dinner.If they eat breakfast $2,so the money will become $8.At the end of the day,they will have $0. Ok,I know how to do that. But how come I using mysql that at 12 pm,the student money will back to $10.
Update With Values
I would like to update an existing row from table A with some values from another row in table A.I've tried several things, also something like the combined "insert into/select" however it did not work saying its not valid SQL. UPDATE A SET value1=b1.value1, value2=b1.value2 SELECT value1, value2 FROM A; Any idea what could be wrong? Is the idea valid in SQL after all?
Update And Add On Values
I have a table that has acculumative hours for each member. I want the members to be able to type in two times, then the code to get the difference between the times and add it on to what is already in the database under their name. Is this just an UPDATE query, or is there more specy stuff involved?
Update Values
I made a mistake converting some time data to unix timecodes while adding some data to a database, and now I noticed some of these dates need to have 15 hours added to the timestamp. So I though about doing a Code: UPDATE ntk_news SET date=date+54000 WHERE newsid>0 AND newsid<178 after having a look at the MySQL manual for Update . Did not work, unfortunately. Anybody knows what I am doing wrong? I took 54000 since that is ~15 hours. The WHERE statement works in a SELECT clause, but then copy-n-pasted into this UPDATE clause it all breaks.
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
How To Update Values In A Column
I have a price list that needs increasing by 10%. Is there any way to do an update commmand and multiply all values in the column by 1.1 to achieve this? I've tried various commands but to no avail.
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:
Update Values In Column
i have a table with about 500 rows, i need to UPDATE the city column in each row. I want to remove a comma (",") a space (" ") and the 2 letter state abv ("FL") from all values in the column (named 'city'). example: "Miami, FL" should become "Miami"
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), .....
Update Values On Inserting Duplicate Index
I am very new to mysql. I have a question about using the "on duplicate update" clause with insert command. my table "data" has two columns, field1 and field2, where field1 is the index and is "unique". when I run insert ignore into `data` ( `field1`,`field2`) values (1,2) (2,6) (2,9) (5,1) I got 1,2 2,6 5,1 because the third value pair, (2,9) was ignored due to duplication in field1. here is what I want to do: when inserting new record with duplicate index, I want the existing record gets updated. in the above case, I want the output look like the following after the insert command: 1,2 2,9 5,1 after searching mysql online document, I only found the "on duplicate update" clause can do something similar, however, all the examples only show setting the duplicate record to somthing unrelated to the new values.
How To Insert And Update Multiple Values In One Record
How do I insert and update multiple values in one record. e.g. 1. How do I insert "dogs,cats, snakes" in one record 2. If I have "dogs, cats, snakes" in one record and I want to update it and add 'pigs' to make it "dogs, cats, snakes, pigs", how do I do that?
Automatic Sort
Is there a way to automatically sort "inserts" according to date in mysql? I have searched high and low for something like this in mysql. I know that it can be done in MS sql but cant find it for mysql.
Automatic Sql Instructions
I'm developing a website and a have to import a txt file in my mysql database. It sounds simple but it has to be done automaticly. I don't know how to do that in Mysql, in Sql Server i could use JOBS, but with mysql i really don't know.
Create Automatic
Does anyone know a script that can create a mysql database autmatically when you run the script?
Automatic Replication
I recently set up replication between my linux server (the master) and a windows 2000 server (the slave).Both are running MySQL 4.0.12. I have noticed that replication isn't automatic. If I go to the slave and do "load data from master" it replicates correctly, but I want it to replicate as changes occur. Is that even possible? Also,is it possible to set both of them up as peers, so either will replicate data to the other?
Automatic Date
I've been trying to add a date field that will automatically add Day/Month/Year after my id field, but I'm getting all kinds of errors. `id` int(10) unsigned NOT NULL auto_increment, `approve` varchar(10) NOT NULL default 'false', `SubmitEmail` varchar(50) NOT NULL default '',
Automatic Updates
I'm not sure if this is possible or not, but is there a way to automatically insert data and delete data in a database at specific times during the day? Is there a script or something out there that would allow me to do this?
Automatic DB Backups
I've been looking at a way to backup my DB automatically (say, every day). All I found was this backup (http://members.lycos.co.uk/wipe_out/automysqlbackup/) but I have to idea how this works, especially these 2 lines - Make the file executable :- chmod u+rwx - Every day AutoMySQLBackup will run (if setup on /etc/cron.daily).
Automatic Deletions
How do I prune my 5.0.11 mysql database (running on linux) automatically? What I am trying to do is have some process that will delete all records older that x days from the database. One complicating factor is that only one of the tables in the (snort) database actually has the timestamp the others just have foreign keys to the table with the timestamp.
Automatic Delete
Is it possible for a row to be deleted automatically based on a date that is inserted. I don't want to have to run an sql statement to select and delte the row, i would like the row to automatically be deleted when it reaches a date that is stored in it? is this possible... if not how do websites that have timelimits/expirey dates work? or do they store all the information and only show the information that has not passed the expirey date?
Automatic Failover
I have set up mysql replication at work, so that if in the middle of the night the master server goes down, i do not have to be called in. It will simply switch to the slave. My question is: 1. Is what i mentioned above accurate? 2. If so, what is the procedure for setting up the master-slave relationship again, after I come into work the next day.
Automatic Repairing
I have a mysql database with some myisam tables. It seems that when the database gets too big or something like that, the server performs an automatic repairing (with BACKUP and FORCE options). The normal process is that when a table is repaired, a TMD file is created and the registers contained in the MYD file are copied into it. When all data are successfully inserted into the TMD file, the MYD is deleted and the TMD is renamed to MYD, so it will be used now.My problem is that, I don't know why, the TMD is filled and the the MYD deleted but then the TMD remains with its name (as a TMD file) and the repairing process fails (I get a 144 error code then, next repairings fail as well). Any idea about what can be happening?
Returning The Automatic ID On Insert ?
Is it possible to return the auto_increment ID on inserting a row ? It would save me alot of hassle so i don't have to do another query to get the ID + i'd have problems getting the ID of a row without the ID to say 'where pic_id = $id'. Then again i could just do 'where pic_created = $time AND user_id = $uid'
Automatic Form Generator
Does anyone know of a free software package that would query the schema of a MySQL table and automatically (or interactively) generate a PHP web form for querying/inserting/updating rows of the table? I've done some googling for this and the closest free thing I found was something called Xdobry that was too confusing and badly translated from German.
Automatic Orphan Delete
I have this little database with some relations between my tables. To make it simple, say I have a table named "Person" and another table named "Car". In my table "Person", I have the name and other information about the person, including its brand of car. There is a relation with the table Car, in which there is information about particular brands of cars. Now, say there was 2 people in my list that had a Chrysler, but they both changed. Now, no one points to the Chrysler record of my Car table, so I would like to remove it. Is there a way to automatically do this? Like the Cascade on Delete option? If not, how can I do it?
Automatic Dataset Refresh
I want to display records from my database in a GUI (windows form). Specifically, I want to display the newest record and I want it to update the display (ideally) every time the database receives a new record. I can easily fill the dataset no problem. I have also tried to use the tableAdapter.FIll() function, but iterating over this doesn't seem efficient and I can't get it to work.
Automatic Type Casting
I noticed that negative values inserted into a unsigned integer field will get set to ZERO. Why? I have to use CASE(number as unsigned) when inserting. Example: drop table testing; create table if not exists testing (i integer, b bigint, m mediumint, u integer unsigned); insert into testing values (-10, -10, -10, -10); insert into testing values (-10, -10, -10, cast(-10 as unsigned)); select * from testing; i b m u -10 -10 -10 0 -10 -10 -10 4294967295 Is there a way to avoid using cast? Why not use automatic type casting? The field is set as unsigned. Isn't that enough info to type cast a negative number rather than set it to zero?
MySQL And Automatic Emailing
Is it possible through a MySQL db [with fields for email addresses (hyperlinked), names and birthdates] to send a birthday message automatically (for the date field to the corresponding name/email address) In other words... is there code to request/schedule field1(email address) be sent a link/image/message at/on field2(date) with field3(name) inserted appropriately to personallize the greeting?
Automatic Cell Deletion
tell me how I can have cells from a table automatically delete themselves after say 15 entries. I'm sure this is a very simple action, but I am a very new basic user of mySQL. Is it possible to set up this action within the datbase itself or do i have to creat a new php file to do this..if so...what should it say.
Automatic Database Backup.
Currently Im using phpMyadmin export feature to create a .sql file that I download as a backup of my database.Is there any way I can automatically get the server to create this backup file for me, and email it to me? I am on linux hosting. There is a button in 'Cpanel' called cron jobs which I think could help but Im not sure how to use them.
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
MySQL Offsite Automatic Backup
Does anyone know of a company that offers automatic offsite mySQL backup on a weekly basis? I often forget to download my backups from the server and would love to sign up for a service that would just do it automatically - I would feel a whole lot more comfortable! I don't like sending them via email as the database is around 500MB and my email provider doesn't like it...
Automatic Operation When Some Condition Apply
I have a table with a big number of rows, on which I do simple operation (basically I need the sums of some columns). As the table gets bigger and bigger, I would like to know if there is a way such than when it reaches a given number of rows (let's say 100000), it stores the results on a new table and use this results for future query (I mean I want to avoid of summing all the rows each time, but I would prefer to use the results I already have obtained). If I have understood well, this could be done with triggers and procedures, but I have no idea about how.
Maxdb 7.5 / Automatic Database Extension
I know my questions have been asked several times, but I could not find a clear answer in maxdb documentation nor in the mailing lists... Can someone give me a pointer to the answers for these questions please: 1) Is it possible to activate some automatic database extension option ? (I have read in some presentation that is does exist), 2) and what are the prerequisites and procedure to activate this option ?
Master Replication Automatic Failover
I am having one master and three slaves. If my master fails suddenly then one of my slave has to become master automatically on any platform (windows/linux). Can you please suggest the process to do this. Note: Manually i know how to do this task, but i need to be do this automatic.
Automatic Natural Join On All Foreign Keys
Is there any automated way (in MySQL 4.1.3) to get the results of a natural join on all foreign keys in a table? In other words, if I have a table T with foreign keys K1, K2, ..., Kn can I get a derived table that has T joined with all the these foreign tables? I am trying to do it now by parsing the CREATE TABLE statement to extract the foreign keys for a table, then using this to join T with these foreign tables. This works decently for 1 level deep (T and all its foreign keys), but I realized that it must work recursively (ie. I must join all the foreign tables on _their_ foreign keys). Even though I can theoretically do it with subqueries, it quickly gets to be a nightmare. Note: I cannot hard-code any table-specific stuff since this is a generic function that is given a table name as input and generates a SELECT statement as output (or returns the records, if I cannot create a SELECT statement).
Real-time Automatic Conditional Data Manipulation
So it happens that I have to delve into the fields I feel very uncomfortable in ... for now. I'm working off the existing MySQL DB, in which I have to: 1. Analyse in real time (or nearly there) every newly entered row in the "entry" table (data is inputed by a third party) based on the set of criteria and depending on the outcome create new entries either in "bad" or "good" tables 2. Perform the same operation but on the different set of criteria on the new entry in the "good" table and create new record in the "output" table, which is then visible to the third party (but contains very different data from originally entered) My original plan was to dive into writing triggers, but this feature does not seem to be supported in the platform of my choice. Are there any GUI tools (or anything that would not require PhD in quantum physics) that can help me to create conditional real-time updates between tables within one MySQL database triggered by appearing new record?
Backup MySQL Via Port 3306 (which Tool? Automatic Backup?)
i have quite a big database on my website - and i cannot get any backup via system dump or scripts anymore, because my hoster added some memory limits - and scripts/dump can't finish... so the only way left is to backup my database via connection to port 3306 and tools like mysqlfront. mysqlfront is unfortunately quite slow and buggy - so do you know any tools which can backup databases via external connection? - it would be great if there are tools which run automatically? (batch/commandline??) backup with mysql.exe - h -u .... is impossible, too!
Complex Query - UPDATE Within UPDATE?
Edit: Before anyone leaves this thread, don't be put off by the regular expressions! They are not the problem, so please stay and read. OK, this query has got my head spinning. I am basically creating a query that goes through each product in a table to update the stock for that particular item with that particular size (i.e. I am talking about shoes - different models and each model has different sizes (uk kids 12 -> uk 11). With each shoe it does (or is meant to do) the following: 1. The PHP script that runs the query is looping through every size outside of the query 2. So for each of these sizes it checks to see whether the product it is currently on matches the size it is on 3. When it finds the size it is on, it then deducts the correct number of units from the stock table 4. The final WHERE clause makes sure this subquery inside the UPDATE only happens when the StockUpdated field of the Product table equals 0 (in other words, the stock hasn't been counted before) Basically what I need to do, is first to make sure what I currently have got does the above correctly but also I need the query to UPDATE the StockUpdated field to 1 only when it has been updated successfully. How could I do this? Unfortunately I cannot just add an extra update entry to the end of the query as this would update the StockUpdated field regardless of whether it has been properly counted or not. Here is the query I have so far (with a little simple PHP around it doing the loop): PHP $shoesizes = array(1 => 'ukk12','ukk13','uk1','uk2','uk3','uk4','uk5','uk6','uk7','uk8','uk9','uk10','uk11'); $numshoesizes = count($shoesizes); for($i = 1; $i < $numshoesizes; $i++) { $stockupdate = " UPDATE heelys_stock,items_ordered SET heelys_stock.size_".$shoesizes[$i]." = (SELECT CASE WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?( )?(Kids)?( )?( )?(UK)?( )?( )?(Kids)?( )?( )?[^0-9]12( )?(' -- if UK Kids 12 THEN heelys_stock.size_ukk12 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?( )?(Kids)?( )?( )?(UK)?( )?( )?(Kids)?( )?( )?[^0-9]13( )?(' -- if UK Kids 13 THEN heelys_stock.size_ukk13 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]1( )?(' -- if UK 1 THEN heelys_stock.size_uk1 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]2( )?(' -- if UK 2 THEN heelys_stock.size_uk2 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]3( )?(' -- if UK 3 THEN heelys_stock.size_uk3 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]4( )?(' -- if UK 4 THEN heelys_stock.size_uk4 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]5( )?(' -- if UK 5 THEN heelys_stock.size_uk5 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]6( )?(' -- if UK 6 THEN heelys_stock.size_uk6 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]7( )?(' -- if UK 7 THEN heelys_stock.size_uk7 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]8( )?(' -- if UK 8 THEN heelys_stock.size_uk8 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]9( )?(' -- if UK 9 THEN heelys_stock.size_uk9 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]10( )?(' -- if UK 10 THEN heelys_stock.size_uk10 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]11( )?(' -- if UK 11 THEN heelys_stock.size_uk11 - (items_ordered.Amount/items_ordered.Price) FROM items_ordered WHERE items_ordered.StockUpdated = 0) WHERE (heelys_stock.id = (SELECT heelys_stock.id FROM heelys_stock,heelys_shoe WHERE SUBSTRING_INDEX(items_ordered.Product,',',1) = heelys_shoe.full_shoe_name)) , items_ordered.StockUpdated = 1" // at the moment this last update of the items_ordered table happens to every record!!! even if the other part of query fails // update stock for size $i mysql_query($stockupdate); } Hope someone can see how I can do this? I've been working on this query for 2 or 3 hours now and I've been making reasonable progress but now I am really stumped.
Update Replication, Force Update
Recently an error in the db on my master caused the slave to fail. I noticed this after a few days when I looked at the status and it said "Slave_SQL_Running: No". After looking further I saw what the error was on the master. What is the best method of re-synching the databases? Is there a command to force a re-replication or synch of the dbs? Would you delete the slave's db and update over? In this case, is there a command to pull the data down from the master?
Unable To Update - Have Update Priveledge
I've been granded update priveledge to tables in a few databases on our server: Select_priv ,Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, and Lock_tables_priv are all set to 'Y' for a selected database. I can connnect and read the data and data definitions just fine. I cannot insert, update, delete, create, or alter any table in this database. Our admin worked for a couple of hours yesterday trying to resolve the issue, but no joy. I've googled for this problem and the most relavent posts I've found were problems related with users not being able to connect. I can connect and I can read, I just can't do any of the other priviledges.
ON DUPLICATE KEY UPDATE - Don't Have A Key But Want To Update
This may seem like more of a PHP question but I will come onto the MySQL part in a minute. Basically I have a PHP script that lets users upload 2 different CSV files to different tables. The problem I have is that sometimes these CSV files are updated and then need to be reimported into the database through the script. I have made this script totally generic so that when you change the table that is being entered to the rest of the script will alter itself to import the correct CSV to that table. But a problem arises when I have a CSV file that contains each product sold and the shopper who bought the product (so the shopperID may appear in more than 1 row) - however this file does not have a unique id for each row meaning that when I use an INSERT INTO with a ON DUPLICATE KEY UPDATE... it will just insert more rows instead of updating rows because there is now key in the table. The format of the table is like this (with some example data to show you more clearly): +-----------+-------------+---------+------+--------+------+ | ShopperID | Product Code | Product | Price | Amount | Units | +-----------+-------------+---------+------+--------+------+ 546733 1315 prod 1 64.00 64.00 0 546733 1316 prod 2 43.99 43.99 0 OK just ignore the last 2 fields - that is a problem with the old system there was which does not add the units up right. Anyway basically I might have the same shopper ordering 2 things which will come up on different rows - I have 3 things I cannot do: 1. I can't make the ShopperID field the PRIMARY KEY because I have many times where there are 2 rows with the same shopper 2. And I cannot just do an UPDATE when it gets to a duplicate entry because it will overwrite every time it gets to a shopper that already exists. 3. I don't want to add a unique primary key to the CSV as this will mean that the system I am creating loses its ability of being automatic because the person (an admin) that uploads the file will have to make sure that it has that extra field which is auto incrementing. Does anyone have any ideas on how I can get round this? Here is my PHP function which contains the query: PHP // this function for insert data to csv function makeINSERTS($text, $table, $tablefields, $correctcsv){ $insert = array(); //make array for hold data insert $i = 0; $success = true; while(list($key, $val) = each($text)){ // Insert the data $insert[$i] = "INSERT INTO ".$table." VALUES('"; $insert[$i] .= implode("','", $val); $insert[$i] .= "') ON DUPLICATE KEY UPDATE "; foreach($tablefields as $k=>$field){ $insert[$i] .= "`$field`='{$val[$k]}',"; } $insert[$i] = substr($insert[$i],0,strlen($insert[$i])-1); // echo $insert[$i].'<p></p>' $result = mysql_query($insert[$i]); if(!$result) { echo 'FAILURE to insert/update any or all of the database form uploaded CSV!<br />' $success = false; die('Query failed: ' . mysql_error().'<br />'); } $i++; } if($success == true && $correctcsv == true){ echo 'SUCCESS in uploading the CSV file to the database!<br />' } else { } return $insert; }
Update Queries Do Not Always Update
We are running a MySQL database using PHP to create html pages and forms to update and add information to the db. Sometimes the update query works, sometimes it doesn't - or at least, not permanently. A new record may be added, but five minutes later it has sometimes, but not always, mysteriously disappeared. Where should I look for a solution? Is there a cache that MySQL creates that may be being accessed unwittingly? We are using the standard php and MySQL versions that come as standard on a Mac OS X Tiger 10.4.7 server. The browser we are using is Firefox 2.0.4.
Get All Values
Is it possible to just return all the values that are in a column?
|
TRACKER
