Questions tagged [mysql-error-1051]
3 questions
1
vote
1 answer
Mysql 1050 followed by 1051
Please help me figure this one out. I've already tried deleting and re-creating data files, flushing tables, restarting the database and entire server.
InnoDB is in Force Recovery = 4
>mysql -u root
Welcome to the MySQL monitor. Commands end with ;…
St.Woland
- 5,357
- 30
- 30
0
votes
2 answers
Error with my left joins?
I'm thinking the coffee isn't strong enough today. I need to query the table fb-celebotd to get the photoid that matches the fb-celebotd.celebdate. Most of the other info needed is dependent on the photos table.
The following is giving me a mysql…
Ian
- 509
- 12
- 36
0
votes
2 answers
'Unknown table' although it really exists
$query = mysql_query("SELECT company.*, factory.*
FROM company
FULL JOIN factory
ON company.n_id = factory.n_id
WHERE company.n_id = '$n_id' AND factory.n_id =…
good_evening
- 21,085
- 65
- 193
- 298