Madumok

Why I cannot successfully create the foreign keys From Navicat Wiki Jump to: navigation, search Apply OS : Windows, Mac, Linux Apply Navicat Product : Navicat for MySQL, Navicat for PostgreSQL, Navicat for SQLite, Navicat for Oracle, Navicat Premium Apply Navicat Version No. : All   MySQL If you recevie MySQL Error likes 1005: Cant create table .mydb#sql-44c_1c.frm(errno: 150) , it is caused by failure on creating Foreign Keys. There are some possible cases that might cause failure on creating Foreign Keys on MySQL database. These errors are related to MySQL itself. Example cases : If the two fields (Field name and the Foreign Field name) are using incompatible field type. If you use "On Delete Set Null" but the field doesnt allow null. To declare foreign keys in MySQL, there are few points which user should bear in mind : Both tables must be InnoDB type. In the referenced table, there must be an index where the referenced columns are listed as the f...

Why Your Testing and Optimization Team Needs a Data Storyteller If a test happens on your website and nobody hears about it, does it make a sound? Not to get too philosophical, but thats one of the big challenges of building a culture of growth and optimization: getting the word out. Thats why a data storyteller is one of the key members of any testing team. In fact, �communication and data storytelling� was noted as a critical skill for a person who leads testing and optimization efforts, according to a survey of marketing leaders who conduct tests and online experiments. 1 The must-have skills rounding out the top three were leadership and, the obvious, analytics. A data storyteller is part numbers-cruncher, part internal marketer, and part ace correspondent from the testing trenches. He or she is someone who can take the sheer data of testing � the stacks of numbers, the fractional wins and losses, the stream of daily choices � and turn it into a narrative that will excite the tea...

Why You Should Care About Attribution Originally Posted on the Adometry M2R Blog This is a guest post by Brian Sim, Product Marketing Manager, Marin Software Attribution is sometimes perceived as being too complex, too technical, and too cold. However, when you look beyond the advanced-level math that goes into attribution algorithms and consider consumer behavior and buying tendencies, the importance of attributing revenue across the customer purchase path becomes very apparent. Consider your own purchase behavior. How many steps did it take to get you from awareness to purchase the last time you bought something? Chances are it took you at least a few steps to get from �I think I could use a new lawn mower� to deciding �This 200cc self-driving, side-discharge robot lawnmower is the exact one that I need, and I�m going to purchase it this weekend because there�s going to be a seasonal sale.� With that in mind, the next logical question is, based on your customer journey, do you think ...

Why Twinkas Payment Was Slow 5k Package 10k Package 20k Package And 50k Package This is the logical explanation why Twinkas payment was slow this past week, (See details about Twinkas HERE| How Twinkas works ) we cant deny the fact that payment wasnt as super-fast as it has been in previous weeks.. but the reasons for this is quite clear; those stuck in the 5k & 10k package were all wailing in all social media platforms they could find due to the delay in their payment. we all know the delayed was caused by the low traffic in that package...but we all know wailing has never solved any problem but patience & understanding does. From Wednesday 15th to Friday 17th upgrade was been done on the 20k & 50k package hence a backlog of payment was created from the previous week....those whose payment were due as at the time the upgrade was been done were not paid completely. Some were paid, some werent paid as only few new participants could sign up during the time the upgrade was b...

Why Building a Culture of Optimization Improves the Customer Experience How can we be more useful to our customers today? Thats the simple question that drives any marketing organization focused on testing, improvement, and growth. But answering the question is not always so simple in our data-rich world. The old challenge of gathering enough data has been replaced by a new one: gleaning insights from the mountains of data we�ve collected � and taking action. In response to this flood of data, many of todays most successful businesses have turned to a new approach: building whats called a culture of growth and optimization . This growth-minded culture is one where everyone is ready to: Test everything  Value data over opinion  Keep testing and learning, even from failures  Most companies have a few people who are optimizers by nature, interest, or experience. Some may even have a �growth team.� But what really moves the dial is when everyone in the company is on board an...

Why Cydia Is Called as Cydia Cydia is a household name amongst the jailbreak community, but what does the word really mean? and why was it called that? Those of you who have jailbroken iOS devices are very likely to have used Cydia. The credit for this store which brings extra unrestricted functionality to our iOS devices goes to Jay �saurik� Freeman, who happens to be the brains behind this concept. Cydia is used by millions of iPhone users and may be a very well known application, but not many people know what it means. Cydia is interestingly enough, named after a moth of all things! The Cydia pomonella to be precise, is the scientific name for the �coddling moth� or what is more commonly known as the stereotypical Apple worm   According to Wikipedia, the Cydia pomonella �has proved to be a problematic pest on several fruit trees, including apples and pears. The caterpillars burrow into the fruit, rendering it un-sellable�. The ironic name of Cydia is therefore fitting, since it ...

Why the MiniKicks Still Win Everytime or my scooters are better than your bikes It seems that during the week in which my boys learned to crawl they also held a meeting wherein they decided that from that day onward the stroller just would not do. Even under the circumstances of extreme exhaustion, they agreed never to settle for anything less than Mommas back or Dadas neck. For a long stretch of time, we found ourselves doing things like carrying toddlers while pushing an empty stroller. Fools at best; suckers at worst. Eventually we just stopped bringing the stroller and embraced our temporary state as pack-mules for the tiny totalitarians.  One of the steps is acceptance, right? But then they got a lot heavier and a bit more reasonable. I decided to reintroduce the stroller as more of a royal livery--they could climb in to rest their weary limbs if need be, take a drink, grab a snack, and then disembark when they felt the need to stretch their limbs. Straps are never acknowledge...

Why I do What I do Thanks Dad! This post has both nothing and everything to do with why and how I do data forensics. I hope youll take a moment to read it.  I am a tenacious do-it-your-selfer in many areas of my life, including home repair, veterinary medicine (just ask my poor dogs), and data forensics. Some of it I even do reasonably well once in a while ( even a broken clock is right twice a day, right? ). There has been a strong influence in my life that lead me inevitably to this station in life: my father. My father is a retired firefighter--scratch that-- fireman.   Some would say he was tough on me while I was growing up.  Im sure Ive said that myself more than once.  But it would be more accurate to say that from an early age, my father instilled in me a strong sense of right-and-wrong and as self-reliance.  No excuses, no B.S.  He never failed to try to teach me, never missed an opportunity to impart wisdom that came from much experience.  He...