~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

select fld3,period,price,price2 from t2,t3 where t2.fld1=t3.t2nr and period >= 1001 and period <= 1002 and t2.companynr = 37 order by fld3,period, price;

1229

fld3 period price price2

1230

admonishing 1002 28357832 8723648

1231

analyzable 1002 28357832 8723648

1232

annihilates 1001 5987435 234724

1233

Antares 1002 28357832 8723648

1234

astound 1001 5987435 234724

1235

audiology 1001 5987435 234724

1236

Augustine 1002 28357832 8723648

1237

Baird 1002 28357832 8723648

1238

bewilderingly 1001 5987435 234724

1239

breaking 1001 5987435 234724

1240

Conley 1001 5987435 234724

1241

dentally 1002 28357832 8723648

1242

dissociate 1002 28357832 8723648

1243

elite 1001 5987435 234724

1244

eschew 1001 5987435 234724

1245

Eulerian 1001 5987435 234724

1246

flanking 1001 5987435 234724

1247

foldout 1002 28357832 8723648

1248

funereal 1002 28357832 8723648

1249

galling 1002 28357832 8723648

1250

Graves 1001 5987435 234724

1251

grazing 1001 5987435 234724

1252

groupings 1001 5987435 234724

1253

handgun 1001 5987435 234724

1254

humility 1002 28357832 8723648

1255

impulsive 1002 28357832 8723648

1256

inch 1001 5987435 234724

1257

intelligibility 1001 5987435 234724

1258

jarring 1001 5987435 234724

1259

lawgiver 1001 5987435 234724

1260

lectured 1002 28357832 8723648

1261

Merritt 1002 28357832 8723648

1262

neonatal 1001 5987435 234724

1263

offload 1002 28357832 8723648

1264

parters 1002 28357832 8723648

1265

pityingly 1002 28357832 8723648

1266

puddings 1002 28357832 8723648

1267

Punjab 1001 5987435 234724

1268

quitter 1002 28357832 8723648

1269

realtor 1001 5987435 234724

1270

relaxing 1001 5987435 234724

1271

repetitions 1001 5987435 234724

1272

resumes 1001 5987435 234724

1273

Romans 1002 28357832 8723648

1274

rusting 1001 5987435 234724

1275

scholastics 1001 5987435 234724

1276

skulking 1002 28357832 8723648

1277

stated 1002 28357832 8723648

1278

suites 1002 28357832 8723648

1279

sureties 1001 5987435 234724

1280

testicle 1002 28357832 8723648

1281

tinily 1002 28357832 8723648

1282

tragedies 1001 5987435 234724

1283

trimmings 1001 5987435 234724

1284

vacuuming 1001 5987435 234724

1285

ventilate 1001 5987435 234724

1286

wallet 1001 5987435 234724

1287

Weissmuller 1002 28357832 8723648

1288

Wotan 1002 28357832 8723648

1289

select t2.fld1,fld3,period,price,price2 from t2,t3 where t2.fld1>= 18201 and t2.fld1 <= 18811 and t2.fld1=t3.t2nr and period = 1001 and t2.companynr = 37;

1290

fld1 fld3 period price price2

1291

018201 relaxing 1001 5987435 234724

1292

018601 vacuuming 1001 5987435 234724

1293

018801 inch 1001 5987435 234724

1294

018811 repetitions 1001 5987435 234724

1295

create table t4 (

1296

companynr tinyint(2) unsigned zerofill NOT NULL default '00',

1297

companyname char(30) NOT NULL default '',

1298

PRIMARY KEY (companynr),

1299

UNIQUE KEY companyname(companyname)

1300

) ENGINE=MyISAM MAX_ROWS=50 PACK_KEYS=1 COMMENT='companynames';

1301

select STRAIGHT_JOIN t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr;

1302

companynr companyname

1303

00 Unknown

1304

29 company 1

1305

34 company 2

1306

36 company 3

1307

37 company 4

1308

40 company 5

1309

41 company 6

1310

50 company 11

1311

53 company 7

1312

58 company 8

1313

65 company 9

1314

68 company 10

1315

select SQL_SMALL_RESULT t2.companynr,companyname from t4,t2 where t2.companynr=t4.companynr group by t2.companynr;

1316

companynr companyname

1317

00 Unknown

1318

29 company 1

1319

34 company 2

1320

36 company 3

1321

37 company 4

1322

40 company 5

1323

41 company 6

1324

50 company 11

1325

53 company 7

1326

58 company 8

1327

65 company 9

1328

68 company 10

1329

select * from t1,t1 t12;

1330

Period Varor_period Period Varor_period

1331

9410 9412 9410 9412

1332

select t2.fld1,t22.fld1 from t2,t2 t22 where t2.fld1 >= 250501 and t2.fld1 <= 250505 and t22.fld1 >= 250501 and t22.fld1 <= 250505;

1333

fld1 fld1

1334

250501 250501

1335

250502 250501

1336

250503 250501

1337

250504 250501

1338

250505 250501

1339

250501 250502

1340

250502 250502

1341

250503 250502

1342

250504 250502

1343

250505 250502

1344

250501 250503

1345

250502 250503

1346

250503 250503

1347

250504 250503

1348

250505 250503

1349

250501 250504

1350

250502 250504

1351

250503 250504

1352

250504 250504

1353

250505 250504

1354

250501 250505

1355

250502 250505

1356

250503 250505

1357

250504 250505

1358

250505 250505

1359

insert into t2 (fld1, companynr) values (999999,99);

1360

select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null;

1361

companynr companyname

1362

99 NULL

1363

select count(*) from t2 left join t4 using (companynr) where t4.companynr is not null;

1364

count(*)

1365

1199

1366

explain select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null;

1367

id select_type table type possible_keys key key_len ref rows Extra

1368

1 SIMPLE t2 ALL NULL NULL NULL NULL 1200 NULL

1369

1 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 Using where; Not exists

1370

explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr is null;

1371

id select_type table type possible_keys key key_len ref rows Extra

1372

1 SIMPLE t4 ALL NULL NULL NULL NULL 12 NULL

1373

1 SIMPLE t2 ALL NULL NULL NULL NULL 1200 Using where; Not exists; Using join buffer (Block Nested Loop)

1374

select companynr,companyname from t2 left join t4 using (companynr) where companynr is null;

1375

companynr companyname

1376

select count(*) from t2 left join t4 using (companynr) where companynr is not null;

1377

count(*)

1378

1200

1379

explain select companynr,companyname from t2 left join t4 using (companynr) where companynr is null;

1380

id select_type table type possible_keys key key_len ref rows Extra

1381

1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE

1382

explain select companynr,companyname from t4 left join t2 using (companynr) where companynr is null;

1383

id select_type table type possible_keys key key_len ref rows Extra

1384

1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE

1385

delete from t2 where fld1=999999;

1386

explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0;

1387

id select_type table type possible_keys key key_len ref rows Extra

1388

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where

1389

1 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 NULL

1390

explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0;

1391

id select_type table type possible_keys key key_len ref rows Extra

1392

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where

1393

1 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 NULL

1394

explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 and t4.companynr > 0;

1395

id select_type table type possible_keys key key_len ref rows Extra

1396

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where

1397

1 SIMPLE t4 eq_ref PRIMARY PRIMARY 1 test.t2.companynr 1 NULL

1398

explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0;

1399

id select_type table type possible_keys key key_len ref rows Extra

1400

1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where

1401

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop)

1402

explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0;

1403

id select_type table type possible_keys key key_len ref rows Extra

1404

1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where

1405

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop)

1406

explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 and companynr > 0;

1407

id select_type table type possible_keys key key_len ref rows Extra

1408

1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where

1409

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop)

1410

explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr is null;

1411

id select_type table type possible_keys key key_len ref rows Extra

1412

1 SIMPLE t4 ALL NULL NULL NULL NULL 12 NULL

1413

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop)

1414

explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0 or t4.companynr > 0;

1415

id select_type table type possible_keys key key_len ref rows Extra

1416

1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 NULL

1417

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop)

1418

explain select t2.companynr,companyname from t4 left join t2 using (companynr) where ifnull(t2.companynr,1)>0;

1419

id select_type table type possible_keys key key_len ref rows Extra

1420

1 SIMPLE t4 ALL NULL NULL NULL NULL 12 NULL

1421

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop)

1422

explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr is null;

1423

id select_type table type possible_keys key key_len ref rows Extra

1424

1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where

1425

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop)

1426

explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0 or companynr > 0;

1427

id select_type table type possible_keys key key_len ref rows Extra

1428

1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where

1429

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop)

1430

explain select companynr,companyname from t4 left join t2 using (companynr) where ifnull(companynr,1)>0;

1431

id select_type table type possible_keys key key_len ref rows Extra

1432

1 SIMPLE t4 ALL NULL NULL NULL NULL 12 Using where

1433

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop)

1434

select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;

1435

companynr companynr

1436

37 36

1437

41 40

1438

explain select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;

1439

id select_type table type possible_keys key key_len ref rows Extra

1440

1 SIMPLE t4 index NULL PRIMARY 1 NULL 12 Using index; Using temporary

1441

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (Block Nested Loop)

1442

select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and period = 1008 or t2.fld1 = 38008 and t2.fld1 =t3.t2nr and period = 1008;

1443

fld1 companynr fld3 period

1444

038008 37 reporters 1008

1445

038208 37 Selfridge 1008

1446

select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t2.fld1 = 38208 or t2.fld1 = 38008) and t2.fld1=t3.t2nr and period>=1008 and period<=1009;

1447

fld1 companynr fld3 period

1448

038008 37 reporters 1008

1449

038208 37 Selfridge 1008

1450

select t2.fld1,t2.companynr,fld3,period from t3,t2 where (t3.t2nr = 38208 or t3.t2nr = 38008) and t2.fld1=t3.t2nr and period>=1008 and period<=1009;

1451

fld1 companynr fld3 period

1452

038008 37 reporters 1008

1453

038208 37 Selfridge 1008

1454

select period from t1 where (((period > 0) or period < 10000 or (period = 1900)) and (period=1900 and period <= 1901) or (period=1903 and (period=1903)) and period>=1902) or ((period=1904 or period=1905) or (period=1906 or period>1907)) or (period=1908 and period = 1909);

1455

period

1456

9410

1457

select period from t1 where ((period > 0 and period < 1) or (((period > 0 and period < 100) and (period > 10)) or (period > 10)) or (period > 0 and (period > 5 or period > 6)));

1458

period

1459

9410

1460

select a.fld1 from t2 as a,t2 b where ((a.fld1 = 250501 and a.fld1=b.fld1) or a.fld1=250502 or a.fld1=250503 or (a.fld1=250505 and a.fld1<=b.fld1 and b.fld1>=a.fld1)) and a.fld1=b.fld1;

1461

fld1

1462

250501

1463

250502

1464

250503

1465

250505

1466

select fld1 from t2 where fld1 in (250502,98005,98006,250503,250605,250606) and fld1 >=250502 and fld1 not in (250605,250606);

1467

fld1

1468

250502

1469

250503

1470

select fld1 from t2 where fld1 between 250502 and 250504;

1471

fld1

1472

250502

1473

250503

1474

250504

1475

select fld3 from t2 where (((fld3 like "_%L%" ) or (fld3 like "%ok%")) and ( fld3 like "L%" or fld3 like "G%")) and fld3 like "L%" ;

1476

fld3

1477

label

1478

labeled

1479

labeled

1480

landslide

1481

laterally

1482

leaflet

1483

lewdly

1484

Lillian

1485

luckily

1486

select count(*) from t1;

1487

count(*)

1488

1489

select companynr,count(*),sum(fld1) from t2 group by companynr;

1490

companynr count(*) sum(fld1)

1491

00 82 10355753

1492

29 95 14473298

1493

34 70 17788966

1494

36 215 22786296

1495

37 588 83602098

1496

40 37 6618386

1497

41 52 12816335

1498

50 11 1595438

1499

53 4 793210

1500

58 23 2254293

1501

65 10 2284055

1502

68 12 3097288

1503

select companynr,count(*) from t2 group by companynr order by companynr desc limit 5;

1504

companynr count(*)

1505

68 12

1506

65 10

1507

58 23

1508

53 4

1509

50 11

1510

select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>"";

1511

count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1) variance(fld1)

1512

70 absentee vest 17788966 254128.0857 3272.5939722090234 10709871.306938833

1513

explain extended select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>"";

1514

id select_type table type possible_keys key key_len ref rows filtered Extra

1515

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 100.00 Using where

1516

Warnings:

1517

Note 1003 /* select#1 */ select count(0) AS `count(*)`,min(`test`.`t2`.`fld4`) AS `min(fld4)`,max(`test`.`t2`.`fld4`) AS `max(fld4)`,sum(`test`.`t2`.`fld1`) AS `sum(fld1)`,avg(`test`.`t2`.`fld1`) AS `avg(fld1)`,std(`test`.`t2`.`fld1`) AS `std(fld1)`,variance(`test`.`t2`.`fld1`) AS `variance(fld1)` from `test`.`t2` where ((`test`.`t2`.`companynr` = 34) and (`test`.`t2`.`fld4` <> ''))

1518

select companynr,count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 group by companynr limit 3;

1519

companynr count(*) min(fld4) max(fld4) sum(fld1) avg(fld1) std(fld1) variance(fld1)

1520

00 82 Anthony windmills 10355753 126289.6707 115550.97568479746 13352027981.708656

1521

29 95 abut wetness 14473298 152350.5053 8368.547956641249 70032594.90260443

1522

34 70 absentee vest 17788966 254128.0857 3272.5939722090234 10709871.306938833

1523

select companynr,t2nr,count(price),sum(price),min(price),max(price),avg(price) from t3 where companynr = 37 group by companynr,t2nr limit 10;

1524

companynr t2nr count(price) sum(price) min(price) max(price) avg(price)

1525

37 1 1 5987435 5987435 5987435 5987435.0000

1526

37 2 1 28357832 28357832 28357832 28357832.0000

1527

37 3 1 39654943 39654943 39654943 39654943.0000

1528

37 11 1 5987435 5987435 5987435 5987435.0000

1529

37 12 1 28357832 28357832 28357832 28357832.0000

1530

37 13 1 39654943 39654943 39654943 39654943.0000

1531

37 21 1 5987435 5987435 5987435 5987435.0000

1532

37 22 1 28357832 28357832 28357832 28357832.0000

1533

37 23 1 39654943 39654943 39654943 39654943.0000

1534

37 31 1 5987435 5987435 5987435 5987435.0000

1535

select /*! SQL_SMALL_RESULT */ companynr,t2nr,count(price),sum(price),min(price),max(price),avg(price) from t3 where companynr = 37 group by companynr,t2nr limit 10;

1536

companynr t2nr count(price) sum(price) min(price) max(price) avg(price)

1537

37 1 1 5987435 5987435 5987435 5987435.0000

1538

37 2 1 28357832 28357832 28357832 28357832.0000

1539

37 3 1 39654943 39654943 39654943 39654943.0000

1540

37 11 1 5987435 5987435 5987435 5987435.0000

1541

37 12 1 28357832 28357832 28357832 28357832.0000

1542

37 13 1 39654943 39654943 39654943 39654943.0000

1543

37 21 1 5987435 5987435 5987435 5987435.0000

1544

37 22 1 28357832 28357832 28357832 28357832.0000

1545

37 23 1 39654943 39654943 39654943 39654943.0000

1546

37 31 1 5987435 5987435 5987435 5987435.0000

1547

select companynr,count(price),sum(price),min(price),max(price),avg(price) from t3 group by companynr ;

1548

companynr count(price) sum(price) min(price) max(price) avg(price)

1549

37 12543 309394878010 5987435 39654943 24666736.6667

1550

78 8362 414611089292 726498 98439034 49582766.0000

1551

101 4181 3489454238 834598 834598 834598.0000

1552

154 4181 4112197254950 983543950 983543950 983543950.0000

1553

311 4181 979599938 234298 234298 234298.0000

1554

447 4181 9929180954 2374834 2374834 2374834.0000

1555

512 4181 3288532102 786542 786542 786542.0000

1556

select distinct mod(companynr,10) from t4 group by companynr;

1557

mod(companynr,10)

1558

1559

1560

1561

1562

1563

1564

1565

1566

1567

select distinct 1 from t4 group by companynr;

1568

1569

1570

select count(distinct fld1) from t2;

1571

count(distinct fld1)

1572

1199

1573

select companynr,count(distinct fld1) from t2 group by companynr;

1574

companynr count(distinct fld1)

1575

00 82

1576

29 95

1577

34 70

1578

36 215

1579

37 588

1580

40 37

1581

41 52

1582

50 11

1583

53 4

1584

58 23

1585

65 10

1586

68 12

1587

select companynr,count(*) from t2 group by companynr;

1588

companynr count(*)

1589

00 82

1590

29 95

1591

34 70

1592

36 215

1593

37 588

1594

40 37

1595

41 52

1596

50 11

1597

53 4

1598

58 23

1599

65 10

1600

68 12

1601

select companynr,count(distinct concat(fld1,repeat(65,1000))) from t2 group by companynr;

1602

companynr count(distinct concat(fld1,repeat(65,1000)))

1603

00 82

1604

29 95

1605

34 70

1606

36 215

1607

37 588

1608

40 37

1609

41 52

1610

50 11

1611

53 4

1612

58 23

1613

65 10

1614

68 12

1615

select companynr,count(distinct concat(fld1,repeat(65,200))) from t2 group by companynr;

1616

companynr count(distinct concat(fld1,repeat(65,200)))

1617

00 82

1618

29 95

1619

34 70

1620

36 215

1621

37 588

1622

40 37

1623

41 52

1624

50 11

1625

53 4

1626

58 23

1627

65 10

1628

68 12

1629

select companynr,count(distinct floor(fld1/100)) from t2 group by companynr;

1630

companynr count(distinct floor(fld1/100))

1631

00 47

1632

29 35

1633

34 14

1634

36 69

1635

37 108

1636

40 16

1637

41 11

1638

50 9

1639

53 1

1640

58 1

1641

65 1

1642

68 1

1643

select companynr,count(distinct concat(repeat(65,1000),floor(fld1/100))) from t2 group by companynr;

1644

companynr count(distinct concat(repeat(65,1000),floor(fld1/100)))

1645

00 47

1646

29 35

1647

34 14

1648

36 69

1649

37 108

1650

40 16

1651

41 11

1652

50 9

1653

53 1

1654

58 1

1655

65 1

1656

68 1

1657

select sum(fld1),fld3 from t2 where fld3="Romans" group by fld1 limit 10;

1658

sum(fld1) fld3

1659

11402 Romans

1660

select name,count(*) from t3 where name='cloakroom' group by name;

1661

name count(*)

1662

cloakroom 4181

1663

select name,count(*) from t3 where name='cloakroom' and price>10 group by name;

1664

name count(*)

1665

cloakroom 4181

1666

select count(*) from t3 where name='cloakroom' and price2=823742;

1667

count(*)

1668

4181

1669

select name,count(*) from t3 where name='cloakroom' and price2=823742 group by name;

1670

name count(*)

1671

cloakroom 4181

1672

select name,count(*) from t3 where name >= "extramarital" and price <= 39654943 group by name;

1673

name count(*)

1674

extramarital 4181

1675

gazer 4181

1676

gems 4181

1677

Iranizes 4181

1678

spates 4181

1679

tucked 4181

1680

violinist 4181

1681

select t2.fld3,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name;

1682

fld3 count(*)

1683

spates 4181

1684

select companynr|0,companyname from t4 group by 1;

1685

companynr|0 companyname

1686

0 Unknown

1687

29 company 1

1688

34 company 2

1689

36 company 3

1690

37 company 4

1691

40 company 5

1692

41 company 6

1693

50 company 11

1694

53 company 7

1695

58 company 8

1696

65 company 9

1697

68 company 10

1698

select t2.companynr,companyname,count(*) from t2,t4 where t2.companynr=t4.companynr group by t2.companynr order by companyname;

1699

companynr companyname count(*)

1700

29 company 1 95

1701

68 company 10 12

1702

50 company 11 11

1703

34 company 2 70

1704

36 company 3 215

1705

37 company 4 588

1706

40 company 5 37

1707

41 company 6 52

1708

53 company 7 4

1709

58 company 8 23

1710

65 company 9 10

1711

00 Unknown 82

1712

select t2.fld1,count(*) from t2,t3 where t2.fld1=158402 and t3.name=t2.fld3 group by t3.name;

1713

fld1 count(*)

1714

158402 4181

1715

select sum(Period)/count(*) from t1;

1716

sum(Period)/count(*)

1717

9410.0000

1718

select companynr,count(price) as "count",sum(price) as "sum" ,abs(sum(price)/count(price)-avg(price)) as "diff",(0+count(price))*companynr as func from t3 group by companynr;

1719

companynr count sum diff func

1720

37 12543 309394878010 0.0000 464091

1721

78 8362 414611089292 0.0000 652236

1722

101 4181 3489454238 0.0000 422281

1723

154 4181 4112197254950 0.0000 643874

1724

311 4181 979599938 0.0000 1300291

1725

447 4181 9929180954 0.0000 1868907

1726

512 4181 3288532102 0.0000 2140672

1727

select companynr,sum(price)/count(price) as avg from t3 group by companynr having avg > 70000000 order by avg;

1728

companynr avg

1729

154 983543950.0000

1730

select companynr,count(*) from t2 group by companynr order by 2 desc;

1731

companynr count(*)

1732

37 588

1733

36 215

1734

29 95

1735

00 82

1736

34 70

1737

41 52

1738

40 37

1739

58 23

1740

68 12

1741

50 11

1742

65 10

1743

53 4

1744

select companynr,count(*) from t2 where companynr > 40 group by companynr order by 2 desc;

1745

companynr count(*)

1746

41 52

1747

58 23

1748

68 12

1749

50 11

1750

65 10

1751

53 4

1752

select t2.fld4,t2.fld1,count(price),sum(price),min(price),max(price),avg(price) from t3,t2 where t3.companynr = 37 and t2.fld1 = t3.t2nr group by fld1,t2.fld4;

1753

fld4 fld1 count(price) sum(price) min(price) max(price) avg(price)

1754

teethe 000001 1 5987435 5987435 5987435 5987435.0000

1755

dreaded 011401 1 5987435 5987435 5987435 5987435.0000

1756

scholastics 011402 1 28357832 28357832 28357832 28357832.0000

1757

audiology 011403 1 39654943 39654943 39654943 39654943.0000

1758

wallet 011501 1 5987435 5987435 5987435 5987435.0000

1759

parters 011701 1 5987435 5987435 5987435 5987435.0000

1760

eschew 011702 1 28357832 28357832 28357832 28357832.0000

1761

quitter 011703 1 39654943 39654943 39654943 39654943.0000

1762

neat 012001 1 5987435 5987435 5987435 5987435.0000

1763

Steinberg 012003 1 39654943 39654943 39654943 39654943.0000

1764

balled 012301 1 5987435 5987435 5987435 5987435.0000

1765

persist 012302 1 28357832 28357832 28357832 28357832.0000

1766

attainments 012303 1 39654943 39654943 39654943 39654943.0000

1767

capably 012501 1 5987435 5987435 5987435 5987435.0000

1768

impulsive 012602 1 28357832 28357832 28357832 28357832.0000

1769

starlet 012603 1 39654943 39654943 39654943 39654943.0000

1770

featherweight 012701 1 5987435 5987435 5987435 5987435.0000

1771

pessimist 012702 1 28357832 28357832 28357832 28357832.0000

1772

daughter 012703 1 39654943 39654943 39654943 39654943.0000

1773

lawgiver 013601 1 5987435 5987435 5987435 5987435.0000

1774

stated 013602 1 28357832 28357832 28357832 28357832.0000

1775

readable 013603 1 39654943 39654943 39654943 39654943.0000

1776

testicle 013801 1 5987435 5987435 5987435 5987435.0000

1777

Parsifal 013802 1 28357832 28357832 28357832 28357832.0000

1778

leavings 013803 1 39654943 39654943 39654943 39654943.0000

1779

squeaking 013901 1 5987435 5987435 5987435 5987435.0000

1780

contrasted 016001 1 5987435 5987435 5987435 5987435.0000

1781

leftover 016201 1 5987435 5987435 5987435 5987435.0000

1782

whiteners 016202 1 28357832 28357832 28357832 28357832.0000

1783

erases 016301 1 5987435 5987435 5987435 5987435.0000

1784

Punjab 016302 1 28357832 28357832 28357832 28357832.0000

1785

Merritt 016303 1 39654943 39654943 39654943 39654943.0000

1786

sweetish 018001 1 5987435 5987435 5987435 5987435.0000

1787

dogging 018002 1 28357832 28357832 28357832 28357832.0000

1788

scornfully 018003 1 39654943 39654943 39654943 39654943.0000

1789

fetters 018012 1 28357832 28357832 28357832 28357832.0000

1790

bivalves 018013 1 39654943 39654943 39654943 39654943.0000

1791

skulking 018021 1 5987435 5987435 5987435 5987435.0000

1792

flint 018022 1 28357832 28357832 28357832 28357832.0000

1793

flopping 018023 1 39654943 39654943 39654943 39654943.0000

1794

Judas 018032 1 28357832 28357832 28357832 28357832.0000

1795

vacuuming 018033 1 39654943 39654943 39654943 39654943.0000

1796

medical 018041 1 5987435 5987435 5987435 5987435.0000

1797

bloodbath 018042 1 28357832 28357832 28357832 28357832.0000

1798

subschema 018043 1 39654943 39654943 39654943 39654943.0000

1799

interdependent 018051 1 5987435 5987435 5987435 5987435.0000

1800

Graves 018052 1 28357832 28357832 28357832 28357832.0000

1801

neonatal 018053 1 39654943 39654943 39654943 39654943.0000

1802

sorters 018061 1 5987435 5987435 5987435 5987435.0000

1803

epistle 018062 1 28357832 28357832 28357832 28357832.0000

1804

Conley 018101 1 5987435 5987435 5987435 5987435.0000

1805

lectured 018102 1 28357832 28357832 28357832 28357832.0000

1806

Abraham 018103 1 39654943 39654943 39654943 39654943.0000

1807

cage 018201 1 5987435 5987435 5987435 5987435.0000

1808

hushes 018202 1 28357832 28357832 28357832 28357832.0000

1809

Simla 018402 1 28357832 28357832 28357832 28357832.0000

1810

reporters 018403 1 39654943 39654943 39654943 39654943.0000

1811

coexist 018601 1 5987435 5987435 5987435 5987435.0000

1812

Beebe 018602 1 28357832 28357832 28357832 28357832.0000

1813

Taoism 018603 1 39654943 39654943 39654943 39654943.0000

1814

Connally 018801 1 5987435 5987435 5987435 5987435.0000

1815

fetched 018802 1 28357832 28357832 28357832 28357832.0000

1816

checkpoints 018803 1 39654943 39654943 39654943 39654943.0000

1817

gritty 018811 1 5987435 5987435 5987435 5987435.0000

1818

firearm 018812 1 28357832 28357832 28357832 28357832.0000

1819

minima 019101 1 5987435 5987435 5987435 5987435.0000

1820

Selfridge 019102 1 28357832 28357832 28357832 28357832.0000

1821

disable 019103 1 39654943 39654943 39654943 39654943.0000

1822

witchcraft 019201 1 5987435 5987435 5987435 5987435.0000

1823

betroth 030501 1 5987435 5987435 5987435 5987435.0000

1824

Manhattanize 030502 1 28357832 28357832 28357832 28357832.0000

1825

imprint 030503 1 39654943 39654943 39654943 39654943.0000

1826

swelling 031901 1 5987435 5987435 5987435 5987435.0000

1827

interrelationships 036001 1 5987435 5987435 5987435 5987435.0000

1828

riser 036002 1 28357832 28357832 28357832 28357832.0000

1829

bee 038001 1 5987435 5987435 5987435 5987435.0000

1830

kanji 038002 1 28357832 28357832 28357832 28357832.0000

1831

dental 038003 1 39654943 39654943 39654943 39654943.0000

1832

railway 038011 1 5987435 5987435 5987435 5987435.0000

1833

validate 038012 1 28357832 28357832 28357832 28357832.0000

1834

normalizes 038013 1 39654943 39654943 39654943 39654943.0000

1835

Kline 038101 1 5987435 5987435 5987435 5987435.0000

1836

Anatole 038102 1 28357832 28357832 28357832 28357832.0000

1837

partridges 038103 1 39654943 39654943 39654943 39654943.0000

1838

recruited 038201 1 5987435 5987435 5987435 5987435.0000

1839

dimensions 038202 1 28357832 28357832 28357832 28357832.0000

1840

Chicana 038203 1 39654943 39654943 39654943 39654943.0000

1841

select t3.companynr,fld3,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 group by companynr,fld3;

1842

companynr fld3 sum(price)

1843

512 boat 786542

1844

512 capably 786542

1845

512 cupboard 786542

1846

512 decliner 786542

1847

512 descendants 786542

1848

512 dopers 786542

1849

512 erases 786542

1850

512 Micronesia 786542

1851

512 Miles 786542

1852

512 skies 786542

1853

select t2.companynr,count(*),min(fld3),max(fld3),sum(price),avg(price) from t2,t3 where t3.companynr >= 30 and t3.companynr <= 58 and t3.t2nr = t2.fld1 and 1+1=2 group by t2.companynr;

1854

companynr count(*) min(fld3) max(fld3) sum(price) avg(price)

1855

00 1 Omaha Omaha 5987435 5987435.0000

1856

36 1 dubbed dubbed 28357832 28357832.0000

1857

37 83 Abraham Wotan 1908978016 22999735.1325

1858

50 2 scribbled tapestry 68012775 34006387.5000

1859

select t3.companynr+0,t3.t2nr,fld3,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 37 group by 1,t3.t2nr,fld3,fld3,fld3,fld3,fld3 order by fld1;

1860

t3.companynr+0 t2nr fld3 sum(price)

1861

37 1 Omaha 5987435

1862

37 11401 breaking 5987435

1863

37 11402 Romans 28357832

1864

37 11403 intercepted 39654943

1865

37 11501 bewilderingly 5987435

1866

37 11701 astound 5987435

1867

37 11702 admonishing 28357832

1868

37 11703 sumac 39654943

1869

37 12001 flanking 5987435

1870

37 12003 combed 39654943

1871

37 12301 Eulerian 5987435

1872

37 12302 dubbed 28357832

1873

37 12303 Kane 39654943

1874

37 12501 annihilates 5987435

1875

37 12602 Wotan 28357832

1876

37 12603 snatching 39654943

1877

37 12701 grazing 5987435

1878

37 12702 Baird 28357832

1879

37 12703 celery 39654943

1880

37 13601 handgun 5987435

1881

37 13602 foldout 28357832

1882

37 13603 mystic 39654943

1883

37 13801 intelligibility 5987435

1884

37 13802 Augustine 28357832

1885

37 13803 teethe 39654943

1886

37 13901 scholastics 5987435

1887

37 16001 audiology 5987435

1888

37 16201 wallet 5987435

1889

37 16202 parters 28357832

1890

37 16301 eschew 5987435

1891

37 16302 quitter 28357832

1892

37 16303 neat 39654943

1893

37 18001 jarring 5987435

1894

37 18002 tinily 28357832

1895

37 18003 balled 39654943

1896

37 18012 impulsive 28357832

1897

37 18013 starlet 39654943

1898

37 18021 lawgiver 5987435

1899

37 18022 stated 28357832

1900

37 18023 readable 39654943

1901

37 18032 testicle 28357832

1902

37 18033 Parsifal 39654943

1903

37 18041 Punjab 5987435

1904

37 18042 Merritt 28357832

1905

37 18043 Quixotism 39654943

1906

37 18051 sureties 5987435

1907

37 18052 puddings 28357832

1908

37 18053 tapestry 39654943

1909

37 18061 trimmings 5987435

1910

37 18062 humility 28357832

1911

37 18101 tragedies 5987435

1912

37 18102 skulking 28357832

1913

37 18103 flint 39654943

1914

37 18201 relaxing 5987435

1915

37 18202 offload 28357832

1916

37 18402 suites 28357832

1917

37 18403 lists 39654943

1918

37 18601 vacuuming 5987435

1919

37 18602 dentally 28357832

1920

37 18603 humanness 39654943

1921

37 18801 inch 5987435

1922

37 18802 Weissmuller 28357832

1923

37 18803 irresponsibly 39654943

1924

37 18811 repetitions 5987435

1925

37 18812 Antares 28357832

1926

37 19101 ventilate 5987435

1927

37 19102 pityingly 28357832

1928

37 19103 interdependent 39654943

1929

37 19201 Graves 5987435

1930

37 30501 neonatal 5987435

1931

37 30502 scribbled 28357832

1932

37 30503 chafe 39654943

1933

37 31901 realtor 5987435

1934

37 36001 elite 5987435

1935

37 36002 funereal 28357832

1936

37 38001 Conley 5987435

1937

37 38002 lectured 28357832

1938

37 38003 Abraham 39654943

1939

37 38011 groupings 5987435

1940

37 38012 dissociate 28357832

1941

37 38013 coexist 39654943

1942

37 38101 rusting 5987435

1943

37 38102 galling 28357832

1944

37 38103 obliterates 39654943

1945

37 38201 resumes 5987435

1946

37 38202 analyzable 28357832

1947

37 38203 terminator 39654943

1948

select sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 and t3.t2nr = 38008 and t2.fld1 = 38008 or t2.fld1= t3.t2nr and t3.t2nr = 38008 and t2.fld1 = 38008;

1949

sum(price)

1950

234298

1951

select t2.fld1,sum(price) from t3,t2 where t2.fld1 = t3.t2nr and t3.companynr = 512 and t3.t2nr = 38008 and t2.fld1 = 38008 or t2.fld1 = t3.t2nr and t3.t2nr = 38008 and t2.fld1 = 38008 or t3.t2nr = t2.fld1 and t2.fld1 = 38008 group by t2.fld1;

1952

fld1 sum(price)

1953

038008 234298

1954

explain select fld3 from t2 where 1>2 or 2>3;

1955

id select_type table type possible_keys key key_len ref rows Extra

1956

1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE

1957

explain select fld3 from t2 where fld1=fld1;

1958

id select_type table type possible_keys key key_len ref rows Extra

1959

1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 NULL

1960

select companynr,fld1 from t2 HAVING fld1=250501 or fld1=250502;

1961

companynr fld1

1962

34 250501

1963

34 250502

1964

select companynr,fld1 from t2 WHERE fld1>=250501 HAVING fld1<=250502;

1965

companynr fld1

1966

34 250501

1967

34 250502

1968

select companynr,count(*) as count,sum(fld1) as sum from t2 group by companynr having count > 40 and sum/count >= 120000;

1969

companynr count sum

1970

00 82 10355753

1971

29 95 14473298

1972

34 70 17788966

1973

37 588 83602098

1974

41 52 12816335

1975

select companynr from t2 group by companynr having count(*) > 40 and sum(fld1)/count(*) >= 120000 ;

1976

companynr

1977

1978

1979

1980

1981

1982

select t2.companynr,companyname,count(*) from t2,t4 where t2.companynr=t4.companynr group by companyname having t2.companynr >= 40;

1983

companynr companyname count(*)

1984

68 company 10 12

1985

50 company 11 11

1986

40 company 5 37

1987

41 company 6 52

1988

53 company 7 4

1989

58 company 8 23

1990

65 company 9 10

1991

select count(*) from t2;

1992

count(*)

1993

1199

1994

select count(*) from t2 where fld1 < 098024;

1995

count(*)

1996

387

1997

select min(fld1) from t2 where fld1>= 098024;

1998

min(fld1)

1999

98024

2000

select max(fld1) from t2 where fld1>= 098024;

2001

max(fld1)

2002

1232609

2003

select count(*) from t3 where price2=76234234;

2004

count(*)

2005

4181

2006

select count(*) from t3 where companynr=512 and price2=76234234;

2007

count(*)

2008

4181

2009

explain select min(fld1),max(fld1),count(*) from t2;

2010

id select_type table type possible_keys key key_len ref rows Extra

2011

1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Select tables optimized away

2012

select min(fld1),max(fld1),count(*) from t2;

2013

min(fld1) max(fld1) count(*)

2014

0 1232609 1199

2015

select min(t2nr),max(t2nr) from t3 where t2nr=2115 and price2=823742;

2016

min(t2nr) max(t2nr)

2017

2115 2115

2018

select count(*),min(t2nr),max(t2nr) from t3 where name='spates' and companynr=78;

2019

count(*) min(t2nr) max(t2nr)

2020

4181 4 41804

2021

select t2nr,count(*) from t3 where name='gems' group by t2nr limit 20;

2022

t2nr count(*)

2023

9 1

2024

19 1

2025

29 1

2026

39 1

2027

49 1

2028

59 1

2029

69 1

2030

79 1

2031

89 1

2032

99 1

2033

109 1

2034

119 1

2035

129 1

2036

139 1

2037

149 1

2038

159 1

2039

169 1

2040

179 1

2041

189 1

2042

199 1

2043

select max(t2nr) from t3 where price=983543950;

2044

max(t2nr)

2045

41807

2046

select t1.period from t3 = t1 limit 1;

2047

period

2048

1001

2049

select t1.period from t1 as t1 limit 1;

2050

period

2051

9410

2052

select t1.period as "Nuvarande period" from t1 as t1 limit 1;

2053

Nuvarande period

2054

9410

2055

select period as ok_period from t1 limit 1;

2056

ok_period

2057

9410

2058

select period as ok_period from t1 group by ok_period limit 1;

2059

ok_period

2060

9410

2061

select 1+1 as summa from t1 group by summa limit 1;

2062

summa

2063

2064

select period as "Nuvarande period" from t1 group by "Nuvarande period" limit 1;

2065

Nuvarande period

2066

9410

2067

show tables;

2068

Tables_in_test

2069

2070

2071

2072

2073

show tables from test like "s%";

2074

Tables_in_test (s%)

2075

show tables from test like "t?";

2076

Tables_in_test (t?)

2077

show full columns from t2;

2078

Field Type Collation Null Key Default Extra Privileges Comment

2079

auto int(11) NULL NO PRI NULL auto_increment #

2080

fld1 int(6) unsigned zerofill NULL NO UNI 000000 #

2081

companynr tinyint(2) unsigned zerofill NULL NO 00 #

2082

fld3 char(30) latin1_swedish_ci NO MUL #

2083

fld4 char(35) latin1_swedish_ci NO #

2084

fld5 char(35) latin1_swedish_ci NO #

2085

fld6 char(4) latin1_swedish_ci NO #

2086

show full columns from t2 from test like 'f%';

2087

Field Type Collation Null Key Default Extra Privileges Comment

2088

fld1 int(6) unsigned zerofill NULL NO UNI 000000 #

2089

fld3 char(30) latin1_swedish_ci NO MUL #

2090

fld4 char(35) latin1_swedish_ci NO #

2091

fld5 char(35) latin1_swedish_ci NO #

2092

fld6 char(4) latin1_swedish_ci NO #

2093

show full columns from t2 from test like 's%';

2094

Field Type Collation Null Key Default Extra Privileges Comment

2095

show keys from t2;

2096

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment

2097

t2 0 PRIMARY 1 auto A 1199 NULL NULL BTREE

2098

t2 0 fld1 1 fld1 A 1199 NULL NULL BTREE

2099

t2 1 fld3 1 fld3 A NULL NULL NULL BTREE

2100

drop table t4, t3, t2, t1;

2101

CREATE TABLE t1 (

2102

cont_nr int(11) NOT NULL auto_increment,

2103

ver_nr int(11) NOT NULL default '0',

2104

aufnr int(11) NOT NULL default '0',

2105

username varchar(50) NOT NULL default '',

2106

hdl_nr int(11) NOT NULL default '0',

2107

eintrag date NOT NULL default '0000-00-00',

2108

st_klasse varchar(40) NOT NULL default '',

2109

st_wert varchar(40) NOT NULL default '',

2110

st_zusatz varchar(40) NOT NULL default '',

2111

st_bemerkung varchar(255) NOT NULL default '',

2112

kunden_art varchar(40) NOT NULL default '',

2113

mcbs_knr int(11) default NULL,

2114

mcbs_aufnr int(11) NOT NULL default '0',

2115

schufa_status char(1) default '?',

2116

bemerkung text,

2117

wirknetz text,

2118

wf_igz int(11) NOT NULL default '0',

2119

tarifcode varchar(80) default NULL,

2120

recycle char(1) default NULL,

2121

sim varchar(30) default NULL,

2122

mcbs_tpl varchar(30) default NULL,

2123

emp_nr int(11) NOT NULL default '0',

2124

laufzeit int(11) default NULL,

2125

hdl_name varchar(30) default NULL,

2126

prov_hdl_nr int(11) NOT NULL default '0',

2127

auto_wirknetz varchar(50) default NULL,

2128

auto_billing varchar(50) default NULL,

2129

touch timestamp NOT NULL,

2130

kategorie varchar(50) default NULL,

2131

kundentyp varchar(20) NOT NULL default '',

2132

sammel_rech_msisdn varchar(30) NOT NULL default '',

2133

p_nr varchar(9) NOT NULL default '',

2134

suffix char(3) NOT NULL default '',

2135

PRIMARY KEY (cont_nr),

2136

KEY idx_aufnr(aufnr),

2137

KEY idx_hdl_nr(hdl_nr),

2138

KEY idx_st_klasse(st_klasse),

2139

KEY ver_nr(ver_nr),

2140

KEY eintrag_idx(eintrag),

2141

KEY emp_nr_idx(emp_nr),

2142

KEY wf_igz(wf_igz),

2143

KEY touch(touch),

2144

KEY hdl_tag(eintrag,hdl_nr),

2145

KEY prov_hdl_nr(prov_hdl_nr),

2146

KEY mcbs_aufnr(mcbs_aufnr),

2147

KEY kundentyp(kundentyp),

2148

KEY p_nr(p_nr,suffix)

2149

) ENGINE=MyISAM;

2150

INSERT INTO t1 VALUES (3359356,405,3359356,'Mustermann Musterfrau',52500,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1485525,2122316,'+','','N',1909160,'MobilComSuper92000D2',NULL,NULL,'MS9ND2',3,24,'MobilCom Shop Koeln',52500,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

2151

INSERT INTO t1 VALUES (3359357,468,3359357,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1503580,2139699,'+','','P',1909171,'MobilComSuper9D1T10SFreisprech(Akquise)',NULL,NULL,'MS9NS1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

2152

INSERT INTO t1 VALUES (3359358,407,3359358,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1501358,2137473,'N','','N',1909159,'MobilComSuper92000D2',NULL,NULL,'MS9ND2',325,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

2153

INSERT INTO t1 VALUES (3359359,468,3359359,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1507831,2143894,'+','','P',1909162,'MobilComSuper9D1T10SFreisprech(Akquise)',NULL,NULL,'MS9NS1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

2154

INSERT INTO t1 VALUES (3359360,0,0,'Mustermann Musterfrau',29674907,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1900169997,2414578,'+',NULL,'N',1909148,'',NULL,NULL,'RV99066_2',20,NULL,'POS',29674907,NULL,NULL,20010202105916,'Mobilfunk','','','97317481','007');

2155

INSERT INTO t1 VALUES (3359361,406,3359361,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag storniert','','(7001-84):Storno, Kd. möchte nicht mehr','privat',NULL,0,'+','','P',1909150,'MobilComSuper92000D1(Akquise)',NULL,NULL,'MS9ND1',325,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

2156

INSERT INTO t1 VALUES (3359362,406,3359362,'Mustermann Musterfrau',7001,'2000-05-20','workflow','Auftrag erledigt','Originalvertrag eingegangen und geprüft','','privat',1509984,2145874,'+','','P',1909154,'MobilComSuper92000D1(Akquise)',NULL,NULL,'MS9ND1',327,24,'MobilCom Intern',7003,NULL,'auto',20010202105916,'Mobilfunk','PP','','','');

2157

SELECT ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma (Kapitalgesellschaft) Sitz im Ausland','Firma (Personengesellschaft)','Firma (Personengesellschaft) Sitz im Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im Ausland','Typ unbekannt') AS Kundentyp ,kategorie FROM t1 WHERE hdl_nr < 2000000 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse = 'Workflow' GROUP BY kundentyp ORDER BY kategorie;

2158

Kundentyp kategorie

2159

Privat (Private Nutzung) Mobilfunk

2160

Warnings:

2161

Warning 1052 Column 'kundentyp' in group statement is ambiguous

2162

drop table t1;

2163

SHOW STATUS LIKE 'Ssl_cipher';

2164

Variable_name Value

2165

Ssl_cipher DHE-RSA-AES256-SHA

2166

2167

# Bug#54790: Use of non-blocking mode for sockets limits performance

2168

2169

# Open ssl_con and set a timeout.

2170

SET @@SESSION.wait_timeout = 2;

2171

# Wait for ssl_con to be disconnected.

2172

# Check that ssl_con has been disconnected.

2173

# CR_SERVER_LOST, CR_SERVER_GONE_ERROR

2174

SELECT 1;

2175

Got one of the listed errors

Older »