/prog/ - MySQL — World4ch

Name: Anonymous 2010-04-23 9:05

How would I retrieve the list of table names and length of the varchars from a MySQL database?

Name: Anonymous 2010-04-23 9:08

By asking politely.

Name: Anonymous 2010-04-23 12:37

select some stuff from the columns table (in information_schema)

Name: Anonymous 2010-04-23 12:55

FUCK YOU! BITCH!

Name: Anonymous 2010-04-23 21:32

>>4
FUCK YOU MY ANUS

Name: Anonymous 2010-04-23 21:40

>>1
switch to a real database like PostgreSQL

Name: Anonymous 2010-04-23 21:46

>>6
switch to a NoSQL database like CouchDB or Cassandra

Name: Anonymous 2010-04-23 22:06

>>7
NoSQL is a cult.

Name: Anonymous 2010-04-23 22:24

>>8
Join it!

Name: Anonymous 2010-04-24 10:47

MySQL
Knowing the table names and length of the varchars is the least of you're problems right now.

Name: Anonymous 2010-04-24 10:50

>>7
NoSQL
What's that pig-disgusting shit anyway? Looks like a normal database where you just have a single TEXT column to store everything together in a shitty format (json). Great fucking idea. At that point, you'd be better off not pretending it's a database - just use plain text files.

Name: Anonymous 2010-04-24 10:58

>>11
NoSQL also uses plain text files

Name: Anonymous 2010-04-25 3:26

>>11
JSON is a fine format.

Name: Anonymous 2010-04-25 10:20

Children, children. A squabble is not what I asked for...

Name: Anonymous 2010-04-25 10:32

>>11
Any "base of data" is a database. A flat file can be a database. It's possible to structure your data into the JSON format and still have a database. NoSQL databases are not relational databases.

Name: Anonymous 2010-04-25 10:42

>>15
IN IN UR BASE, KILLIN UR DATAS

Name: Anonymous 2010-04-26 20:59

show tables;

don't know about the rest :3

MySQL

1 Name: Anonymous 2010-04-23 9:05

2 Name: Anonymous 2010-04-23 9:08

3 Name: Anonymous 2010-04-23 12:37

4 Name: Anonymous 2010-04-23 12:55

5 Name: Anonymous 2010-04-23 21:32

6 Name: Anonymous 2010-04-23 21:40

7 Name: Anonymous 2010-04-23 21:46

8 Name: Anonymous 2010-04-23 22:06

9 Name: Anonymous 2010-04-23 22:24

10 Name: Anonymous 2010-04-24 10:47

11 Name: Anonymous 2010-04-24 10:50

12 Name: Anonymous 2010-04-24 10:58

13 Name: Anonymous 2010-04-25 3:26

14 Name: Anonymous 2010-04-25 10:20

15 Name: Anonymous 2010-04-25 10:32

16 Name: Anonymous 2010-04-25 10:42

17 Name: Anonymous 2010-04-26 20:59

19 Name: Anonymous 2011-02-03 7:23