One cannot TRUNCATE, MySQL table that has FK constraints applied on it. TRUNCATE is not the same as DELETE. There are 2 possible workarounds for the problem. The good (which does not risk damage to data integrity) and the bad.
Delete manually the rows that now have references to nowhere.
Option 2: Aka the BAD variant. Very handy during development.
SET FOREIGN_KEY_CHECKS =0;
SET FOREIGN_KEY_CHECKS =1;
SET FOREIGN_KEY_CHECKS = 0;
SET FOREIGN_KEY_CHECKS = 1;
Disabling foreign key checks may lead to a damage to the data integrity, for ex. leaving your tables with rows that do not adhere to the FOREIGN KEY constraints.
I was skeptical about having a tablet, finding no use of the device at all, but due to my recent involvement with my gift – Samsung Galaxy S3 i got fascinated with the development opportunities android based devices offer. As a software developer this side of things is more interesting.
Now on the topic. Having some ideas for apps I was looking for a debug console and device beside my phone to test the apps on. So after quick research i decided that 100 euro tablet would do the trick. I was also looking into the even cheaper tablets but they felt laggy while in use.
The device I brought is Privileg MID-7A tablet.
Cheap 7″ tablet with 1GB of ram, 8GB of internal storage, 1.2 Ghz processor, resolution of 1024×600 and WiFi. Also front and back cameras. The touch screen is good. The OS is Android 4.0.3. Perfect for debugging and testing apps.
While doing the job of a development tool I slowly started using the tablet for different things like watching a movie in bed. Browsing the net and playing games. I also blog from the device while on the road. Its usefully for the times when you don’t want to carry a laptop around or having some time to kill. The tablet in combination with my S3 is my new mobile setup. I share the net from the phone.
I am considering the idea to buy a case with a keyboard.
In conclusion. I like having a tablet around. I really like it. When I have some free time I will root the device and install Android 4.2 on it.
Nice little thing 🙂 I’m writing this post from it.