Copy a column from watchdog table to a new database table

By Jverg on 11 Mar 2015 at 10:53 UTC

What I really want is to copy the uid column and create a new table with the uids from watchdog with the name blablabla... Could anyone help me solve this problem?

Comments

Not with the little

Jaypan commented 11 March 2015 at 11:05

Not with the little information you've given us.

Please explain further.

ok

Jverg commented 11 March 2015 at 11:07

i want to create an extra table in the database with the name blablabla and what i want to have this table is only the uid column with each values from the watchdog.

DB Query

vijaythummar commented 11 March 2015 at 12:11

You can write query something like below if you don't want code.

INSERT INTO test (uid)
    SELECT watchdog.uid
    FROM watchdog

Thanks,
Vijay Thummar

Why would you need that? You

Jaypan commented 11 March 2015 at 12:59

Why would you need that? You already have all the UIDs in the watchdog table. You can query them from there.

i want them

Jverg commented 11 March 2015 at 13:44

i want them because in my module i need to delete some of them and i do not want to delete it from watchdog.

In that case, as Vijaythummar

Jaypan commented 11 March 2015 at 14:03

In that case, as Vijaythummar said, you want hook_schema(): https://api.drupal.org/api/drupal/modules!system!system.api.php/function...

yes i saw

Jverg commented 11 March 2015 at 14:06

I saw this link but how i can pass the uid from watchdog in my new table?

When install the module

Jverg commented 11 March 2015 at 12:03

I want this table to create when i install the module. Plz help me solve this problem out.

hook_schema

vijaythummar commented 11 March 2015 at 12:13

Use Drupal hook called hook_schema to create table on module installation.

Thanks,
Vijay Thummar

ok with all that

Jverg commented 11 March 2015 at 12:51

Ok with all that thinks but the code how would be in .install file in order to catch my purpose??

_

WorldFallz commented 12 March 2015 at 14:57

you're not going to be able to just improvise your way through creating a drupal module-- i suggest familiarizing yourself with the developer docs and perhaps buy a book.