[`SIGNED BIGINT`](http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html) is a 8-bytes long integer just like Java&#39;s `long`.

Java long max value is positive: `9,223,372,036,854,775,807`

This means for positive only unsigned numbers `UNSIGNED BIGINT(19)` should be enough or you can just use `UNSIGNED BIGINT` which is equal to `UNSIGNED BIGINT(20)`

If you are going to use negative numbers as well `BIGINT(19)` will be enough.

I am trying to use the ps -o command to get just specific info about processes matching a certain name. However, I am having some issues on this, when I try to use this even to just get all processes, like so, it just returns a subset of what a normal `ps -ef` would return (it doesn&#39;t return nearly the same number of results so its not returning all running processes)

    ps -ef -o pid,time,comm

I want to try something like this (below) but incorporate the ps -o to just get specific info from it (just the PID)

    ps -ef |grep `whoami`| grep firefox-bin

Any advice is appreciated as to how to do this properly, thanks 

Linux / Bash, using ps -o to get process by specific name?

I tried to truncate a table with foreign keys and got the message:

&gt; &quot;**Cannot truncate table  because it is being referenced by a FOREIGN KEY constraint**&quot;. 

I read a lot of literature about the problem and thought that I found the solution by using delete 

    DELETE FROM table_name DBCC CHECKIDENT (table_name, RESEED, 0)

But I still got an error message:

&gt; &quot;**The DELETE statement conflicted with the REFERENCE constraint**&quot;. 

When I try to delete with Microsoft Management Studio and execute the previous query 
    
    DELETE FROM table_name DBCC CHECKIDENT (table_name, RESEED, 0)

it doesn&#39;t give an error and works properly. I want to delete all information from a table and add new into it, but I don&#39;t want to drop and create foreign keys.



I got error &quot;The DELETE statement conflicted with the REFERENCE constraint&quot;

What is the equivalent of a Java long in the context of MySql variables?

Java long to MySql

<p>What is the equivalent of a Java long in the context of MySql variables?</p>


In my app I need to do a lot of INSERTS. Its a Java app and I am using plain JDBC to execute the queries. The DB being Oracle. I have enabled batching though, so it saves me network latencies to execute queries. But the queries execute serially as separate INSERTs:

    insert into some_table (col1, col2) values (val1, val2)
    insert into some_table (col1, col2) values (val3, val4)
    insert into some_table (col1, col2) values (val5, val6)

I was wondering if the following form of INSERT might be more efficient:

    insert into some_table (col1, col2) values (val1, val2), (val3, val4), (val5, val6)

i.e. collapsing multiple INSERTs into one.

Any other tips for making batch INSERTs faster?


Efficient way to do batch INSERTS with JDBC

What is the best way to save user settings in java desktop app securely? For example If I want to save an Ftp account settings what is the best way to do that?

Thanks

What is the best way to save user settings in java application?

I have this ugly code:

    if ( v &gt; 10 ) size = 6;
    if ( v &gt; 22 ) size = 5;
    if ( v &gt; 51 ) size = 4;
    if ( v &gt; 68 ) size = 3;
    if ( v &gt; 117 ) size = 2;
    if ( v &gt; 145 ) size = 1;
    return size;

How can I get rid of the multiple if statements?

Get rid of ugly if statements

What does AtomicBoolean do that a volatile boolean cannot achieve?

Volatile boolean vs AtomicBoolean

Saw this line in a class method and my first reaction was to ridicule the developer that wrote it.. But then, I figured I should make sure I was right first.
    
    public void dataViewActivated(DataViewEvent e) {
        if (this != null)
            // Do some work
    }

Will that line ever evaluate to false? 

Can &quot;this&quot; ever be null in Java?

I connect to `mysql` from my Linux shell. Every now and then I run a `SELECT` query that is too big. It prints and prints and I already know this is not what I meant. I would like to stop the query.

Hitting `Ctrl+C` (a couple of times) kills `mysql` completely and takes me back to shell, so I have to reconnect.  

Is it possible to stop a query without killing `mysql` itself?

How can I stop a running MySQL query?

My iPhone application connects to my PHP web service to retrieve data from a MySQL database, a request can return up to 500 results.

What is the best way to implement paging and retrieve 20 items at a time?

Let&#39;s say I receive the first 20 entries from my database, how can I now request the next 20 entries?

MySQL Data - Best way to implement paging?

I have something like:

    SELECT *
    FROM table
    WHERE id IN (118, 17, 113, 23, 72);

It returns the rows ordered by ID, ascending. Is there a way to get back the rows in the order specified in the `IN` clause?

Sort the rows according to the order specified in WHERE IN clause

I need to update 2 datetime columns, and I need them to be exactly the same, using mysql version 4.1.20. I&#39;m using this query:

    mysql&gt; update table set last_update=now(), last_monitor=now() where id=1;

It is safe or there is a chance that the columns are update with different time, because of the 2 visible calls to `now()`?  
I don&#39;t think that it can be update with different values (I think internally mysql calls `now()` just once per row or something similar), but I&#39;m not an expert, what do you think?

**Update:**
Second question was extracted [here][1].


  [1]: https://stackoverflow.com/questions/56269245/update-multiple-columns-with-same-value-short-syntax

mysql update multiple columns with same now()

How can I change the position of a certain existing column in **MySQL** table?

Ex: I want to move the column *username* from its current position to instead be after all the columns or I want it before any certain column in my table.

Content Type	Original Author	Original Content on Stackoverflow
Question	syker	View Question on Stackoverflow
Solution 1 - Java	Crozin	View Answer on Stackoverflow
Solution 2 - Java	Fırat KÜÇÜK	View Answer on Stackoverflow

Java long to MySql

Java Problem Overview

Java Solutions

Solution 1 - Java

Solution 2 - Java

I got error "The DELETE statement conflicted with the REFERENCE constraint"

Linux / Bash, using ps -o to get process by specific name?

Attributions