Comment

martin
Errors,
October 28, 2008 at 8:02 AM

Please can you help me identify the error in this code?

CREATE TABLE Country ( Name VARCHAR ( 30 ) PRIMARY KEY , Cont VARCHAR ( 30 ) , Pop INTEGER , GDP INT )
INSERT INTO Country VALUES ('CANADA', 'NAM', 30.1,658.0);
INSERT INTO Country VALUES ('MEXICO', 'NAM',107.5,694.3);
INSERT INTO Country VALUES ('BRAZIL', 'SAM',183.3,1004.0);
INSERT INTO Country VALUES ('CUBA', 'NAM', 11.7, 16.9);
INSERT INTO Country VALUES ('USA', 'NAM', 270.0 , 8003.0);
INSERT INTO Country VALUES ('ARGENTINA', 'SAM', 36.3 , 348.2);

The error

CREATE TABLE Country ( Name VARCHAR ( 30 ) PRIMARY KEY , Cont VARCHAR ( 30 ) , Pop INTEGER , GDP INT )
INSERT INTO Country VALUES ('CANADA', 'NAM', 30.1,658.0);
INSERT INTO Country VALUES ('MEXICO', 'NAM',107.5,694.3);
INSERT INTO Country VALUES ('BRAZIL', 'SAM',183.3,1004.0);
INSERT INTO Country VALUES ('CUBA', 'NAM', 11.7, 16.9);
INSERT INTO Country VALUES ('USA', 'NAM', 270.0 , 8003.0);
INSERT INTO Country VALUES ('ARGENTINA', 'SAM', 36.3 , 348.2);


View All Comments | View Tutorial
Advertisement
Related Tutorial and Articles
Java Beginners

errors
that what the errors in above code 

Java Beginners

errors
 

Java Beginners

Getting 404 errors - Java Beginners
("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql... I received a 404 errors and I identified that the servlet doesn't appear..."); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/test 

PHP Tutorial

How to show all errors in PHP?
How to show all errors in PHP? I this tutorial I will explain you how you can... all errors in PHP?" by the PHP developers. As it is necessary to see all the errors while developing PHP programs. What change I should make in the code 

HTML Questions

check for errors
check for errors  How can I check for errors 

Java Beginners

What is the errors?
What is the errors?  ) while ( c <= 5 ) { product *= c; ++c;   if ( gender == 1 ) cout << "Woman" << endl; else; cout << "Man" << endl;   Post the whole code 

Servlet Interview Questions

compilation errors
() { } } giving errors: 1) WelcomeServlet.java:37: ')' expected 

Java Magazine Questions

java errors
 

Java Beginners

getting errors
 

PHP Questions

types of errors in php
types of errors in php  What are the different types of errors in php 

Java Beginners

Compiler errors in java
Compiler errors in java  Hi, I used GenerateRDF java file. Am getting errors when i run this code. I used command prompt only. getting errors as no package exist. i followed your instructions properly. Please help me out 

JavaScript Questions

selectoptions errors in java script
selectoptions errors in java script  hi, in my web page when I select the color of the image it displays that particular color but when i again opt the select option it displays errors message. How do I rectify this problem 

JSP Servlet Questions

Servlets errors in same page.
Servlets errors in same page.  How do I display errors list in the same page where a form field exists using servlets...........i.e. without using JSP? Please explain with a simple username password program 

Spring Framework

The errors tag
In this section, you will learn about the errors tag of the Spring form tag library 

JSP Servlet Questions

jsp errors - JSP-Servlet
jsp errors  Hi I got errors when running a jsp file I am giving the file. this is from rose india. I set the class path for 3 jar files i.e.... Now i am getting less errors compared to previous. But I am getting 2 errors 

Java Beginners

Java Program Errors
Java Program Errors  These are the 2 errors which I am getting when executing the java source code extracted from executable jar file The project was not built since its build path is incomplete. Cannot find the class file 

Java Beginners

Correct errors - Java Beginners
Correct errors  Identify and correct the errors in the following program: public java Method { public static method1(int n, m) { n += m; xMethod(3. 4); } public static int xMethod(int n) { if (n > 0) return 1 

Struts Questions

STRUTS2.0 Validation Errors
the previous field errors persist in the page. For eg:if i am not entering both 

PHP Questions

WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?
WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?  WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP 

Java Beginners

Java errors - Java Beginners
 

Swing AWT

compilation errors - Swing AWT
 

PHP Questions

php display errors
 

Java Beginners

Java errors when attempting the following.
Java errors when attempting the following.  Give the java errors in attempting the following : 1) performing division operation on string value. 2) redefining base class final method in derived class. 3) defining a method 

PHP Tutorial

date_get_last_errors
date_get_last_errors date_get_last_errors alias DateTime::getLastErrors function returns the warnings and errors while parsing a date/time string... about warnings and errors. Example: <?php $date = date_create('asdfasdf 

IDE Questions

Need urgent help with C++ errors!
Need urgent help with C++ errors!  hi, i'm new to C++ programming. this is my code... i'm using Turbo C++. It's showing so many errors!.. I...() { cout<<"Can somebody fix this?"; } the errors are listed as follows 

Java Beginners

remopving errors incore java programming
remopving errors incore java programming  sir error in program:-file does not contain class runnable program:- class MyRunnable implements Runnable{ public void run(){ System.out.println("Run"); } public 

Java Beginners

remopving errors incore java programming
remopving errors incore java programming  sir error in program:-file does not contain class runnable program:- class MyRunnable implements Runnable{ public void run(){ System.out.println("Run"); } public 

Java Beginners

remopving errors incore java programming
remopving errors incore java programming  sir error in program:-file does not contain class runnable program:- class MyRunnable implements Runnable{ public void run(){ System.out.println("Run"); } public 

JSP Tutorials

Runtime Errors
Runtime Errors          Errors are arised when there is any logic problem with the logic of the program.  In this program we are trying 

Java Beginners

need to fix errors please help
need to fix errors please help  it does have 2 errors what should i fix? import java.io.*; class InputName static InputStreamReader reader = new InputStreamReader(system.in); static BufferedReader input = new BufferedReader 

Applet Questions

Help please, some strange errors
this errors so i have posted the whole program here. Here i tried to make the monopoly... is causing that run-time errors? Any kind of help will be helpful to me. and let 

MySQL

MySQL Front
errors.     MySQL-Front version 3.2 MySQL-Front... MySQL Front       In this page you will find many tools that you can use as MySQL Front to work with the MySQL 

MySQL

MySQL Books
MySQL Books       List of many MySQL books. MySQL Books Hundreds of books and publications related to MySQL are in circulation that can help you get the most of out MySQL. These books 

Struts Questions

Display Errors using Message Resources - Struts
Display Errors using Message Resources  Hello.. I've a login page where i used applicationresources.properties to display errors for null values and i wrote the condition in formbean. Now i want to show the errors for invalid 

JDBC Questions

JBBC ,MYSQL ND JAVA
JBBC ,MYSQL ND JAVA  import java.sql.*; import...:mysql://localhost/ACCOUNT","root","ADMIN"); st=con.createStatement...) { JOptionPane.showMessageDialog(null,"error"); } CAN ANYONE HELP ME IN FINDING THE ERRORS IN DIS 

SQL Question

Assigning variable in mysql - SQL
the following code but recieve errors. create table Purchase ( productCode...-new.quantitySold where productCode = @d; but i recieve errors about my syntax 

Struts Questions

i am Getting Some errors in Struts - Struts
i am Getting Some errors in Struts   I am Learning Struts Basics,I am Trying examples do in this Site Examples.i am getting lot of errors.Please Help me 

Java Server Faces Questions

errors while run - Java Server Faces Questions
errors while run  I,ve download the SimpleHelloByEnteringName jsf intoduntion sample project and tried to run this application following the steps narrated in roseindia jsf tutorial. But i found the fillowing error:(My 

SQL Question

MYSQL
MYSQL  How to create time and date based trigger in mysql   MySQL Time Trigger 

SQL Question

mysql
mysql  how to open\import table in .dbf format in mysql 

SQL Question

MySql
MySql  what is default password of mySql, and how i configure mySql.   Hi, If you are installing MySQL on windows then you will have to provide the Password for the user root at the installation time. You may try 

SQL Question

mysql
you need to download the mysql-connector jar file for connecting java program from mysql database.......   Hi friend, MySQL is open source database... is the link for the page from where you can understand how to Download and Install MySQL 

MySQL

MySQL Administrator
MySQL Administrator       MySQL Administrator MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain 

PHP Questions

mysql
mysql  want the code for mysql nested select query with single where condition.want to select data from more than one table 

Hibernate Questions

Calling hibernate query list() method generates errors
of the job id from REFRESH to PERSIST, but still the same errors occur. Does cache 

Java Beginners

Coding errors for printing function, please help
Coding errors for printing function, please help  Hello, We, my classmates and I, wrote this software but I ran into problems with printing button. Can someone please take a look and help me to fix this. Although 

JDBC Questions

verify the code and give me the code with out errors
clear the errors and give me correct tutorial for my knowledge improving.pls anyone 

Struts Questions

How to validate a form in action class and forward errors to the jsp in struts?
How to validate a form in action class and forward errors to the jsp in struts?  How to validate a form in action class and forward errors to the jsp in struts 

Date Calendar

mysql
 

SQL Question

MySQL
 

XML Tutorials

Handling Errors While Parsing an XML File
Handling Errors While Parsing an XML File       This Example shows you how to Handle Errors While... below for Handling Errors:-SAXParserFactory saxpf = SAXParserFactory.newInstance 

Struts Questions

how to display action errors in jsp which is in a form list
how to display action errors in jsp which is in a form list  My jsp contains list of forms iterating using display:table, each FORM forms a row. I want to display action errors for individual form in the same row 

Java Beginners

<errors><error><domain>yt:quota</domain><code>too_many_recent_calls</code></error></errors>
 

General

Welcome to the MySQL Tutorials
MySQL Errors... MySQL Tutorial - SQL Tutorials       The MySQL database server is most popular database 

Hibernate Questions

Any specific log4j statements for Hibernate Envers for showing the Envers related errors
Any specific log4j statements for Hibernate Envers for showing the Envers related errors  We are applying Hibernate Envers for existing hibernate project. If there is any specific errors related to hibernate envers those 

Spring Framework Questions

How to customize property type conversion errors in Spring MVC 3.
How to customize property type conversion errors in Spring MVC 3.  Hi, I have readed "Spring 3 MVC Validation Example" http://www.roseindia.net/tutorial/spring/spring3/web/spring-3-mvc-validation-example.html. In the validation 

Struts Questions

access data from mysql through struts
access data from mysql through struts  I am Pradeep Kundu. I am making a program in struts in which i want to access data from MySQL through struts. I am using Strut 1.3.8 , Netbean 6.7.1 and MySQL 5.5. In this program ,I want 

General

Ask MySQL Questions online
Ask MySQL Questions online       MySQL is an open source Relational Database... the pressure and problem, which results several errors. In this move, we have 

Spring Framework Questions

SEVERE: Context [/hospital] startup failed due to previous errors
org.apache.catalina.core.StandardContext start SEVERE: Context [/hospital] startup failed due to previous errors Jan 

MySQL

cPanel upgrade MySQL 5.1 to 5.5
it will may give following errors: MySQL server PID file could not be found! [FAILED...cPanel upgrade MySQL 5.1 to 5.5 - Upgrade MySQL 5.1 to MySQL 5.5 through cPanel wizard and configure the server after update Learn how to update MySQL 5.1 

Spring 3

SQLExceptionTranslator example
; errors are left for translation by the SQLExceptionTranslator interface. We...;property name="jdbcUrl" value="jdbc:mysql://192.168.10.13:3306/ankdb 

MySQL

MySQL
MySQL In this section we will read about what is MySQL, MySQL distribution, MySQL features, MySQL architecture etc. MySQL unofficially, pronounced as My... the database. The development, distribution, and support of MySQL is done 

MySQL

MySQL Database
MySQL Database       MYSQL... of the most popular freeware databases in use today, MySQL.  There are actually four versions of MySQL:  * MySQL Standard includes the standard storage 

Hibernate Questions

Access data from mysql through struts-hibernate integration
Access data from mysql through struts-hibernate integration  Hi friends, I am making a program in which I want to access data from mysql... delete and insert command gives output correctly but they don't update mysql 

JSP Servlet Questions

in the below code two errors are there one at the button onclick atttibute and the next is at the next button
in the below code two errors are there one at the button onclick atttibute and the next is at the next button  <%@ page import="java.sql.*" %> function editRecord(id){ var f=document.form; f.method="post 

JDBC Questions

Dateformat in MySQL
Dateformat in MySQL  Date format in MySQL 

SQL Question

mysql doubt
mysql doubt  1.What are the method to write malayalam in mysql command prompt?Is it necessary to write malayalam corressponding unicode in mysql command prompt? 2.How to store & retrieve Malayalam from mysql databases 

Java-Tutorials

MySQL NOT IN
MySQL NOT IN In this section we will read about how to use the NOT IN function in MySQL with a simple example. MySQL NOT IN() function specifies... will demonstrate you about how to use MySQL not in() function. In this example we 

JDBC Questions

Mysql connector
Mysql connector  Wer can i get mysql-connector? Is it jar or exe file.../pub/mirrors/maven/mysql/jars/mysql-connector-java-5.0.5.jar It will provide you the download option for mysql-connector-java-5.0.5.jar file. Thanks 

SQL Question

Mysql connect
Mysql connect  i can have a mysql database file and mysql-connector-net .but i have not mysql database. how to connect vb.net thsis database.(C:\Documents and Settings\Admin\My Documents\VB.NET\Stock delna\STC.sql ). plz help me 

Struts Questions

I tried to create a dropdown list using struts2.it is not working.can you find the errors in this code?
I tried to create a dropdown list using struts2.it is not working.can you find the errors in this code?  /jsp code for creating dropdownlist using struts2/ <html> <body> <p:form action="addemp" method="post"> 

SQL Question

mysql - SQL
mysql  hi i want to export my data from mysql to excel using php script. pls help me  Hi Friend, Please visit the following link: http://www.roseindia.net/sql/mysql-table/mysql-php-select.shtml Thanks 

Struts Questions

MYSql with struts
MYSql with struts  How to write insert and update query in struts by using mysql database?   Please visit the following link: http://www.roseindia.net/struts/struts2/struts-2-mysql.shtml 

SQL Question

mysql - SQL
mysql  How to insert the check box values in mysql database through php 

Java Beginners

java-mysql
java-mysql  how i retrive all the values of a table in mysql to java forms or java table 

PHP Questions

php mysql
php mysql  automatically insert a value in the month field at the last date of current month in mysql database 

PHP Questions

php mysql
php mysql  automatically insert a value in the month field at the last date of current month in mysql database 

Java Beginners

Image in mysql
Image in mysql  Hi. How to insert and retrieve images in mysql db using JSP or JAVA Servlet? Thanks in advance 

JSP Servlet Questions

JSP &MYSQL
JSP &MYSQL  Develop a web page for the telephone directory using jsp and mysql 

JDBC Questions

Java and Mysql
Java and Mysql  Sir, I want to connect my java program with mysql server (mysql server is situated on another windows machine ) ??? ???? ?????   Put mysql jar file in your jdk lib and set the classpath. After 

MySQL

Mysql As
Mysql As       Mysql As is used to specify the another name for the existing column and table name... from 'Mysql As'. To understand this example we create a table 'stu'. The create 

SQL Question

MySQL - SQL
MySQL  how to set a time to repeat a trigger in Mysql?  Hi Friend, Please visit the following links: http://www.roseindia.net/mysql/mysql5/triggers.shtml http://www.roseindia.net/sql/trigger/mysql-time 

Java Beginners

Java and MySQL
Java and MySQL   I am doing a project on an accounting system. I need to know to things: How do I write reports using information in an MySQL database . How get multiple MySQL database rows and assign them to variables r 

SQL Question

user in mysql
user in mysql  how to create user in mysql?   Please visit the following link: http://www.roseindia.net/mysql/mysql5/mysql-creating-account.shtml 

PHP Questions

connectivity with mysql
/phpdatabase/Check-PHP-MySQL-Connectivity.html   Please visit the following.../tutorial/php/phpdatabase/ http://www.roseindia.net/sql/mysql-example/php-mysql 

SQL Question

mysql - SQL
mysql  hi i am using mysql. i want to create simple table...=INNODB; For more information MySql visit to : http://www.roseindia.net/mysql/ Thanks 

Vehicle Tracking Technology

Factors responsible for GPS signal errors
Factors responsible for GPS signal errors   ... of intentional errors like creating noise in the satellite clock or transmitting some... those errors.       

SQL Tutorial

Online Mysql Training
Online Mysql Training       Introduction to Mysql SQL is Structured Query Language plays an important role in date manipulation language. The Online training on Mysql provides 

Struts Questions

STRUTS 1.2.9 (NetBeans 6.1) - ValidationGroup for <html:errors> and <html:submit> as .NET? - Struts
 

Mobile Applications Questions

mysql - MobileApplications
* FROM Persons WHERE unit='india' For read more information on JDBC-Mysql visit to : http://www.roseindia.net/jdbc/jdbc-mysql/ http 

WebSevices Questions

mysql - WebSevices
mysql  Hello, mysql storing values in column with zero,but there is no 0.after 0 it is storing my values which i have extract from the file... when I want to store this value in mysql it store 0 first and than 60 

SQL Question

MYSQL - SQL
MYSQL  how to select last row in table?(MYSQL databse)   How to select last row of the table in mySql Here is the query given below selects tha last row of the table in mySql database. SELECT * FROM stu_info 

SQL Question

service mysql restart: cPanel MYSQL 5.1 to 5.5
service mysql restart: cPanel MYSQL 5.1 to 5.5  service mysql restart: cPanel MYSQL 5.1 to 5.5 

SQL Question

Upgrading databases between MySQL 5.0 to MySQL 5.5
Upgrading databases between MySQL 5.0 to MySQL 5.5  Upgrading databases between MySQL 5.0 to MySQL 5.5 

SQL Question

Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel
Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel   Mysql Upgrade on WHM (Mysql 5.1 to 5.5) - cPanel 

SQL Question

Mysql Upgrade on WHM (Mysql 5.1 to 5.5)cPanel
Mysql Upgrade on WHM (Mysql 5.1 to 5.5)cPanel   Mysql Upgrade on WHM (Mysql 5.1 to 5.5) cPanel 

MySQL

Mysql Not
Mysql Not       Mysql... with Example The Tutorial illustrate an example from 'MySQL Not'. The Select... for Mysql not : select !0 : The !0 in the select Query is used to return 1.    

SQL Question

MySql,java
MySql,java  In MySQL table i am adding the fields of name,photo,video,age,category.in the category i have some subjects.if one person login into my-site the he upload the one video under one subject.then i want the following 

PHP Questions

mysql query
mysql query  how do transfer into the excel data to my sql  ... the mysql connection in your php and store the list values inside the mysql...("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql 

SQL Question

mysql query
mysql query  I have two tables namely sms and bdpaidbribe. I want to insert a column "Message" of sms table into "caddiinfo" column of bdpaidbribe table. and whenever the Message is inserted into sms table it should automatically 

Advertisements Advertisements
 

 

 

DMCA.com