IF NOT EXISTS( SELECT NULL
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'price'
AND table_schema = 'db_name'
AND column_name = 'pr1') THEN
ALTER TABLE `price` ADD `pr1` tinyint(1) NOT NULL AFTER `pr`;
END IF;SELECT T2.*, T1.OPSOS, T1.REGION
FROM TABLE2 T2
LEFT JOIN TABLE1 T1
ON T1.PREFIX = T2.PREFIX
AND T1.PHONE BETWEEN T2.MIN AND T2.MAX
WHERE T2.SITY = 'Москва'SELECT owner, segment_name, segment_type, block_id
FROM dba_extents
WHERE FILE_ID = <id datafile>
ORDER BY block_id DESC;ALTER TABLESPACE <MyTablespace> DROP DATAFILE 'C:\ORADATA\MYFILE.DBF';alter database datafile 'C:\ORADATA\MYFILE.DBF' resize 2m;
UPDATE lifeusers SET readers = CONCAT(readers, '. ', '$login') WHERE id='$addreader';-- Получишь все записи которые относятся к тесту №1
select * from t1 where question_id = 1;
-- Получишь все записи которые относятся к тесту №2
-- и пользователю с идентификатором 12
select * from t1 where question_id = 2 and user_id = 12;using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Newtonsoft.Json;
using System.IO;
using System.Net;
using System.Runtime.Serialization;
using Newtonsoft.Json.Linq;
namespace load_calendar
{
class Program
{
static void Main(string[] args)
{
string json = File.ReadAllText("calendar.json");
List<Calendar2> calendar = JsonConvert.DeserializeObject<List<Calendar2>>(json);
Console.WriteLine("Февраль:");
foreach (Calendar2 r in calendar)
{
for (int i = 0; i < r.february.Length; i++)
{
Console.WriteLine(r.february[i]);
}
}
Console.ReadKey();
}
public class Calendar2
{
[JsonProperty(PropertyName = "Год/Месяц")]
public string year { get; set; }
public string[] january { get; set; }
public string[] february { get; set; }
//и т.д.
[JsonExtensionData]
private IDictionary<string, JToken> _additionalData;
[OnDeserialized]
private void OnDeserialized(StreamingContext context)
{
string _jan = (string)_additionalData["Январь"];
january = _jan.Split(',');
string _feb = (string)_additionalData["Февраль"];
february = _feb.Split(',');
//и т.д.
}
public Calendar2()
{
_additionalData = new Dictionary<string, JToken>();
}
}
}
}Февраль:
4,
5,
11,
12,
18,
19,
22*,
23,
24,
25,
26SELECT USR1.NAME,
USR1.ID,
C.CNT,
D.EXCNT
FROM USERS USR1
LEFT JOIN (SELECT COUNT (*) AS CNT, OBJ.REALTOR_ID
FROM OBJECTS OBJ
GROUP BY REALTOR_ID) AS C ON USR.ID = C.REALTOR_ID
LEFT JOIN (SELECT COUNT (*) AS EXCNT, OBJ.REALTOR_ID
FROM OBJECTS OBJ WHERE OBJ.EXCLUSIVE = 1
GROUP BY REALTOR_ID) AS D ON USR.ID = D.REALTOR_ID;
WHERE MANAGER_ID IS NULLALTER TABLE `Услуги_предприятий`
ADD CONSTRAINT `<CONSTRAINT_NAME1>` FOREIGN KEY (`org_id`) REFERENCES `Предприятия` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT `<CONSTRAINT_NAME2>` FOREIGN KEY (`service_id`) REFERENCES `Список_услуг` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;UPDATE my_tab2 as t2
JOIN (SELECT a.region,
a.host
FROM ftpup a,
(SELECT info,
type,
timestamp,
max(date) as time
FROM ftpup
GROUP BY type ) b
WHERE a.type = b.type
AND a.date = b.time
AND a.status <> '0' ) AS t1 ON t1.host = t2.host and t1.region = t2.host
SET t2.status = '2'INSERT INTO PAGES (ID, CATEGORY_ID, TITLE) VALUES (4, 3, 'title3');SELECT ID,
CATEGORY_ID,
TITLE
FROM PAGES
WHERE TITLE IN (SELECT TITLE FROM PAGES GROUP BY TITLE HAVING COUNT(*)>1)
GROUP BY TITLE,
CATEGORY_ID
HAVING COUNT(*)=1;