I am getting this error when inserting a query into the SQL tab of a database, it only adds 2 tables when it is supposed to add more, but the error is stopping it?
Query im inserting:
Software version: 5.1.68-cll - MySQL Community Server (GPL)
If you can help me out, I'd really appreciate, thanks!
Edited 3 Years Ago by Ronnie.Sk1ttl3s.Eke
The error seems to be right after you try to insert a null value, but the table structure seems to want not null
From what I can see there is something in the data in some of the inserts that is off or a special charcter . I tried to run your sql code and remove various rows from teh fe table and it would never load. If I removed the inserts for fe it continued on down till it got to news and did the same thing. It might be the text data type you are using. I suggest taking the sql dump and running only the create tables statements to get the tables created and then go back in and create your inital vales again and see what happens.
Thanks for the very detailed reply rch1231, I am no expert in SQL so I don't fully understand what to do, ill maybe get a mate or someone to do what you said, thanks.
I cant do it, could anyone please fix it up for me and send me the code, I am begging you, been trying to do this for over a week, please guys or girls.
Okay so I looked at the screenshot and code, and I saw something that caught my eye.
You said you are only creating 2 tables correct, so I went to your code and looked between where you created your 2nd and 3rd table.
Which is this:
LOCK TABLES `fe` WRITE; /*!40000 ALTER TABLE `fe` DISABLE KEYS */; INSERT INTO `fe` (`ID`, `userID`, `type`, `ip`, `note`) VALUES (1,12,'e','18.104.22.168','Auspride018'),(2,13,'e','22.214.171.124',''),(3,8,'f','126.96.36.199','Nely'),(4,8,'f','188.8.131.52','Brittany'),(5,8,'f','184.108.40.206','channa'),(6,8,'f','220.127.116.11','Hector'),(7,8,'f','18.104.22.168','Kimmie'),(8,8,'f','22.214.171.124','Karissa'),(9,8,'f','126.96.36.199','Lilla'); /*!40000 ALTER TABLE `fe` ENABLE KEYS */; UNLOCK TABLES;
Now let's take a look at those values shall we
(1,12,'e','188.8.131.52','Auspride018'), (2,13,'e','184.108.40.206',''), (3,8,'f','220.127.116.11','Nely'), (4,8,'f','18.104.22.168','Brittany'), (5,8,'f','22.214.171.124','channa'), (6,8,'f','126.96.36.199','Hector'), (7,8,'f','188.8.131.52','Kimmie'), (8,8,'f','184.108.40.206','Karissa'), (9,8,'f','220.127.116.11','Lilla');
Notice how entry 2 has an empty value for the 5th value? Now I am no expert on SQL, but I feel that empty value for the entry between Auspride018 and Nely might be the issue. Why not try inserting a value there, and running it. See if that works
Edited 3 Years Ago by JOSheaIV
Help! I want to create a java program that finds the highest even integer among the values entered by the user. Stop asking values when a value less than 1 have been entered. If no even integer is entered, display "No Even Integer"
Here is the sample output that I ...
Hello All ...
Iam Getting An Error With try to excecute the stored procedure .
I have Have Sql database , the stored procedure like so :
USE [MPRS] GO /****** Object: StoredProcedure [dbo].[Search_Licenses_By_Number] Script Date: 26-Nov-16 8:06:52 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE ...
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...