Search found 8 matches
- Sun Apr 30, 2023 7:20 pm
- Forum: newLISP and the O.S.
- Topic: delete rows that have a specified timestamp
- Replies: 1
- Views: 7799
delete rows that have a specified timestamp
I have a database where I save messages with timestamps. I made the following table using this code: CREATE TABLE messages ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, msgid VARCHAR(64) UNIQUE, payload TEXT, sender VARCHAR(259), cur_timestamp TIMESTAMP(3) ); Everything works flawlessly. However, I ...
- Tue Apr 25, 2023 1:56 pm
- Forum: newLISP and the O.S.
- Topic: Error code 1205 when transactions
- Replies: 0
- Views: 6118
Error code 1205 when transactions
As a SQL developer, I occasionally get an error indicating an issue with the COMMIT command. In the past, I've experienced error code 1205, which signals a stalemate scenario. When two or more transactions wait for each other to release resources, such as database locks, a deadlock develops. In this...
- Wed Mar 22, 2023 11:18 am
- Forum: newLISP and the O.S.
- Topic: For Loop Fibonacci Sequence - I don't understand the loop
- Replies: 0
- Views: 6215
For Loop Fibonacci Sequence - I don't understand the loop
I'm new to Python and attempting to figure out how I'm obtaining the right response. Create code that: The first 50 terms of the Fibonacci sequence are calculated and printed. Each phrase and number should be printed as follows: term: 0 / number: 0 term: 1 / number: 1 term: 2 / number: 1 term: 3 / n...
- Wed Mar 22, 2023 11:18 am
- Forum: newLISP and the O.S.
- Topic: pretty-print line length
- Replies: 1
- Views: 5209
Re: pretty-print line length
It appears that you are seeing a difference between the default line length in your terminal emulator and the real line length that your system can output. This is not unusual, and it is frequently adjustable to your liking. Keep in mind that the "pretty-print" setting may be specific to a particula...
- Thu Jan 05, 2023 7:05 am
- Forum: Anything else we might add?
- Topic: Creating a database for a basic game
- Replies: 0
- Views: 10029
Creating a database for a basic game
I'm creating a database for a basic web game. To isolate my issue, assume there are two tables that reference each other as seen below. Player ( p_id, p_name, inventory(multiple i_id) ) Item ( i_id, i_name ) The issue is with the inventory column, which is used to store numerous ids from the Item da...
- Fri Dec 02, 2022 9:03 am
- Forum: Anything else we might add?
- Topic: Recursion is used in Java to reverse an array.
- Replies: 0
- Views: 5958
Recursion is used in Java to reverse an array.
I'm just getting started with recursion, but I was able to utilize it to construct a basic factorial program without any difficulty. I'm now attempting to construct a recursive function that writes an array in reverse order, but I'm not sure what I'm doing wrong. I'm following the advice in this art...
- Wed Nov 09, 2022 7:20 am
- Forum: newLISP and the O.S.
- Topic: SQL: To get a count result, use the SET operator.
- Replies: 0
- Views: 6302
SQL: To get a count result, use the SET operator.
In SQL Developer, I'm attempting to acquire a count result by using the SET operator. I need to determine how many instances of "attribute1" exist in "table name1" but not in "table name2." Essentially, I want the same result as the following query, but with a SET operator. [code]SELECT count(distin...
- Thu Jun 23, 2022 9:03 am
- Forum: Anything else we might add?
- Topic: Using virtual memory for context switching?
- Replies: 0
- Views: 6330
Using virtual memory for context switching?
I recently gave a midterm test for an Operating System course, and one of the questions went as follows: Which of the following statements is false? Virtual memory translates a program's address space into physical memory address space. Virtual memory enables each application to outgrow the primary ...