Đã hoàn thành

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. 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 nhiều hơn: www i force com, www force com, skills to improve, regexp example, performance test job, i force com, html 5 dev, en save, triggers, what is a test case, test case software, sql server max, sql server job, p sql, max sql server, max p, character td, my sql data base, dev mysql com, test sql server, test my skills, test case, sql software, sql and c, Sql 2012

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

ID dự án: #1737233

Được trao cho:


Hi, please check the PM.

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

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


Hi, Ready to start. Check PMB please.

$150 USD trong 10 ngày
(24 Nhận xét)

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ận xét)

I am ready to do it.

$100 USD trong 0 ngày
(0 Nhận xét)

Please check PM for the demo trigger.

$150 USD trong 2 ngày
(0 Nhận xét)

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

$90 USD trong 1 ngày
(0 Nhận xét)

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ận xét)

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

$30 USD trong 1 ngày
(0 Nhận xét)