01-29-2019
A question: can you not place your data temporarily in a file and use command line tools to get your answer, since the query runs for potentially a very long time? What table contains "data"? Then you can use a subquery.
Plus, having been an admin and system programmer for a long time I would commend code like this to help from a very senior techie. Quadratic time queries may have system wide impacts that affect other processes and users. This is a polite way of me saying if you did this you would incur the wrath of a lot of people. Just saying. If it is your desktop, okay, maybe.
8 More Discussions You Might Find Interesting
1. Programming
Hi there,
I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks!
YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies
2. Shell Programming and Scripting
Hi there, I have a table that stores multiple records for many different servers, each of which is timestamped ... I wanted to write a query that would enable me to only output the "latest" record (based on timestamp) for each "unique" server. So for example my main table looks like this
... (3 Replies)
Discussion started by: hcclnoodles
3 Replies
3. Web Development
hello all
i have 2 columns every column in the following format
column1
2011-04-01 11:39:54
column2
2019-02-03 00:00:00
i want get difference between above data as following
2 days 11:39
how to do so ?
i tried many functions but nothing works
please advice what is the query... (6 Replies)
Discussion started by: mogabr
6 Replies
4. Shell Programming and Scripting
Hi,
I want to access mysql query from database , for that i have tried the below code
#! /bin/bash
TABLE_NAME=database1
USER_NAME=root
IP_ADDR=111.20.9.256
somevar=`echo "select altid from alert where altid='2724'"| mysql -h $IP_ADDR -u $USER_NAME $TABLE_NAME `
echo $somevar
... (1 Reply)
Discussion started by: aish11
1 Replies
5. Programming
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (0 Replies)
Discussion started by: aish11
0 Replies
6. Shell Programming and Scripting
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (11 Replies)
Discussion started by: aish11
11 Replies
7. Programming
Hello
i have created mysql query to compare to values and get difference in percentage
as following:
SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies
8. Programming
Hi All,
i have a table in mysql with the following data
Table name Test
Assettype Serial_No Status location
Mouse 123456 In Stock chennai
Mouse 98765 Allocated chennai
Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies
LEARN ABOUT DEBIAN
systemd-ask-password
SYSTEMD-ASK-PASSWO(1) systemd-ask-password SYSTEMD-ASK-PASSWO(1)
NAME
systemd-ask-password - Query the user for a system password
SYNOPSIS
systemd-ask-password [OPTIONS...] [MESSAGE]
DESCRIPTION
systemd-ask-password may be used to query a system password or passphrase from the user, using a question message specified on the command
line. When run from a TTY it will query a password on the TTY and print it to STDOUT. When run with no TTY or with --no-tty it will query
the password system-wide and allow active users to respond via several agents. The latter is only available to privileged processes.
The purpose of this tool is to query system-wide passwords -- that is passwords not attached to a specific user account. Examples include:
unlocking encrypted hard disks when they are plugged in or at boot, entering an SSL certificate passphrase for web and VPN servers.
Existing agents are: a boot-time password agent asking the user for passwords using Plymouth; a boot-time password agent querying the user
directly on the console; an agent requesting password input via a wall(1) message; an agent suitable for running in a GNOME session; a
command line agent which can be started temporarily to process queued password requests; a TTY agent that is temporarily spawned during
systemctl(1) invocations.
Additional password agents may be implemented according to the systemd Password Agent Specification[1].
If a password is queried on a tty the user may press TAB to hide the asterisks normally shown for each character typed. Pressing Backspace
as first key achieves the same effect.
OPTIONS
The following options are understood:
--h, --help
Prints a short help text and exits.
--icon=
Specify an icon name alongside the password query, which may be used in all agents supporting graphical display. The icon name should
follow the XDG Icon Naming Specification[2].
--timeout=
Specify the query timeout in seconds. Defaults to 90s.
--no-tty
Never ask for password on current TTY even if one is available. Always use agent system.
--accept-cached
If passed accept cached passwords, i.e. passwords previously typed in.
--multiple
When used in conjunction with --accept-cached accept multiple passwords. This will output one password per line.
EXIT STATUS
On success 0 is returned, a non-zero failure code otherwise.
SEE ALSO
systemd(1), systemctl(1), plymouth(8), wall(1)
AUTHOR
Lennart Poettering <lennart@poettering.net>
Developer
NOTES
1. systemd Password Agent Specification
http://www.freedesktop.org/wiki/Software/systemd/PasswordAgents
2. XDG Icon Naming Specification
http://standards.freedesktop.org/icon-naming-spec/icon-naming-spec-latest.html
systemd 10/07/2013 SYSTEMD-ASK-PASSWO(1)