mysql q 22 Responses

Last post: 5 months, 3 weeks ago | Thread started: Jun 12, 08, 2:09 p.m.

RespondNew TopicDisable Images

• BattleAxe

  is there a way to export the records from just one field and import them into a different databse , every time i do export it does the whole table ,

  im using 5.0.45
  and using phpMyAdmin - 2.8.0.1

  Jun 12, 08, 2:09 p.m. – Permalink

• acescence

  click the SQL tab, enter your query SELECT field FROM table, click the export link

  • sorry, click go after you enter the query, then you will see the export link– acescence

  

  You must be logged in to add a note. Login now or register for an account.

  Cancel

  Dog-earJun 12, 08, 2:29 p.m. – Permalink

• BattleAxe

  SELECT *
  FROM `phpbb_users`
  WHERE `username`
  LIMIT 0 , 30

  i only get 3 records(out of 600+), and it ads that Limit when i click go ? is that limit messing it up

  • its limiting to _30_ records, so if you're only getting 3 back - no it's not messing it up.– sublocked

  

  You must be logged in to add a note. Login now or register for an account.

  Cancel

  Dog-earJun 12, 08, 3:32 p.m. – Permalink