Skip navigation links

MySQL Forums :: General :: Error 1146: Table 'mysql.1' doesn't exist


Advanced Search

Re: Error 1146: Table 'mysql.1' doesn't exist
Posted by: Rick James ()
Date: November 22, 2009 01:39PM

Is the table name "x.y"? That syntax is reserved for database=x with table=y. If you must have a table named "x.y", then quote it with backtics: `x.y`.

If "1" is the problem, where is that coming from? There are cases, esp in Perl, where a array is used in a scalar context. Perhaps you thought you had a table name, but instead you had an array with one name in it. When you assign that to a scalar, you get '1'.

Options: ReplyQuote


Subject Written By Posted
Error 1146: Table 'mysql.1' doesn't exist Luke Smith 01/06/2005 05:55PM
Re: Error 1146: Table 'mysql.1' doesn't exist Han Chyuan Tan 01/02/2006 12:49AM
Re: Error 1146: Table 'mysql.1' doesn't exist Michael Screatchbear 07/07/2008 02:27AM
Re: Error 1146: Table 'mysql.1' doesn't exist Han Chyuan Tan 01/02/2006 12:55AM
Re: Error 1146: Table 'mysql.1' doesn't exist ste MAR 07/24/2008 10:21AM
Re: Error 1146: Table 'mysql.1' doesn't exist Siddhartha Singh 10/14/2009 01:15AM
Re: Error 1146: Table 'mysql.1' doesn't exist Lance Shaw 05/16/2006 09:53AM
Re: Error 1146: Table 'mysql.1' doesn't exist Bill Karwin 05/16/2006 12:13PM
Re: Error 1146: Table 'mysql.1' doesn't exist First Last 05/05/2009 09:02AM
Re: Error 1146: Table 'mysql.1' doesn't exist Edward Mansfield 05/26/2006 08:48AM
Re: Error 1146: Table 'mysql.1' doesn't exist Bill Karwin 05/26/2006 10:12AM
Re: Error 1146: Table 'mysql.1' doesn't exist sudarshana chavan 04/23/2008 12:47AM
Error No. 1146 Table 'mysql.servers' doesn't exist sudarshana chavan 04/23/2008 12:49AM
Re: Error No. 1146 Table 'mysql.servers' doesn't exist Keerthi S 05/06/2008 01:53PM
Re: Error No. 1146 Table 'mysql.servers' doesn't exist Predrag Stolic 06/01/2008 12:01PM
Re: Error No. 1146 Table 'mysql.servers' doesn't exist Peter Brawley 06/01/2008 03:11PM
Re: Error No. 1146 Table 'mysql.servers' doesn't exist Jairo Maldonado 06/07/2008 11:37AM
Re: Error No. 1146 Table 'mysql.servers' doesn't exist Ron Ford 02/13/2009 11:20AM
Re: Error 1146: Table 'mysql.1' doesn't exist KS Chan 08/23/2008 07:54PM
Re: Error 1146: Table 'mysql.1' doesn't exist Fil Sand 11/04/2008 07:17PM
Re: Error 1146: Table 'mysql.1' doesn't exist Amir Malik Imran 12/31/2008 05:50PM
Re: Error 1146: Table 'mysql.1' doesn't exist Janardhan koduri 07/03/2009 02:07AM
Re: Error 1146: Table 'mysql.1' doesn't exist Artur Grigor 07/25/2009 06:24AM
Re: Error 1146: Table 'mysql.1' doesn't exist Sony George 10/28/2009 12:20PM
Re: Error 1146: Table 'mysql.1' doesn't exist jitin nandwani 11/06/2009 05:12AM
Re: Error 1146: Table 'mysql.1' doesn't exist Sumit Sharma 11/06/2009 05:56AM
Re: Error 1146: Table 'mysql.1' doesn't exist Amol Shirke 11/19/2009 11:53PM
Re: Error 1146: Table 'mysql.1' doesn't exist Rick James 11/22/2009 01:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.