Search found 8 matches

by Mobo01
Sun Apr 30, 2023 7:20 pm
Forum: newLISP and the O.S.
Topic: delete rows that have a specified timestamp
Replies: 1
Views: 778

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 ...
by Mobo01
Tue Apr 25, 2023 1:56 pm
Forum: newLISP and the O.S.
Topic: Error code 1205 when transactions
Replies: 0
Views: 696

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...
by Mobo01
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: 747

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...
by Mobo01
Wed Mar 22, 2023 11:18 am
Forum: newLISP and the O.S.
Topic: pretty-print line length
Replies: 1
Views: 2056

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...
by Mobo01
Thu Jan 05, 2023 7:05 am
Forum: Anything else we might add?
Topic: Creating a database for a basic game
Replies: 0
Views: 1266

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...
by Mobo01
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: 885

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...
by Mobo01
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: 912

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...
by Mobo01
Thu Jun 23, 2022 9:03 am
Forum: Anything else we might add?
Topic: Using virtual memory for context switching?
Replies: 0
Views: 1268

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 ...