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.

Taidot: MySQL, tietojärjestelmäarkkitehtuuri, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 13 arvostelua ) Buenos aires, Argentina

Projektin tunnus: #1737233

Myönnetty käyttäjälle:


Hi, please check the PM.

60 $ USD 1 päivässä
(15 arvostelua)

8 freelancers are bidding on average $113 for this job


Hi, Ready to start. Check PMB please.

150 $ USD 10 päivässä
(24 arvostelua)

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 Lisää

70 $ USD 3 päivässä
(2 arvostelua)

I am ready to do it.

100 $ USD 0 päivässä
(0 arvostelua)

Please check PM for the demo trigger.

150 $ USD 2 päivässä
(0 arvostelua)

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

90 $ USD 1 päivässä
(0 arvostelua)

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

250 $ USD 1 päivässä
(0 arvostelua)

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

30 $ USD 1 päivässä
(0 arvostelua)