Select/Count not showing me my records...permissions?

3 Message(s) by 2 Author(s) originally posted in mysql database

From: John Bailo

Date: Thursday, May 10, 2007

I imported 600,000 records from SQL

<language, database, standard> /S Q L/ An industry-standard
	language for creating, updating and, querying {relational
	database management systems}.

	SQL was developed by {IBM} in the 1970s for use in {System R}.
	It is the {de facto standard} as well as being an {ISO} and
	{ANSI} {standard}.  It is often embedded in general purpose
	programming languages.

	The first SQL standard, in 1986, provided basic language
	constructs for defining and manipulating {tables} of data; a
	revision in 1989 added language extensions for {referential
	integrity} and generalised {integrity} {constraints}.  Another
	revision in 1992 provided facilities for {schema} manipulation
	and {data administration}, as well as substantial enhancements
	for data definition and data manipulation.

	Development is currently underway to enhance SQL into a
	computationally complete language for the definition and
	management of {persistent}, complex objects.  This includes:
	generalisation and specialisation hierarchies, {multiple
	inheritance}, user defined {data types}, {triggers} and
	{assertions}, support for {knowledge based systems},
	{recursive query expressions}, and additional data
	administration tools.  It also includes the specification of
	{abstract data types} (ADTs), object identifiers, {methods},
	{inheritance}, {polymorphism}, {encapsulation}, and all of the
	other facilities normally associated with object data
	management.

	The emerging {SQL3} standard is expected to be complete in
	1998.

	According to Allen G. Taylor, SQL does _not_ stand for
	"Structured Query Language".  That, like "SEQUEL" (and its
	pronunciation /see'kw*l/), was just another unofficial name
	for a precursor of SQL.  However, the IBM SQL Reference manual
	for DB2 and Craig Mullins's "DB2 Developer's Guide" say SQL
	_does_ stand for "Structured Query Language".

	{SQL Standards (http://www.jcc.com/sql_stnd.html)}.

	{An SQL parser
	(ftp://ftp.ora.com/published/oreilly/nutshell/lexyacc/)} is
	described in "Lex & Yacc", by Levine, Mason & Brown published
	by O'Reilly.

	{The 1995 SQL Reunion: People, Projects, and Politics
	(http://www.mcjones.org/System_R/SQL_Reunion_95/)}.

	["A Guide to the SQL Standard", C.J. Date, A-W 1987].

	["SQL for Dummies", Allen G. Taylor, IDG Books Worldwide].

	(2005-11-17)

Server 2005 to mySQL.

I know they are in there -- I just can not see them!

When I do a SELECT, it processes for a while, and then returns nothing.

Same with a count, it sits there processing, and then returns a '0'

However when I do the same on a table

<database> A collection of {records} in a {relational database}.

	(1997-06-04)

I know has no rows, it definitely
comes back right away.

I'm logged in as root. Do I need to assign myself some permissions to
see these records? And the count numbers?

From: Good Man

Date: Friday, May 11, 2007

wrote in message

In {object-oriented programming} sending a message to an
	{object} (to invoke a {method}) is equivalent to calling a
	{procedure} in traditional programming languages, except that
	the actual code executed may only be selected at run time
	depending on the {class} of the object.  Thus, in response to
	the message "drawSelf", the method code invoked would be
	different if the target object were a circle or a square.

	(1995-02-16)

I imported 600,000 records from SQL Server 2005 to mySQL.
I know they are in there -- I just can not see them!
When I do a SELECT, it processes for a while, and then returns nothing.
Same with a count, it sits there processing, and then returns a '0'
However when I do the same on a table I know has no rows, it definitely
comes back right away.
I'm logged in as root. Do I need to assign myself some permissions to
see these records? And the count numbers?

What is your query?

From: John Bailo

Date: Sunday, May 13, 2007

wrote in message:

I imported 600,000 records from SQL Server 2005 to mySQL.
I know they are in there -- I just can not see them!
When I do a SELECT, it processes for a while, and then returns nothing.
Same with a count, it sits there processing, and then returns a '0'
However when I do the same on a table I know has no rows, it definitely
comes back right away.
I'm logged in as root. Do I need to assign myself some permissions to
see these records? And the count numbers?

Ok, the first time I imported, I stopped it 2/3rds of the way and I
thought I had 2/3rds of the records, but apparently not.

I let it run

<operating system, programming> The process of carrying out
	the {instructions} in a computer program by a computer.

	See also {dry run}.

	(1996-05-13)

all the way through and it works brilliantly.

mySQL is faster than sql2005 for sure....

Next Message: Connection life