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.
- Remove constraints.
- Perform TRUNCATE.
- Delete manually the rows that now have references to nowhere.
- Create constraints.
Option 2: Aka the BAD variant. Very handy during development.
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.
Here are the device specs on Bulgarian.
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.