Đang Thực Hiện

Improve Sql with 2 trigger

I need to improve my mysql by adding two [url removed, login to view] .sql with sample data is here attached

Job, is just to me a .sql file to add to my server. I meant that Job will be to clone my actual table (and adding trigger to sql.) and migrate actual table to new one, where trigger will filter results.

What i need is :

NEW cloned table:

1. all fields not null (save 1 bit per row)

2. fix Collation because now we have

-- Character set: latin1

-- Collation: latin1_swedish_ci

but some caracters are not showed right.

3. give me recomenadtions to improve performance, up to type fields used. For example, we will change from varchar to inet_atom in IP field.

4. Table have more than 5 millons rows, take that in consideration.

AND adding this trigger with SET MESSAGE_TEXT like [url removed, login to view]

Trigger Before insert

1. DO NOT INSERT

1. with regexp:

in field base (domain) only parental domains should be allowed, for example:

yes [url removed, login to view] – adrian .com – [url removed, login to view]

no for [url removed, login to view] - [url removed, login to view] – [url removed, login to view]

I think something like '%.{3letters here max}.{2 or 3letters here max}' could work.

2. up to domain extension NEW.country={number} should be a number, up to the table country.

3. Update rubro up to the title of website with cases, example ([url removed, login to view] )

for example if title is '%blog%' ? New.rubro='Blog'

4. As all fields will be not null, when a [url removed, login to view] will be added that to the table , what should trigger do ? Maybe … if new.field=null set new.field=0 .. ? wait your opinion here.

Trigger After insert

1. update stats_country table, update +1 up to the country added in tbl_website table, i meant for each [url removed, login to view] added to tbl_website , stats_country +1 where country=chile

I just need the .sql to execute in my server.

To test your skills sent me in private message one trigger example where only numbers can be added to a example field.

Kỹ năng: MySQL, Kiến trúc phần mềm, SQL

Xem thêm: skills improve, regexp example, performance test job, html dev, en save, triggers, test case software, sql server max, sql server job, p sql, max sql server, max p, character td, test sql server, test skills, sql software, sql 2012, native apps, my ar, improve website, chile, update sql file, rows insert, mysql number sql, sql maybe

Về Bên Thuê:
( 13 nhận xét ) Buenos aires, Argentina

Mã Dự Án: #1737233

Đã trao cho:

liuxinran

Hi, please check the PM.

$60 USD trong 1 ngày
(15 Đánh Giá)
4.1

8 freelancer đang chào giá trung bình $113 cho công việc này

thelogicgates1

Hi, Ready to start. Check PMB please.

$150 USD trong 10 ngày
(24 Đánh Giá)
6.2
AliSafder

Dear Sir, Having expertise in SQL Server 2005 / 2008 with working experience of more than 6 years. I have exceptional skills regarding database designing and up-gradation. I have designed number of systems runnin Thêm

$70 USD trong 3 ngày
(2 Đánh Giá)
1.2
coderserve

I am ready to do it.

$100 USD trong 0 ngày
(0 Đánh Giá)
0.0
kwelsan

Please check PM for the demo trigger.

$150 USD trong 2 ngày
(0 Đánh Giá)
0.0
phiro

Gidday, See the PM for the trigger demo solution. Kind regards, PhiRo

$90 USD trong 1 ngày
(0 Đánh Giá)
0.0
SKEpOh438

Custom software development - The Administrator removed this message due to advertising which breaches our Terms and Conditions.

$250 USD trong 1 ngày
(0 Đánh Giá)
0.0
ronishikder

Just give me the work, I'll complete it as per your requirement.

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0