sql queries

1SELECT  'test1' AS [@class]
2    , ( SELECT  'test2' as [@class]
3        , (SELECT 'Name' FOR XML PATH(''))
4        FOR XML PATH('td'), type)
5    ,(SELECT  'test3' as [@class]
6        , (SELECT 'Value' FOR XML PATH(''))
7        FOR XML PATH('td'), type) 
8FOR XML PATH('tr'), type

1CREATE TABLE friends (
2   id INTEGER,
3   name TEXT,
4   birthday DATE
5);
6
7INSERT INTO friends (id, name, birthday) 
8VALUES (1, 'Jane Doe', '1990-05-30');
9
10
11INSERT INTO friends(id , name , birthday)
12VALUES(2 , 'APOORV' , '2000-2-2');
13
14
15
16UPDATE friends
17SET name = 'Jane Srivastava'
18WHERE id = 1;
19
20ALTER TABLE friends 
21ADD COLUMN email TEXT; 
22
23
24UPDATE friends 
25SET email =  '203029@klsafjls'
26where id  = 1; 
27
28UPDATE friends 
29SET email =  '203029@klsafjls'
30where id  = 2;
31
32DELETE FROM friends 
33WHERE id = 1;
34
35
36SELECT * 
37FROM friends;

1DROP DATABASE db_name;

1$meta_query_args = array(
2    'relation' => 'OR', // Optional, defaults to "AND"
3    array(
4        'key'     => '_my_custom_key',
5        'value'   => 'Value I am looking for',
6        'compare' => '='
7    ),
8    array(
9        'relation' => 'AND',
10        array(
11            'key'     => '_my_custom_key_2',
12            'value'   => 'Value I am looking for 2',
13            'compare' => '='
14        ),
15        array(
16            'key'     => '_my_custom_key_3',
17            'value'   => 'Value I am looking for 3',
18            'compare' => '='
19        )
20    )
21);
22$meta_query = new WP_Meta_Query( $meta_query_args );
23

1Dont use SQL it sucks

1ALTER TABLE table_name ADD column_name datatype;