Tue Nov 8, 2011
In 1988 students from the University of Illinois were tasked with imagining the computer of the year 2000. What they came up with was a tablet computer that bears a striking resemblance to the iPad. From the report:
Our machine will have the same dimensions as a standard notebook. It will look like an 8”x11” monolith from the movie 2001, and be reminiscent of the Dynabook. This rectangular slab will weigh but a few pounds, and have no buttons or knobs to play with. The front surface will be a touch-sensitive display screen and will blink to life upon touching two corners.
You can read the full report here.
This report is yet more proof that great ideas do not spontaneously strike like lightening. Rather, a “revolutionary” product is the culmination of decades of research, the overcoming of technological hurdles, and the courage to strike out from the pack. In this case, the tablet PC is a manifestation of a cultural perception of what such a device would look like. It is the moment when the fantastical becomes real. For example, the Star Trek communicator influencing the design of the flip-phone. Oh wait - flip phones are so 20th century.
Source: Paleofuture blog - an awesome blog for viewing the future that never was.


Aston Barclay wins Ogilvie Fleet remarketing contract
by Gareth RobertsAston Barclay has secured a two-year contract extension with Ogilvie Fleet, becoming its remarketing partner until 2021.
The contract will involve some 8,000 used vehicles and their disposal across the Aston Barclay network, including Wakefield, Prees Heath, Donington Park and Westbury.
Ogilvie Fleet celebrates its 40th anniversary this year and has had a long-standing relationship with Aston Barclay, which has remained an independent business since 1984.
The Ogilvie Group – Ogilvie Fleet’s parent company – celebrated its 60th birthday in 2013 and also remains a 100% independently owned business.
“We are looking forward to continuing our relationship with Aston Barclay on the basis they offer a consistently good quality of service across its auction network,” explained Ogilvie’s operations director Jim Hannah.
“Both businesses have a strong cultural fit and Aston Barclay help us optimise residual values on a diverse range of end-of-lease used cars and light vans that come back from our customers each month.”
Martin Potter, Aston Barclay’s auction managing director, added: “Ogilvie Fleet continues to grow its fleet and win awards and we are pleased to contribute to their success as a key partner in their fleet supply chain.”


Microsoft Azure Security Infrastructure
Implement maximum control, security, and compliance processes in Azure cloud environments In Microsoft Azure Security Infrastructure ,1/e three leading experts show how to plan, deploy, and operate Microsoft Azure with outstanding levels of control, security, and compliance. You’ll learn how to prepare infrastructure with Microsoft’s integrated tools, prebuilt templates, and managed services–and use these to help safely build and manage any enterprise, mobile, web, or Internet of Things (IoT) system. The authors guide you through enforcing, managing, and verifying robust security at physical, network, host, application, and data layers. You’ll learn best practices for security-aware deployment, operational management, threat mitigation, and continuous improvement–so you can help protect all your data, make services resilient to attack, and stay in control no matter how your cloud systems evolve.
Yuri Diogenes, Tom Shinder, Debra Shinder
Buy it


Your server is running in AP mode. In order to connect to the Internet, please provide a WiFi Base Station (SSID) to connect to and a host name for your Solar Server. Password can be left blank if your WiFi is open.


dont need resync only remove komodostatefile but I thaught I fixed this in last commit ? @Mylo
your not getting banned by peers but banning them btw (edited)
Mylo27-Apr-19 12:02 PM
oh
damn, i should have been more patient
i can fire up a bunch of servers and build jl777/dev on them and sync to test if you need
i think i have 3 that are synced atm for testing, so can rebuild and restart on those with current chain tip
blackjok3r27-Apr-19 12:03 PM
no the issue is that the notarization folder is still there, and it cant activate the chain,, becuse it thinks its chain tip is notarised higher than what it is....(edited)
but Im sure that I fixed this in the last coimmit
Mylo27-Apr-19 12:04 PM
once synced i can stop it from both nodes and rsync the notarizations dir if you need a guinea pig
@Alright
Since @NutellaLicka pinged everyone to point at the repo, I was confuzzed if everyone pulled it not despite it or not being time(edited)
blackjok3r27-Apr-19 12:05 PM
IO tested the crap out of i, I just dont get how this happend to you
how is 1 > 391440 >?
Mylo27-Apr-19 12:05 PM
Alright27-Apr-19 12:05 PM
there was no update
only to BEER daemon, but it doesn't really matter right now
Mylo27-Apr-19 12:05 PM
i don't htink i had a full sync on that node. was only up to block 500k or something ??shrug??
Alright27-Apr-19 12:05 PM
~3pm UTC we'll change min sigs
Mylo27-Apr-19 12:06 PM
one node i updated everything, the other rebuild and only restarted BEER
blackjok3r27-Apr-19 12:06 PM
maybe I need to add an extra print out there
why did you delete that
Mylo27-Apr-19 12:06 PM
impatient sorry
blackjok3r27-Apr-19 12:06 PM
did you update to the very altest dev in jl777 befoire starting KMD there
that bug exists if a node was improperly shut down
I found it today and fixed right away(edited)
Mylo27-Apr-19 12:07 PM
yes
kmd wasn't running. server was just booted after a day or two off.
did not start kmd.
saw message.
recompiled jl777/dev.
started kmd.
error ht.1
30 mins ago
blackjok3r27-Apr-19 12:08 PM
so it was starting from height of 1
makes 0 difffrence
Mylo27-Apr-19 12:14 PM
ok - well i just realized that's what happened with this test box restart script
pkill -9 is quite rude, metaphilibert said use -15 to be more polite to the process
blackjok3r27-Apr-19 12:16 PM
you need to kill it liek that to make the bug appear
Mylo27-Apr-19 12:16 PM
killed, restarting with pubkey anyway
blackjok3r27-Apr-19 12:16 PM
I discovered it when testing stuff and it segfaulted on me
Mylo27-Apr-19 12:16 PM
ahhh...i've kill -9 this time, i kill -15 before
blackjok3r27-Apr-19 12:16 PM
testnet node also did it when I did a snapshot and moved it to Toyko
Mylo27-Apr-19 12:17 PM
but -9 will likely stuff things up because you're urgently killing it and it might be part-way through something important
blackjok3r27-Apr-19 12:17 PM
exactly
Mylo27-Apr-19 12:17 PM
joizus
blackjok3r27-Apr-19 12:17 PM
thats why I asked you to do it... because ths the cause of the error you posted
Mylo27-Apr-19 12:17 PM
ahhhhh then i can tell you i had a hardware error on teh server
blackjok3r27-Apr-19 12:18 PM
I still dont understand what happened in this case.. like its missing one vairable from the print maybe... going to add it hopefulkly someone encounters it again.
Mylo27-Apr-19 12:19 PM
i can make a script to start kmd; when RPC is ready, kill -9 and loop it if you want and if error, can notify you?
blackjok3r27-Apr-19 12:19 PM
doesnt help
i already did tha manually abvout 20 times, and couldnt get it to do that
after the fix that is
Mylo27-Apr-19 12:20 PM
i can push the power button?
blackjok3r27-Apr-19 12:21 PM
I still dont know how you did it. Im pushing an extra print to the fix, if it happens to anybvody else I hope they give me the print out.
1
Mylo27-Apr-19 12:23 PM
what is the dfference between pindexOldTip->GetHeight() and pindexFork->GetHeight() ?
what is old tip & fork?
(p = pointer, index presumably index of the vector) for lurkers
blackjok3r27-Apr-19 12:26 PM
pindexOldTip->GetHeight() == the height of the chain you are on
pindexFork->GetHeight() == the height that is being reorged to
in the middle of those is a notarized height
1
with the fix you must be over the notarised height and the for must be under it for it to error(edited)
jl777c27-Apr-19 12:27 PM
kill -9 is as bad as the automatic windows wallet corruptor
1
blackjok3r27-Apr-19 12:27 PM
yes very bad... but in this case it is a shortcut to reproduce this error
seem to me that the only way that contition can happen is if you are trying to sync the chain without deleteing the komodostate files
jl777c27-Apr-19 12:34 PM
komodo state is part of the blockchain state, it needs to be deleted when resyncing
Mylo27-Apr-19 12:36 PM
so when i had the hardware error on this box, i don't know what it was doing unforch. it may have been midway through a reorg, then boom - killed. could that set the state into a problem case?
blackjok3r27-Apr-19 12:37 PM
it seems to me the entire bock index corrupted and it started a sync... but didnt delete komodostate (it does delete i automaically for a reindex I think)
maybe on chain init if block == 0 it should delte the file also ?
jl777c27-Apr-19 12:38 PM
yes, maybe it should, block == 1 is probably more sure to be triggered. some parts skip genesis block
1
blackjok3r27-Apr-19 12:39 PM
i'll try to test something for this tomorrow, trying to work on paymetnscc keep getting distracted
jl777c27-Apr-19 12:40 PM
need payments for fully autonomous DAO type things
Mylo27-Apr-19 12:43 PM
just killed (-9) whilst rewinding, restarted. no problem, its syncing.
1
Strob27-Apr-19 01:31 PM
So what should we do now? Can we update komodo, rebuild, restart BEER and at 3pm utc do git pull and m_start_notary?
CrisF27-Apr-19 01:34 PM
Hi, that's what I did, and am waiting for.
Strob27-Apr-19 02:15 PM
I synched komodo, rebuilt it and restarted BEER but when I do getinfo for BEER the notarized hash is still all 0000 is it expected?(edited)
komodo update is not mandatory, and shouldn't affect anything
blackjok3r27-Apr-19 02:34 PM
BEER should show notarized height after update once it sees a notarization
has to see one first though.
Strob27-Apr-19 02:43 PM
ok get it now:
"notarizedhash": "0099cbcb416312216c35d0a36d51612c2ea6666931b901b6857d9a7d8ffcf434",
"notarizedtxid": "5ec5f54648c93f454baeed8f9fae4acdba757c82e1464ecf0a820c148aedb431",
2
Alright27-Apr-19 02:59 PM
@deleted-role please do git pull./m_notary_testnet. We're doing some tests to see if we have network connectivity problems. We increased min sigs to 13. We're going to leave it at 13 for at least 2 or 3 days regardless of performance.
If you haven't updated your BEER node to latest dev branch, make sure you rebuild and restart. You may end up on a fork in the event of a reorg if you do not. Only your BEER node needs to be restarted.
5
18
1
2
NNoperator27-Apr-19 04:17 PM
looks like we still have a group of 7 nodes that are notarizing BEER. We will need at least one of them to update.
What is a reasonable time for updating? 12 hours? 24?
ComputerGenie 👴👴👴27-Apr-19 04:30 PM
87 seconds
1
CrisF27-Apr-19 04:30 PM
That's what I thought!
NNoperator27-Apr-19 04:31 PM
Don't sweat it, I am just being impatient cause I want to see the testnet do a full set of 13. One hour to get updated is very fast (especially on the weekend)
CrisF27-Apr-19 04:32 PM
I'm just wondering what it's like on mainnet. Not worried, haha.
NNoperator27-Apr-19 04:32 PM
Some take days. You want to be earlier so you get bonuses and extra counts.
SHossain27-Apr-19 04:32 PM
the updates should always be carried out at the earliest opportunity on mainnet. sometimes there are critical updates.(edited)
1
CrisF27-Apr-19 04:33 PM
Yeah, I know soon is good. Just curious on what it's like.

CrisF27-Apr-19 04:34 PM
We've had to wait a while sometimes in Labs, but it is usually very fast there.


Volvo and BMW Recall over 500 000 Diesel Cars because of Risk of Fire in the Engine
China's Volvo Cars has announced that it will complete the refurbishment of more than 50,000 diesel vehicles in the coming months to reduce the risk of fire in the engine, DPA reported.
In July, the company announced that some of the components in the engine were at risk of melting, which in the worst case scenario could cause it to ignite. The solution is to install new software and a new cooling system. Consumers have been notified of the necessary upgrades since October, company spokesman told DPA.
According to him, the upgrade covers 54,000 cars in Germany and 86,000 in Sweden. Models with four-cylinder diesel motors manufactured between 2014 and 2019 have been affected.
The Stockholm daily Dagens Nyheter reported that German carmaker BMW will be upgrading about 12,900 diesel cars sold in Sweden for similar reasons.
The German concern said on Thursday that it would retrofit 232,000 diesel vehicles, including 113,000 in Germany, because of a potential fire risk.
In 2010, China's Zhejiang Geely Holding Group bought Volvo Cars from Ford.


Overview
Package
Class
Use
Tree
Deprecated
Index
Help
PREV LETTER
NEXT LETTER
FRAMES
NO FRAMES
All Classes
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X
L
lastConnected
- Variable in class org.apache.tomcat.jdbc.pool.
PooledConnection
The Timestamp when the last time the connect() method was called successfully
lastInvocation
- Variable in class org.apache.tomcat.jdbc.pool.interceptor.
SlowQueryReport.QueryStats
lastRun
- Variable in class org.apache.tomcat.jdbc.pool.
ConnectionPool.PoolCleaner
lastValidated
- Variable in class org.apache.tomcat.jdbc.pool.
PooledConnection
timestamp to keep track of validation intervals
latch
- Variable in class org.apache.tomcat.jdbc.pool.
ConnectionPool.ConnectionFuture
latch
- Variable in class org.apache.tomcat.jdbc.pool.
FairBlockingQueue.ItemFuture
latch
- Variable in class org.apache.tomcat.jdbc.pool.
MultiLockFairBlockingQueue.ItemFuture
listeners
- Variable in class org.apache.tomcat.jdbc.pool.jmx.
ConnectionPool
Listeners that are local and interested in our notifications, no need for JMX
lock
- Variable in class org.apache.tomcat.jdbc.pool.
FairBlockingQueue
Phase one entry lock in order to give out per-thread-locks for the waiting phase we have a phase one lock during the contention period.
lock
- Variable in class org.apache.tomcat.jdbc.pool.
PooledConnection
Lock for this connection only
lock()
- Method in class org.apache.tomcat.jdbc.pool.
PooledConnection
Locks the connection only if either
PoolConfiguration.isPoolSweeperEnabled()
or
PoolConfiguration.getUseLock()
return true.
LOCK_COUNT
- Variable in class org.apache.tomcat.jdbc.pool.
MultiLockFairBlockingQueue
locks
- Variable in class org.apache.tomcat.jdbc.pool.
MultiLockFairBlockingQueue
Phase one entry lock in order to give out per-thread-locks for the waiting phase we have a phase one lock during the contention period.
log
- Static variable in class org.apache.tomcat.jdbc.naming.
GenericNamingResourcesFactory
log
- Static variable in class org.apache.tomcat.jdbc.pool.
ConnectionPool
Logger
log
- Static variable in class org.apache.tomcat.jdbc.pool.
DataSource
log
- Static variable in class org.apache.tomcat.jdbc.pool.
DataSourceFactory
log
- Static variable in class org.apache.tomcat.jdbc.pool.
DataSourceProxy
log
- Static variable in class org.apache.tomcat.jdbc.pool.interceptor.
AbstractQueryReport
log
- Static variable in class org.apache.tomcat.jdbc.pool.interceptor.
ConnectionState
log
- Static variable in class org.apache.tomcat.jdbc.pool.interceptor.
QueryTimeoutInterceptor
log
- Static variable in class org.apache.tomcat.jdbc.pool.interceptor.
SlowQueryReport
log
- Static variable in class org.apache.tomcat.jdbc.pool.interceptor.
SlowQueryReportJmx
log
- Static variable in class org.apache.tomcat.jdbc.pool.interceptor.
StatementFinalizer
log
- Static variable in class org.apache.tomcat.jdbc.pool.jmx.
ConnectionPool
logger
log
- Static variable in class org.apache.tomcat.jdbc.pool.
PooledConnection
Logger
log
- Static variable in class org.apache.tomcat.jdbc.pool.
PoolProperties
logAbandoned
- Variable in class org.apache.tomcat.jdbc.pool.
PoolProperties
logger
- Static variable in class org.apache.tomcat.jdbc.pool.interceptor.
StatementDecoratorInterceptor
logValidationErrors
- Variable in class org.apache.tomcat.jdbc.pool.
PoolProperties
Overview
Package
Class
Use
Tree
Deprecated
Index
Help
PREV LETTER
NEXT LETTER
FRAMES
NO FRAMES
All Classes
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X


Menu bars, tool bars, status bars - these are common examples of special containers found in application windows. These containers create functional grouping of application controls and bring order to complex screens. Substance skinning layer provides a flexible and powerful set of APIs to define the visual appearance of these control groups - called decoration areas. At the same time, Substance decoration painters enforce visual consistency and connections across the components in related areas and states. In addition, Substance provides a set of published APIs for applications that wish to skin custom components and preserve visual consistency with the Swing controls painted by the core Substance UI delegates.
The org.pushingpixels.substance.api.DecorationAreaType
class contains the available core decoration area types. As a picture
is worth a thousand words, the following screenshots illustrate the
different decoration area types.
The following screenshot is the main Substance test application under the Business Black Steel skin (click to see full size version):
The next screenshot shows the title
decoration area,
which in this example includes the title pane of the main window:
The next screenshot shows the header
decoration area,
which in this example includes the menu bar of the main window:
The next screenshot shows the toolbar
decoration area,
which in this example includes the tool bar of the main window:
The next screenshot shows the footer
decoration area,
which in this example includes the status bar component from the
SwingX suite:
The next screenshot shows the general
decoration area,
which in this example includes the task pane container
component from the SwingX suite:
Let's go back to the original screenshot:
It illustrates that the specific skin assigns different color schemes to different decoration areas. The controls in those areas get the background and foreground colors based on their assigned color scheme (without any custom application code), thus creating visual distinction between different application areas.
To use the matching decoration painter in custom painting routines of your application, call the following published Substance APIs:
SubstanceLookAndFeel.getCurrentSkin()
to retrieve the component skin.SubstanceSkin.getDecorationPainter()
to retrieve the decoration painter of the component skin.SubstanceLookAndFeel.getDecorationType()
to retrieve the decoration area type of the component.SubstanceDecorationPainter.paintDecorationArea()
(see below) to paint the decoration background on the specific graphics context.The base class for Substance decoration painters is
org.pushingpixels.substance.api.painter.decoration.SubstanceDecorationPainter
.
The only painting method in this class is:
/**
* Paints the decoration area.
*
* @param graphics
* Graphics context.
* @param comp
* Component.
* @param decorationAreaType
* Decoration area type. Must not be null.
* @param width
* Width.
* @param height
* Height.
* @param skin
* Skin for painting the decoration area.
*/
public void paintDecorationArea(Graphics2D graphics, Component comp,
DecorationAreaType decorationAreaType, int width, int height,
SubstanceSkin skin);
The width
and
height
parameters specify the rectangle to paint (the decoration
painters can only paint rectangular areas), the
skin
specifies the Substance
skin to be used to compute the gradient colors, while
decorationAreaType
indicates the decoration area type.


Disclaimer: Hotkeys may not work if another extension is using the same hotkeys
Visit Goodpods
Options


Find all Developers programs, student opportunities & other resources at one place.
| S.no | Name | About | Link |
|---|---|---|---|
| 1 | Venkat Panchapakesan Memorial Scholarship | Selected students will receive a financial award of 750 USD towards tuition and education related expenses, and will be invited to visit the YouTube headquarters in San Bruno, California, USA. | Link |
| 2 | Google Conference Scholarship | Get travel grant to attend an international Computer Science research conference. | Link |
| 3 | Facebook Fellowship for PhD's | The Facebook Fellowship is a global program designed to encourage and support promising doctoral students who are engaged in innovative and relevant research in areas related to computer science | Link |
| 4 | Facebook Hacker cup | Hacker Cup is Facebook's annual open programming competition. Open to participants around the world. | Link |
| 5 | Bertelsmann Tech Scholarships | Upskill for the thousands of tech-related jobs companies like Bertelsmann are hiring for! | Link |
| 6 | AWS Machine Learning Scholarship Program | Build the skills that are hugely in-demand at businesses preparing for the future of AI. | Link |
| 7 | Coursera Scholarhsips | Scholarships for Learners in India | Link |
| 8 | Educational Outreach scholarship (by Girlscript Foundation) | An Educational Outreach scholarship program by Girlscript Foundation. | Link |
| 9 | PALANTIR SCHOLARSHIPS | Scholarships to support students from communities historically underrepresented in technology. | Link |
| 10 | Ethereum India Fellowship | Ethereum India Fellowship is an 8-week mentor-led program. | Link |


A database is a collection of data that is organized in a manner that facilitates ease of access, as well as efficient management and updating. A database is made up of tables that store relevant information. For example, you would use a database, if you were to create a website like YouTube, which contains a lot of information like videos, usernames, passwords, comments. In this course we will learn how to create and query databases using SQL.
A table stores and displays data in a structured format consisting of columns and rows that are similar to those seen in Excel Spreadsheets. Databases often contain multiple tables, each designed for a specific purpose. For example, imagine creating a database table of names and telephone numbers. First, we would set up columns with the titles: FirstName, LastName, and TelephoneNumber. Each table includes its own set of fields, based on the data it will store. A table has a specified number of columns but can have any number of rows.
A primary Key is a field in the table that uniquely identifies the table records. The primary key’s main features: -It must contain a unique value for each value for each row. -It cannot contain NULL values *NULL- An absence of values* For example, our table contains a record for each name in a phone book. The unique ID number would be a good choice for a primary in the table, as there is always the chance for more than one person to have the same name. Tables are limited to ONE primary key each. The primary keys value must be different for each row.
Once you understand what a database is, understanding SQL is easy. SQL stands for Structured QUery Language. SQL is used to access and manipulate a database. MySQL is a program that understands SQL. SQL can: -insert, updata, or delete records in a database. -create new databases, table stores procedures, views. -retrieve data from a database, etc. SQL is an ANSI (American National Standards Institute) standard, but there are different versions of the SQL language. Most SQL database programs have their own proprietary extensions in addition to the SQL standard, but all of them support the major commands.
The SQL SHOW statements display information contained in the database and its tables. This helpful tool lets you keep track of your database contents and remind yourself about the structure of your tables. For example, the SHOW DATABASES command lists the databases managed by the server.
Throughout the tutorial we will be using the MYSQL engine and the PHPMyAdmin tool to run SQL queries. The easiest way to get MySQL and PHPMyAdmin is to install free tools like XAMPP or WAMP, which include all necessary installers.
The SHOW TABLES command is used to display all of the tables inn the currently selected MySQL database. For our example, we have created a database, my_database, with a table called customers. The SHOW COLUMNS displays information about the columns in a given table. The following example displays the columns in our customers table: SHOW COLUMNS FROM customers SHOW COLUMNS displays the following values for each table column: Field: column name Type: column data type Key: indicates whether the column is indexed Default: default value assigned to the column Extra: may contain any additional information that is available about a given column The columns for the customers table have also been created using the PHPMyAdmin tool.
The SELECT statement is used to select data from a database. The result is stored in a result table, which is called the result- set. A query may retrieve information from selected columns or from all columns in the table. To create a simple SELECT statement, specify the name(s)of the column(s) you need from the table. Syntax of the SQL SELECT Statement: SELECT column_list FROM table_name -column_list includes one or more columns from which data is retrieved -table-name is the name of the table from which the information is retrieved The following SQL statement selects the FIrstName from the customers table: SELECT FirstName FROM customers A SELECT statement retrieves zero or more rows from one more database table.
Multiple Queries SQL allows to run multiple queries or commands at the same time. The following SQL statement selects the FirstName and City columns from the customers table: SELECT FirstName FROM customers; SELECT City FROM customers; Remember to end each SQL statement with a semicolon to indicate that the statement complete and ready to be interpreted.
SQL is case insensitive The following statements are equivalent and will produce the same result: select City from customers; SELECT City FROM customers; sElEct City From customers It is common practice to write all SQL commands in Upper case
A single SQL statement can be placed one or more text lines. In addition multiple SQL statements can be combined on a single text line. White spaces and multiple lines are ignored in SQL. For example, the following query is absolutely correct: SELECT City FROM customers; However it is recommended to avoid unnecessary white spaces and lines. Combined with proper spacing and indenting,breaking up the commands into logical lines will make your SQL statements much easier to read and maintain. As previously mentioned, the SQL SELECT statement retrieves records from tables in your SQL database. You can select multiple table columns at once. Just list the column names, separated by commas: SELECT FirstName, LastName, City FROM customers; Do not put a comma after the last column name.
To retrieve all of the information contained in your table, place an asterisk (*) sign after the SELECT command, rather than typing in each column's names separately. The following SQL statement selects all of the columns in the customers table: SELECT * FROM customers; In SQL, the asterisk means all.
In situations in which you have multiple duplicate records in a table, it might make more sense to return only unique records, instead of fetching the duplicates. The SQL DISTINCT keyword is used in conjunction with SELECT to eliminate all duplicate records and return only unique ones. The basic syntax of DISTINCT is as follows: SELECT DISTINCT column_name1, column_name2 FROM table_name; Note that there are duplicate City names. The following SQL statement selects only distinct values from the City column: SELECT DISTINCT City FROM customers; This would produce the following result. Duplicate entries have been removed. The DISTINCT keyword only fetches the unique values.
By default, all results that satisfy the conditions specified in the SQL statement are returned. However, sometimes we need to retrieve just a subset of records. In MySQL, this is accomplished by using the LIMIT keyword. The syntax for LIMIT is as follows: SELECT column list FROM table_name LIMIT [number of records]; For example, we can retrieve the first five records from the customers table. SELECT ID, FirstName, LastName, City FROM customers LIMIT 5; By default, all results that satisfy the conditions specified in the SQL statement are returned. You can also pick up a set of records from a particular offset. In the following example, we pick up four records, starting from the third position: SELECT ID, FirstName, LastName, City FROM customers LIMIT 3, 4; The reason that it produces results starting from ID number four, and not three, is that MySQL starts counting from zero, meaning that the offset of the first row is 0, not 1.
Fully Qualified Names In SQL, you can provide the table name prior to the column name, by separating them with a dot. The following statements are equivalent: SELECT City FROM customers; SELECT customers. City FROM customers; The term for the above- mentioned syntax is called the “fully qualified name” of that column This form of writing is especially useful when working with multiple tables that may share the same column names.
ORDER BY is used with SELECT to sort the returned data The following example sorts our customers table by the FirstName column SELECT *FROM customers ORDER BY FirstName; By default, the ORDER BY keyword sorts the results in ascending order
ORDER BY can sort retrieved data by multiple columns When using ORDER BY with more than one column, separate the list of columns to follow ORDER BY with commas. To order by LastName and Age: SELECT *FROM customers ORDER BY LastNam, Age; As we have two Smiths, they will be ordered by the Age column in ascending order. The ORDER BY command starts ordering in the same sequence as the columns It will order by the first solemn listed, then by the second and so on.
- All the documentation in this page is taken from MDN


a guide
Neal Caren - University of North Carolina, Chapel Hill mail web twitter scholar
I’m publishing a series of tutorials that teach the fundamentals of quantitative text analysis for social scientists or humanities scholars. The emphasis is on application. How can you collect and analyze thousands of web pages, historical documents or Tweets? What are the best practices for turning words into numbers?
The tutorials are designed for people who may be familiar with a standard statistical program, such as Stata or SPSS, or perhaps a qualitative analysis program like NVivo, but who haven’t done any quantitative text analysis or used Python. Python is an open-source computer language that is quite popular amongst computer programmers. Computational linguistics and computer scientists have developed a large number of add-ons for Python that make it a popular choice for quantitative text analysis.
You can also download most of the pages and code (as IPython notebooks).
Introduction
Data collection
Analysis
Other


Reports any new StringBuffer()
and new StringBuilder() calls with an argument
with type char. Such an argument is silently
casted to an integer used to specify the length of the buffer. Usually this is
not what was intended.
Powered by InspectionGadgets